Air France 447 is another example of when an unexpected transition to manual controls caused a crash. There's a good story on autopilot and automation more generally at: http://www.npr.org/sections/money/2015/07/29/427467598/episo...

There are pros to automation - even if the transition to manual causes problems, overall autopilot can be safer than manual.