Fatal NTSB investigations, OH
7 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 1 |
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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' 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 CEN20LA197Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35-A33 · Cambridge, OHA fuel injection system leak at or near the No. 3 cylinder that resulted in a partial loss of engine power during cruise flight.NTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…NTSB CEN15LA318Accident · 1 fatalLimited investigationFinal reportPiper PA38 - 112 · Millbury, OHA loss of engine power due to three of the engine valve adjustment mechanisms backing out, which resulted from improper maintenance.NTSB CEN15FA088Accident · 1 fatalField investigationFinal reportPiper PA 23-160 · Port Clinton, OHThe pilot's loss of control following a loss of left engine power for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…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 CHI08LA166Accident · 1 fatalLimited investigationFinal reportHelton Lark 95 · West Carrollton, OHThe improper installation of spark plugs during the annual inspection which resulted in a loss of engine power shortly after takeoff. Contributing to the accident was the lack of suitable terrain during the forced landing.