NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ANC24LA087Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Lime Village, AKThe pilot’s excessive braking during the landing roll, resulting in a nose over.NTSB ANC24LA086Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Tok, AKThe airplane’s encounter with gusting winds resulting in a loss of altitude with performance insufficient to outclimb terrain.NTSB ANC24FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18-150 · McGrath, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB WPR24LA303Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Big Bend-Gold Bar, WAThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR24LA299Accident · Serious injuriesClass 4 · LimitedFinal reportWilliams Helicopter UH-1H · Colusa, CAThe pilot’s failure to set collective friction which resulted in collective bounce and subsequent loss of control.NTSB WPR24LA294Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Bend, ORA failure of the left fuel valve, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA24WA276Accident · 1 fatalClass 5 · ForeignBoeing E75 · Frohngau, GermanyNTSB ERA24LA366Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20K · Fairmont, WVThe pilot’s failure to attain the proper touchdown point, and his delay in aborting the landing.NTSB ERA24FA362Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Waynesville, OHA loss of control on takeoff for undetermined reasons.NTSB DCA24WA334IncidentClass 5 · ForeignBoeing 757-224 · Brussels, BelgiumNTSB ANC24LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Aleknagik, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.NTSB WPR24FA288Accident · 2 fatalClass 3 · FieldPreliminary reportTextron T206H · Yellow Pine, IDOn August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA24LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lynchburg, VAA total loss of engine power for undetermined reasons.NTSB DCA24WA305AccidentClass 3 · ForeignBoeing 737 · Malabo, Equatorial GuineaNTSB WPR24LA323AccidentClass 3 · LimitedPreliminary reportBeech J35 · Belgrade, MTOn August 27, 2024, about 1845 mountain daylight time, a Beech J35, N8350D, was substantially damaged when it was involved in an accident near Belgrade, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR24LA292Accident · No injuriesClass 4 · LimitedFinal reportRonald J Mclaughlin Bearhawk Patrol · Shearer, IDThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ANC24LA084Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Hawi, HIThe airplane’s loss of engine power due to carburetor ice that formed during a long descent, contributing to the outcome is the pilot’s delayed use of carburetor heat.NTSB GAA24WA275Accident · No injuriesClass 5 · ForeignCessna 152 · Daszewice, PolandNTSB GAA24WA270Accident · 1 fatalClass 4 · ForeignPiper PA18 · Defford, United KingdomNTSB ERA24LA359Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7ECA · Sussex, NJThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA24WA322Accident · No injuriesClass 5 · ForeignBoeing 767-300 · Milano Malpensa Airport, ItalyNTSB CEN24LA330Accident · No injuriesClass 4 · LimitedFinal reportEsqual VM1 · Oshkosh, WIThe pilot’s premature rotation during takeoff which resulted in the airplane settling back to the runway and the subsequent separation of the left wheel.NTSB GAA24WA272Accident · 1 fatalClass 5 · ForeignBeech 58 · Amatschonjoch, AustriaNTSB ERA24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 65-TAC · Clearwater, FLThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the outcome, was the pilot’s inability to control the engine following the loss of directional control due to the separation of a knob from the engine’s throttle…NTSB ERA24LA360Accident · No injuriesClass 4 · LimitedFinal reportBeech B100 · Jesup, GAA hard landing short of the runway threshold, which resulted in a collapse of the left main landing gear and subsequent runway excursion during landing.NTSB CEN24FA327Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Wayne, NEThe non-instrument-rated pilot’s encounter with instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN24FA326Accident · 1 fatalClass 3 · FieldFinal reportRans S19 · Crofton, NEThe non-instrument-rated pilot's decision to continue visual flight into an area of low cloud cover and precipitation which resulted in an inadvertent encounter with instrument meteorological conditions and a loss of control due to spatial disorientation.NTSB WPR24FA287Accident · Serious injuriesClass 3 · FieldFinal reportPitts S1 · Santa Paula, CAThe total loss of engine power at low altitude for reasons that could not be determined.NTSB ERA24LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Sterling, MAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and subsequent landing gear collapse. Contributing was the flight instructor’s delayed remedial action.NTSB DCA24WA325Incident · No injuriesClass 5 · ForeignBoeing 737 · Constantine, AlgeriaNTSB ANC24LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Sagwon, AKA failure of the landing gear fitting at the fuselage attachment point to due to a poor weld joint.NTSB WPR24FA285Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Kent, WAThe pilot’s failure to properly configure the amphibious landing gear for a water landing, which resulted in a touchdown on the water with the wheels extended, noseover, and airplane submersion.NTSB GAA24WA299Accident · Minor injuriesClass 3 · ForeignLeonardo AQ139 · Paul Village, IndiaNTSB DCA24WA317Accident · Serious injuriesClass 5 · ForeignBoeing 757 · Palma, SpainNTSB ANC24LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · King Salmon, AKThe pilot’s failure to maintain control during takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR24LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Stanley, IDThe pilot’s loss of directional control in reduced visibility conditions due to a wind gust, which resulted in a collision with a trailer.NTSB GAA24WA269Incident · No injuriesClass 5 · ForeignCessna 402 · Kariba, ZimbabweNTSB ERA24LA399Accident · No injuriesClass 3 · LimitedFinal reportBell Textron Canada 505 · Marianna, FLThe student pilot’s failure to maintain rotor rpm during a simulated autorotation, which allowed for a resonance phenomenon to develop. Contributing to the accident was the flight instructor’s inadequate monitoring of the student pilot’s collective control…NTSB CEN24FA325Accident · 1 fatalClass 3 · FieldPreliminary reportArrow Falcon Exporters OH-58A+ · Newton, TXOn August 23, 2024, about 1330 central daylight time, a restricted category Arrow Falcon Exporters OH-58A helicopter, N199BD was substantially damaged when it was involved in an accident near Newton, Texas. The pilot was fatally injured and one person on the…NTSB GAA24WA300Accident · 9 fatalClass 5 · ForeignCessna 208 · What Khao Din, ThailandNTSB GAA24WA282Accident · 2 fatalClass 5 · ForeignPartenavia P66 · LIAA (Identifier), ItalyNTSB GAA24WA267Accident · No injuriesClass 5 · ForeignRobinson R66 · Poblacion, ChileNTSB ERA24LA368Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Shelter Island, NYThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA24LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisa, VAThe pilot’s improper landing flare which resulted in a hard landing.NTSB DCA24WA286AccidentClass 5 · ForeignBoeing 737 · London, United KingdomNTSB CEN24LA323Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Cut and Shoot, TXThe pilot’s failure to maintain directional control during a go-around that resulted in an impact with a fence.NTSB WPR24FA284Accident · 1 fatalClass 3 · FieldPreliminary reportLockwood AIR CAM · Minden, NVOn August 20, 2024, about 0819 Pacific daylight time, an experimental amateur-built Lockwood Air Cam, N2412Y, was substantially damaged when in was involved in an accident at the Minden-Tahoe Airport, Minden, Nevada. The pilot was fatally injured, and the…NTSB GAA24WA266Accident · 2 fatalClass 3 · ForeignCessna 152 · Jamshedpur, IndiaNTSB ERA24LA356Accident · No injuriesClass 4 · LimitedFinal reportCanadian Light Acft Sales &Svc Bushcaddy Explorer R80 · Charleston, WVThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind, which resulted in a ground loop and subsequent landing gear collapse.NTSB ERA24LA353Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Mohawk, NYThe pilot’s failure to maintain directional control during the landing roll in wet conditions, which resulted in a runway excursion and collision with a fence.