Well.. do you avoid being driven by someone else ? If not, then the argument "car accidents are the most common way to die" doesn't really make sense.
Bad experiences knock everyone's confidence a bit. I got reversed into by a lorry in a heavy traffic jam once (no comment ............) so every time I get stuck behind a lorry in a traffic jam, I get a bit suspicious! But you can't apply one situation to everything else afterwards :<
Being nervous on the drive is only going to affect your ability to make decisions, and therefore make you more likely to be involved in an accident. I know it's easy to say, but you've just gotta look past some guy who rear ended you one time, and believe in yourself!
The most dangerous thing on the road is indecisiveness; a complete idiot on the road driving way over the speed limit at least visibly makes decisions (stupid or not) for other drivers to see ;p Someone who's really cautious and can't decide what to do can really confuse other drivers.
Remember you passed your test the same as everyone else =) And there are risks in life with anything... going out on a really hot day could make you more likely to get cancer ( which is a very common disease unfortunately :< ) but does that stop you from getting out in the sun ? =x I don't think driving to a show should be considered as risk! For your "most common way to die" statistic, I think you should compare daily percentages of those who drive and survive to those who don't ... then you'd probably get a more accurate representation of the risks =x