NTSB investigations, 2011
13 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\") = 2011
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") = 2011 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 CEN12LA125Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · McKinney, TXThe passenger's inadvertent contact with a rotating propeller after exiting the parked airplane. Contributing to the accident were the dark night conditions and the deplaning of the passenger while the propeller was turning.NTSB ERA11IA521Incident · No injuriesIncident investigationFinal reportBeech V35 · New Haven, CTThe in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.NTSB ERA11LA483Accident · Minor injuriesLimited investigationFinal reportDurling James RV-6A · Hollywood, FLParticulate ingestion from the engine, which resulted in the malfunction of the propeller governor during the airplane’s initial climb.NTSB WPR11LA412Accident · No injuriesLimited investigationFinal reportWheeler Vans RV-6A · Albany, ORThe in-flight separation of a propeller blade due to fatigue.NTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…NTSB CEN11LA555Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Millsap, TXA sudden loss of engine thrust due to the separation of a propeller blade in cruise flight due to high cycle fatigue.NTSB CEN11FA528Accident · 2 fatalField investigationFinal reportWright B Flyer Wright B Flyer · Springfield, OHThe flight crew’s failure to maintain airplane control following a partial loss of engine thrust during cruise flight. Contributing to the accident was the failed weld as a result of incomplete welding on the left propeller shaft, which led to the partial…NTSB CEN11LA512Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Anderson, INThe fatigue failure of the propeller governor speeder spring, which resulted in the pilot’s inability to control engine output power.NTSB CEN11LA527Accident · No injuriesLimited investigationFinal reportSnow Quickie 2 · Ashtabula, OHThe incorrect propeller pitch and lower-than-expected engine speed that did not allow the airplane to attain a proper climb rate during takeoff, and the subsequent hard landing that occurred when the pilot reduced power.NTSB ERA11FA406Accident · 1 fatalField investigationFinal reportMooney M20K · Augusta, GAThe pilot’s decision to fly the airplane after maintenance personnel advised him that the airplane should not be flown because the pilot provided an incorrect propeller for installation and the subsequent failure of the propeller attachment bolts and the…NTSB CEN11FA253Accident · 3 fatalField investigationFinal reportPiper PA46-350P · Monroe, MIThe pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.NTSB ERA11LA150Accident · Minor injuriesLimited investigationFinal reportFlaglor Tom Kolb Aircraft MK III · Stetson, METhe in-flight failure of the No. 1 composite propeller blade due to fatigue, which resulted in a violent vibration, loss of engine power, and a subsequent forced landing to unsuitable terrain.NTSB CEN11IA235Incident · No injuriesIncident investigationFinal reportSchlichtman Stol CH750 · Cassville, MOThe fatigue failure of the propeller hub retaining bolts due to insufficient clamping force .