NTSB investigations, 2026
5 cases where NTSB found Aircraft handling/service.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 41 |
| 2010 | 26 |
| 2011 | 27 |
| 2012 | 28 |
| 2013 | 23 |
| 2014 | 31 |
| 2015 | 29 |
| 2016 | 22 |
| 2017 | 17 |
| 2018 | 13 |
| 2019 | 10 |
| 2020 | 8 |
| 2021 | 12 |
| 2022 | 13 |
| 2023 | 11 |
| 2024 | 11 |
| 2025 | 4 |
| 2026 | 5 |
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\", '0101'))
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", '0101')) 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 CEN26LA260Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Emerson, IAThe failure of the pilot to verify the loading hose had been disconnected before taking off and the failure of the loader to disconnect the fuel hose from the helicopter.NTSB ERA26LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, NCThe flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.NTSB CEN26LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Northport, MIThe pilot's decision to resume taxiing on a turf runway that was unable to adequately support the airplane's weight, which resulted in the nose landing gear sinking into the soft ground and the propeller striking the terrain.NTSB WPR26LA170Accident · No injuriesClass 4 · LimitedFinal reportBalony Kubicek Spol Sro BB100Z · Elk Grove, CAThe pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…NTSB CEN26LA145Accident · No injuriesClass 4 · LimitedFinal reportClassic Waco YMF · Galveston, TXThe biplane pilot’s failure to maintain an adequate visual lookout while taxiing, which included the failure to perform S-turns to compensate for limited forward visibility.