# NTSB investigations, MI: Takeoff

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 9 · 408 cases

## Latest cases

- [NTSB CEN27LA026](https://openairdocs.org/ntsb/CEN27LA026.md): Piper J3C-65 · Eagle Harbor, MI · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 17, 2026 · N3368N · Substantial damage
- [NTSB CEN26LA320](https://openairdocs.org/ntsb/CEN26LA320.md): Diamond Aircraft Ind DA20-C1 · Howell, MI · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 13, 2026 · N942RM · Substantial damage
- [NTSB CEN26LA292](https://openairdocs.org/ntsb/CEN26LA292.md): Taylorcraft DCO-65 · Copper City, MI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 14, 2026 · N48446 · Substantial damage
  > On August 14, 2026, about 1945 central daylight time, a Taylorcraft DCO-65 airplane, N48446, was substantially damaged when it was involved in an accident near Copper City, Michigan. The pilot was seriously injured. The pilot-rated passenger was not injured.…
- [NTSB CEN26LA285](https://openairdocs.org/ntsb/CEN26LA285.md): Staudacher Jon ZZ 102 · Vicksburg, MI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 12, 2026 · N134ZZ · Substantial damage
  > On August 12, 2026, about 1906 eastern daylight time, a Staudacher ZZ 102 experimental airplane, N134ZZ, was substantially damaged when it was involved in an accident near Vicksburg, Michigan. The airline transport pilot and one passenger were seriously…
- [NTSB ANC26LA031](https://openairdocs.org/ntsb/ANC26LA031.md): Piper PA-28-151 · Lapeer, MI · Accident · No injuries · Class 4 · Limited · Final report · Apr 23, 2026 · N44690 · Substantial damage
  > The flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…
- [NTSB CEN25LA383](https://openairdocs.org/ntsb/CEN25LA383.md): Quad City Challenger · Crystal Mountain, MI · Accident · No injuries · Class 4 · Limited · Final report · Sep 16, 2025 · N65176 · Substantial damage
  > The pilot’s failure to maintain aircraft control during initial climb.
- [NTSB OPS25LA054](https://openairdocs.org/ntsb/OPS25LA054.md): Bombardier CL-600-2D24 · Freeland, MI · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 16, 2025 · N833SK · No damage
  > On July 16, 2025, about 1542 eastern daylight time (EDT), SkyWest Airlines (SKW) flight 3751, a Bombardier CL-600-2D24, N833SK, departed from a closed runway at MBS International Airport (MBS), Freeland, Michigan. The flight continued without further incident…
- [NTSB CEN25LA241](https://openairdocs.org/ntsb/CEN25LA241.md): Cessna 177 · Jenison, MI · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 8, 2025 · N29342 · Substantial damage
  > The pilot’s failure to maintain airplane control and clearance from trees during takeoff.
- [NTSB ERA25FA248](https://openairdocs.org/ntsb/ERA25FA248.md): Robert Fidler Lancair 320/360 · Zeeland, MI · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 29, 2025 · N360RF · Destroyed
  > On June 29, 2025, at 10:49 eastern daylight time, an experimental, amateur-built Lancair 360, N360RF, was destroyed when it was involved in an accident near Zeeland, Michigan. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB CEN25LA195](https://openairdocs.org/ntsb/CEN25LA195.md): Cessna 182 · Charlevoix, MI · Accident · No injuries · Class 4 · Limited · Final report · Jun 2, 2025 · N71149 · Substantial damage
  > The pilot’s failure to maintain pitch control during the takeoff that resulted in multiple bounces and substantial damage to the fuselage.
- [NTSB CEN25LA102](https://openairdocs.org/ntsb/CEN25LA102.md): Cessna 177 · Iron River, MI · Accident · No injuries · Class 4 · Limited · Final report · Feb 24, 2025 · N34284 · Substantial damage
  > The airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.
- [NTSB CEN22LA385](https://openairdocs.org/ntsb/CEN22LA385.md): Piper PA-28-140 · Sparta, MI · Accident · No injuries · Class 3 · Limited · Final report · Aug 10, 2022 · N55338 · Substantial damage
  > The pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.
- [NTSB CEN22LA358](https://openairdocs.org/ntsb/CEN22LA358.md): Cessna 120 · Mecosta, MI · Accident · No injuries · Class 4 · Limited · Final report · Jul 30, 2022 · N2902N · Substantial damage
  > The pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.
- [NTSB CEN22LA052](https://openairdocs.org/ntsb/CEN22LA052.md): Cirrus Design SR20 · Marshall, MI · Accident · No injuries · Class 4 · Limited · Final report · Nov 20, 2021 · N22WU · Substantial damage
  > The airplane’s collision with a deer during takeoff.
- [NTSB CEN21LA420](https://openairdocs.org/ntsb/CEN21LA420.md): Quad City Ultralight Challenger II · Rogers City, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 11, 2021 · N778H · Substantial damage
  > The separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…
- [NTSB CEN21LA384](https://openairdocs.org/ntsb/CEN21LA384.md): Cirrus Design SF50 · Lansing, MI · Accident · No injuries · Class 3 · Limited · Final report · Aug 24, 2021 · N1GG · Destroyed
  > The pilot’s decision to depart with a tailwind as a thunderstorm approached, which resulted in a loss of airplane performance due to an encounter with a significant tailwind gust and a subsequent runway excursion.
- [NTSB CEN21LA294](https://openairdocs.org/ntsb/CEN21LA294.md): Consolidated Aeronautics Lake LA-4-200 · Mio, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 28, 2021 · N963L · Substantial damage
  > The pilot’s failure to abort the takeoff roll when the engine did not produce full power.
- [NTSB CEN20LA431](https://openairdocs.org/ntsb/CEN20LA431.md): Cessna 172 · Big Rapids, MI · Accident · No injuries · Class 4 · Limited · Final report · Sep 29, 2020 · N79300 · Substantial damage
  > The airplane’s impact with a deer during takeoff.
- [NTSB CEN20LA372](https://openairdocs.org/ntsb/CEN20LA372.md): Cessna 414 · Ray, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 30, 2020 · N698D · Substantial damage
  > The pilot’s loss of directional control on takeoff.
- [NTSB CEN20CA387](https://openairdocs.org/ntsb/CEN20CA387.md): Powrachute Airwolf · Casco, MI · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 11, 2020 · N465JP · Substantial damage
  > The pilot's decision to takeoff towards known obstacles which resulted in an impact with a power line.
- [NTSB CEN20CA213](https://openairdocs.org/ntsb/CEN20CA213.md): Piper PA18 · Cadillac, MI · Accident · Minor injuries · Class 4 · Data collection · Final report · Jun 4, 2020 · N68EE · Substantial damage
  > The pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.
- [NTSB CEN19FA279](https://openairdocs.org/ntsb/CEN19FA279.md): Aero Commander 200 · Howell, MI · Accident · 2 fatal · Class 3 · Field · Final report · Aug 20, 2019 · N200HS · Substantial damage
  > The improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…
- [NTSB CEN19LA217](https://openairdocs.org/ntsb/CEN19LA217.md): Piper PA34 · Ypsilanti, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2019 · N2930Y · Substantial damage
  > The pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…
- [NTSB WPR19TA009](https://openairdocs.org/ntsb/WPR19TA009.md): Kreling Supercat · Three Rivers, MI · Accident · Serious injuries · Final report · Oct 9, 2018 · UNREG · Substantial damage
  > The pilot's failure to maintain the proper pitch attitude and adequate airspeed during takeoff, which resulted in an aerodynamic stall.
- [NTSB CEN18LA365](https://openairdocs.org/ntsb/CEN18LA365.md): MD Helicopters MD-369 · Orchard Lake, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 2018 · N1601Y · Substantial damage
  > The pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.
- [NTSB CEN18TA374](https://openairdocs.org/ntsb/CEN18TA374.md): Beech 35 · Harrisville, MI · Accident · Minor injuries · Final report · Sep 1, 2018 · N5321E · Substantial damage
  > The pilot’s delayed decision to abort the takeoff, which resulted in the loss of lateral control of the airplane and collision with trees at the end of the runway. Contributing to the accident was the pilot’s decision to depart with a center of gravity…
- [NTSB CEN18LA280](https://openairdocs.org/ntsb/CEN18LA280.md): Best Off Skyranger · Houghton Lake, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 8, 2018 · N4329R · Substantial damage
  > A partial loss of engine power during takeoff for undetermined reasons.
- [NTSB GAA18CA407](https://openairdocs.org/ntsb/GAA18CA407.md): Beech 58 · Mackinac Island, MI · Accident · No injuries · Data collection · Final report · Jul 1, 2018 · N66568 · Substantial damage
  > The 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.
- [NTSB CEN18LA206](https://openairdocs.org/ntsb/CEN18LA206.md): Hughes Aero Predator "C" · Copemish, MI · Accident · Serious injuries · Limited investigation · Final report · May 29, 2018 · N369SL · Minor damage
  > The pilot's improper decision to take off with a passenger in high-density altitude conditions from a runway with tall grass present, which resulted in the powered-parachute's poor takeoff performance and its inability to clear a tree line and led to a…
- [NTSB CEN18FA160](https://openairdocs.org/ntsb/CEN18FA160.md): Belair Raven · Sault Ste Marie, MI · Accident · 2 fatal · Field investigation · Final report · May 5, 2018 · C-FNKZ · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff in gusty crosswind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.
- [NTSB CEN17LA257](https://openairdocs.org/ntsb/CEN17LA257.md): Cessna 182T · Jackson, MI · Accident · No injuries · Limited investigation · Final report · Jul 5, 2017 · CGBFY · Substantial damage
  > The pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.
- [NTSB DCA17FA076](https://openairdocs.org/ntsb/DCA17FA076.md): Mcdonnell Douglas MD80 · Ypsilanti, MI · Accident · Minor injuries · Class 1 · Field · Final report · Mar 8, 2017 · N786TW · Substantial damage
  > the jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…
- [NTSB CEN17LA057](https://openairdocs.org/ntsb/CEN17LA057.md): Stinson 108-3 · Ionia, MI · Accident · No injuries · Limited investigation · Final report · Dec 16, 2016 · N812C · Substantial damage
  > A failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.
- [NTSB OPS16IA002](https://openairdocs.org/ntsb/OPS16IA002.md): Bombardier CL600 2D24 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Jan 27, 2016 · N316PQ · No damage
  > The local controller's failure to visually scan and ensure that the runway surface was not occupied by a vehicle or other aircraft before issuing a takeoff clearance to the pilot. Contributing to this incident was the relieved controller's failure to monitor…
- [NTSB GAA16CA054](https://openairdocs.org/ntsb/GAA16CA054.md): Aeronca 7AC · Fowlerville, MI · Accident · No injuries · Data collection · Final report · Nov 17, 2015 · N84157 · Substantial damage
  > The pilot's failure to maintain pitch control during the takeoff roll, which resulted in an impact with terrain.
- [NTSB CEN15FA386](https://openairdocs.org/ntsb/CEN15FA386.md): Barrow Ted A ONE Easy · Battle Creek, MI · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2015 · N227TB · Destroyed
  > The pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.
- [NTSB GAA15CA143](https://openairdocs.org/ntsb/GAA15CA143.md): Aventura II · Fenton, MI · Accident · No injuries · Data collection · Final report · Jul 17, 2015 · N1204A · Substantial damage
  > The failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.
- [NTSB GAA15CA163](https://openairdocs.org/ntsb/GAA15CA163.md): Gates Learjet 35A · Grosse Ile, MI · Accident · No injuries · Data collection · Final report · Jun 22, 2015 · N640BA · Substantial damage
  > The airplane's collision with a deer on the unfenced runway during the takeoff roll. Contributing to the accident is the airport's failure to establish a continuous fence between the runway and the nature conservancy.
- [NTSB CEN15CA097](https://openairdocs.org/ntsb/CEN15CA097.md): Cessna 172M · Marquette, MI · Accident · No injuries · Data collection · Final report · Jan 5, 2015 · N6591H · Substantial damage
  > The pilot did not maintain directional control during takeoff on the snow and ice covered runway in gusting crosswind conditions.
- [NTSB CEN15CA013](https://openairdocs.org/ntsb/CEN15CA013.md): Piper PA-28-181 · Ann Arbor, MI · Accident · No injuries · Data collection · Final report · Oct 10, 2014 · N2817X · Substantial damage
  > The collision with a deer during a night takeoff.
- [NTSB CEN14LA454](https://openairdocs.org/ntsb/CEN14LA454.md): Rans S17 · Lowell, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 24, 2014 · UNREG · Substantial damage
  > The pilot’s overconfidence, which led to his improper decision to continue flight in the recently purchased, unregistered airplane without acquiring training and to his continued erratic handling of the airplane and subsequent loss of airplane control.
- [NTSB CEN14LA406](https://openairdocs.org/ntsb/CEN14LA406.md): Cessna 177RG · Manistee, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2014 · N468LE · Substantial damage
  > The pilot receiving instruction's inability to respond to or compensate for the sudden change in wind direction and speed that the airplane encountered shortly after liftoff, which resulted in a tailwind condition, a corresponding decrease in airspeed, and a…
- [NTSB CEN14LA387](https://openairdocs.org/ntsb/CEN14LA387.md): Aeronca 11AC · Flushing, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2014 · N4453P · Substantial damage
  > The pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…
- [NTSB CEN14CA368](https://openairdocs.org/ntsb/CEN14CA368.md): Mckenzie Douglas E Stol CH750 · Dodgeville, MI · Accident · Minor injuries · Data collection · Final report · Jul 13, 2014 · N792MC · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.
- [NTSB CEN13LA555](https://openairdocs.org/ntsb/CEN13LA555.md): Buckeye Industries Dream Machine · St. Joseph, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2013 · N6122F · Substantial damage
  > The pilot's failure to maintain control of the powered-parachute during takeoff.
- [NTSB CEN13CA469](https://openairdocs.org/ntsb/CEN13CA469.md): Cessna 182T · Mackinac Island, MI · Accident · No injuries · Data collection · Final report · Aug 5, 2013 · N3559E · Substantial damage
  > The pilot's delayed response to abort the takeoff, which resulted in an excursion and collision with a fence. Contributing to the accident was the pilot's failure to check the pitot tube for debris during preflight.
- [NTSB CEN13CA333](https://openairdocs.org/ntsb/CEN13CA333.md): Cessna 172P · Pontiac, MI · Accident · No injuries · Data collection · Final report · Jun 6, 2013 · N549TT · Substantial damage
  > The student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.
- [NTSB CEN13LA076](https://openairdocs.org/ntsb/CEN13LA076.md): Cessna 177RG · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Nov 28, 2012 · N1912Q · Substantial damage
  > A loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.
- [NTSB CEN12LA339](https://openairdocs.org/ntsb/CEN12LA339.md): Piper PA-32-260 · Applegate, MI · Accident · No injuries · Limited investigation · Final report · May 12, 2012 · N4727S · Substantial damage
  > The pilot’s decision to attempt to take off from an unimproved field, which resulted in a collapsed nose landing gear.
- [NTSB CEN12CA270](https://openairdocs.org/ntsb/CEN12CA270.md): Cessna 172M · Three Rivers, MI · Accident · No injuries · Data collection · Final report · May 1, 2012 · N30380 · Substantial damage
  > Collision with a deer during the takeoff roll.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?state=MI&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?state=MI

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.