NTSB investigations, OH
20 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2024 | 1 |
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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' 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 ERA24FA310Accident · 1 fatalClass 3 · FieldFinal reportWilliams John Titan T-51 Mustang · Geneva, OHA sudden propeller overspeed and subsequent separation of the propeller blades and hub, while maneuvering at high speed and at low altitude, which resulted in a collision with a tree during the subsequent forced landing attempt.NTSB CEN21LA472Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · East Sparta, OHA total loss of engine power due to a fatigue failure of the No. 2 cylinder exhaust valve.NTSB CEN19LA303Accident · No injuriesClass 3 · LimitedFinal reportPhantom Aeronautics X-1 · Van Wert, OHA loss of engine power due to the separation of the carburetor from the intake socket resulting from the improper installation of the intake silencer.NTSB CEN19LA056Accident · 2 fatalLimited investigationFinal reportDouglas DC3C · Kidron, OHThe loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.NTSB CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.NTSB CEN17FA207Accident · 1 fatalField investigationFinal reportVarga 2150A · Bowling Green, OHThe pilot's loss of control due to impairment from carbon monoxide poisoning. Contributing to the accident was the corrosion of the heat exchanger and the failure of maintenance personnel to adequately inspect and repair or replace the exchanger during the…NTSB ENG17IA017Incident · No injuriesIncident investigationFinal reportDouglas DC 9 83 · Dayton, OHThe probable cause of the No. 2 (right) engine fire was an uncontained generator failure. Deformed rotating generator components and/or metal fragments radially released by the generator severed the constant speed drive-to-oil cooler return line located…NTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.NTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.NTSB CEN12TA550Accident · No injuriesFinal reportMD Helicopter 369 · Columbus, OHThe failure of a 4th-stage turbine blade due to high-cycle fatigue, which resulted in the loss of engine power.NTSB CEN11LA669Accident · Serious injuriesLimited investigationFinal reportOwen Vans RV-10 · Marietta, OHThe in-flight engine fire and loss of engine power due to an improperly installed fuel injector nozzle during a recent engine overhaul.NTSB CEN11LA491Accident · No injuriesLimited investigationFinal reportBeech C35 · Medina, OHThe loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…NTSB CEN11LA464Accident · Serious injuriesLimited investigationFinal reportBurtner Charles W Derjager D IX · East Liverpool, OHThe pilot's improper landing flare, which resulted in a porpoised landing and propeller contact with the runway, which caused an in-flight disintegration of the propeller during the go-around, and subsequent collision with trees.NTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.NTSB CEN09CA378Accident · No injuriesData collectionFinal reportPiper PA-24 · Urbana, OHA failure of the carburetor heat cable attach bracket which resulted in the inadvertent activation of carburetor heat and the subsequent loss of engine power during takeoff. Contributing to the accident was the pilot's operation of the aircraft with a known…NTSB CEN09LA209Accident · No injuriesLimited investigationFinal reportBeech B24R · Bellefontaine, OHThe inadequate torque of the Number 3 cylinder rod bolts by maintenance personnel, which resulted in a failure of the connecting rod and a total loss of engine power.NTSB CHI08CA284Accident · No injuriesData collectionFinal reportFleet 2 · Leroy, OHThe loss of engine power due to the propeller hub failure during a low-level maneuver. Contributing to the accident were the trees encountered during the forced landing.NTSB CHI08LA274Accident · Minor injuriesLimited investigationFinal reportSadler Vampire · Findlay, OHA total loss of engine power due to the failure of the reduction drive assembly as a result of excessive wear and high temperatures. Contributing to the accident were the pilot's lack of total experience in the airplane and the unsuitable terrain for a forced…NTSB CHI08CA139Accident · No injuriesData collectionFinal reportCessna 172N · Blue Ash, OHThe separation of the throttle cable from the linkage during the approach to land and the altitude/clearance not being available to the pilot during the forced landing. Contributing to the accident was the electrical wires the airplane impacted.NTSB CHI08CA103Accident · No injuriesData collectionFinal reportKoleno Titan T-51 · Geneva, OHThe failure of the propeller pitch control mechanism during approach. Contributing to the accident were the inability of the pilot to maintain airspeed and altitude, and the unsuitable terrain.