# NTSB investigations, MI: Maneuvering

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 7 · 321 cases

## Latest cases

- [NTSB ANC26FA002](https://openairdocs.org/ntsb/ANC26FA002.md): Raytheon Hawker 800XP · Bath, MI · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 16, 2025 · XA-JMR · Destroyed
  > On October 16, 2025, about 1728 eastern standard time, a Raytheon Hawker 800XP airplane, Mexican registration XA-JMR, was destroyed when it was involved in an accident near Bath Township, Michigan. The captain, co-pilot, and passenger were fatally injured.…
- [NTSB CEN24LA318](https://openairdocs.org/ntsb/CEN24LA318.md): Ayres S2R · Stanwood, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2024 · N4004K · Substantial damage
  > The pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…
- [NTSB CEN24LA230](https://openairdocs.org/ntsb/CEN24LA230.md): Cirrus Design SR20 · Litchfield, MI · Accident · No injuries · Class 4 · Limited · Final report · Jun 19, 2024 · N154WF · Substantial damage
  > The student pilot’s loss of control and the flight instructor’s delayed remedial reaction which resulted in a spin.
- [NTSB CEN23FA361](https://openairdocs.org/ntsb/CEN23FA361.md): Mikoyan Gurevich MIG-23UB · Belleville, MI · Accident · Serious injuries · Class 3 · Field · Final report · Aug 13, 2023 · N23UB · Destroyed
  > A reported partial loss of engine power while maneuvering for reasons that could not be determined.
- [NTSB CEN23FA257](https://openairdocs.org/ntsb/CEN23FA257.md): Avid Magnum · Beaver Island, MI · Accident · 1 fatal · Class 3 · Field · Final report · Jun 23, 2023 · N103DG · Substantial damage
  > The pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.
- [NTSB CEN23LA219](https://openairdocs.org/ntsb/CEN23LA219.md): Robinson Helicopter R44 · Pontiac, MI · Accident · No injuries · Class 4 · Limited · Final report · May 31, 2023 · N7102Z · Substantial damage
  > The flight crew’s inadequate compensation for gusting wind, and the flight instructor’s delayed remedial action, which resulted in impact with the ground.
- [NTSB ERA22FA351](https://openairdocs.org/ntsb/ERA22FA351.md): Smith Aerostar 600 · South Haven Charter Township, MI · Accident · 2 fatal · Class 3 · Field · Final report · Aug 2, 2022 · N9784Q · Destroyed
  > A loss of power to the left engine due to contamination of the fuel system. Contributing to the accident was the pilots’ failure to properly configure the airplane for flight with one engine inoperative.
- [NTSB CEN21LA387](https://openairdocs.org/ntsb/CEN21LA387.md): Six Chuter Skye Ryder · Harrison, MI · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 11, 2021 · UNREG · Substantial damage
  > The pilot’s loss of control while maneuvering at low altitude, which resulted in impact with terrain.
- [NTSB CEN21LA283](https://openairdocs.org/ntsb/CEN21LA283.md): Air Tractor AT-502B · Edwardsburg, MI · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 20, 2021 · N8523Z · Substantial damage
  > The 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.
- [NTSB CEN21LA123](https://openairdocs.org/ntsb/CEN21LA123.md): Piper J3F-50 · Weidman, MI · Accident · No injuries · Class 4 · Limited · Final report · Feb 3, 2021 · N26811 · Substantial damage
  > The pilot’s failure to maintain clearance from terrain during a low approach over a snow-covered runway. Contributing to the accident was the loss of depth perception due to the bright sunlight and snow.
- [NTSB CEN20LA272](https://openairdocs.org/ntsb/CEN20LA272.md): Golden Circle Air T-Bird · Grosse Ile, MI · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 11, 2020 · N50JH · Substantial damage
  > The noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.
- [NTSB CEN19LA214](https://openairdocs.org/ntsb/CEN19LA214.md): Piper PA18 · Bay City, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 6, 2019 · N796AB · Substantial damage
  > The pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.
- [NTSB CEN19FA134](https://openairdocs.org/ntsb/CEN19FA134.md): Alliant Destiny 2000 · New Era, MI · Accident · 1 fatal · Class 2 · Field · Final report · May 4, 2019 · N65481 · Destroyed
  > The pilot's failure to maintain aircraft control while maneuvering that resulted in collapse of the canopy and an uncontrolled descent into terrain.
- [NTSB CEN19CA062](https://openairdocs.org/ntsb/CEN19CA062.md): Piper PA 18 · Iron Mountain, MI · Accident · Minor injuries · Data collection · Final report · Jan 19, 2019 · N3298Z · Substantial damage
  > The pilot's distraction and subsequent loss of situational awareness and visual horizon in overcast sky conditions, which led to an unrecognized descent during a low-level maneuver and subsequent impact with snow-covered terrain.
- [NTSB CEN18FA339](https://openairdocs.org/ntsb/CEN18FA339.md): Air Tractor AT502 · Bronson, MI · Accident · 1 fatal · Field investigation · Final report · Aug 18, 2018 · N502RL · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering, which resulted in exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control at an altitude too low for recovery.
- [NTSB CEN18LA313](https://openairdocs.org/ntsb/CEN18LA313.md): Brantly B-2 · Midland, MI · Accident · No injuries · Limited investigation · Final report · Aug 3, 2018 · N5901X · Substantial damage
  > The in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.
- [NTSB CEN18LA106](https://openairdocs.org/ntsb/CEN18LA106.md): Schweizer 269D · Stockbridge, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 13, 2018 · N471RA · Substantial damage
  > The pilot’s failure to maintain adequate clearance from terrain while maneuvering the helicopter at a low altitude after departure. Contributing to the accident were the pilot’s distraction by the smoke in the cabin and the limited visible features in the…
- [NTSB CEN18FA001](https://openairdocs.org/ntsb/CEN18FA001.md): Brantly B 2B · Midland, MI · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2017 · N2284U · Substantial damage
  > The pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…
- [NTSB CEN17FA332](https://openairdocs.org/ntsb/CEN17FA332.md): Cessna 180J · Gaylord, MI · Accident · Serious injuries · Field investigation · Final report · Aug 28, 2017 · N180LP · Substantial damage
  > The pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.
- [NTSB CEN17LA316](https://openairdocs.org/ntsb/CEN17LA316.md): Navion Navion G · Adrian, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 11, 2017 · N249KC · Substantial damage
  > A leak in the gascolator, which allowed air to enter the fuel system and resulted in a partial loss of engine power.
- [NTSB CEN16FA240](https://openairdocs.org/ntsb/CEN16FA240.md): Aeronca 11AC · Frankenmuth, MI · Accident · 2 fatal · Field investigation · Final report · Jul 3, 2016 · N86078 · Destroyed
  > The pilot's loss of control for undetermined reasons based on available information.
- [NTSB CEN15LA398](https://openairdocs.org/ntsb/CEN15LA398.md): Buckeye Dream Macine · Zeeland, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2015 · UNREG · Destroyed
  > The noncertificated pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from a tree.
- [NTSB GAA15CA102](https://openairdocs.org/ntsb/GAA15CA102.md): Bell 206 - B11 · Caledonia, MI · Accident · No injuries · Data collection · Final report · May 29, 2015 · N206ED · Substantial damage
  > A loss of tail rotor effectiveness while maneuvering at low altitude, resulting in a collision with trees.
- [NTSB CEN15LA235](https://openairdocs.org/ntsb/CEN15LA235.md): Lathrop Steven A B8M · Ravenna, MI · Accident · Serious injuries · Limited investigation · Final report · May 1, 2015 · N5606X · Destroyed
  > A total loss of engine power due to carburetor icing.
- [NTSB CEN14LA371](https://openairdocs.org/ntsb/CEN14LA371.md): Air Command 532 · Petersburg, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 10, 2014 · UNREG · Substantial damage
  > The noncertificated pilot’s failure to maintain control of the gyroplane following a total loss of engine power due to a loose spark plug.
- [NTSB CEN13LA546](https://openairdocs.org/ntsb/CEN13LA546.md): Brantly B-2B · Rothbury, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 2013 · N2253U · Substantial damage
  > The pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.
- [NTSB CEN13CA501](https://openairdocs.org/ntsb/CEN13CA501.md): Mcdonnell Douglas Heli 369FF · Reese, MI · Accident · No injuries · Data collection · Final report · Aug 22, 2013 · N975BW · Substantial damage
  > The failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.
- [NTSB CEN13LA493](https://openairdocs.org/ntsb/CEN13LA493.md): Trick Trikes Storm Trooper · Covert, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 2013 · N5157G · Substantial damage
  > The student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.
- [NTSB CEN13LA422](https://openairdocs.org/ntsb/CEN13LA422.md): Grumman Aircraft Cor-Schweizer G-164A · Elmira, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2013 · N8719H · Substantial damage
  > The pilot's failure to maintain clearance from a line of trees while applying agricultural product to a field.
- [NTSB CEN13LA401](https://openairdocs.org/ntsb/CEN13LA401.md): JDT 1600R · Chesaning, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 6, 2013 · UNREG · Destroyed
  > The failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…
- [NTSB CEN13LA383](https://openairdocs.org/ntsb/CEN13LA383.md): Vink Robert D Youngster · Grand Haven, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2013 · N258RV · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB CEN13LA086](https://openairdocs.org/ntsb/CEN13LA086.md): Bell 47G-2 · Walkerville, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 1, 2012 · N3755Z · Substantial damage
  > The pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.
- [NTSB CEN12CA603](https://openairdocs.org/ntsb/CEN12CA603.md): Flight Design Ctls · Pittsford, MI · Accident · Minor injuries · Data collection · Final report · Aug 31, 2012 · N995LS · Substantial damage
  > The student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.
- [NTSB CEN12LA578](https://openairdocs.org/ntsb/CEN12LA578.md): Destiny XLT · Hart, MI · Accident · 2 fatal · Limited investigation · Final report · Aug 24, 2012 · N1674A · Substantial damage
  > The partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.
- [NTSB CEN12LA483](https://openairdocs.org/ntsb/CEN12LA483.md): Eipper Quicksilver MXL II · Goodrich, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 2012 · UNREG · Substantial damage
  > The operation of an unregistered and unairworthy airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s improper preflight inspection, which resulted in a total loss of engine power due to water/debris…
- [NTSB CEN12LA330](https://openairdocs.org/ntsb/CEN12LA330.md): Schleicher ASW-27 · Ionia, MI · Accident · 1 fatal · Limited investigation · Final report · May 29, 2012 · N127PC · Substantial damage
  > The pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.
- [NTSB CEN12LA324](https://openairdocs.org/ntsb/CEN12LA324.md): North American T-6G · Perry, MI · Accident · 1 fatal · Limited investigation · Final report · May 28, 2012 · N3753G · Substantial damage
  > The pilot’s failure to maintain control while maneuvering at low altitude after takeoff, resulting in a collision with a barn.
- [NTSB CEN12IA385](https://openairdocs.org/ntsb/CEN12IA385.md): Cessna 182 · Fowlerville, MI · Incident · No injuries · Incident investigation · Final report · May 27, 2012 · N287TC · Minor damage
  > The airplane’s encounter with clear air turbulence, which caused a momentary loss of control and minor damage to the airplane.
- [NTSB CEN12LA318](https://openairdocs.org/ntsb/CEN12LA318.md): Aeros Ltd/Skyranger Skyranger II · Saline, MI · Accident · Serious injuries · Limited investigation · Final report · May 25, 2012 · N192RR · Substantial damage
  > The pilot did not maintain proper control of the airplane while maneuvering at low altitude, which resulted in an aerodynamic stall.
- [NTSB CEN12LA296](https://openairdocs.org/ntsb/CEN12LA296.md): Maule M-7-420AC · Hanover Township, MI · Accident · Minor injuries · Limited investigation · Final report · May 13, 2012 · N420RP · Substantial damage
  > A total loss of engine power for reasons that could not be determined during an exhaustive postaccident examination of the engine and its components.
- [NTSB CEN12CA294](https://openairdocs.org/ntsb/CEN12CA294.md): Beckert Bruce A RV-6 · Au Gres, MI · Accident · Serious injuries · Data collection · Final report · May 13, 2012 · N212LB · Substantial damage
  > The pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.
- [NTSB CEN12FA097](https://openairdocs.org/ntsb/CEN12FA097.md): Piper PA-32-260 · St. Ignace, MI · Accident · 2 fatal · Field investigation · Final report · Dec 4, 2011 · N33315 · Substantial damage
  > The pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.
- [NTSB CEN11FA666](https://openairdocs.org/ntsb/CEN11FA666.md): Robinson Helicopter R44 · Curren, MI · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2011 · N8324F · Substantial damage
  > The non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.
- [NTSB CEN11CA638](https://openairdocs.org/ntsb/CEN11CA638.md): Enstrom F-28F · Menominee, MI · Accident · No injuries · Data collection · Final report · Aug 29, 2011 · N228F · Substantial damage
  > The pilot's failure to maintain control of the helicopter during a hover.
- [NTSB CEN11LA606](https://openairdocs.org/ntsb/CEN11LA606.md): Boeing A75N1(PT17) · Mt. Clemens, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 21, 2011 · N49739 · 2 aircraft · No damage
  > The wing walker’s decision to release his grip of the airplane during an attempted aerial transfer from airplane to helicopter before both aircraft achieved the proper relative positioning for the transfer.
- [NTSB CEN11FA480](https://openairdocs.org/ntsb/CEN11FA480.md): Taylorcraft DCO-65 · Boyne City, MI · Accident · 1 fatal · Field investigation · Final report · Jul 16, 2011 · N50408 · Substantial damage
  > The pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.
- [NTSB CEN11LA459](https://openairdocs.org/ntsb/CEN11LA459.md): Wingtip To Wingtip Panzl S-330 · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Jul 3, 2011 · N330JK · Substantial damage
  > The inadequate aileron hinge design, which resulted in the in-flight separation of the left aileron following a fatigue failure of the center hinge rod-end.
- [NTSB CEN11FA417](https://openairdocs.org/ntsb/CEN11FA417.md): Beech A36 · Charlevoix, MI · Accident · 2 fatal · Field investigation · Final report · Jun 24, 2011 · N88MN · Substantial damage
  > The pilot's inadequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to not execute a missed approach in weather conditions below minimums.
- [NTSB CEN11FA253](https://openairdocs.org/ntsb/CEN11FA253.md): Piper PA46-350P · Monroe, MI · Accident · 3 fatal · Field investigation · Final report · Mar 29, 2011 · N619VH · Substantial damage
  > The pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.
- [NTSB CEN11LA182](https://openairdocs.org/ntsb/CEN11LA182.md): Cessna 150L · Trenton, MI · Accident · No injuries · Limited investigation · Final report · Feb 12, 2011 · N6622G · Substantial damage
  > The loss of preload torque on a connecting rod nut and bolt, which precipitated a separation of the connecting rod from the engine's crankshaft and resulted in the total loss of engine power.

Next page: https://openairdocs.org/ntsb-phases/450/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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/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.