NTSB investigations
8,203 cases where the first occurrence was “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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 FTW96LA370Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Plains, TXfailure of the pilot to maintain control of the airplane, while maneuvering after a swath run, which subsequently resulted in a collision with the terrain. A factor relating to the accident was: the adverse wind condition (gusty wind and possible windshear).NTSB CHI96FA322Accident · 1 fatalField investigationFinal reportMankovich Sonerai · Jeffersonville, INinadequate maintenance and inspection of the airplane by the pilot/owner and other airframe and powerplant mechanics, which failed to assure adequate sealing of the engine firewall, and led to the pilot's incapacitation due to carbon monoxide.NTSB MIA96LA219Accident · Serious injuriesLimited investigationFinal reportFlightstar 2SL · Kiln, MSfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.NTSB CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.NTSB NYC96LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Rome, NYThe pilot's improper decision to take off on a runway of insufficient length, and his failure to obtain adequate airspeed.NTSB FTW96LA359Accident · Serious injuriesLimited investigationFinal reportFernandez Baby ACE D · New Raymer, COThe pilot's loss of control for reasons undetermined.NTSB IAD96LA140Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Frederick, MDthe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain.NTSB IAD96LA139Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Annapolis, MDfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall and subsequent collision with water.NTSB FTW96LA356Accident · No injuriesLimited investigationFinal reportBell 47 Soloy · Intracoastal, LAthe loss of aircraft control by unknown person(s).NTSB SEA96LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Sisters, ORinadequate preflight planning/preparation by the flight instructor (CFI), and his failure to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall. Excessive gross weight, high density altitude, and improper use of flaps were…NTSB CHI96LA312Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Urbana, ILthe pilot's failure to maintain airspeed. A factor was the diverted attention of the pilot.NTSB CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.NTSB FTW96LA353Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Hale Center, TXthe pilot's inadequate preflight planning/preparation and failure to obtain and/or maintain adequate airspeed after takeoff, which resulted in an inadvertent stall/mush. The overweight condition of the airplane and high density altitude were related factors.NTSB CHI96LA308Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Grosse Ile, MIimproper attachment of the flight control cables to the ailerons by the mechanic who performed the last annual inspection. A factor relating to this accident was the pilot's failure to perform an adequate check of the flight controls before takeoff.NTSB FTW96LA351Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Midland, TXfailure of the pilot to obtain or maintain adequate airspeed, by allowing the airplane to enter an excessive nose high attitude and an excessive rate of climb after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain. A…NTSB CHI96LA307Accident · No injuriesLimited investigationFinal reportCessna 180 · Duxbury, MNthe failure of the pilot to maintain airspeed.NTSB CHI96FA301Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Hinckley, ILthe instructor pilot exceeded the design stress limits of the aircraft which resulted in the overload failure of the wing. A factor was that the weight and balance of the aircraft was exceeded by the instructor pilot.NTSB IAD96FA136Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elkton, MDThe pilot's failure to maintain adequate altitude and control of the airplane while performing aerobatic maneuvers.NTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.NTSB LAX96LA306Accident · Minor injuriesLimited investigationFinal reportCessna 172Q · Kayenta, AZthe pilot's failure to adhere to the manufacturer's performance data by not maintaining the recommended best rate of climb speed, resulting in an inadvertent stall/mush event. The high density altitude was a related factor.NTSB CHI96LA297Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOthe improper recovery from a bounced landing by the pilot in command. Factors were the gusty wind conditions, and the failure of the pilot to maintain aircraft control.NTSB NYC96LA167Accident · No injuriesLimited investigationFinal reportBell 206B · Starks, MEthe pilot's improper decision to operate at slow airspeed, and close to the critical relative wind azimuth area in gusty, variable winds, which resulted in an inadvertent loss of tail rotor effectiveness. The gusty crosswind and lack of a suitable terrain for…NTSB SEA96FA186Accident · 1 fatalField investigationFinal reportLet L-13 · Shelton, WAfailure of the operator to provide its pilots with information essential for an accurate determination of the glider's weight and balance, the resultant operation of the glider with a center-or-gravity that exceeded the aft limit, and the pilot's inadvertent…NTSB IAD96FA132Accident · 3 fatalField investigationFinal reportCessna 172P · Summersville, WVThe pilot's improper flare, his delay in aborting a landing, and his failure to maintain adequate airspeed, which resulted in a bounced landing and a stall during climb out in an attempt to avoid collision with trees.NTSB FTW96FA339Accident · 1 fatalField investigationFinal reportBeech 23 · Wimberley, TXThe pilot's failure to maintain airspeed. Factors were the high density altitude, the tail wind, and the pilot's failure to adhere to the limitations prescribed by his flight instructor.NTSB FTW96LA340Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Hudson, COthe pilot's delay in initiating a go-around and failure to attain sufficient airspeed to clear obstructions at the departure end of the runway, which resulted in an inadvertent stall and collision with the ground. Factors relating to the accident were: the…NTSB CHI96LA287Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wellfleet, NEfailure of the pilot to maintain aircraft control, while maneuvering at low latitude. The hilly (rolling) terrain and unfavorable wind were related factors.NTSB SEA96LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Rexburg, IDthe pilot's failure to maintain directional control. Factors relating to the accident were: the pilot's failure to verify whether the flaps had raised, the resultant premature lift-off, and trees on the adjacent golf course.NTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.NTSB FTW96FA337Accident · 2 fatalField investigationFinal reportCulbertson Thorp T-18 · Albuquerque, NMthe pilot's failure to maintain control of the airplane while maneuvering. Factors were the high winds and the high density altitude.NTSB LAX96LA297Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Truckee, CAThe pilot's failure to properly compensate for a crosswind component during the go-around in a high density altitude environment that led to a loss of aircraft control..NTSB IAD96LA125Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHfailure of the student pilot to maintain sufficient airspeed during an attempted go-around, which resulted in a stall/spin and an uncontrolled collision with the ground. A factor related to the accident was: an improper (premature) flare for landing.NTSB NYC96LA161Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Pittsburgh, PAThe pilot's failure to maintain alignment with the runway, and his failure to maintain control of the airplane during the aborted landing, which resulted in the inadvertent stall/mush, and collision with the runway.NTSB CHI96LA269Accident · 1 fatalLimited investigationFinal reportVanwinkle Kitfox · Mt Vernon, ILfailure of the pilot to maintain control of the airplane.NTSB FTW96FA324Accident · 2 fatalField investigationFinal reportSlaybaugh Mustang II · Crested Butte, COThe pilot's failure to maintain aircraft control. A factor was the inadequatete altitude in which to effect a safe recovery.NTSB SEA96FA171Accident · 2 fatalField investigationFinal reportCessna 340A · Richland, WAThe pilot-in-command's allowing the aircraft's airspeed to decrease below the single-engine minimum control speed (Vmc) resulting in a stall/spin condition. Factors contributing to the accident were the pilot-in-command's allowing the left engine to be shut…NTSB FTW96LA320Accident · 2 fatalLimited investigationFinal reportQualline Hatz CB-1 · Pipe Creek, TXloss of aircraft control in flight for undetermined reason(s).NTSB CHI96LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Backus, MNthe pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.NTSB CHI96LA254Accident · No injuriesLimited investigationFinal reportCessna 150 · Dubuque, IAinadequate airspeed and the student pilot's failure to perform a recovery from the bounced landing. Factors associated with the accident were the crosswind and the student's over compensation for the crosswind.NTSB NYC96FA157Accident · 2 fatalField investigationFinal reportCessna 182P · Brewer, MEfailure of the pilot to maintain control of the airplane, during a missed approach, after diverting to an alternate destination, while on his first solo flight in instrument meteorological conditions (IMC).NTSB SEA96FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Yellow Pine, IDfailure of the pilot to maintain adequate airspeed, while maneuvering in mountainous terrain, which resulted in a stall/spin and collision with terrain.NTSB LAX96LA278Accident · 1 fatalLimited investigationFinal reportCessna 172 · Midas, NVthe decision of the pilot to perform a low-level steep turn which resulted in an inadvertent loss of control and subsequent stall/spin. Factors were high density altitude and inadequate altitude for recovery.NTSB CHI96LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Beltrami, MNthe pilot's inadequate preflight planning. Factors in the accident were the pilot's failure to jettison the load and the soft runway overrun area.NTSB CHI96LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Versailles, MOthe student pilot's failure to maintain airplane control during a go-around.NTSB ANC96FA099Accident · 1 fatalField investigationFinal reportRotorway Exec 90 · Anchorage, AKthe pilot's excessive control inputs and the lack of familiarity with the helicopter. A factor associated with the accident was the pilot's failure to follow the prescribed operating limitations.NTSB MIA96FA185Accident · 1 fatalField investigationFinal reportChampion Aeronca 7GCB · Fairhope, ALfailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in an inadvertent stall and uncontrolled impact with the water. The pilot's ostentatious display and the lack of altitude to recover from a stall were…NTSB IAD96LA118Accident · No injuriesLimited investigationFinal reportCessna 172 · Frederick, MDthe private pilot's inadvertently stalling the airplane immediately after takeoff. A related factor was the pilot's improper procedures during lift-off.NTSB CHI96LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lafeyette, INthe pilot's failure to maintain directional control during landing. Factors related to the accident were the pilot's inadequate compensation for the wind conditions and the crosswind.NTSB MIA96LA182Accident · Serious injuriesLimited investigationFinal reportTocholke 1300-Z MAX · Lascassas, TNfailure of the pilot to maintain adequate airspeed, while maneuvering (turning) after takeoff, which resulted in an inadvertent stall at too low of an altitude to allow recovery.NTSB IAD96LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Hartford, CTthe pilot's inadequate preflight planning/preparation, and his failure to attain the proper lift-off airspeed, which resulted in a stall and collision with the terrain (river).