NTSB investigations, 2010, MI

7 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2010, MI per year, 2008–2026: 103 cases
20084
20099
20107
20118
201210
201310
20148
20153
20165
20171
20186
20198
20202
20214
20222
20234
20242
20258
20262

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\") = 2010
    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\" = '240' 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 CEN11CA135Accident · No injuriesData collectionFinal reportAllen Raymond H Lancair Legacy · Troy, MIThe pilot's failure to maintain adequate airspeed during the landing which resulted in an inadvertent stall. Contributing to the accident was the structural icing on the airframe.Dec 25, 2010 · N385AS · Substantial damageNTSB CEN11FA029Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Sebewaing, MIThe pilot's failure to maintain airspeed and aircraft control following a loss of engine power after takeoff.Oct 18, 2010 · N105AC · Substantial damageNTSB CEN11LA014Accident · Serious injuriesLimited investigationFinal reportDrake Ronald A Acro Sport 1 · Fowlerville, MIThe pilot's loss of control during a go-around maneuver following a bounced landing. Contributing to the accident was the pilot's limited experience in the make and model airplane.Oct 11, 2010 · N53DB · Substantial damageNTSB CEN10FA394Accident · 4 fatalField investigationFinal reportBeech 58 · St. Ignace, MIThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons.Jul 13, 2010 · N3081N · Substantial damageNTSB CEN10CA187Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Maybee, MIThe pilot's failure to compensate for gusting crosswinds resulting in the loss of directional control while landing.Apr 3, 2010 · N125AB · Substantial damageNTSB CEN10FA182Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Spol Sro Mermaid · Algonac, MIThe pilot’s loss of control resulting from an aerodynamic stall/spin while maneuvering at low altitude.Apr 1, 2010 · N853CZ · DestroyedNTSB CEN10FA101Accident · 2 fatalField investigationFinal reportCessna 172 · Holland, MIThe pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…Jan 17, 2010 · N8405E · Destroyed