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.

NTSB NYC91LA192Accident · No injuriesLimited investigationFinal reportCessna 150M · Brookville, OHThe student pilot's improper flare and his improper recovery from the bounced landing.Jul 28, 1991 · N9247U · Substantial damageNTSB 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.Jul 28, 1991 · N7690R · Substantial damageNTSB 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…Jul 28, 1991 · N2315P · Substantial damageNTSB 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.Jul 28, 1991 · N6681Q · DestroyedNTSB 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.Jul 28, 1991 · N94385 · DestroyedNTSB 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…Jul 28, 1991 · N82716 · DestroyedNTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.Jul 28, 1991 · N2801F · Minor damageNTSB 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.Jul 28, 1991 · N8233A · Substantial damageNTSB FTW91DRG05Accident · 1 fatalFinal reportCessna 188B · Driscoll, TXThe pilot's failure to maintain clearance from the guy wire during the aerial application maneuver.Jul 28, 1991 · N85987 · DestroyedNTSB 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.Jul 28, 1991 · N573AF · Substantial damageNTSB 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.Jul 28, 1991 · N1033Y · DestroyedNTSB 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.Jul 28, 1991 · N2AW · Substantial damageNTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.Jul 28, 1991 · N64022 · Substantial damageNTSB ATL91LA144Accident · No injuriesLimited investigationFinal reportBeech C24R · Morrisville, NCFailure of the left main landing gear uplock cylinder which precluded extension of the landing gear.Jul 28, 1991 · N6713P · Substantial damageNTSB 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.Jul 28, 1991 · N174PH · Substantial damageNTSB 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.Jul 28, 1991 · N7684H · Substantial damageNTSB 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.Jul 27, 1991 · N2NV · Substantial damageNTSB 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.Jul 27, 1991 · N9425Y · Substantial damageNTSB 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.Jul 27, 1991 · N62246 · Substantial damageNTSB 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.Jul 27, 1991 · N6088K · Substantial damageNTSB LAX91TL#08Accident · 1 fatalClass 3Final reportBell 206L-1 · Lake Alpine, CAJul 27, 1991 · N523RR · DestroyedNTSB 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.Jul 27, 1991 · N3087D · DestroyedNTSB 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.Jul 27, 1991 · N2037W · Substantial damageNTSB 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.Jul 27, 1991 · N491AA · 2 aircraft · Minor damageNTSB FTW91LA132Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Sealy, TXThe pilot's failure to maintain clearance from an object on approach.Jul 27, 1991 · N8514 · Substantial damageNTSB 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.Jul 27, 1991 · N4821G · Substantial damageNTSB 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.Jul 27, 1991 · N66365 · DestroyedNTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.Jul 27, 1991 · N14961 · Substantial damageNTSB 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.Jul 27, 1991 · N43494 · Substantial damageNTSB 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.Jul 26, 1991 · N31864 · Substantial damageNTSB 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.Jul 26, 1991 · N781BA · Substantial damageNTSB 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.Jul 26, 1991 · N54746 · DestroyedNTSB ANC91LA109Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane on landing.Jul 26, 1991 · N917VK · Substantial damageNTSB LAX91TF#09Accident · No injuriesClass 3Final reportMBB BO-105 · Mercury, NVJul 25, 1991 · N5EG · DestroyedNTSB 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.Jul 25, 1991 · N766MP · Substantial damageNTSB 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.Jul 25, 1991 · N3813U · DestroyedNTSB 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.Jul 25, 1991 · N8507P · Substantial damageNTSB 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.Jul 25, 1991 · N413P · DestroyedNTSB 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.Jul 25, 1991 · N28580 · Substantial damageNTSB BFO91LA069Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ashland, KYLost of engine power for undetermined reasons.Jul 25, 1991 · N8071 · Substantial damageNTSB 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.Jul 24, 1991 · N6702Q · Substantial damageNTSB 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.Jul 24, 1991 · NC698N · Substantial damageNTSB 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.Jul 24, 1991 · N85HC · DestroyedNTSB 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.Jul 24, 1991 · N6045M · Substantial damageNTSB 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.Jul 24, 1991 · N72JP · Substantial damageNTSB 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.Jul 24, 1991 · N5352D · Substantial damageNTSB FTW91LA133Accident · No injuriesLimited investigationFinal reportCessna 150 · Searcy, ARThe pilots misjudgment of altitude and lack of a timely flare.Jul 24, 1991 · N7655U · Substantial damageNTSB 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.Jul 24, 1991 · N3575 · Substantial damageNTSB FTW91DRG06Accident · 1 fatalFinal reportQuestair Venture · San Marcos, TXThe pilot's failure to maintain flying airspeed resulting in a stall.Jul 24, 1991 · N7PZ · DestroyedNTSB FTW91DPG17Accident · No injuriesFinal reportGrumman G-164 · Goodwin, ARThe failure of the right main landing gear.Jul 24, 1991 · N634U · Substantial damage