http://www.aaib.gov.uk/cms_resources...FCI%2007-8.pdf
Interesting reading. This chap seems to have been the master of his own destiny and his demise was ultimately self-inflicted. The tragedy is that he took an innocent passenger with him.
Unfortunately, muppets like the so called 'commander' of this flight provide a strong case for increased regulation of private pilots (possibly including random alcohol / drug testing and regular checkrides with instructors) and bolster opposition to general aviation. This would be an unfortunate burden on GA, the majority of PPLs being far more responsible and capable.