Over the years I've had one high-qualify CF card die on me, and zero high-quality SD cards die - and that's with owning more SD cards than CF (and significantly more capacity in SD than CF).

I have had some other SD and microSD cards die, but these were the cheaper versions where that wouldn't surprise me - not something I've ever use in a camera.