NTSB investigations, 2016
8 cases where NTSB found Aircraft power plant, general.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 24 |
| 2010 | 13 |
| 2011 | 15 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 7 |
| 2022 | 9 |
| 2023 | 12 |
| 2024 | 6 |
Where
Open the mapLatest 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\", '010500'))
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", '010500')) 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 GAA17LA090Accident · No injuriesLimited investigationFinal reportPiper PA28R · Watertown, WIThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…NTSB GAA17CA039Accident · No injuriesData collectionFinal reportEvolution Revo · Carson City, NVThe pilot receiving instruction's inadvertent application of throttle during the engine start, which led to an inadvertent acceleration and a roll-over.NTSB CEN17LA021Accident · Serious injuriesLimited investigationFinal reportZenith CH-750 · Morristown, MNA total loss of engine power due to fuel vapor lock. Contributing to the loss of engine power were the corrosion of the spark plugs and the spacing of the electrode gaps.NTSB ERA16FA311Accident · 3 fatalField investigationFinal reportSikorsky S61 · Palm Bay, FLA dual loss of engine power for undetermined reasons after the pilot's improper decision to attempt another maneuver after recovering from a perceived compressor stall, rather than returning to the airport.NTSB CEN16FA307Accident · 1 fatalField investigationFinal reportWilson BUGATTI-DEMONGE 100P · Burns Flat, OKThe pilot's failure to maintain airspeed following an engine anomaly during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was an…NTSB CEN16LA297Accident · No injuriesLimited investigationFinal reportCessna 172F · Newark, ILThe failure of the No. 4 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB WPR16LA104Accident · No injuriesLimited investigationFinal reportBell UH 1B · Maxwell, CAA reduction in available engine power during takeoff due to a stuck hot air valve, which resulted in low rotor rpm and a forced landing. Contributing to the accident was the lack of dry film lubricant and the presence of corrosion on the hot air valve…NTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.