Fatal NTSB investigations
1,001 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 16 |
| 2010 | 31 |
| 2011 | 31 |
| 2012 | 27 |
| 2013 | 32 |
| 2014 | 46 |
| 2015 | 59 |
| 2016 | 72 |
| 2017 | 63 |
| 2018 | 80 |
| 2019 | 56 |
| 2020 | 47 |
| 2021 | 43 |
| 2022 | 57 |
| 2023 | 54 |
| 2024 | 56 |
| 2025 | 80 |
| 2026 | 139 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA27WA015Accident · 2 fatalClass 5 · ForeignVans RV7 · Sao Paulo, BrazilNTSB GAA27WA013Accident · 2 fatalClass 5 · ForeignPiper PA38 · Dryman, United KingdomNTSB GAA27WA016Accident · 3 fatalForeign investigationBeech 300 · Santana Do Paraiso, BrazilNTSB CEN27FA006Accident · 1 fatalClass 3 · FieldPreliminary reportLancair IV · Haslet, TXOn October 7, 2026, at 0952 central daylight time, an Lancair IV-P airplane, N5SV, was destroyed when it was involved in an accident near Haslet, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB GAA27WA003Accident · 1 fatalClass 5 · ForeignRutan Varieze · Worplesdon, United KingdomNTSB GAA27WA002Accident · 2 fatalClass 5 · ForeignCessna 501 · Los Mezquites, MexicoNTSB CEN27LA005Accident · 2 fatalClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 · Eldorado Springs, COOn October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB GAA27WA001Accident · 6 fatalForeign investigationGulfstream Gulfstream G100 · International Waters, CanadaNTSB WPR27FA001Accident · 1 fatalClass 3 · FieldInvestigation openRoesler Scott D Roesler Glasair · Everett, WANTSB WPR26FA363Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter Deutschland EC 135 P2+ · Avalon, CAOn September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…NTSB GAA26WA336Accident · 5 fatalClass 5 · ForeignBell 430 · Mendamu, ZimbabweNTSB GAA26WA329Accident · 4 fatalForeign investigationRobinson R44 · Farnham, CanadaNTSB ERA26FA350Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 112 · Chatsworth, GAOn September 26, 2026, about 1120 eastern daylight time, an Aero Commander 112, N1102J, was substantially damaged when it was involved in an accident near Chatsworth, Georgia. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORNTSB GAA26WA324Accident · 5 fatalForeign investigationBell 430 · Serra do Corvo Branco, BrazilNTSB WPR26FA346Accident · 2 fatalClass 3 · FieldPreliminary reportAirbus AS332 · Yosemite Valley, CAOn September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…NTSB GAA26WA330Accident · 2 fatalClass 5 · ForeignComp Air 7SL · Primavera do Leste, BrazilNTSB GAA26WA325Accident · 2 fatalForeign investigationCessna 172 · Kisbey, CanadaNTSB ANC26FA106Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Northway, AKNTSB ERA26FA341Accident · 1 fatalClass 3 · FieldPreliminary reportWeatherly 620 · Lynchburg, SCOn September 17, 2026, about 0720 eastern daylight time, a Weatherly Aviation Company Inc. 602B, N20003, was substantially damaged when it was involved in an accident near Lynchburg, South Carolina. The pilot was fatally injured. The airplane was operated as…NTSB WPR26FA345Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter AS 350 B2 · Chatsworth, CAOn September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…NTSB ANC26FA105Accident · 2 fatalClass 3 · FieldInvestigation openCessna A185F · Stony River, AKNTSB GAA26WA320Accident · 3 fatalClass 5 · ForeignCessna F172 · Fronderath, GermanyNTSB GAA26WA311Accident · 5 fatalForeign investigationCessna T206 · Tatama Massif, ColombiaNTSB GAA26WA322Accident · 3 fatalClass 4 · ForeignCessna 402 · Agua Boa, BrazilNTSB GAA26WA302Accident · 1 fatalClass 5 · ForeignCanadian Home Rotors Safari · Eyrewell, New ZealandNTSB GAA26WA300Accident · 5 fatalClass 5 · ForeignBolkow BO105 · Long Lellang, MalaysiaNTSB GAA26WA301Accident · 2 fatalClass 5 · ForeignBeech A36 · Archerfield, AustraliaNTSB GAA26WA297Occurrence · 4 fatalClass 3 · ForeignPiper PA-34-200T · Andros, BahamasNTSB CEN26FA311Accident · 2 fatalClass 3 · FieldPreliminary reportEXP Stol CH701 · Neosho, MOOn September 7, 2026, about 1337 central daylight time, an experimental STOL CH701 airplane, N101XV, sustained substantial damage when it was involved in an accident near Neosho, Missouri. The pilot and passenger sustained fatal injuries. The airplane was…NTSB GAA26WA317Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Calgary, CanadaNTSB ANC26FA097Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T206H · Dunton, COOn September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of…NTSB GAA26WA312Accident · 2 fatalClass 5 · ForeignTecnam P2006T · Kampur, IndiaNTSB GAA26WA295Accident · 1 fatalClass 5 · ForeignBeech 58 · Groote Eylandt, AustraliaNTSB WPR26FA309Accident · 8 fatalClass 3 · FieldPreliminary reportCessna 441 · Cape Newenham, AKOn August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA292Accident · 1 fatalClass 5 · ForeignBeech 200 · Prince George, CanadaNTSB CEN26LA296Accident · 1 fatalClass 3 · LimitedPreliminary reportPara-Ski VX · Westport, SDOn August 19, 2026, about 1920 central daylight time, a Para-Ski VX powered parachute, C-IFBY, was substantially damaged when it was involved in an accident near Westport, South Dakota. The pilot sustained serious injuries, passenger 1 sustained fatal…NTSB GAA26WA285Accident · 7 fatalClass 5 · ForeignEurocopter EC130 · Ewaso Nyiro, KenyaNTSB GAA26WA283Accident · 3 fatalClass 5 · ForeignBell 206 · Exambela, GreeceNTSB GAA26WA282Accident · 2 fatalClass 5 · ForeignPiper PA28 · Trawsfynydd, United KingdomNTSB WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…NTSB GAA26WA279Accident · 4 fatalForeign investigationRobinson R44 · Rio de Janeiro, BrazilNTSB GAA26WA278Accident · 1 fatalClass 5 · ForeignCessna 150 · Portimao, PortugalNTSB ANC26FA079Accident · 2 fatalClass 3 · FieldPreliminary reportHelicopter Transport Services CH-54A · Cove Fort, UTOn August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…NTSB ERA26FA291Accident · 2 fatalClass 3 · FieldPreliminary reportBeech H35 · Bogalusa, LAOn August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA289Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Bend, OROn August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…NTSB GAA26WA277Accident · 1 fatalForeign investigationCessna 172L · Chilliwack, CanadaNTSB GAA26WA270Accident · 2 fatalClass 5 · ForeignBell 214ST · West Attica, GreeceNTSB GAA26WA268Accident · 13 fatalClass 5 · ForeignCessna 208 · Nazca, PeruNTSB GAA26WA267Accident · 7 fatalClass 5 · ForeignBell 412 · San Agustín, Argentina