NTSB investigations, 2013, MI

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

Cases per year

20082026
NTSB investigations, 2013, 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\") = 2013
    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 CEN14LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Oscoda, MIThe student pilot’s loss of control during landing in gusting wind conditions. Contributing to the accident was the pilot’s decision to land with gusting wind.Dec 11, 2013 · N5386Z · Substantial damageNTSB CEN13CA479Accident · Minor injuriesData collectionFinal reportKerr Matthew Starduster TOO · Frankenmuth, MIThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and subsequent impact with a corn field.Aug 10, 2013 · N159MK · Substantial damageNTSB CEN13CA335Accident · No injuriesData collectionFinal reportCessna 172S · Ann Arbor, MIThe pilot’s failure to make a go-around in a timely manner and his loss of control during landing.Jun 9, 2013 · N857SP · Substantial damageNTSB CEN13CA202Accident · No injuriesData collectionFinal reportCessna 172L · Pontiac, MIThe pilot's failure to maintain airplane control after an unexplained increase in engine power while taxiing.Mar 17, 2013 · N7282Q · Substantial damageNTSB CEN13CA185Accident · Minor injuriesData collectionFinal reportPiper PA22 · Baraga, MIThe pilot’s failure to maintain directional control during taxi.Mar 2, 2013 · N2238A · Substantial damageNTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.Feb 12, 2013 · N12989 · Substantial damage