NTSB investigations, 2012, OH

8 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2012, OH per year, 2008–2026: 227 cases
200821
200919
201015
201128
20128
20136
201412
20159
201615
201719
201818
201917
20205
20216
20226
20234
20244
20257
20268

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\") = 2012
    AND 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\" = '470' 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.

NTSB CEN13LA055Accident · Serious injuriesLimited investigationFinal reportCentral Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OHThe total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.Nov 4, 2012 · N667DF · Substantial damageNTSB CEN12LA569Accident · No injuriesLimited investigationFinal reportPiper PA28 · Leesburg, OHThe pilot's improper preflight planning and decision to attempt a takeoff from a runway that was too short for conditions, which resulted in the airplane settling into terrain.Aug 18, 2012 · N1845J · Substantial damageNTSB 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.Aug 16, 2012 · N551CP · Substantial damageNTSB CEN12LA538Accident · No injuriesLimited investigationFinal reportCantlon Starduster Too SA300 · Galion, OHThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing an aborted landing.Aug 7, 2012 · N111LC · Substantial damageNTSB CEN12IA451Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Marysville, OHFatigue failure of the left main wheel assembly on takeoff, which resulted in a loss of directional control and runway excursion.Jul 16, 2012 · N566FD · Minor damageNTSB CEN12LA381Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Farmersville, OHThe pilot did not maintain directional control of the airplane on takeoff after noting reduced engine power in high density altitude.Jun 18, 2012 · N7075H · Substantial damageNTSB CEN12LA369Accident · No injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Norwalk, OHThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.Jun 8, 2012 · N721R · Substantial damageNTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.Jun 4, 2012 · N2434M · Substantial damage