NTSB investigations
5,010 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.\"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.
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."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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.NTSB ERA09CA255Accident · Serious injuriesData collectionFinal reportMartin Edward H Fire Star II · Church Hill, TNThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during final approach.NTSB ERA09FA248Accident · 1 fatalField investigationFinal reportCessna 421B · Oakland Park, FLThe pilot's failure to maintain aircraft control and secure the right engine during an emergency return to the airport after takeoff. Contributing to the accident was an in-flight fire of the right engine for undetermined reasons.NTSB ANC09LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall while maneuvering at a high density altitude.NTSB CEN09CA251Accident · Minor injuriesData collectionFinal reportAviat A-1B · Great Bend, KSThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions.NTSB WPR09LA195Accident · Serious injuriesLimited investigationFinal reportSungkwon Kim LONG-EZE · Dunsmuir, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.NTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.NTSB ANC09LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nunapitchuk, AKThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing approach.NTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.NTSB CEN09LA247Accident · Serious injuriesLimited investigationFinal reportCessna 182T · Stigler, OKThe loss of directional control during takeoff. Contributing to the accident was the pilot's decision to take off with 40-degrees of flaps and with a tailwind.NTSB ERA09WA237Accident · 1 fatalForeign investigationPiper PA-34 · Valdivia, ChileNone.NTSB WPR09LA244Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot’s failure to maintain clearance from an object during takeoff from the deck of a fishing vessel.NTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.NTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.NTSB ANC09CA029Accident · No injuriesData collectionFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's selection of an unsuitably rough and snow-covered landing area.NTSB WPR09FA176Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Hungry Horse, MTThe pilot's improper decision to continue flight into an area of reduced visibility and snow showers during cruise flight, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control.NTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.NTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.NTSB ERA09CA220Accident · No injuriesData collectionFinal reportSIAI Marchetti SM-1019B · Dade City, FLThe pilot's failure to maintain directional control during initial climb.NTSB ERA09CA219Accident · Minor injuriesData collectionFinal reportParks Jerry R Lancair · Milton, FLThe pilot's failure to maintain aircraft control during landing.NTSB ERA09FA215Accident · 1 fatalField investigationFinal reportCessna 182Q · Lexington, KYThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB ANC09CA026Accident · Minor injuriesData collectionFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to attain adequate airspeed to avoid an aerodynamic stall. Contributing to the accident was the pilot's decision to take off with the airplane over its maximum allowable gross weight.NTSB WPR09CA183Accident · No injuriesData collectionFinal reportDenny Aerocraft Kitfox III · Oakdale, CAThe pilot's inadequate compensation for the crosswind conditions.NTSB WPR09MA159Accident · 14 fatalClass 1 · MajorFinal reportPilatus PC-12/45 · Butte, MT(1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…NTSB WPR09FA158Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Corona, CAThe pilot did not maintain airplane control during climb due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB ERA09CA207Accident · No injuriesData collectionFinal reportPiper PA28-151 · Dover, DEThe pilot's failure to maintain directional control during landing.NTSB WPR09LA153Accident · 1 fatalLimited investigationFinal reportHowes RV-6 · Paulden, AZA total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…NTSB CEN09LA238Accident · Serious injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Lakeville, MNThe instructor pilot’s failure to maintain directional control of the airplane, and the student pilot’s unintentional interference with the instructor’s rudder pedal during the go-around. Contributing to the accident was the cockpit design which allowed…NTSB ERA09LA200Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Gaithersburg, MDThe pilot’s spatial disorientation after the passenger door opened during flight in instrument meteorological conditions. Contributing to the accident was the pilot’s failure to properly secure the door latch.NTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB CEN09LA202Accident · Serious injuriesLimited investigationFinal reportHughes 269C · El Indio, TXThe pilot's failure to maintain control of the helicopter while attempting to land on a transport trailer in heavy rain and gusting winds.NTSB ERA09LA193Accident · 2 fatalLimited investigationFinal reportBurkholder Jimmy C Zodiac 601HD · Live Oak, FLThe pilot's loss of control of the airplane for undetermined reasons.NTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.NTSB CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.NTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.NTSB WPR09LA144Accident · Minor injuriesLimited investigationFinal reportMD Helicopter 369D · Trona, CAThe pilot's failure to maintain control while landing in a high density altitude environment due to a loss of tail rotor effectiveness.NTSB ERA09LA189Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Montauk, NYThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the instructor's delayed remedial action.NTSB CEN09LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Wood Lake, NEThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.NTSB CEN09CA186Accident · Minor injuriesData collectionFinal reportBeech A36 · Athens, TXThe non-certificated pilot's failure to maintain control during his unauthorized use of the airplane.NTSB WPR09FA141Accident · 1 fatalField investigationFinal reportStephenson Zodiac 601 XL · Antelope Island, UTThe in-flight failure of both wings due to aileron flutter. The aileron flutter was the result of inadequate wing stiffness and the lack of aileron counterbalances.NTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…NTSB WPR09LA130Accident · 1 fatalLimited investigationFinal reportToland S/Thornburgh J Twin 503SL · Torrance, CAThe passenger’s inadvertent activation of the engine throttle.NTSB WPR09CA131Accident · No injuriesData collectionFinal reportCessna TR182 · Amargosa Valley, NVThe pilot's failure to maintain adequate airspeed and runway alignment.NTSB ERA09LA173Accident · 1 fatalLimited investigationFinal reportHughes 369F · Moyock, NCThe flight instructor's failure to verify that the helicopter's skid was clear of an obstruction while demonstrating a one-skid and toe-in landing maneuver. Contributing to the accident was the flight instructor's decision to practice this maneuver at an…NTSB CEN09WA174Accident · 4 fatalClass 5 · ForeignCirrus Design SR 22 · Itzehoe, GermanyOn February 24, 2009, at 1600 coordinated universal time, a Cirrus Design Corporation SR22 , German registered D-EPDK, was destroyed when it impacted terrain under unknown circumstances near Itzehoe Germany. Visual meteorological conditions prevailed at the…NTSB CEN09LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Kelleys Island, OHThe pilot's failure to maintain aircraft control while landing in gusty winds due to inadequate aileron cable tension.NTSB ERA09FA169Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Deltona, FLThe pilot receiving instruction's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the flight instructor's inadequate supervision and both pilots'…