NTSB investigations, 2009, MI

19 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2009, MI per year, 2008–2026: 222 cases
200814
200919
201017
201122
201219
201317
201415
20159
201613
201712
201814
201916
20205
202110
20227
20237
20243
20253

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\" = '470' 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 CEN10LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Coldwater, MIA loss of engine power due to the separation of the No. 4 piston connecting rod as a result of inadequate torque of the connecting rod bolt.Nov 2, 2009 · N8364W · Substantial damageNTSB 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 CEN10FA029Accident · 1 fatalField investigationFinal reportBeech A36TC · Kalamazoo, MIThe loss of engine power for an undetermined reason.Oct 27, 2009 · C-FFIH · 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 CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.Sep 25, 2009 · N4864S · 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 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 CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.Aug 25, 2009 · N2418T · Substantial damageNTSB CEN09CA517Accident · No injuriesData collectionFinal reportBell 47G-2A · Covert, MIA loss of engine power due to fuel starvation as a result of blocked fuel vents.Aug 11, 2009 · N9526 · Substantial damageNTSB 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 CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.Jul 31, 2009 · N337BA · Substantial damageNTSB CEN09LA353Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103C Twin III Acro · Gregory, MIThe pilot's failure to maintain sufficient airspeed during the turn to return for landing, which resulted an inadvertent stall/spin. Contributing to the accident was the failure of the ground winch tow cable shortly after takeoff.Jun 14, 2009 · N103MS · Substantial damageNTSB CEN09CA338Accident · Minor injuriesData collectionFinal reportGarrett Rans S-6ES · Williamsburg, MIThe pilot/builder's improper installation of the fuel line cable-tie, which resulted in fuel starvation and the loss of engine power.Jun 5, 2009 · N213KT · Substantial damageNTSB 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 · DestroyedNTSB 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