Fatal NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE c.\"highestInjuryLevel\" = 'Fatal' 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 WHERE c."highestInjuryLevel" = 'Fatal' 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 ANC24FA029Accident · 2 fatalClass 3 · FieldFinal reportDouglas C54D · Fairbanks, AKA loss of power of the No. 1 engine for reasons that could not be determined, and the incorrect installation of a B-nut fitting in the propeller feathering system, which allowed engine oil to spray onto the exhaust system when the propeller was feathered…NTSB CEN24FA164Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy FG · Spicewood, TXThe pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA24LA185Accident · 1 fatalClass 3 · LimitedFinal reportBailey-Moyes Dragonfly · Groveland, FLThe pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.NTSB CEN24FA160Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Hartsburg, MOThe pilot’s encounter with convective weather conditions, which resulted in a loss of airplane control, the exceedance of the airplane’s never exceed speed, and the resulting overload failure of the horizontal stabilizer and subsequent failure of the…NTSB WPR24FA124Accident · 1 fatalClass 3 · FieldFinal reportGulfstream 695A · San Bernardino, CAThe pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA24WA145Accident · 3 fatalClass 5 · ForeignBell 206 · Meico City, MexicoNTSB GAA24WA143Accident · 2 fatalClass 5 · ForeignExtra 300 · Tokol, Hungary, HungaryNTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.NTSB CEN24LA157Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Montmorenci, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB GAA24WA141Accident · 1 fatalClass 5 · ForeignCessna T210M · Leeds, United KingdomNTSB WPR24FA123Accident · 1 fatalClass 3 · FieldFinal reportAyres S2R-G10 · Derner, CAThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.NTSB CEN24FA148Accident · 3 fatalClass 3 · FieldFinal reportDavis DA-3 · Antlers, OKImpact with terrain for reasons that could not be determined.NTSB ERA24FA160Accident · 1 fatalClass 3 · FieldFinal reportArthur B Canning Merlin Lite · Mulberry, FLThe pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…NTSB CEN24LA144Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Muncie, INThe pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…NTSB WPR24FA119Accident · 2 fatalClass 3 · FieldPreliminary reportDaher TBM700 · Truckee, CAOn March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA24WA134Accident · 1 fatalClass 5 · ForeignReims Cessna FR172F · Tyrol, AustriaNTSB ERA24FA157Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Fort Pierce North, FLThe flight instructor’s failure to maintain control of the multiengine airplane after a partial loss of engine power on one engine during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the mechanic’s failure to check the…NTSB GAA24WA159Accident · 1 fatalClass 5 · ForeignCessna 152 · Tolima, ColombiaNTSB GAA24WA133Accident · 1 fatalClass 4 · ForeignCessna 172 · La Linea, ChileNTSB GAA24WA158Accident · 1 fatalClass 5 · ForeignPiper PA34 · Serra do Japi, BrazilNTSB GAA24WA128Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Cambridgeshire, United KingdomNTSB ERA24FA154Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · St. Augustine, FLThe pilot’s failure to maintain adequate airspeed of the airplane while in the traffic pattern, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s distraction due to the in-flight opening of the main cabin door, which resulted from the…NTSB GAA24WA132Accident · 1 fatalClass 5 · ForeignCessna A188 · Lucas Do Rio Verde, BrazilNTSB GAA24WA122Accident · 4 fatalClass 3 · ForeignBeech C90 · Santa Rosa de Osos, ColombiaNTSB GAA24WA121Accident · 1 fatalClass 5 · ForeignRans S12 · Tabacundo, EcuadorNTSB WPR24FA112Accident · 1 fatalClass 3 · FieldFinal reportHolmes William B AIR Creation Twin · Gila Bend, AZThe pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.NTSB WPR24FA105Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Madras, ORThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with turbulence and structural icing conditions, loss of control, and subsequent impact with terrain.NTSB ERA24FA136Accident · 5 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Hot Springs, VAThe PIC’s continuation of an unstabilized approach in gusting wind conditions and his failure to monitor the airplane’s altitude during the approach, which led to a descent into terrain short of the runway. Contributing was the flight crew’s failure to set…NTSB WPR24FA104Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar KXP · Cave Junction, ORThe pilot's exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's use of potentially impairing substances with bipolar disorder, which resulted in a decreased…NTSB GAA24WA113Accident · 2 fatalClass 5 · ForeignCessna 208B · Belo Horizonte, BrazilNTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB GAA24WA110Accident · 1 fatalClass 5 · ForeignZenith CH-801 · Bunberry, AustraliaNTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB ERA24FA120Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Jackson, OHThe non-instrument-rated pilot’s decision to depart under visual flight rules into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.NTSB GAA24WA101Accident · 3 fatalClass 5 · ForeignRobinson R44 · Goianesia Do Para, BrazilNTSB ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.NTSB GAA24WA095Accident · 2 fatalClass 5 · ForeignCessna U206 · Canaima, VenezuelaNTSB ENG24WA011Accident · 2 fatalClass 5 · ForeignBlackshape BK160 · Kapar, MalaysiaNTSB GAA24WA131Accident · 9 fatalClass 5 · ForeignBeech E90 · Lote Ocho, MexicoNTSB GAA24WA089Accident · 1 fatalClass 5 · ForeignCessna 208 · Puerto Escondido, MexicoNTSB CEN24MA111Accident · 6 fatalClass 2 · MajorFinal reportAirbus Helicopters EC 130 · Halloran Springs, CAThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the company’s inadequate oversight of its…NTSB ERA24FA110Accident · 2 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Naples, FLCorrosion of both engines’ variable geometry (VG) system components, which led to their operation in an off-schedule position and resulted in near-simultaneous sub-idle rotating compressor stalls on approach, subsequent loss of thrust in both engines, and an…NTSB WPR24FA083Accident · 2 fatalClass 2 · FieldFinal reportHawker Beechcraft Hawker 900XP · Westwater, UTThe flight crew’s decision to conduct a post-maintenance stall test in an area of icing conditions, which resulted in wing contamination that significantly decreased the airplane’s critical angle of attack. Also causal was the airplane manufacturer’s lack of…NTSB GAA24WA086Accident · 1 fatalClass 3 · ForeignRobinson R44 · Lago Ranco, ChileNTSB ERA24FA104Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Clearwater, FLAn in-flight engine compartment fire due to a partially loose flexible fuel hose b-nut at the fuel metering unit. Contributing to the severity of the accident was the pilot’s inability to visually identify the destination airport at night, which prolonged the…NTSB ERA24FA103Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. GA-7 · Coatesville, PAThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to water-contaminated fuel, and his subsequent loss of control. Contributing to the accident was an inadequate annual maintenance inspection, during which maintenance…NTSB ERA24FA102Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24 · Eufaula, ALA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate fuel planning/management.NTSB WPR24FA080Accident · 1 fatalClass 3 · FieldFinal reportSwanson R/Swanson S RV-6 · Concord, CAA total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.NTSB CEN24FA101Accident · 2 fatalClass 3 · FieldFinal reportLockwood AIR CAM · Ranchitos Las Lomas, TXThe pilot's failure to maintain clearance from a meteorological evaluation tower.NTSB GAA24WA087Accident · 7 fatalClass 4 · ForeignPiper PA46 · Itapeva, Brazil