Final NTSB investigations, 2025
8 cases where the sequence of events included Preflight or dispatch event.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 32 |
| 2010 | 29 |
| 2011 | 27 |
| 2012 | 19 |
| 2013 | 28 |
| 2014 | 25 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 25 |
| 2018 | 16 |
| 2019 | 7 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 7 |
| 2023 | 14 |
| 2024 | 3 |
| 2025 | 8 |
| 2026 | 4 |
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\") = 2025
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '030' 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 year(c."eventDate") = 2025 AND c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' 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 CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.NTSB CEN25LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Air Force Academy, COThe student pilot’s failure to perform an adequate preflight inspection.NTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.NTSB ERA25LA212Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Fremont, OHThe pilot’s inadequate takeoff performance planning, which resulted in a runway overrun and collision with terrain.NTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…NTSB ERA25LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Clarksville, TNThe flight instructor’s inadequate preflight inspection of the airplane, which allowed the partially secured engine cowl to separate in flight.