If it's part of the storyline, great. Otherwise, no. It might as well be a "game over" screen then, because noone would consider continuing a game with a permanently dead NPC when they might as well re-load.