NTSB investigations, 2026
276 cases where the defining event was Unknown or undetermined.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 20 |
| 2010 | 35 |
| 2011 | 34 |
| 2012 | 36 |
| 2013 | 32 |
| 2014 | 56 |
| 2015 | 72 |
| 2016 | 92 |
| 2017 | 78 |
| 2018 | 94 |
| 2019 | 68 |
| 2020 | 73 |
| 2021 | 89 |
| 2022 | 106 |
| 2023 | 134 |
| 2024 | 115 |
| 2025 | 118 |
| 2026 | 276 |
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 year(c.\"eventDate\") = 2026
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000')
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 year(c."eventDate") = 2026 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 GAA27WA031Incident · No injuriesForeign investigationCessna U206 · Barinas, VenezuelaNTSB CEN27FA038Accident · 1 fatalClass 3 · FieldInvestigation openBeech H35 · Deenwood, GANTSB GAA27WA030Accident · No injuriesClass 5 · ForeignCessna 152 · Sao Paulo, BrazilNTSB GAA27WA028Accident · Minor injuriesForeign investigationCessna 182 · San Juan, GuatemalaNTSB ERA27FA034Accident · 1 fatalClass 3 · FieldInvestigation openRobinson Helicopter R44 II · Coral Gables, FLNTSB GAA27WA027Accident · 1 fatalClass 5 · ForeignZenair CH601 · Anteuil, FranceNTSB CEN27FA037Accident · 2 fatalClass 3 · FieldInvestigation openCirrus SR22 · Brumley, MONTSB GAA27WA026Accident · 2 fatalForeign investigationCessna 172 · Nelson, New ZealandNTSB GAA27WA022Accident · 1 fatalForeign investigationPiper PA32 · Nassau, BahamasNTSB GAA27WA025Accident · 1 fatalForeign investigationCessna 337 · Tibooburra, AustraliaNTSB GAA27WA023Accident · Serious injuriesForeign investigationCirrus Design SR22 · Leeds, United KingdomNTSB GAA27WA020Accident · 1 fatalForeign investigationCessna U206 · Puerto Ayacucho, VenezuelaNTSB GAA27WA017Accident · No injuriesClass 5 · ForeignTecnam P-Mentor · North Cat Cay, BahamasNTSB GAA27WA019Accident · No injuriesForeign investigationGulfstream Aerospace GVIII-G700 · Rome, ItalyNTSB CEN27FA030Accident · 3 fatalClass 3 · FieldInvestigation openPiper PA-28-235 · Gunnison, CONTSB GAA27WA015Accident · 2 fatalClass 5 · ForeignVans RV7 · Sao Paulo, BrazilNTSB GAA27WA013Accident · 2 fatalClass 5 · ForeignPiper PA38 · Dryman, United KingdomNTSB GAA27WA018Accident · No injuriesForeign investigationBeech G58 · Entebbe, UgandaNTSB GAA27WA014Accident · Serious injuriesClass 5 · ForeignChampion 7GCAA · Pattaya, ThailandNTSB GAA27WA011IncidentForeign investigationBeech 58 · San Bernardina, UruguayNTSB GAA27WA024Accident · 2 fatalClass 5 · ForeignCessna 182 · Mucajaí, BrazilNTSB GAA27WA010Occurrence · No injuriesClass 5 · ForeignCessna T210 · Calafquen, ChileNTSB GAA27WA008Accident · Minor injuriesClass 5 · ForeignCessna 182 · Zabaykalsky Krai, RussiaNTSB GAA27WA016Accident · 3 fatalForeign investigationBeech 300 · Santana Do Paraiso, BrazilNTSB GAA27WA007AccidentClass 5 · ForeignSteen Skybolt · Ontario, CanadaNTSB GAA27WA012Incident · No injuriesForeign investigationPiper PA-25 · Villavicencio, ColombiaNTSB ERA27LA006Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 525 · Bedford, PAOn October 7, 2026, at 1021 eastern daylight time, a Cessna 525 airplane, N600AL, was substantially damaged when it was involved in an accident near Bedford, Pennsylvania. One airline transport pilot sustained minor injuries, and the other airline transport…NTSB 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 fatalClass 3 · ForeignGulfstream Gulfstream G100 · International Waters, CanadaNTSB GAA27WA004Accident · No injuriesClass 5 · ForeignFairchild UC61 · Wilhelmshaven, GermanyNTSB WPR27FA001Accident · 1 fatalClass 3 · FieldPreliminary reportStoddard Hamilton Glasair · Everett, WAOn October 1, 2026, about 1450 Pacific daylight time, an experimental amateur built Glasair FT airplane, N314SR, was destroyed when it was involved in an accident near Everett, Washington. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB 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 GAA26WA334Incident · No injuriesClass 5 · ForeignCessna 441 · Villavicencio, ColombiaNTSB 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 GAA26WA335Accident · No injuriesForeign investigationPiper PA18 · Bragado, ArgentinaNTSB GAA26WA328Incident · Minor injuriesClass 5 · ForeignCessna 152 · João Pessoa, BrazilNTSB GAA26WA327Accident · No injuriesClass 5 · ForeignCessna 172 · Campo Alegre, ColombiaNTSB WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORNTSB GAA26WA326Accident · No injuriesClass 5 · ForeignLaviasa PA25 · Cajati, BrazilNTSB 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 · FieldPreliminary reportPiper PA-18-150 · Northway, AKOn September 17, 2026, about 1930 Alaska daylight time, a Piper PA-18-150 airplane, N9128D, was substantially damaged when it was involved in an accident near Northway, Alaska. The pilot and passenger were fatally injured. The airplane was operated as a Title…NTSB 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…