NTSB investigations, 2026
9 cases where NTSB found Not determined.
Cases per year
| 2008 | 150 |
|---|---|
| 2009 | 199 |
| 2010 | 195 |
| 2011 | 156 |
| 2012 | 171 |
| 2013 | 128 |
| 2014 | 150 |
| 2015 | 163 |
| 2016 | 137 |
| 2017 | 135 |
| 2018 | 143 |
| 2019 | 118 |
| 2020 | 86 |
| 2021 | 98 |
| 2022 | 76 |
| 2023 | 68 |
| 2024 | 37 |
| 2025 | 29 |
| 2026 | 9 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05')) 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 GAA26WA326Accident · No injuriesClass 5 · ForeignLaviasa PA25 · Cajati, BrazilNTSB GAA26WA309Incident · No injuriesClass 5 · ForeignBell 412 · Ciudad del Carmen, MexicoNTSB GAA26WA286Incident · No injuriesClass 5 · ForeignGuimbal Cabri · Oxford, United KingdomNTSB GAA26WA275Occurrence · No injuriesClass 5 · ForeignCessna U206 · Iquique, ChileNTSB GAA26WA261Incident · 1 fatalClass 5 · ForeignCessna 152 · Mengeringhausen, GermanyNTSB GAA26WA201Incident · No injuriesClass 5 · ForeignPiper PA28 · Aguadulce District, PanamaNTSB GAA26WA247Accident · No injuriesClass 5 · ForeignPiper PA28 · Roszczep, PolandNTSB GAA26WA183Accident · 1 fatalClass 5 · ForeignCessna 182 · Santa Cruz Barillas, GuatemalaNTSB ANC26LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna U206F · Juneau, AKA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean.