NTSB investigations, MI

6 cases where NTSB found Sloped/uneven terrain.

Cases per year

20102026
NTSB investigations, MI per year, 2010–2026: 6 cases
20102
20161
20181
20211
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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03021017'))
  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 CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.Jun 3, 2026 · N4101M · Substantial damageNTSB CEN21LA283Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Edwardsburg, MIThe pilot’s failure to identify rising terrain and to maintain terrain clearance from trees during an aerial application pass that resulted in an in-flight collision with trees and terrain.Jun 20, 2021 · N8523Z · Substantial damageNTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.Jul 1, 2018 · N66568 · Substantial damageNTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.May 18, 2016 · N757LF · Substantial damageNTSB CEN10LA498Accident · Minor injuriesLimited investigationFinal reportFreeman Super Koala · Traverse City, MIA loss of engine power due to the improper torquing of the number one cylinder's spark plug as a result of inadequate maintenance.Aug 24, 2010 · N220FF · Substantial damageNTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.Apr 12, 2010 · N93876 · Substantial damage