NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 NYC91LA192Accident · No injuriesLimited investigationFinal reportCessna 150M · Brookville, OHThe student pilot's improper flare and his improper recovery from the bounced landing.NTSB NYC91LA191Accident · No injuriesLimited investigationFinal reportBeech C-23 · Williamstown, MAEngine failure as a result of improper engine overhaul performed by other maintenance personnel. A factor was the lack of suitable terrain.NTSB NYC91LA190Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Thomasville, PAThe pilot's improper use of flight controls during the landing roll, which resulted in a loss of airplane control. Factors related to the accident were: the loose nose wheel shimmy dampener and the pilot's lack of flight experience in this make and model of…NTSB LAX91LA332Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Arizona City, AZFailure of the pilot to maintain an adequate visual outlook to avoid the collision with the power transmission lines. Contributing to the accident was the dark night light conditions that prevailed at the time of the accident.NTSB LAX91FA334Accident · 1 fatalField investigationFinal reportErcoupe 415C · Rubidoux, CAThe mechanic's improper installation of the magnetos and the pilot's failure to maintain flying speed. Factors related to this accident are the pilot's inadvertent stall and the residential area.NTSB LAX91FA333Accident · 3 fatalField investigationFinal reportPiper PA 28-181 · Sonora, CAFailure of the flight instructor/pilot-in-command to adequately supervise the flight and to maintain adequate airspeed by exceeding the climb performance of the airplane. Contributing to the accident was the pilot-in-command's inadequate planning and his…NTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.NTSB FTW91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heber Springs, ARThe pilot's touchdown at an improper point on the airstrip. A factor was the wet downsloping grass airstrip.NTSB FTW91DRG05Accident · 1 fatalFinal reportCessna 188B · Driscoll, TXThe pilot's failure to maintain clearance from the guy wire during the aerial application maneuver.NTSB FTW91DRD07Accident · No injuriesFinal reportGrumman G-164B · Donaldsonville, LAThe mechanical failure of the propeller blade pitch positioning bolt. A factor was the lack of suitable terrain available for the forced landing.NTSB DEN91LA105Accident · Minor injuriesLimited investigationFinal reportFink, Charles H. FIN-1 · Albuquerque, NMA failure of the throttle system which prevented the pilot from achieving sufficient power to maintain flight. A factor was: the rough terrain.NTSB CHI91DEC03Accident · 1 fatalFinal reportAL White Breezy AWY · Leslie, MIThe pilot's failure to adequately maintain control of the aircraft. A factor was the exessive descent rate.NTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.NTSB ATL91LA144Accident · No injuriesLimited investigationFinal reportBeech C24R · Morrisville, NCFailure of the left main landing gear uplock cylinder which precluded extension of the landing gear.NTSB ATL91LA143Accident · No injuriesLimited investigationFinal reportHinton Kitfox · Killen, ALWeather conditions conducive to carburetor icing. A factor was the lack of a carburetor heat system on the engine.NTSB ANC91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Palmer, AKThe pilot's failure to maintain airspeed and inadvertent stall during low level maneuvering flight. Contributing to the accident was the high terrain.NTSB SEA91LA194Accident · No injuriesLimited investigationFinal reportLet L-13 · Wallsburg, UTThe in flight encounter with downdraft winds and the lack of suitable terrain in the area for a landing.NTSB SEA91LA193Accident · No injuriesLimited investigationFinal reportBeech N35 · Hillsboro, ORFuel starvation due to the improper use of the fuel selector switch by the pilot and his failure to extend the landing gear for the forced landing.NTSB NYC91LA189Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Westfield, MAThe pilot's failure to refuel resulting in a power failure due to fuel exhaustion, and subsequent forced landing in unsuitable terrain.NTSB MIA91LA192Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Caribbean SeaImproper placement of the boost pump selector by the pilot in command, and electrical system failure for undetermined reasons. This resulted in the total loss of engine power due to fuel starvation.NTSB LAX91TL#08Accident · 1 fatalClass 3Final reportBell 206L-1 · Lake Alpine, CANTSB LAX91LA331Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Visalia, CAA loss of engine power due to the failure of the master rod to the number one cylinder resulting from a lack of oil.NTSB LAX91LA330Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Minden, NVThe pilot's failure to properly adjust the mixture setting prior to landing to ensure the continued operation of the engine.NTSB FTW91LA137Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Dfw Airport, TXThe captain of the other aircraft misjudged clearance between his aircraft and the standing commuter airplane. A factor was the failure by the second pilot of the other airplane to identify a hazardous condition.NTSB FTW91LA132Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Sealy, TXThe pilot's failure to maintain clearance from an object on approach.NTSB CHI91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sheboygan, WIThe pilot's failure to maintain aircraft control. Factors are the pilot's lack of total expereince, his inadequate recovery from the bounced landing and the crosswind condition.NTSB CHI91LA233Accident · 1 fatalLimited investigationFinal reportCessna 172P · Lansing, ILThe pilot's inadvertent stall/spin during low altitude maneuvers. Related factors are ground personnel's inadequate traffic advisory, and the pilot's abrupt pull up.NTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.NTSB BFO91LA075Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Warrenton, VAThe pilot's inadequate preflight operations, which failed to detect the presence of water contamination in the fuel system, and resulted in the loss of power and subsequent forced landing. Other related factor: standing water on the grassy area.NTSB MIA91LA191Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Hilliard, FLFailure of the pilot to maintain a proper glidepath during final approach resulting in the inflight collision with trees then the ground.NTSB CHI91LA231Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIA collision with wires after the glider overshot the landing area due to inadvertent lowering of the flaps and no use of spoilers.NTSB ATL91FA142Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Manteo, NCThe loss of left engine power for undetermined reasons, and the failure of the pilot to maintain minimum controllable airspeed, which resulted in the stalling of the airplane.NTSB ANC91LA109Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane on landing.NTSB LAX91TF#09Accident · No injuriesClass 3Final reportMBB BO-105 · Mercury, NVNTSB LAX91LA339Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Kahului, HIA non-mechanical loss of engine power due to fuel exhaustion and subsequent hard landing by the pilot. Contributing to the accident was a malfunctioning fuel low level indication system.NTSB LAX91FA329Accident · 4 fatalField investigationFinal reportBeech F33A · Earp, CAThe pilot's failure to maintain adequate airspeed, while maneuvering during a low pass, which resulted in a stall. A factor related to the accident was: lack of altitude to recover from the stall.NTSB FTW91LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Nashville, ARFuel starvation induced loss of power due to a blocked finger fuel strainer in the fuel servo unit. A factor was the unsuitable terrain at the pilot's disposal.NTSB FTW91DPJ03Accident · 2 fatalFinal reportGrimm Cavalier SA102.5 · Mcalester, OKThe pilot's attempted flight into IMC and his subsequent loss of control due to spatial disorientation.NTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.NTSB BFO91LA069Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ashland, KYLost of engine power for undetermined reasons.NTSB SEA91LA191Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hamer, IDThe pilot's failure to maintain runway aligment. Factors include high vegetation, and an inadverent ground loop/swerve.NTSB SEA91LA188Accident · No injuriesLimited investigationFinal reportWaco KNF · Wendover, UTPilot installed an improper 'o' ring which restricted normal landing gear extension and subsequent loss of control by the pilot.NTSB NYC91FA188Accident · Serious injuriesField investigationFinal reportCessna 172M · Phillips, MEAn inadvertent stall and loss of control due to the pilot's improper use of the wing flaps for takeoff. Factors related to the accident were: the pilot's misunderstanding of airplane performance, and the pilot's decision to takeoff uphill.NTSB LAX91LA328Accident · No injuriesLimited investigationFinal reportBeech 76 · Sacramento, CAA fatigue failure of the landing gear strut due to an inadequate design by the manufacturer. Contributing to the accident was maintenance personnel not having completed an inspection of the gear strut, in accordance with the manufacturer's service bulletin.NTSB LAX91LA327Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Reno, NVThe pilot's failure to maintain directional control of his airplane and his inadequate compensation for the crosswind condition. A contributing factor related to the presence of the crosswind.NTSB LAX91LA325Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAThe cfi's failure to initiate the go-around maneuver in a timely manner, and his failure to terminate the simulated emergency maneuver at a proper altitude. A contributing factor was the gusty surface wind.NTSB FTW91LA133Accident · No injuriesLimited investigationFinal reportCessna 150 · Searcy, ARThe pilots misjudgment of altitude and lack of a timely flare.NTSB FTW91LA126Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Provencal, LAFuel leakage from the fuel drain valve. A factor was the inaccessibility of suitable terrain for fored landing.NTSB FTW91DRG06Accident · 1 fatalFinal reportQuestair Venture · San Marcos, TXThe pilot's failure to maintain flying airspeed resulting in a stall.NTSB FTW91DPG17Accident · No injuriesFinal reportGrumman G-164 · Goodwin, ARThe failure of the right main landing gear.