Do hornets die after they sting someone?

No. Unlike bees, hornets and wasps are able to withdraw their stingers after stinging. This makes it easier to treat the wound, but also that a single creature can sting multiple times.