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 FTW92LA164Accident · No injuriesLimited investigationFinal reportCessna 320D · Aztec, NMFailure of the right propeller to feather and inoperative gear retraction system. Factors were the high density altitude and the power loss due to connecting rod failure.Jun 18, 1992 · N3307Q · Substantial damageNTSB ANC92LA093Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKFailure to maintain directional control. Factors include tailwheel vibration/shimmy, and an inadvertent ground loop.Jun 18, 1992 · N125KT · Substantial damageNTSB SEA92LA128Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seattle, WAThe pilot's failure to follow procedures. A factor to the accident was: diverted attention.Jun 17, 1992 · CGRJA · Substantial damageNTSB SEA92LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mccall, IDThe pilot's poorly planned approach which resulted in a long landing and overrun of the runway.Jun 17, 1992 · N95710 · Substantial damageNTSB MIA92LA139Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau 300 · Titusville, FLSeparation of the propeller governor cover from the body for undetermined reasons and visual restriction of the pilot due to leaking oil which covered the windscreen.Jun 17, 1992 · N300XL · Substantial damageNTSB FTW92FA163Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Bethany, OKThe pilot's failure to maintain control which resulted in an inadvertent stall. The gusty wind was a factor.Jun 17, 1992 · N7419J · DestroyedNTSB DEN92FA060Accident · 1 fatalField investigationFinal reportBeech V35B · Tulsa, OKAircraft climb performance exceeded. Factors were: aircraft gross weight exceeded, grass runway selected, takeoff flaps not used, and premature rotation.Jun 17, 1992 · N4567S · DestroyedNTSB CHI92LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Wichita, KSA loss of directional control and remedial action not performed by the pilot. Factors related to this accident were a swerve encountered by the pilot and the pilot's lack of overall experience.Jun 17, 1992 · N7867U · Substantial damageNTSB CHI92LA181Accident · No injuriesLimited investigationFinal reportNorth American NA-265-50 · Cedar Rapids, IAThe pilot-in-command's selection of the wrong runway for landing. A factor was the tailwind.Jun 17, 1992 · N50CR · Substantial damageNTSB CHI92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Catherine, KSThe pilot's inadequate preflight planning. Factors associated with this accident were unsuitable terrain selected by the pilot and airplane clearance over the fence not attained by the pilot.Jun 17, 1992 · N2363K · Substantial damageNTSB CHI92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Troy, MIThe pilot's failure to maintain control of the airplane.Jun 17, 1992 · N429HD · DestroyedNTSB NYC92LA119Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Felton, PAA precautionary landing in unsuitable terrain. An additional cause was the failure of the mechanic to tighten the oil return line on the number three cylinder. A factor related to the accident was the pressure the mechanic felt to complete the job in a timely…Jun 16, 1992 · N21RE · Substantial damageNTSB NYC92FA118Accident · 4 fatalField investigationFinal reportBeech BE-200 · New Castle, DEThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in a loss of airspeed and subsequent stall at an altitude too low for recovery. A factor related to the accident was the fatigue failure of a compressor turbine…Jun 16, 1992 · N32HG · DestroyedNTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.Jun 16, 1992 · N1041B · DestroyedNTSB LAX92LA251Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Big Bear Lake, CAThe lose of engine power for undetermined reasons. The mountainous road on which the pilot attempted to land and the two motor vehicles that were on the road were factors in the accident.Jun 16, 1992 · N7133E · Substantial damageNTSB LAX92LA250Accident · No injuriesLimited investigationFinal reportBeech A-23 · Willows, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot misjudged the flare altitude and failed to maintain the proper airspeed.Jun 16, 1992 · N1482L · Substantial damageNTSB LAX92LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · El Monte, CAThe student pilot's failure to maintain directional control and improper use of the brakes.Jun 16, 1992 · N9279Y · Substantial damageNTSB CHI92DCA02Accident · No injuriesFinal reportCessna 188B · Risco, MOThe pilot in commands failure to maintain directional control of the airplane during the aborted takeoff. The pilot's inadequate evaluation of the wind was a factor.Jun 16, 1992 · N731GX · Substantial damageNTSB ANC92LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Elmendorf Afb, AKThe pilot's failure to maintain directional control. Factors contributing to the accident were his psychological condition.Jun 16, 1992 · N96082 · Substantial damageNTSB SEA92LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · W. Yellowstone, MTA stall/mush encountered due to poor pre-flight planning/preparation. Factors to the accident were: high density altitude and gross weight exceeded.Jun 15, 1992 · N2839R · Substantial damageNTSB NYC92LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Wauseon, OHThe pilot improperly used the brakes, resulting in the airplane nosing over.Jun 15, 1992 · N76009 · Substantial damageNTSB LAX92FA247Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Boulder City, NVThe instructor pilot's inadequate supervision of the student pilot to insure the proper flap setting for takeoff which resulted in the proper climb rate not being attained. Contributing to the accident was rising terrain.Jun 15, 1992 · N2516D · DestroyedNTSB FTW92DRD03Accident · No injuriesFinal reportAir Tractor AT-502 · Kaplan, LAThe pilot's failure to lower flaps to the takeoff position.Jun 15, 1992 · N45383 · Substantial damageNTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.Jun 15, 1992 · N8285K · DestroyedNTSB CHI92LA178Accident · No injuriesLimited investigationFinal reportCessna 150L · Colby, KSA jammed exhaust valve in the number one cylinder of the engine assembly.Jun 15, 1992 · N19317 · Substantial damageNTSB ATL92FA126Accident · No injuriesField investigationFinal reportAerospatiale AS-355-F · Fort Bragg, NCThe total blockage of the oil supply line for the rear main bearing in engine module three which resulted in the failure of the bearing, and the subsequent leak from the engine start drain valve.Jun 15, 1992 · N365DU · Substantial damageNTSB ANC92LA094Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Oshetna River, AKThe tailwind and the pilot not understanding the effects. Factors relating to the accident were the attempted precautionary landing and the high vegetation in the forced landing area.Jun 15, 1992 · N3516P · DestroyedNTSB ANC92LA091Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Memory Lake, AKFuel exhaustion. Factors include inadequate preflight planning, lack of familiarity with the aircraft, and unsuitable terrain.Jun 15, 1992 · N1480H · Substantial damageNTSB SEA92LA126Accident · No injuriesLimited investigationFinal reportBeech K35 · Sula, MTPoor inflight planning/decision. Factors to the accident were: delayed remedial action, a white out weather condition and inadequate clearance.Jun 14, 1992 · N212M · Substantial damageNTSB NYC92LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Elkton, MDThe pilot's failure to maintain the proper climb attitude which resulted in an aerodynamic stall. Factors in this accident were: the airplane weight and balance was exceeded, the pilot's lack of total experience in the type of airplane, and his lack of recent…Jun 14, 1992 · N2326K · Substantial damageNTSB LAX92LA245Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Hanford, CAThe pilot's failure to maintain rotor RPM during the takeoff. Contributing factors were: the pilot's lack of familiarity with the aircraft and unfavorable winds that existed at the time of takeoff.Jun 14, 1992 · N159Q · Substantial damageNTSB FTW92LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Walnut Ridge, ARThe inadvertent ground loop. A factor was the pilots total lack of experience in type airplane.Jun 14, 1992 · N3711P · Substantial damageNTSB FTW92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Danbury, TXThe failure of the landing gear skid due to internal corrosion. A factor was the soft ground.Jun 14, 1992 · N6746D · Substantial damageNTSB FTW92LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rector, ARThe pilot's premature liftoff.Jun 14, 1992 · N15424 · Substantial damageNTSB FTW92LA155Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Morgan City, LAThe second pilot's failure to maintain aircraft control.Jun 14, 1992 · N2620 · Substantial damageNTSB FTW92DRD02Accident · No injuriesFinal reportGuzzino, P.A. Rotorway Exec · Iowa, LAThe non helicopter rated pilot's failure to maintain directional control during an attempted precautionary landing. A factor was the pilots total lack of experience in helicopters.Jun 14, 1992 · UNREG · Substantial damageNTSB FTW92DPG03Accident · Serious injuriesFinal reportMclaughlin KIT FOX Model 2 · Jonesboro, ARThe inadvertent stall of the airplane.Jun 14, 1992 · N626KF · DestroyedNTSB DEN92LA059Accident · No injuriesLimited investigationFinal reportCessna 177RG · Gunnison, COThe pilot's failure to maintain directional control. Factor(s) included: fuel exhaustion and the misjudging of fuel consumption calculations.Jun 14, 1992 · N52658 · Substantial damageNTSB CHI92LA179Accident · No injuriesLimited investigationFinal reportCessna 210B · Belleville, ILThe improper fuel pump high end discharge adjustment. A related factor is improper maintenance/annual inspection.Jun 14, 1992 · N9545X · Substantial damageNTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.Jun 14, 1992 · N56311 · Substantial damageNTSB CHI92LA172Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILThe pilot's improper approach to landing. Related factors are the thunderstorm and the excessive airspeed.Jun 14, 1992 · N62538 · Substantial damageNTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.Jun 14, 1992 · N97883 · Substantial damageNTSB ATL92LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ft. Gaines, GAThe pilot's inadequate preflight planning/preparation.Jun 14, 1992 · N7357 · Substantial damageNTSB NYC92LA125Accident · Minor injuriesLimited investigationFinal reportBeech 33A · Farmingdale, NJThe pilot's improper recovery from a bounced landing which resulted in collapsing of the nose gear. A factor in the accident was gusting cross winds.Jun 13, 1992 · N17818 · Substantial damageNTSB NYC92LA113Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hadley, MAA power loss of undetermined origin while operating over unsuitable terrain.Jun 13, 1992 · N5220X · Substantial damageNTSB NYC92LA112Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indian Head, MDThe pilot improperly compensated for the wind conditions and lost control of the airplane after touchdown which resulted in the airplane departing the runway. An additional cause of the accident was, the delayed remedial action on the part of the flight…Jun 13, 1992 · N7958Y · Substantial damageNTSB NYC92LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Lewisburg, WVThe failure of the instructor pilot to take proper remedial action during a takeoff resulting in a loss of airplane control and subsequent inadvertant stall. Factors related to the accident were the instructor's lack of total, recent and instructional flight…Jun 13, 1992 · N5506K · Substantial damageNTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.Jun 13, 1992 · N3117 · Substantial damageNTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jun 13, 1992 · N7979H · Substantial damageNTSB MIA92LA137Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Atlantic Ocean (Atlantic Ocean)For undetermined reason(s), the right engine failed and the right propeller would not feather.Jun 13, 1992 · N402PB · Substantial damage