(Old greenwich ct )
Sorry, but that rather pretty moth is a pest! The squash vine borer moth lays eggs on most squash vines. The larvae emerge and bore into the stem killing the whole vine.
Next time you see it, squash it!
The moths are sometimes confused with wasps.
They are found in eastern North America.
In CT, you will have the moths flying till mid July. They lay the eggs (football shaped ovals) on zucchini, squash, gourds, and pumpkins. The do not prefer butternut squash. Moths feed on nectar. There are 2 generations of this pest in the south.
Time to check your squashes, esp the zucchini for evidence of the borer/eggs. The borers will bore in at a leaf axil then head inside the stem. You will see light brown sawdust looking frass (larvae poop) near the hole where it bored in. If you find the larvae in the stems you can poke them with a wire to kill them. Then put soil over the base of the squash plant to help it heal over the wound.
They usually lay eggs on the early squash crops, so planting a late crop helps to avoid an infestation in the north. It is not too late to plant another planting to avoid loss of all your squash.
That is a great photo so every one here knows what the adult looks like!!