Fatal NTSB investigations, 2017
11 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 17 |
| 2010 | 14 |
| 2011 | 15 |
| 2012 | 13 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 15 |
| 2016 | 14 |
| 2017 | 11 |
| 2018 | 17 |
| 2019 | 19 |
| 2020 | 9 |
| 2021 | 14 |
| 2022 | 12 |
| 2023 | 11 |
| 2024 | 12 |
| 2025 | 4 |
| 2026 | 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\") = 2017
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' 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") = 2017 AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' 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 ERA18WA061Accident · 1 fatalForeign investigationCessna A188 · Dom Pedrito, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…NTSB ERA18FA012Accident · 1 fatalField investigationFinal reportBeech 35C33 · Whiteville, NCThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…NTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…NTSB ERA17MA316Accident · 4 fatalClass 2 · MajorFinal reportEurocopter Deutschland MBB BK 117 · Hertford, NCA failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…NTSB ERA17FA248Accident · 1 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PAA partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…NTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.NTSB WPR17FA146Accident · 1 fatalField investigationFinal reportChicco Miguel E Quicksilver Sport II · Point Mugu, CAA partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…NTSB CEN17FA197Accident · 2 fatalField investigationFinal reportAerotek Pitts S 2A · Sheboygan Falls, WIThe pilot's failure to maintain airplane control following a partial loss of engine power during a low-level aerobatic maneuver; the reason for the loss of engine power could not be determined during postaccident examination of the engine. Contributing to the…NTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…