NTSB investigations, MO

91 cases where the sequence of events included Loss of control in flight.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN15FA282Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Cameron, MOThe pilot’s failure to maintain airplane control during a low-level aerobatic flight maneuver.Jun 27, 2015 · N877UP · Substantial damageNTSB CEN15FA267Accident · 4 fatalField investigationFinal reportBeech A36 · Huggins, MOThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall and loss of control.Jun 12, 2015 · N3193W · DestroyedNTSB GAA15CA052Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · West Plains, MOThe pilot's failure to maintain control while landing in gusty wind conditions.Apr 21, 2015 · N332AL · Substantial damageNTSB CEN15FA164Accident · 1 fatalField investigationFinal reportAirbus Helicopters (Eurocopte EC-130-B4 · St Louis, MOThe pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…Mar 7, 2015 · N356AM · DestroyedNTSB CEN15CA165Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lee's Summit, MOThe pilot-receiving-instruction's excessive pitch control during takeoff, which resulted in an aerodynamic stall shortly after liftoff and the subsequent loss of control. Contributing to the accident was the flight crew's decision to have the flight…Mar 1, 2015 · N3575X · Substantial damageNTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…Nov 30, 2014 · N6629V · Substantial damageNTSB CEN14CA532Accident · Minor injuriesData collectionFinal reportAirborne Edge X · Willow Springs, MOThe pilot's loss of control after the weight-shift-control aircraft encountered low-level wind shear shortly before touchdown. Also causal to the accident was the pilot's inadequate preflight weather assessment that failed to correctly determine the actual…Sep 1, 2014 · N2017A · Substantial damageNTSB CEN14LA313Accident · Minor injuriesLimited investigationFinal reportRobinson R22 - Beta · Moscow Mills, MOThe flight instructor’s delayed remedial action to correct the student pilot’s use of an excessive descent rate during a practice autorotation, which resulted in a hard landing.Jun 19, 2014 · N784SH · Substantial damageNTSB CEN14CA223Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Liberty, MOThe pilot's failure to maintain directional control while operating in gusty wind conditions at a low altitude.Apr 25, 2014 · N32VB · Substantial damageNTSB CEN14FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kirksville, MOA loss of control due to spatial disorientation. Contributing to the accident were the private pilot's impairment due to a sedating antihistamine and both pilots' fatigue.Nov 6, 2013 · N408DM · DestroyedNTSB CEN13CA521Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Osage Beach, MOThe pilot’s failure to maintain aircraft control during initial climb in gusty wind conditions.Sep 1, 2013 · N407EV · Substantial damageNTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…Aug 18, 2013 · N9201R · Substantial damageNTSB CEN13CA575Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Mariner · Lee's Summit, MOThe student pilot's improper flare while performing an autorotation and the flight instructor's delayed remedial action to correct the high sink rate, which resulted in a hard landing.Aug 18, 2013 · N8316D · Substantial damageNTSB CEN13FA259Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Lamar, MOThe pilot's in-flight loss of control, which was likely due to a sudden cardiac event.May 5, 2013 · N82509 · Substantial damageNTSB CEN13FA044Accident · 2 fatalField investigationFinal reportCessna 310 · Stotts City, MOThe pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…Nov 5, 2012 · N6BS · Substantial damageNTSB CEN12LA645Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Branson, MOThe pilot's failure to maintain airplane control during an attempted go-around in dark night conditions.Sep 20, 2012 · N34722 · Substantial damageNTSB CEN12LA636Accident · 1 fatalLimited investigationFinal reportJDT Mini-Max 1500R · Cameron, MOThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall and spin at a low altitude.Sep 16, 2012 · N3533D · Substantial damageNTSB CEN12FA633Accident · 5 fatalField investigationFinal reportCirrus Design SR22 · Willard, MOThe pilot's loss of airplane control as a result of spatial disorientation experienced in night instrument meteorological conditions.Sep 15, 2012 · N436KS · Substantial damageNTSB CEN12CA656Accident · Minor injuriesData collectionFinal reportFairchild PT-19A · Cape Girardeau, MOThe pilot’s failure to maintain sufficient airspeed during a low approach, which resulted in an aerodynamic stall.Sep 13, 2012 · N19GP · Substantial damageNTSB CEN12FA188Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Mexico, MOThe pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…Mar 18, 2012 · N158EA · Substantial damageNTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.Dec 8, 2011 · N7138K · Substantial damageNTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.Oct 8, 2011 · N27492 · Substantial damageNTSB CEN11CA589Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Matthews, MOThe pilot's failure to maintain control of the airplane during takeoff.Aug 22, 2011 · N113AA · Substantial damageNTSB CEN11CA590Accident · No injuriesData collectionFinal reportRans Designs S-7LS · Joplin, MOThe pilot's failure to maintain aircraft control during the landing.Aug 21, 2011 · N544RS · Substantial damageNTSB CEN11LA582Accident · 1 fatalLimited investigationFinal reportVertical Unlimited 12 · Kansas City, MOThe pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.Aug 20, 2011 · N2BJ · Substantial damageNTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.Jan 4, 2011 · N1416F · Substantial damageNTSB CEN11GA020Accident · 1 fatalFinal reportBell 206B · Clarkson Valley, MOThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and decision-making, and his improper control inputs following the loss of engine power, which resulted in mast bumping and separation of the…Oct 15, 2010 · N96MP · Substantial damageNTSB CEN10CA386Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Chillicothe, MOThe pilot's failure to maintain aircraft control during takeoff.Jul 9, 2010 · N6513K · Substantial damageNTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…Sep 22, 2009 · N3234M · Substantial damageNTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.Sep 7, 2009 · N65873 · Substantial damageNTSB CEN09LA427Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540 · Tarkio, MOThe pilot's failure to maintain aircraft control during the aerobatic flight.Jul 10, 2009 · N26HB · Substantial damageNTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.Oct 6, 2008 · N868S · Substantial damageNTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.Aug 29, 2008 · N41411 · DestroyedNTSB DFW08FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Cassville, MOThe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…Aug 10, 2008 · N214MT · DestroyedNTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.Aug 5, 2008 · N411EV · Substantial damageNTSB DFW08CA185Accident · Minor injuriesData collectionFinal reportStits SA3A · St Louis, MOThe pilot's failure to maintain control of the airplane during takeoff.Jul 14, 2008 · N134JW · Substantial damageNTSB DFW08LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Bethany, MOThe pilot's decision to take off with a known deficiency.Jun 24, 2008 · N5005G · Substantial damageNTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.Jun 20, 2008 · N3150U · Substantial damageNTSB DFW08LA157Accident · 1 fatalLimited investigationFinal reportLucas D E/ Lucas K A AcroSport II · St Charles, MOThe pilot's failure to maintain control during an attempted low pass maneuver.Jun 1, 2008 · N114KT · Substantial damageNTSB DEN08CA093Accident · Minor injuriesData collectionFinal reportKitfox IV 1200 · FlyingBar Ranch, MOThe pilot's improper decision to takeoff with a quartering tailwind and failure to maintain aircraft control. Contributing to the accident were the gusting tailwind and operating the airplane near maximum gross weight.May 24, 2008 · N108KX · Substantial damageNTSB DEN08FA078Accident · 2 fatalField investigationFinal reportCessna P206 · Mount Vernon, MOThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing factors in this accident were the entanglement of the parachute in the elevator control system, reducing the pilot's ability to regain control.Apr 19, 2008 · N2537X · Destroyed