Final NTSB investigations, 2025
4 cases where the sequence of events included Fire/smoke (post-impact).
Cases per year
| 2008 | 42 |
|---|---|
| 2009 | 34 |
| 2010 | 11 |
| 2011 | 15 |
| 2012 | 17 |
| 2013 | 18 |
| 2014 | 20 |
| 2015 | 31 |
| 2016 | 24 |
| 2017 | 21 |
| 2018 | 25 |
| 2019 | 16 |
| 2020 | 9 |
| 2021 | 5 |
| 2022 | 16 |
| 2023 | 16 |
| 2024 | 12 |
| 2025 | 4 |
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\") = 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\" = '170' 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" = '170' 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 ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.NTSB CEN25LA163Accident · Serious injuriesClass 4 · LimitedFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hartford, ILThe pilot’s failure to maintain directional control during the initial climb at night from a confined area landing zone, that resulted in an impact with a tree, a loss of control, and a subsequent impact with terrain.NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Pearland, TXBoth pilots’ failure to follow emergency procedures pertaining to the partial loss of engine power by either applying carburetor heat to address the carburetor icing or to abort the takeoff when they observed a partial loss of engine power during the takeoff…