NTSB investigations, 2010, MI

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 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\" = '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 CEN11CA047Accident · No injuriesData collectionFinal reportAardema Robert John 1 Aardema RAG WNG SP · Oshtemo, MIThe failure of the ignition system wiring, which resulted in a total loss of engine power.Oct 29, 2010 · N768BA · 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 CEN11CA003Accident · Minor injuriesData collectionFinal reportCessna 310J · St. Johns, MIThe failure by the pilot to attain/maintain a climb rate for undetermined reasons during a go-around.Oct 1, 2010 · N3051L · Substantial damageNTSB CEN10CA548Accident · No injuriesData collectionFinal reportPiper PA-17 · Edwardsburg, MIA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot’s improper fuel planning.Sep 19, 2010 · N4610H · Substantial damageNTSB CEN10LA571Accident · Serious injuriesLimited investigationFinal reportCa Tecnam P2004 Bravo · Mason, MIA total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.Sep 17, 2010 · N508LM · Substantial damageNTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.Sep 9, 2010 · N3560B · Substantial damageNTSB CEN10CA469Accident · Serious injuriesData collectionFinal reportHughes 269B · Lakeview, MIThe pilot's excessive descent angle during landing approach, which resulted in a settling with power condition.Aug 7, 2010 · N11XC · Substantial damageNTSB CEN10CA467Accident · No injuriesData collectionFinal reportCessna 152 · Breckenridge, MIThe pilot's failure to mantain directional control during the aborted landing.Jul 30, 2010 · N24472 · Substantial damageNTSB CEN10LA432Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Muskegon, MIA loss of engine power for undetermined reasons.Jul 25, 2010 · N24584 · 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 CEN10CA317Accident · No injuriesData collectionFinal reportBell 47G · Plymouth, MIThe pilot's failure to use carburetor heat, which led to carburetor icing and a loss of engine power following takeoff.Jun 13, 2010 · N47WK · Substantial damageNTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.Apr 12, 2010 · N3470R · Substantial damageNTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.Apr 3, 2010 · N222UN · 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 CEN10CA155Accident · No injuriesData collectionFinal reportSchulke Avid Magnum · Lowell, MIThe pilot's inability to maintain directional control while landing on a slush-covered runway due to inadequate maintenance of the airplane brakes by maintenance personnel.Mar 2, 2010 · N103DG · Substantial damageNTSB 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