This is likely the black and red lined blister beetle (Megetra cancellata). These beetles secrete a blistering agent called cantharidin. The red stripes are to warn predators of this toxin.
The marmorated stink bug is an insect that has brown and black horizontal stripes. These type of stink bugs are found in Massachusetts and Missouri.
So far all I could fine is it is a beetle.
A milkweed bug. I hate them
red back spider
Yellow jackets are native to North America but are not true hornets. They have horizontal yellow and black stripes on the lower half.
Wasps and hornets
It looks like you'redescribing something like a carpet beetle. Harmless.
The gardensarfari lady beetle has a similar look as the lady bug. However, instead of dots on its back it has black stripes. The body and stripes of this insect can be reversed as well in some varieties of this bug.
There is not any data for a black beetle with a yellow stripe and red tail. You may be looking at the fourlined plant bug. The fourlined plant bug is black and yellow striped but does not have a red tail.
It may be the larva stage of a Coccinelidae (ladybug).
Tungaw is a huge yellow bug with black and purple stripes that is poisonous to humans and other small animals...it can be found in Asia
The Flea Beetle has an outer shell of yellow-white with three black stripes. It is usually found in western North America and tend to hide in the soil.