A bit more on bees, wasps, et al, and their insect imitators. The picture below was a fluke shot ... I happened to catch this Honeybee just as she was launching herself from the goldenrod.
A bee fly, probably a member of the genus Villa.
Another one of our local bee flies: Exoprosopa decora.
Locust Borer (Megacyllene robiniae) ... a beetle impersonating a wasp