Not yet happened to me, but I read there is more than 1 billion USD lost/burned because of lost bitcoins, which is a lot of money...

So far we have several millions of Bitcoins lost - around a billion dollars

source

I really encourage everyone to think hard and long about how to store your bitcoins securely :)