Final NTSB investigations, 2025
10 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 23 |
| 2010 | 25 |
| 2011 | 27 |
| 2012 | 28 |
| 2013 | 25 |
| 2014 | 28 |
| 2015 | 30 |
| 2016 | 36 |
| 2017 | 34 |
| 2018 | 59 |
| 2019 | 29 |
| 2020 | 23 |
| 2021 | 21 |
| 2022 | 14 |
| 2023 | 27 |
| 2024 | 22 |
| 2025 | 10 |
| 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\") = 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\" = '338' 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" = '338' 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 CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB CEN25LA328Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV14 · Parker, COSeparation of the right landing gear wheel assembly during landing.NTSB WPR25LA209Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Colorado City, AZThe pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.NTSB ERA25LA236Accident · No injuriesClass 4 · LimitedFinal reportSting Sport TL-2000 · Dunavant, VAThe inflight failure of the propeller due to its exceedance of the manufacturer’s overhaul requirement.NTSB ERA25LA204Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Fort Washington, PAMaintenance personnel’s failure to identify and replace damaged rivet nuts at the air conditioning louver assembly, which resulted in the separation of the louver assembly from the helicopter, the louver assembly’s impact with the tail rotor, and subsequent…NTSB ANC25LA028Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Royal Kunia, HIImproper alteration of the crankshaft propeller flange at an unknown time, which resulted in an in-flight separation of the propeller assembly.NTSB CEN25LA117Accident · No injuriesClass 3 · LimitedFinal reportVans RV-7A · Plainview, TXThe improper machining of the propeller blade bearing seat, which resulted in an inflight propeller blade fatigue failure. Contributing to the accident was the improper machining of the propeller hub and propeller blade root and machining surface quality…NTSB WPR25LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Minersville, UTThe failure of the propeller blade due to fatigue that originated from an impact pit sustained at an unknown time. Contributing to the accident was the failure of unknown maintenance personnel to detect and repair the impact pit before painting the propeller,…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.NTSB ERA25LA102Accident · No injuriesClass 4 · LimitedFinal reportDaniel A Robinson High 6 Berkut 540 · Orlando, FLThe pilot’s failure to verify the canopy latches were in the locked position prior to takeoff.