I would quote UcanUwill which I strongly support:
I would love to have career ending injuries. It is the same as your proposed death, only death is wrong term in a game IMO. Career ending injury, simple.
In addition I would say that the injuries should be a little less random.
A player who has higher stamina should be less fragile (the randmenss should have less propability on his case, but not zero...).
A player who plays "Run'n'Gun" or "Pressure" should have higher chances to get injured.
Players that are part of a very close game, has higher tendancy to get injured.
Players who are exhausted (weekm game or seasoin level) tend to have higher risk to be injured.
And so on.
And yes, you pay your top dollar and training time, and then your player is get injured (for a week or for life).
This is life, and that is what happens in real BB-teams.
It should be the same here.