NTSB investigations, 2012, OH

9 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2012, OH per year, 2008–2026: 99 cases
20088
20097
20104
20115
20129
20133
20145
20154
201610
20176
201810
20195
20204
20214
20223
20232
20243
20251
20266

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\" = '230' 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 CEN13CA043Accident · Minor injuriesData collectionFinal reportFairchild Heli-Porter Pilatus PC6/B1A-H2 · Georgetown, OHThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Nov 3, 2012 · N476XP · Substantial damageNTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.Aug 30, 2012 · N84KF · Substantial damageNTSB CEN12CA585Accident · No injuriesData collectionFinal reportCessna 180 · Brookville, OHThe pilot's failure to maintain directional control of the airplane during the attempted takeoff in gusting crosswind conditions.Aug 28, 2012 · N2909A · 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 CEN12CA413Accident · Serious injuriesData collectionFinal reportCessna 182K · Newark, OHThe pilot's loss of control during taxi in strong wind conditions.Jun 29, 2012 · N2591R · 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 CEN12CA238Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Youngstown, OHThe pilot's loss of control while landing, which resulted in a ground loop.Apr 9, 2012 · N441TC · Substantial damageNTSB CEN12LA176Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Bowling Green, OHThe pilot’s failure to maintain directional control during landing.Feb 19, 2012 · N45TT · Substantial damage