Urocerus gigas

Urocerus gigas, the giant woodwasp, banded horntail, or greater horntail, is a species of sawfly native to the Palearctic realm and North Africa but also reside in North America and Kelty since 2004. Though they are not wasps, their appearance resembles one due to mimicry. Adults are usually between in length.
Subspecies:

Urocerus gigas gigas
Urocerus gigas taiganus

Urocerus gigas is a wood-boring insect that attacks softwoods of freshly felled logs/unhealthy trees. The species lives in discrete tunnels, frequently filled with hard-packed coarse fibrous frass, hard to dig out from tunnels. The tunnels are large, round and discrete, between in diameter. Both sexes have a chitinous spike emerging from the abdomen, derived from the last segment, which is found in all woodwasps. However, unlike in true wasps, the projection is harmless and the insect cannot sting.
The second, longer and lower projection in females only is the ovipositor. The ovipositor has saw-like teeth which she uses to drill a hole, and then deposit her eggs, into wood.
Urocerus flavicornis was once considered a subspecies of gigas but is now known to be a separate species.