NPN BJT Relay Circuit will not turn off
Add a fly-back diode.

When switching the current off, a coil will reduce the voltage until something starts to conduct so it can continue to let the current flow, as long as it has magnetic energy inside. Sadly, the conductive path is provided by your transistor -- after it was fried.

That negative pulse can reach thousands of volts. Seriously!