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 SEA93LA111Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Walla Walla, WAThe premature landing flare by the pilot which resulted in a hard landing and the pilot's failure to maintain airspeed above stall speed during the balked landing.May 18, 1993 · N81829 · Substantial damageNTSB MIA93LA122Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Destin, FLThe pilot-in-command's failure to abort the takeoff roll, resulting in an on-ground loss of control, and on-ground collision with terrain. Contributing to the accident was the failure of the nose wheel steering cable.May 18, 1993 · N4579W · Substantial damageNTSB LAX93LA218Accident · No injuriesLimited investigationFinal reportBeech 36 · Hayward, CAfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to ensure that adequate fuel existed in the fuel tanks to be used.May 18, 1993 · N7687N · Substantial damageNTSB BFO93LA091Accident · No injuriesLimited investigationFinal reportCessna 172N · Petersburg, OHThe pilot's failure to attain the proper touchdown point while attempting to land on a wet grass strip, and his failure to perform a go around. The wet grass runway was a factor.May 18, 1993 · N7355E · Substantial damageNTSB SEA93LA109Accident · Minor injuriesLimited investigationFinal reportRainey Aero Phaeton · Mead, WAThe pilot in command's inadvertently entering a stall condition. A factor contributing to the accident was gusts.May 17, 1993 · N54BR · Substantial damageNTSB LAX93T#A03Accident · No injuriesClass 3Final reportBell 206 L3 · Daggett, CAMay 17, 1993 · N81427 · Substantial damageNTSB LAX93LA217Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jean, NV1) The pilots inadequate preflight inspection of the aircraft, 2) his failure to adequately compensate for the existing gusty wind conditions, and, 3) his failure to maintain an adequate landing approach airspeed. Contributing to the accident was the pilots…May 17, 1993 · N410DS · Substantial damageNTSB FTW93LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 680 · Marietta, OKThe pilot's inadequate visual lookout for obstructions on the runway and the airport operator's failure to ensure that animals could not enter the runway environmentMay 17, 1993 · N6244D · Substantial damageNTSB FTW93FA158Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Weatherford, TXTotal loss of engine power with cause undetermined. A factor was the lack of suitable terrain.May 17, 1993 · N4924Z · Substantial damageNTSB BFO93LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, KYThe pilot's inadequate preflight planning when determining his fuel load, which led to an exhaustion of the airplane's fuel supply.May 17, 1993 · N6943W · Substantial damageNTSB BFO93LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape May, NJThe pilot's failure to properly flare during landing, and his failure to properly recover from a bounced landing.May 17, 1993 · N5215Q · Substantial damageNTSB BFO93FA093Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Hancock, MDImproper planning/decision by the pilot, his initiation of VFR flt into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were fog, rain, the pilot's self induced…May 17, 1993 · N8247G · DestroyedNTSB ANC93LA065Accident · No injuriesLimited investigationFinal reportCessna 172K · Rohn Roadhouse, AKThe pilot in command's inadequate compensation for the wind conditions and allowing the airspeed to go below stalling speed in the landing configuration.May 17, 1993 · N736BY · Substantial damageNTSB ANC93LA063Accident · No injuriesLimited investigationFinal reportCessna 206 · Deadhorse, AKThe pilot's poor judgment in attempting to land under the existing high wind condition.May 17, 1993 · N734GW · Substantial damageNTSB ANC93FA064Accident · Serious injuriesField investigationFinal reportFairchild FH-1100 · Malina Bay, AKThe installation of a bogus transmission to engine driveshaft. The failure of the company maintenance personnel to comply with the service bulletins and letters was a factor.May 17, 1993 · N5060F · Substantial damageNTSB SEA93LA110Accident · No injuriesLimited investigationFinal reportCessna 210 · Palouse, WAThe pilot in command not maintaining directional control. A factor contributing to the accident was the control interference by the passenger.May 16, 1993 · N9421T · DestroyedNTSB SEA93LA108Accident · No injuriesLimited investigationFinal reportGrove GR-2 · Buckley, WAThe pilot's premature liftoff. The pilot's failure to maintain directional control and the high vegetation beside the runway were factors.May 16, 1993 · N84GR · DestroyedNTSB MIA93FA121Accident · 2 fatalField investigationFinal reportBell 47-G · Parker, FLthe misjudgement of the distance by the nonrated pilot-in-command and subsequent collision with a tree. Contributing to the accident was the lack of helicopter experience of the pilot-in-command.May 16, 1993 · N970B · DestroyedNTSB LAX93LA216Accident · No injuriesLimited investigationFinal reportGrumman American AA5 · Visalia, CAThe pilot's failure to see and avoid the wires due to alcohol impairment. A factor which contributed to the accident was unwarranted low flying over the river.May 16, 1993 · N9520L · DestroyedNTSB LAX93FA215Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe pilot prematurely raising the airplane's flaps at an airspeed insufficient to maintain flight which resulted in an inadvertent stall mush condition. A factor in this accident was the darkness of the night.May 16, 1993 · N26075 · No damageNTSB FTW93TA#04Accident · No injuriesFinal reportPiper PA-18-150 · Godley, TXMay 16, 1993 · N2520S · Substantial damageNTSB DEN93LA060Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Mead, COA failure by the pilot in command to compensate for wind conditions and maintain control of the helicopter. A factor was: unfavorable wind conditions.May 16, 1993 · N38Q · Substantial damageNTSB CHI93LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Plainwell, MIThe pilot-in-command's initiating hand starting of the airplane unattended by a qualified person.May 16, 1993 · N8657B · Substantial damageNTSB CHI93LA174Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Springport, MIA partial loss of engine power for undetermined reasons.May 16, 1993 · N35HM · Substantial damageNTSB CHI93DEP01Accident · No injuriesFinal reportBryant Mustang II · Kenosha, WIThe pilot-in-command's not maintaining control of the aircraft.May 16, 1993 · N90YP · DestroyedNTSB BFO93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Manassas, VAThe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel.May 16, 1993 · N5416T · Substantial damageNTSB BFO93LA089Accident · Serious injuriesLimited investigationFinal reportMeador Dragonfly SP · Hamilton, OHThe pilot's inadequate inspection of the fuel filter, which resulted in subsequent loss on engine power due to fuel contamination, and his failure to maintian adequate airspeed while maneuvering to land in an open field, which resulted on an inadvertent stall.May 16, 1993 · N32T · DestroyedNTSB ATL93LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Grandview, TNFailure of the aircraft battery.May 16, 1993 · N6231B · Substantial damageNTSB LAX93LA219Accident · No injuriesLimited investigationFinal reportCessna 182Q · Concord, CAThe passenger/dual student's improper recovery from a bounced landing, and the pilot's inadequate supervision of the flight.May 15, 1993 · N735HD · Substantial damageNTSB FTW93LA159Accident · No injuriesLimited investigationFinal reportCessna A188A · Decatur, TXThe pilot's failure to maintain adequate clearance. A factor was the turbulenceMay 15, 1993 · N9901G · DestroyedNTSB FTW93LA156Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARPilot's failure to maintain terrain clearance. A factor was the diverted attention of the pilot.May 15, 1993 · N6556 · Substantial damageNTSB DEN93LA062Accident · No injuriesLimited investigationFinal reportSchleicher ASH 25 E · Peyton, COThe encounter with a downdraft.May 15, 1993 · N555AB · Substantial damageNTSB DEN93LA059Accident · No injuriesLimited investigationFinal reportCessna 305A · Fort Collins, COAn excessive rate of descent resulting in a hard landing.May 15, 1993 · N5225G · Substantial damageNTSB CHI93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot's selection of unsuitable terrain on which to land and his excessive use of brakes.May 15, 1993 · N16686 · Substantial damageNTSB BFO93LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVFailure of the pilots to properly clear the engine during the approach.May 15, 1993 · N16224 · Substantial damageNTSB BFO93LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Norfolk, VAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was the unsuitable terrain.May 15, 1993 · N68910 · Substantial damageNTSB BFO93LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Bath, NYThe pilot did not attain the proper touchdown point and did not go around while there was still sufficient speed to do so. The wet runway grass was a related factor.May 15, 1993 · N21137 · Substantial damageNTSB FTW93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dougherty, TXFuel exhaustion power loss due to refueling not performed by the pilot. A factor was lack of suitable terrainMay 14, 1993 · N39663 · Substantial damageNTSB FTW93LA154Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Roseland, LAThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. The lack of suitable terrain for the forced landing was a factor in the accident.May 14, 1993 · N407CS · Substantial damageNTSB DEN93LA058Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fountain, COFailure of both the pilot in command and the safety pilot to relinquish control of the airplane. A factor was the pilot in command's failure to communicate with the safety pilot.May 14, 1993 · N29RP · DestroyedNTSB CHI93LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · West Chicago, ILThe pilot-in-command's inadequate compensation for the wind conditions he encountered during the landing approach and touchdown and not maintaining a proper descent rateMay 14, 1993 · N2947E · Substantial damageNTSB CHI93LA170Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Oconto, NEThe pilot's inability to maintain altitude after encountering a downdraft.May 14, 1993 · N4503U · DestroyedNTSB CHI93FA171Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hubbardston, MIThe pilot's failure to maintain airspeed due to alcohol impairment while maneuvering at low altitude.May 14, 1993 · N4563R · DestroyedNTSB SEA93LA107Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Cody, WYThe failure of the pilot to maintain directional control while hovering. Factors relating to the accident were the improper decision by the pilot, improper touchdown point selection, high density altitude, and wind gusts.May 13, 1993 · N14NH · Substantial damageNTSB DEN93LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Durango, COAn inadvertent stall. A factor was: downdrafts and the pilot's continued flight into known adverse weather.May 13, 1993 · N773JB · DestroyedNTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.May 13, 1993 · N10011 · Substantial damageNTSB BFO93LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Paintsville, KYFailure of the pilot to maintain adequate altitude or clearance from the terrain. Factors related to the accident were the unfavorable wind condition and the proximity of the hill to the runway.May 13, 1993 · N6001U · DestroyedNTSB ATL93LA092Accident · Minor injuriesLimited investigationFinal reportJones Lightning BUG 2 · Walterboro, SCThe disconnection of an elevator rod end fitting in flight, which disabled the elevatorMay 13, 1993 · N200NJ · DestroyedNTSB SEA93LA105Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Anatone, WAFatigue failure of the rotor transmission drive system, resulting from the improper certification/approval of the aircraft modification by the federal aviation administration.May 12, 1993 · N846D · DestroyedNTSB FTW93LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arnaudville, LAThe loss of engine power for undetermined reasons. A factor was the unsuitable terrainMay 12, 1993 · N6639Q · Substantial damage