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 LAX97GA105Accident · 1 fatalFinal reportMcDonnell Douglas 369D · Santee, CASpatial disorientation and temporary visual impairment that led to a loss of aircraft control as result of difficulty to light adaptivity. Contributing was the crew coordination and inadequate night flight recurrency training.NTSB FTW97LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172M · San Antonio, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A factor was the pilot's lack of recent experience.NTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).NTSB MIA97LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Homosassa, FLthe unqualified person's poor judgment, by taking the helicopter without the owner's permission and attempting an unauthorized flight at night; and his failure (or inability) to maintain control the helicopter. Darkness was a related factor.NTSB ANC97FA026Accident · 1 fatalField investigationFinal reportPiper PA-18 · Circle, AKinadequate preflight by the pilot; and his subsequent loss of aircraft control, during the initial climb after takeoff. Factors relating to the accident were: the pilot failed to ensure that the cargo was properly secured, and he allowed the aircraft's weight…NTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.NTSB SEA97LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Moorcroft, WYThe pilot's failure to maintain adequate airspeed. A factor was the pilot's low altitude flight and maneuvering.NTSB MIA97LA081Accident · Serious injuriesLimited investigationFinal reportCessna A150L · St. Mary'S, GAthe pilot's failure to maintain airspeed which resulted in an inadvertent stall the at too low an altitude to allow recovery. A factor in this accident was the pilot's attention was diverted.NTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.NTSB FTW97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brownsville, TXThe pilot's delayed go-around and subsequent inadvertent stall. A factor was the gusty winds.NTSB MIA97LA073Accident · 1 fatalLimited investigationFinal reportCress Cress B-8-M (Bensen) · Williston, FLfailure of the pilot to maintain rotor rpm, while maneuvering, which resulted in an uncontrolled descent and collision with terrain.NTSB NYC97LA044Accident · Serious injuriesLimited investigationFinal reportMooney 20F · Jaffrey, NHThe pilot's failure to maintain aircraft control during a go around attempt, which resulted in a loss of control and collision with trees.NTSB IAD97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Alton, NHAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.NTSB MIA97LA061Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lincolnton, NCThe student pilot's improper use of flaps and failure to maintain airspeed during a go-around.NTSB IAD97LA041Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blue Bell, PAthe pilot's inadequate handling of the airplane and failure to maintain adequate airspeed, which resulted in a stall, and collision with the ground.NTSB DCA97MA017Accident · 29 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Monroe, MIThe Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…NTSB SEA97FA044Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Winston, MTPilot incapacitation due to hypoxia. Failure of the pilot to use available oxygen is a factor.NTSB FTW97LA079Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Wellington, COThe pilot's failure to maintain control of the aircraft and his improper autorotation technique that induced the roll and subsequent ground collision. A factor was his lack of recurrent training.NTSB SEA97FA041Accident · 5 fatalField investigationFinal reportCessna P210N · Cambridge, IDthe pilot's failure to maintain control of the aircraft. Flight into adverse weather and turbulence were factors.NTSB MIA97LA052Accident · 1 fatalLimited investigationFinal reportSirocco Flying Club MJ 5 · Sanford, FLfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern (crosswind) after takeoff, which resulted in an inadvertent stall, uncontrolled descent, and collision with terrain.NTSB NYC97LA039Accident · No injuriesLimited investigationFinal reportCessna 150D · Catawba Valley, VAthe pilot's improper planning/decision, and his failure to attain adequate airspeed, which resulted in a stall after takeoff and collision with ground. Factors relating to the accident were: the pilot's use of inadequate terrain for takeoff, high vegetation…NTSB ATL97FA029Accident · 2 fatalField investigationFinal reportMooney M20C · Roxboro, NCfailure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: the pilot's use of an unapproved drug, low ceiling, restricted visibility (fog), and an undetermined anomaly with the vacuum system.NTSB IAD97LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Manville, NJThe pilot's failure to perform a go-around, and his failure to retract the flaps in increments.NTSB NYC97LA037Accident · 1 fatalLimited investigationFinal reportRichardson Kitfox 4 · Trenton, MEfailure of the pilot to maintain adequate airspeed while maneuvering after takeoff, which resulted in a stall/spin and an uncontrolled descent into terrain. The airplane's excessive gross weight was a related factor.NTSB MIA97LA048Accident · No injuriesLimited investigationFinal reportKelly Rans S-12 · Jacksonville, FLfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in a stall/mush and collision with trees.NTSB LAX97FA070Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Lucerne Valley, CAthe pilot's failure to maintain an adequate airspeed after encountering turbulence, low level wind shear, and an open door.NTSB DCA97MA016Accident · 6 fatalClass 1 · MajorFinal reportDouglas DC-8-63F · Narrows, VAthe inappropriate control inputs applied by the flying pilot during a stall recovery attempt, the failure of the nonflying pilot-in-command to recognize, address, and correct these inappropriate control inputs, and the failure of ABX to establish a formal…NTSB SEA97FA037Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Eagle Point, ORThe failure of the first pilot (flight instructor) to initiate proper aircraft control, and his failure to perform the adequate remedial action to recover from an intentional inverted spin.NTSB ANC97LA014Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with terrain (water). A factor associated with the accident was the gusty wind condition.NTSB FTW97LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Broomfield, COfailure of the pilot to maintain proper alignment with the runway, while landing. A factor relating to the accident was: the variable/gusty wind condition with possible windshear.NTSB NYC97LA026Accident · 1 fatalLimited investigationFinal reportParker Mustang · Port Norris, NJThe student pilot's failure to maintain adequate airspeed.NTSB MIA97FA034Accident · 2 fatalField investigationFinal reportBeech D-45 · Poplarville, MSthe noninstrument-rated pilot's intentional operation of the airplane with known deficiencies in equipment (inoperative attitude indicator and directional gyro) with an estimated time of arrival after official twilight. Also, poor in-flight planning decision…NTSB FTW97LA056Accident · No injuriesLimited investigationFinal reportBeech A23 · Conway, ARthe pilot's inadequate compensation for the crosswind during the landing, and his failure to remain clear of the tree during the attempted go-around. The crosswind and the proximity of the small tree were related factors.NTSB CHI97LA040Accident · No injuriesLimited investigationFinal reportBeech B55 · Park Rapids, MNthe pilot's high flare. Factors were the icing weather condition and the airframe ice.NTSB LAX97FA059Accident · 3 fatalField investigationFinal reportMorane-Saulnier MS760 II · Irvine, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering in a steep banked turn to the landing runway, which resulted in an inadvertent stall/spin. Factors in the accident were: the pilot's inadequate preflight inspection of the aircraft…NTSB ANC97FA009Accident · 2 fatalField investigationFinal reportCessna 185 · Marshall, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and collision with the terrain.NTSB IAD97LA026Accident · Serious injuriesLimited investigationFinal reportCessna 205 · Columbia, PAThe pilot's failure to obtain/maintain airspeed, which resulted in an inadvertent stall, and collision with trees during the initial climb. A factor in the accident was a tailwind condition.NTSB LAX97FA049Accident · 1 fatalField investigationFinal reportBeech 95-C55 · San Diego, CAthe pilot's lack of situational awareness (becoming lost/disoriented during the approach), his failure to fly the approach as charted, and his failure to maintain aircraft control, while attempting an abrupt turn toward the airport, which led to an…NTSB LAX97FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Lost Hills, CAThe pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…NTSB SEA97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper in-flight planning/decision, which allowed his aircraft to encounter wake turbulence from a Lear Jet, and/or the student allowed the aircraft to stall. The crosswind component from the quartering headwind was a possible factor.NTSB LAX97FA046Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Goleta, CAfailure of the pilot to maintain control of the aircraft during an instrument approach, due to spatial disorientation, and/or his failure to maintain proper altitude. Factors relating to the accident were: the pilot's delay (or failure) to initiate a missed…NTSB SEA97LA029Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Ballston, ORa loss of control for undetermined reasons.NTSB IAD97FA022Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · West Milton, OHThe pilot's inability to maintain aircraft control after an undetermined failure of the automatic flight control. A contributing factor was failure of the maintenance technician to have the airplane test flown prior to release.NTSB FTW97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Manvel, TXLoss of aircraft control due to the pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB LAX97FA036Accident · 1 fatalField investigationFinal reportCessna 310I · Van Nuys, CAThe pilot's failure to maintain a climb following initiation of a missed approach in fog due to spatial disorientation, and his inadequate training by company personnel. Potential rescue was delayed due to the FAA radar controller's failure to follow…NTSB CHI97FA025Accident · 3 fatalField investigationFinal reportEnstrom F28F · Gutherie, ILthe pilot's inadequate preflight preparation and not maintaining control of the helicopter during its rearward flight. A factor was the pilot's over-confidence in his personal ability.NTSB MIA97FA020Accident · 3 fatalField investigationFinal reportPiper PA-60-600 · New Bern, NCthe pilot's failure to maintain airspeed (VMC). Contributing to the accident was his lack of total experience in kind of aircraft.NTSB CHI97FA024Accident · 1 fatalField investigationFinal reportCessna 177B · Chancellor, SDthe pilot's attempted flight with known deficiencies in equipment, his initiating VFR flight into IMC conditions, his spatial disorientation and loss of control of the airplane. Factors were fog, dark night, and inoperative directional gyro.NTSB IAD97LA015Accident · No injuriesLimited investigationFinal reportAyres Scorpion Executive · Union Vale, NYthe pilot's failure to maintain control of the helicopter, which resulted in a subsequent emergency landing and collision with a fence and a cherry picker (vehicle). A factor relating to the accident was: the student pilot's lack of experience in the type…