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 BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.Sep 22, 1993 · N8081A · Substantial damageNTSB ANC93IA183Incident · No injuriesIncident investigationFinal reportCessna 180C · Anchorage, AKA frayed fuel hose.Sep 22, 1993 · N9211T · Minor damageNTSB LAX93LA364Accident · No injuriesLimited investigationFinal reportMcinroy DER Jager DIX · Hesperia, CAFailure of the pilot to lean the aircraft's fuel mixture for the airport's density altitude.Sep 21, 1993 · N16RM · Substantial damageNTSB LAX93LA362Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Twentynine Palm, CAThe pilot's attemted takeoff from a taxiway due to alcoholic impairment. The night light condition was a factor.Sep 21, 1993 · N93321 · Substantial damageNTSB CHI93LA374Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot-in-command's failure to maintain airspeed. Factors were his lack of total experience and his premature retraction of the flaps.Sep 21, 1993 · N757MT · Substantial damageNTSB CHI93LA371Accident · No injuriesLimited investigationFinal reportPiper PA-60-601 · Lone Rock, WIInadequate maintenance and excessive airspeed during the landing approach.Sep 21, 1993 · N9825Q · Substantial damageNTSB CHI93IA372Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Indianapolis, INan undetermined problem which resulted in the physical impairment of flight attendants, passengers and the first officer.Sep 21, 1993 · N527AU · No damageNTSB ANC93LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Pumice Creek, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors were the pilot misjudged the wind information, and the unfavorable wind.Sep 21, 1993 · N4563B · Substantial damageNTSB SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.Sep 20, 1993 · N61043 · Substantial damageNTSB SEA93FA206Accident · 1 fatalField investigationFinal reportCessna 180B · Mullan, IDThe pilot's poor in flight decision, and his inadvertent continuation of a VFR flight into instrument meteorological conditions. Factors include low ceilings, snow, fog, rain, and mountainous/hilly terrain.Sep 20, 1993 · N985DB · DestroyedNTSB LAX93LA361Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Buttonwillow, CAThe pilot's failure to avoid wires.Sep 20, 1993 · N8133K · Substantial damageNTSB LAX93LA359Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Hawthorne, CAdual student's failure to maintain directional control and improper use of the rudder and the CFI's inadequate supervision of the flight.Sep 20, 1993 · N88EW · Substantial damageNTSB LAX93FA360Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Pine Mountain, CAThe pilot in command did not maintain adequate clearance with the terrain. Factors in this accident were: the dark night, and the poor in flight planning and decision making by the pilot.Sep 20, 1993 · N9778Y · DestroyedNTSB CHI93LA375Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Spencer, IAthe pilot's to switch fuel tanks which resulted in fuel starvation. A factor related to the accident was the rough terrain on which the airplane was landed.Sep 20, 1993 · N5309Y · Substantial damageNTSB CHI93LA373Accident · No injuriesLimited investigationFinal reportBeech 18-C45G · Jeffersonville, INthe mechanical binding of the landing gear extension mechanism.Sep 20, 1993 · N80323 · Substantial damageNTSB ANC93LA187Accident · No injuriesLimited investigationFinal reportCessna 180A · Charlie Lake, AKThe pilot delayed his decision to abort the takeoff, and did not follow the standard procedures/directives for the aborted takeoff. Factors were the pilot's improper preflight planning/decision, and the rough/uneven terrain.Sep 20, 1993 · N9600B · Substantial damageNTSB ANC93LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot failed to adequately compensate for the wind conditions. A factor was the unfavorable wind.Sep 20, 1993 · N6721L · Substantial damageNTSB SEA93LA204Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot's failure to maintain the proper airspeed and glidepath.Sep 19, 1993 · N3117Y · Substantial damageNTSB MIA93FA198Accident · 3 fatalField investigationFinal reportSocata TB 10 · Aguadilla, PRIn flight encounter with a level ii thunderstorm and flight into known advese weather by the pilot in command. Contributing to the accident was failure of the pilot in command to obtain a preflight weather briefing.Sep 19, 1993 · N104F · DestroyedNTSB LAX93T#A07Accident · No injuriesClass 3Final reportHughes OH-6A · San Diego, CASep 19, 1993 · N97BP · DestroyedNTSB LAX93LA358Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Napa, CAThe loss of engine power for undetermined reasons. The rough/uneven terrain was a factor in this accident.Sep 19, 1993 · N2485K · Substantial damageNTSB FTW93LA260Accident · No injuriesLimited investigationFinal reportCessna A188B · Manila, ARPartial loss of engine power due to the collapse of an air induction hose.Sep 19, 1993 · N731UF · Substantial damageNTSB CHI93LA370Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Lenox, ILSelection of the wrong runway by the pilot after misreading the wind sock. The resultant tailwind was a related factor.Sep 19, 1993 · N8753E · Substantial damageNTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.Sep 19, 1993 · N6752N · Substantial damageNTSB BFO93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Painesville, OHThe pilot's attempt to land with excessive airspeed, his improper use of the brakes, and his delay in performing remedial action.Sep 19, 1993 · N6294J · Substantial damageNTSB BFO93LA181Accident · No injuriesLimited investigationFinal reportCessna 180H · New Philadelphi, OHThe pilot's failure to maintain directional control of the airplane during landing rollout, subsequently causing the airplane to veer off the runway and groundloop.Sep 19, 1993 · N9704G · Substantial damageNTSB BFO93LA180Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottdale, PAThe pilot's selection of unsuitable terrain for landing and his delay in performing remedial action.Sep 19, 1993 · N88RD · Substantial damageNTSB BFO93LA179Accident · No injuriesLimited investigationFinal reportCessna 172 · North Kingstown, RIThe pilot inadvertently allowed the airplane to stall as he was maneuvering to avoid birds on final approach.Sep 19, 1993 · N9931Q · Substantial damageNTSB ATL93LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student pilot's inadequate compensation for wind conditions during the touch and go landing. Factors were the crosswind conditions, and the hidden obstruction (rock) in the grass adjacent to the runway.Sep 19, 1993 · N4794B · Substantial damageNTSB ANC93LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKTotal loss of engine power due to fuel exhaustion and the pilot's improper fuel consumption calculations. Factor was the unsuitable terrain.Sep 19, 1993 · N3680M · Substantial damageNTSB ANC93LA180Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Yantarni Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. A factor was the crosswind.Sep 19, 1993 · N4259H · Substantial damageNTSB LAX93LA357Accident · No injuriesLimited investigationFinal reportCessna 210F · Chino, CAthe pilot's inadequate compensation for the downdraft and his failure to maintain the proper glidepath.Sep 18, 1993 · N1842F · Substantial damageNTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.Sep 18, 1993 · N840B · Substantial damageNTSB CHI93LA365Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Aurora, ILthe fatigue failure and separation of a portion of propeller blade during cruise flight. Related factors are the damage to the flat face of the blade, and inadequate maintenance inspection of the propeller.Sep 18, 1993 · N55VL · Substantial damageNTSB BFO94WA055Accident · Minor injuriesForeign investigationHiller H-23C · Egwell, GermanySep 18, 1993 · N144RG · DestroyedNTSB BFO93FA178Accident · 1 fatalField investigationFinal reportMaule M-4-210C · Staunton, VAInadequate preflight by the pilot which resulted in inadequate altitude to clear the embankment during the initial climb. Factors in this accident were a tailwind on takeoff and rising terrain at the departure end of the grass airstrip.Sep 18, 1993 · N2026U · DestroyedNTSB ATL93LA160Accident · 1 fatalLimited investigationFinal reportCornwell KR-2 · Covington, TNThe pilot's misjudged obstacle clearance on final approach. Factors were, the dark night, and the pilot's defective distant vision.Sep 18, 1993 · N289DC · Substantial damageNTSB ANC93LA184Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's improper planning/decision. The rough water in the takeoff area was a factor.Sep 18, 1993 · N84627 · Substantial damageNTSB ANC93LA179Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, AKThe pilot's improper in-flight planning/decision, and his failure to attain the proper touchdown point. A factor was the rough/uneven terrain.Sep 18, 1993 · N5029M · Substantial damageNTSB MIA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Fernandina Bch, FLThe pilot-in-command's excessive airspeed, his failure to touch down at the proper point on the runway, and his failure to abort the landing.Sep 17, 1993 · N456CB · Substantial damageNTSB LAX93LA356Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Oracle, AZFailure of the crankshaft due to fatigue.Sep 17, 1993 · N6336B · Substantial damageNTSB FTW93LA261Accident · Minor injuriesLimited investigationFinal reportCulver V · Carlsbad, NMAn inadvertent stall when the pilot lowered the landing gear. A factor was a leaking o-ring in the propeller governor.Sep 17, 1993 · N44680 · DestroyedNTSB CHI93LA368Accident · Minor injuriesLimited investigationFinal reportKewley KR2 · Carbondale, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to lack of fuel.Sep 17, 1993 · N25DK · Substantial damageNTSB CHI93LA366Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Madison, WIthe loose fuel selector handle/valve which resulted in an inability to properly switch fuel tanks.Sep 17, 1993 · N823PJ · Substantial damageNTSB MIA93LA196Accident · Minor injuriesLimited investigationFinal reportSukhoi SU-26M · Natchez, MSThe pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.Sep 16, 1993 · N26CY · Substantial damageNTSB LAX93LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Hesperia, CAThe pilot in command not maintaining a proper glidepath. Factors pertaining to this accident were: the pilot in command not obtaining a weather forecast for the return flight, and the lack of total experieince in night flying.Sep 16, 1993 · N49813 · Substantial damageNTSB CHI93LA364Accident · No injuriesLimited investigationFinal reportCessna 172P · Fieldon, ILPartial failure (deterioration) of the #1 piston pin plug, which resulted in contamination of the lubricating system and failure of the #3 connecting rod.Sep 16, 1993 · N52502 · Substantial damageNTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.Sep 16, 1993 · N2353K · Substantial damageNTSB CHI93LA362Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hobart, INThe certificated flight instructor's inadequate supervision of the flight during a simulated single engine approach and landing.Sep 16, 1993 · N4470P · Substantial damageNTSB ATL93LA159Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAWas the pilot's inaccurate evaluation of weather conditions which resulted in the flight entering an area of turbulence.Sep 16, 1993 · N627DL · No damage