NTSB investigations, OH

6 cases where NTSB found Aircraft handling/service.

Cases per year

20092026
NTSB investigations, OH per year, 2009–2026: 6 cases
20091
20112
20121
20131
20211

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0101'))
  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.

NTSB CEN21LA310Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Wapakoneta, OHThe pilot’s inadequate engine hand propping procedure resulting in the unoccupied airplane’s unintended movement and subsequent impact with a hangar.Jul 5, 2021 · N9149E · Substantial damageNTSB CEN13CA190Accident · Serious injuriesData collectionFinal reportMooney M20E · Middletown, OHThe total loss of engine power due to fuel exhaustion, which resulted from the noncurrent pilot’s improper in-flight fuel management and decision-making and his decision to conduct the flight after consuming alcohol.Mar 12, 2013 · N199Q · Substantial damageNTSB CEN12LA401Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Baltic, OHLoss of engine power due to fuel starvation as a result of particulate contaminant on the carburetor screens.Jun 28, 2012 · N3170P · Substantial damageNTSB CEN12CA032Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Radnor, OHThe pilot's failure to properly secure the engine controls prior to manually rotating the propeller, which led to an inadvertent engine start and runaway airplane.Oct 15, 2011 · N8746W · Substantial damageNTSB 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…Jul 20, 2011 · N1883D · Substantial damageNTSB CEN09LA440Accident · 1 fatalLimited investigationFinal reportAntares MA-33 · Centerburg, OHThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall.Jul 15, 2009 · N6405 · Substantial damage