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 BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.NTSB ANC93IA183Incident · No injuriesIncident investigationFinal reportCessna 180C · Anchorage, AKA frayed fuel hose.NTSB 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.NTSB 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.NTSB 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.NTSB CHI93LA371Accident · No injuriesLimited investigationFinal reportPiper PA-60-601 · Lone Rock, WIInadequate maintenance and excessive airspeed during the landing approach.NTSB 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.NTSB 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.NTSB SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.NTSB 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.NTSB LAX93LA361Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Buttonwillow, CAThe pilot's failure to avoid wires.NTSB 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.NTSB 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.NTSB 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.NTSB CHI93LA373Accident · No injuriesLimited investigationFinal reportBeech 18-C45G · Jeffersonville, INthe mechanical binding of the landing gear extension mechanism.NTSB 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.NTSB 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.NTSB SEA93LA204Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot's failure to maintain the proper airspeed and glidepath.NTSB 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.NTSB LAX93T#A07Accident · No injuriesClass 3Final reportHughes OH-6A · San Diego, CANTSB 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.NTSB FTW93LA260Accident · No injuriesLimited investigationFinal reportCessna A188B · Manila, ARPartial loss of engine power due to the collapse of an air induction hose.NTSB 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.NTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.NTSB 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.NTSB 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.NTSB BFO93LA180Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottdale, PAThe pilot's selection of unsuitable terrain for landing and his delay in performing remedial action.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX93LA357Accident · No injuriesLimited investigationFinal reportCessna 210F · Chino, CAthe pilot's inadequate compensation for the downdraft and his failure to maintain the proper glidepath.NTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.NTSB 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.NTSB BFO94WA055Accident · Minor injuriesForeign investigationHiller H-23C · Egwell, GermanyNTSB 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.NTSB 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.NTSB ANC93LA184Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's improper planning/decision. The rough water in the takeoff area was a factor.NTSB 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.NTSB 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.NTSB LAX93LA356Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Oracle, AZFailure of the crankshaft due to fatigue.NTSB 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.NTSB CHI93LA368Accident · Minor injuriesLimited investigationFinal reportKewley KR2 · Carbondale, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to lack of fuel.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.NTSB 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.NTSB 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.