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 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.NTSB ANC92LA093Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKFailure to maintain directional control. Factors include tailwheel vibration/shimmy, and an inadvertent ground loop.NTSB SEA92LA128Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seattle, WAThe pilot's failure to follow procedures. A factor to the accident was: diverted attention.NTSB SEA92LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mccall, IDThe pilot's poorly planned approach which resulted in a long landing and overrun of the runway.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Troy, MIThe pilot's failure to maintain control of the airplane.NTSB 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…NTSB 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…NTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC92LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Wauseon, OHThe pilot improperly used the brakes, resulting in the airplane nosing over.NTSB 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.NTSB FTW92DRD03Accident · No injuriesFinal reportAir Tractor AT-502 · Kaplan, LAThe pilot's failure to lower flaps to the takeoff position.NTSB 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.NTSB CHI92LA178Accident · No injuriesLimited investigationFinal reportCessna 150L · Colby, KSA jammed exhaust valve in the number one cylinder of the engine assembly.NTSB 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.NTSB 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.NTSB ANC92LA091Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Memory Lake, AKFuel exhaustion. Factors include inadequate preflight planning, lack of familiarity with the aircraft, and unsuitable terrain.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB FTW92LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rector, ARThe pilot's premature liftoff.NTSB FTW92LA155Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Morgan City, LAThe second pilot's failure to maintain aircraft control.NTSB 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.NTSB FTW92DPG03Accident · Serious injuriesFinal reportMclaughlin KIT FOX Model 2 · Jonesboro, ARThe inadvertent stall of the airplane.NTSB 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.NTSB CHI92LA179Accident · No injuriesLimited investigationFinal reportCessna 210B · Belleville, ILThe improper fuel pump high end discharge adjustment. A related factor is improper maintenance/annual inspection.NTSB 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.NTSB CHI92LA172Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILThe pilot's improper approach to landing. Related factors are the thunderstorm and the excessive airspeed.NTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.NTSB ATL92LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ft. Gaines, GAThe pilot's inadequate preflight planning/preparation.NTSB 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.NTSB NYC92LA113Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hadley, MAA power loss of undetermined origin while operating over unsuitable terrain.NTSB 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…NTSB 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…NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.NTSB 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.NTSB 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.