NTSB investigations, 2016
6 cases where NTSB found Propeller system.
Cases per year
| 2008 | 18 |
|---|---|
| 2009 | 13 |
| 2010 | 13 |
| 2011 | 13 |
| 2012 | 15 |
| 2013 | 10 |
| 2014 | 14 |
| 2015 | 11 |
| 2016 | 6 |
| 2017 | 8 |
| 2018 | 7 |
| 2019 | 10 |
| 2020 | 7 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 9 |
| 2024 | 9 |
| 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\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010461'))
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") = 2016 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010461')) 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 ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…NTSB ERA16FA325Accident · 2 fatalField investigationFinal reportMooney M20J · Pittstown, NJThe pilot's improper landing touchdown attitude, which resulted in a propeller strike, and his inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and led to an aerodynamic stall during…NTSB ERA16LA295Accident · No injuriesLimited investigationFinal reportPiper PA34 · Hollywood, FLMaintenance personnel’s failure to comply with an airworthiness directive for the propeller, which resulted in a propeller hub failure due to fatigue.NTSB GAA16CA322Accident · Serious injuriesData collectionFinal reportMarks Steven Challenger · Marion, WIThe failure of the airplane engine drive belt during the takeoff, resulting in a forced landing and impact with terrain.NTSB CEN16FA172Accident · 1 fatalField investigationFinal reportCessna 310F · North Little Rock, ARThe pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…NTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…