NTSB investigations, 2017
7 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
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\") = 2017
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") = 2017 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 ERA18LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech B 55 · Statesville, NCA total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.NTSB WPR18CA028Accident · No injuriesData collectionFinal reportStill Michael J Titan T-51 · Chandler, AZThe pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down.NTSB WPR17LA174Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Brawley, CAThe partial loss of engine power due to the overstress separation of three supercharger drive gear teeth.NTSB WPR17LA136Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 310R · Santa Ana, CAThe pilot’s inability to maintain adequate airspeed after a loss of power to the right engine while maneuvering in the pattern to return to the airport. Contributing to the accident were the loss of power to the right engine for reasons that could not be…NTSB WPR17LA106Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182P · Anderson, CALoss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA190Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Tahoka, TXThe partial loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB WPR17LA070Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Pomona, CAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.