NTSB investigations, 2009, MI

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

Cases per year

20082026
NTSB investigations, 2009, MI per year, 2008–2026: 82 cases
20081
20097
20104
20116
20122
20136
20148
20155
20166
20172
20185
20193
20207
20216
20222
20248
20253
20261

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\") = 2009
    AND c.\"eventStateOrRegion\" = 'MI' 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 CEN09CA583Accident · No injuriesData collectionFinal reportSierra E5A Replica · Port Huron, MIThe pilot's failure to maintain aircraft control during landing.Sep 12, 2009 · N44062 · Substantial damageNTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.Sep 2, 2009 · N6446F · Substantial damageNTSB CEN09CA545Accident · Minor injuriesData collectionFinal reportDekkinga Vans RV-7A · Jenison, MIThe pilot's failure to maintain aircraft control during the landing.Aug 27, 2009 · N811AK · Substantial damageNTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.Aug 15, 2009 · N4380H · Substantial damageNTSB CEN09CA426Accident · No injuriesData collectionFinal reportCessna A188B · South Haven, MIThe pilot's failure to maintain directional control during landing.Jun 15, 2009 · N9010R · Substantial damageNTSB CEN09LA319Accident · No injuriesLimited investigationFinal reportMileski Zenair · New Hudson, MIThe pilot's improper flare which resulted in a hard landing and subsequent failure of the nose landing gear.May 24, 2009 · N701MW · Substantial damageNTSB CEN09LA291Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe · Brighton, MIThe pilot's failure to attain the proper touchdown point, and his failure to initiate a go-around.May 12, 2009 · N99811 · Substantial damage