Whatever works for the story. It isn't pleasant when a favorite character dies, but if the story dictates it, then do it. The one thing I suggest is that you not do it just to do it. Killing off a character just to do it, or for shock factor, usually falls flat. But if there is a very compelling reason to do so for the story, then I think it could be quite dramatic and quite interesting.