[0]: http://www.theatlantic.com/national/archive/2011/08/how-to-h...
[1]: http://www.latimes.com/world/la-fg-german-jet-crash-door-201...
a) It appears to be standard procedure in the aftermath of 9/11 to keep the cabin doors locked at all times.
b) Many of the cases mentioned where this is useful are cases where the cabin crew are incapacitated due to, say, hypoxia or some other malady.
Given both of these I fail to see how this skill is as useful as others appear to be claiming it to be.
There were plenty of incidents with small aircraft especially training aircraft where a non pilot had to land it but I don't think anyone untrained was ever in a position to land something as big as 737.
He even waved at the chase F-16 next to him but one engine flamed out as soon as he entered and the plane started to descend, crashing just 15 min later.
Maybe if he had had more time (and oxygen) he could have managed to bring the aircraft to an airport, but we will never know.
Edit: For what it's worth this was posted on some aviation-specific forums I follow and there are several inaccuracies in the video. It's the person is not a 737 pilot but they may be a commercial pilot certified for some other aircraft, or just someone with a lot of time on their hands.
There might be some thing like with doctors where you can register and they'll know you are one but I'm not sure.
For the most part there inst a situation in which you going to have both pilots unavailable and the aircraft isn't going to be plummeting into the ground.
What's the likelihood of this every happening to a member of the public these days? I presume that, in the eventuality of all pilots being out, there's a hierarchy of people who would then take over? I.e. if there are no pilots on board, the head of the cabin crew would perform this?