NTSB investigations, 2009, MI

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

Cases per year

20082026
NTSB investigations, 2009, 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\") = 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\" = '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 CEN10FA063Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Harrison, MIA loss of aircraft control for undetermined reasons.Dec 4, 2009 · N85EM · DestroyedNTSB CEN10LA031Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gaylord, MIThe pilot's failure to maintain adequate airspeed during a low altitude turn resulting in an aerodynamic stall/spin and loss of control.Oct 27, 2009 · N2239E · DestroyedNTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.Oct 23, 2009 · N6025U · Substantial damageNTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.Sep 2, 2009 · N9649U · Substantial damageNTSB CEN09LA549Accident · 1 fatalLimited investigationFinal reportPiper PA-15 · Lakeview, MIThe pilot's failure to maintain control of the airplane.Aug 26, 2009 · N4585H · DestroyedNTSB CEN09CA513Accident · No injuriesData collectionFinal reportBeech A36TC · Brighton, MIThe pilot's failure to maintain airspeed and compensate for wind conditions during final approach.Aug 9, 2009 · N336TC · Substantial damageNTSB CEN09LA512Accident · 1 fatalLimited investigationFinal reportHooper James A Bushby MUS · Gladwin, MIThe pilot's failure to maintain aircraft control for undetermined reasons.Aug 7, 2009 · N37JD · DestroyedNTSB CEN09CA334Accident · Minor injuriesData collectionFinal reportAerotrike Safari · Lake City, MIThe pilot's failure to maintain adequate airspeed during the initial climb.May 23, 2009 · N8035W · Substantial damageNTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.May 21, 2009 · N39JT · Destroyed