Most ends are sad.
Examples of tragic ends: someone young, talented; unfulfilled potential; sudden death; unexpected death; tragic circumstances e.g. in a disaster; someone who dies leaving a young family behind, and so on. "Tragic" says something about the circumstances of the death.