Brown and yellow bugs the look like hornets but burrow in grounds?

This insect is called a cicada killer, a giant wasp that ranges from 20-40mm. The cicada killer paralyzes cicadas with it's stinger, sometimes in mid-flight, and drags the cicada down into it's burrow. It then lays it's eggs on the cicada, and it's larvae eat it.