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 ANC92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Funter Bay, AKThe pilot's attempted flight into known adverse weather.May 25, 1992 · N15950 · Substantial damageNTSB SEA92FA109Accident · 1 fatalField investigationFinal reportCessna 172L · Colburn, IDThe pilot became lost/disoriented, failed to maintain airspeed when he attempted to reverse course in a box canyon, and the aircraft stalled. Factors relating to the accident were the narrow box canyon, the high density altitude, and the lack of mountain…May 24, 1992 · N3988Q · DestroyedNTSB MIA92LA126Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Cross City, FLThe inadequate inspection for contamination of the aircraft fuel system after modification resulting in failure of the engine driven fuel pump due to contamination. Contributing to the accident was the improper modification of the fuel system which resulted…May 24, 1992 · N4547J · Substantial damageNTSB MIA92LA125Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Yulee, FLLoss of engine power due to undetermined reasons shortly after takeoff.May 24, 1992 · N7044M · Substantial damageNTSB LAX92LA215Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAThe pilot's failure to maintain directional control and improper use of the brakes.May 24, 1992 · N8412K · Substantial damageNTSB BFO92LA082Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 - S-66A · Southhampton, NJThe pilot used an excessive descent rate during landing. Contributing to the accident was an unfavorable wind condition.May 24, 1992 · N3604Y · No damageNTSB BFO92LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Saxonburg, PAThe pilot mismanaged the fuel supply, which resulted in fuel starvation and the lost of engine power.May 24, 1992 · N55733 · Substantial damageNTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.May 24, 1992 · N8102X · DestroyedNTSB ANC92LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Kahiltna Glacie, AKThe fracture of the landing gear wheel ski pivot shaft due to improper manufacture.May 24, 1992 · N124KT · Substantial damageNTSB ANC92LA077Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2-T · Alexander Creek, AKThe pilot's inadvertent deactivation of the engine's fuel supply by switching off the fuel shut off. Factor related to the accident was the soft mud in the forced landing area.May 24, 1992 · N4478 · Substantial damageNTSB SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.May 23, 1992 · N116DC · Substantial damageNTSB SEA92LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Spray, ORThe pilot's selection of unsuitable terrain for landing. Factors include soft and uneven terrain.May 23, 1992 · N61167 · Substantial damageNTSB LAX92LA216Accident · Minor injuriesLimited investigationFinal reportQuestair Venture · Ely, NVThe inadequate installation of the engine oil temperature/pressure transducer by the pilot/owner that resulted in a fatigue failure of the transducer mounting fitting in the engine oil system. The soft landing surface and the mountainous terrain in which the…May 23, 1992 · N3VD · Substantial damageNTSB FTW92LA143Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate terrain clearance. A factor was the loss of power as result of the uncoupling of the engine and the propeller.May 23, 1992 · N8380K · Substantial damageNTSB FTW92LA140Accident · Minor injuriesLimited investigationFinal reportArdovino Mariucci CRI-CRI MC-12 · Arlington, TXTotal power loss caused by blocked carburetor screen and ignition points open beyond manufacturer's specification. A factor was inadequate annual inspection and ignition point maintenance adjustment not performed.May 23, 1992 · N71AM · Substantial damageNTSB CHI92LA158Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Oshkosh, WIThe inadequate inspection by other maintenance personnel, and an inadequate preflight inspection by the pilot in command. A factor contributing to the accident was the reversal of the aileron cables.May 23, 1992 · N47373 · Substantial damageNTSB BFO92LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Coatesville, PAThe passengers interference with the control yoke, which resulted in the airplane entering an unusual attitude, and the pilot overstressing the wings during the recovery.May 23, 1992 · N733PG · Substantial damageNTSB BFO92LA072Accident · 1 fatalLimited investigationFinal reportPiper J3C · Camillus, NYThe pilot's failure to properly judge the ground clearance required to perform an aerobatic manuever.May 23, 1992 · N88070 · DestroyedNTSB ATL92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150E · N.Myrtle Beach, SCThe ostentatious display of the Piper cub's pilot caused the accident airplane's pilot to loose control and crash.May 23, 1992 · N6209R · DestroyedNTSB ATL92FA107Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Wetumpka, ALThe pilot's inadequate visual lookout, and his failure to maintain proper clearance from the transmission wires.May 23, 1992 · N62047 · Substantial damageNTSB ATL92FA106Accident · No injuriesField investigationFinal reportCessna 152 · Seale, ALA loss of engine power for undetermined reasons. A factor was the right seat pilot's selection of unsuitable terrain for the forced landing.May 23, 1992 · N49449 · Substantial damageNTSB ANC92LA076Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Birchwood, AKThe loss of engine power for undetermined reasons. A factor relating to the accident was the pilot's intentional ground loop.May 23, 1992 · N7869H · Substantial damageNTSB SEA92FA114Accident · 1 fatalField investigationFinal reportCessna 172B · Eatonville, WAUndetermined.May 22, 1992 · N7579X · DestroyedNTSB LAX92LA214Accident · No injuriesLimited investigationFinal reportCobb Intl Exec 90 · Glendale, AZThe improper carburetor idle adjustment by company maintenance personnel. Contributing to this accident was the cfi's inability to attain adequate RPM and the soft dirt.May 22, 1992 · N7656T · Substantial damageNTSB FTW92LA139Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-CD · Van, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.May 22, 1992 · N3454H · Substantial damageNTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.May 22, 1992 · N6349G · Substantial damageNTSB BFO92LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172N · St Francis, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The wind condition was a related factor.May 22, 1992 · N739GM · DestroyedNTSB ANC92LA081Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Bainbridge, AKCarburetor ice and the pilot's failure to follow procedure. A factor relating to the accident was the rough/uneven terrain in the forced landing area.May 22, 1992 · N3717M · Substantial damageNTSB ANC92LA075Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7CCM · Willow, AKThe complete failure of the connecting rod. Factors were the high vegetation and the pilot not maintaining a proper altitude to successfully complete a forced landing.May 22, 1992 · N82568 · DestroyedNTSB SEA92LA108Accident · No injuriesLimited investigationFinal reportCessna A188A · Redmond, ORProper clearance from objects was not maintained. Factors to the accident were: sunglare, wires, and visual lookout was not possible.May 21, 1992 · N9990G · Substantial damageNTSB SEA92FA113Accident · 4 fatalField investigationFinal reportCessna 177B · St. Ignatius, MTThe pilot in command's inadvertently allowing the aircraft to enter into a stall/spin. Factors contributing to the accident were: terrain condition, rising terrain, and the pilot in command's lack of familiarity with the geographic area.May 21, 1992 · N30922 · DestroyedNTSB LAX92LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · New Cuyama, CAThe loss of engine power for undetermined reasons. Contributing to this accident was the rough terrain.May 21, 1992 · N3170A · Substantial damageNTSB LAX92FA212Accident · 2 fatalField investigationFinal reportCessna 150 · Cottonwood, AZA failure of the student pilot to conduct an adequate pre-flight inspection to remove contaminated fuel; a failure to maintain adequate airspeed to prevent an inadvertent stall. Contributing to the accident was an inadequate annual inspection of the fuel…May 21, 1992 · N191P · DestroyedNTSB FTW92LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Des Arc, ARThe power loss due to the failed exhaust stack resultant from inadequate maintenance inspection. Factors were the lack of suitable terrain for the landing and the pilot's failure to maintain airspeed.May 21, 1992 · N7354Z · Substantial damageNTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.May 21, 1992 · N6989K · Substantial damageNTSB CHI92LA155Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dekalb, ILThe pilot not maintaining a proper glidepath to the landing runway.May 21, 1992 · N6510V · Substantial damageNTSB BFO92LA073Accident · No injuriesLimited investigationFinal reportCessna 172P · Poughkeepsie, NYThe pilot failed to maintain directional control.May 21, 1992 · N97154 · Substantial damageNTSB BFO92LA071Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Turner, METhe pilot's inadequate flare which resulted in a hard landing. Contributing to the accident was the soft terrain.May 21, 1992 · N9446G · Substantial damageNTSB BFO92LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Morrisville, VTThe pilot's failure to maintain clearance with the terrain. Contributing to the accident was a dark night and the lack of familiarity with the geographic area.May 21, 1992 · N2950K · DestroyedNTSB ANC92LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mcgrath, AKThe pilot's failure to maintain directional control, and his inadequate remedial action.May 21, 1992 · N6840B · Substantial damageNTSB SEA92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Big Timber, MTAirspeed was not maintained. Factors to the accident were: no thermal lift and inadequate remedial action.May 20, 1992 · N2739H · Substantial damageNTSB FTW92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Port Sulphur, LAThe pilot planned the approach with a tailwind and did not attain the proper touchdown point. Factors were the tailwind and the delayed aborted landing.May 20, 1992 · N735SW · Substantial damageNTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.May 20, 1992 · N18244 · Substantial damageNTSB CHI92LA154Accident · 1 fatalLimited investigationFinal reportCessna 150H · Robinson, ILPoor judgement by the pilot in intentionally proceeding to the airport in instrument meteorological conditions. The weather conditions were a factor.May 20, 1992 · N7200S · Substantial damageNTSB CHI92DEX01Accident · No injuriesFinal reportJames D. Bierly VARI-EZ · Jeffersonville, INA collapsed carburetor air intake duct. Factors related to the accident were soft, unsuitable terrain on which to make a forced landing.May 20, 1992 · N64SJ · Substantial damageNTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.May 20, 1992 · N5519S · DestroyedNTSB LAX92FA211Accident · 2 fatalField investigationFinal reportTaylorcraft BL · Chandler, AZAn excessive pull-up during departure and a failure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing to the accident was continued flight operations with known airworthiness deficiencies.May 19, 1992 · N26535 · Substantial damageNTSB FTW92FA133Accident · No injuriesField investigationFinal reportCessna 310K · Carswell Afb, TXLoss of power to both engines from fuel starvation and the improper selector positions of fuel tanks by the pilot. A factor was the pilot's failure to feather the propellers.May 19, 1992 · N6980L · Substantial damageNTSB CHI92LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Climax Springs, MODelay in aborting the landing by the pilot in command.May 19, 1992 · N80255 · Substantial damageNTSB CHI92DEC01Accident · No injuriesFinal reportCessna 188A · Imlay City, MIThe pilot induced premature liftoff which resulted in inadequate airspeed and the resulting stall.May 19, 1992 · N9946G · Destroyed