I dislike flying because of the sheer unpleasant of the whole experience but I am not scared of flying. It is one of the safest modes of transportation. But we sometimes forget, in this age of autopilots where human pilots seem almost superfluous, how necessary they are and how skilled the pilots must be in order to deal with unexpected situations.
Here is a description of an incredible landing on a narrow and short New Orleans levee by the pilot of a Boeing 737 that had lost power in both engines in a storm. (Scroll down a bit to the comment and links by Thunder.) The actual landing was not caught on video but it was recreated in a Smithsonian documentary and here is the key segment.
Here is a another set of ten scary landings.