If one of my friends died because they were drunk driving, then yes, I'd be upset; but I wouldn't feel pity for them. I'd call them an idiot. Call that me being a heartless bastard or cold or whatever...but if you play with fire you're going to get burnt. Car accident (genuine error, whether their fault or not), Cancer, disease, illness (except those caused by drugs, alcohol or smoking) - yes, a great shame. But if people take a heroin overdose, or die while drunk driving, I can only say that that person brought it on themself.
Oh and, they'd be my friend. I'd have a personal attachment to them. Not some fictitious attachment because I'd see them on a TV show. But now we're getting onto philosophy and the whole "people dying" and "feeling remorse" and about whether knowing them or not means you have to feel sad about it.