NTSB investigations
1,703 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 82 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 259 |
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.\"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."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 GAA27WA014Accident · Serious injuriesClass 5 · ForeignChampion 7GCAA · Pattaya, ThailandNTSB GAA27WA011IncidentForeign investigationBeech 58 · San Bernardina, UruguayNTSB GAA27WA010Occurrence · No injuriesClass 5 · ForeignCessna T210 · Calafquen, ChileNTSB GAA27WA008Accident · Minor injuriesForeign investigationCessna 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 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 GAA27WA004Accident · No injuriesClass 5 · ForeignFairchild UC61 · Wilhelmshaven, GermanyNTSB 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 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 injuriesForeign investigationCessna 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 · 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 CEN26LA332Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA18 · Karinen, SDOn September 17, 2026, about 0710 mountain daylight time, a Piper PA18-150 airplane, N3879Z, was substantially damaged when it was involved in an accident near Karinen, South Dakota. The pilot was seriously injured. The airplane was operated as a Title 14…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 GAA26WA310Accident · No injuriesClass 5 · ForeignPiper PA17 · Viseu, PortugalNTSB GAA26WA313Accident · Serious injuriesClass 5 · ForeignCessna 550 · Parelhas, BrazilNTSB GAA26WA311Accident · 5 fatalForeign investigationCessna T206 · Tatama Massif, ColombiaNTSB GAA26WA322Accident · 3 fatalClass 4 · ForeignCessna 402 · Agua Boa, BrazilNTSB GAA26WA308Accident · No injuriesClass 5 · ForeignCessna 152 · Mapitac, PhilippinesNTSB GAA26WA305Accident · Serious injuriesClass 5 · ForeignCessna 172 · Midrand, South AfricaNTSB GAA26WA309Incident · No injuriesClass 5 · ForeignBell 412 · Ciudad del Carmen, MexicoNTSB GAA26WA306Accident · No injuriesClass 5 · ForeignPiper PA28 · Mossel Bay, South AfricaNTSB GAA26WA302Accident · 1 fatalClass 5 · ForeignCanadian Home Rotors Safari · Eyrewell, New ZealandNTSB GAA26WA300Accident · 5 fatalClass 5 · ForeignBolkow BO105 · Long Lellang, MalaysiaNTSB GAA26WA314Accident · Serious injuriesForeign investigationCessna 185 · Torbole, ItalyNTSB 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…