# NTSB investigations, MI: Approach

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 14 · 652 cases

## Latest cases

- [NTSB CEN27LA012](https://openairdocs.org/ntsb/CEN27LA012.md): Diamond Aircraft Ind DA20-C1 · Flint, MI · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 10, 2026 · N96YY · Substantial damage
- [NTSB CEN25LA401](https://openairdocs.org/ntsb/CEN25LA401.md): CubCrafters CCK-2000 · Thompsonville, MI · Accident · No injuries · Class 3 · Limited · Final report · Sep 7, 2025 · N40DT · Substantial damage
  > A total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…
- [NTSB CEN25FA270](https://openairdocs.org/ntsb/CEN25FA270.md): Van's RV-14 · Lowell, MI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 21, 2025 · N21KL · Destroyed
  > On July 21, 2025, about 1627 eastern daylight time, a Van’s Aircraft RV-14A airplane, N21KL, was destroyed when it was involved in an accident near Lowell, Michigan. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was operated…
- [NTSB CEN25LA147](https://openairdocs.org/ntsb/CEN25LA147.md): Cessna 150F · Zeeland, MI · Accident · No injuries · Class 4 · Limited · Final report · Apr 8, 2025 · N6561F · Substantial damage
  > The flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…
- [NTSB CEN24LA378](https://openairdocs.org/ntsb/CEN24LA378.md): Piper PA32 · Caro, MI · Accident · No injuries · Class 3 · Limited · Final report · Sep 30, 2024 · N31407 · Substantial damage
  > A total loss of engine power due to maintenance personnel’s failure to properly tighten the fuel supply line B-nut at the fuel servo.
- [NTSB CEN24FA215](https://openairdocs.org/ntsb/CEN24FA215.md): Piper PA28 · Clinton, MI · Accident · 1 fatal · Class 3 · Field · Final report · Jun 10, 2024 · N1039X · Substantial damage
  > The flight instructor’s failure to maintain airplane control while maneuvering for a forced landing. Contributing to the accident was the student pilot’s or flight instructor’s inadvertent positioning of the fuel selector valve between the Left Tank and Off…
- [NTSB CEN24LA113](https://openairdocs.org/ntsb/CEN24LA113.md): Piper J3C-65 · South Lyon, MI · Accident · No injuries · Class 4 · Limited · Final report · Feb 12, 2024 · N87965 · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the landing approach.
- [NTSB CEN24LA058](https://openairdocs.org/ntsb/CEN24LA058.md): Piper PA46-500TP · Ann Arbor, MI · Accident · No injuries · Class 4 · Limited · Final report · Dec 10, 2023 · N90ZZ · Substantial damage
  > The airplane’s encounter with unexpected wind shear during final approach, which resulted in a hard landing short of the runway.
- [NTSB CEN23LA266](https://openairdocs.org/ntsb/CEN23LA266.md): Piper PA-28-181 · Howell, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 24, 2023 · N4008Q · Substantial damage
  > A loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.
- [NTSB CEN23LA254](https://openairdocs.org/ntsb/CEN23LA254.md): Let L-23 Super Blanik · Gregory, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 21, 2023 · N10BR · Substantial damage
  > The flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.
- [NTSB CEN23LA214](https://openairdocs.org/ntsb/CEN23LA214.md): Progressive Aerodyne Searey LSA · Detroit, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 1, 2023 · N316SR · Substantial damage
  > A loss of engine power due to fuel exhaustion that resulted from the pilots’ inadequate preflight planning.
- [NTSB CEN23LA161](https://openairdocs.org/ntsb/CEN23LA161.md): Piper PA-28-181 · Flint Township, MI · Accident · No injuries · Class 3 · Limited · Final report · Apr 20, 2023 · N419W · Substantial damage
  > The pilot’s failure to apply carburetor heat during the landing approach, which resulted in a loss of engine power from carburetor ice.
- [NTSB CEN22LA251](https://openairdocs.org/ntsb/CEN22LA251.md): Trojan TA16 · Ray, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 2, 2022 · N36YR · Substantial damage
  > A lack of lubrication and inadequate cooling, which resulted in internal damage to the engine and a subsequent total loss of engine power.
- [NTSB CEN22LA194](https://openairdocs.org/ntsb/CEN22LA194.md): Cessna 172S · Traverse City, MI · Accident · No injuries · Class 3 · Limited · Final report · May 10, 2022 · N184NW · Substantial damage
  > The failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.
- [NTSB CEN22FA032](https://openairdocs.org/ntsb/CEN22FA032.md): Beech E-90 · Boyne City, MI · Accident · 2 fatal · Class 3 · Field · Final report · Nov 15, 2021 · N290KA · Destroyed
  > The pilot’s failure to maintain sufficient airspeed and his exceedance of the airplane’s critical angle of attack while in icing conditions, which resulted in an aerodynamic stall and subsequent ground impact.
- [NTSB CEN22FA031](https://openairdocs.org/ntsb/CEN22FA031.md): Britten-Norman BN-2A · Beaver Island, MI · Accident · 4 fatal · Class 3 · Field · Final report · Nov 13, 2021 · N866JA · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during final approach, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.
- [NTSB CEN21LA303](https://openairdocs.org/ntsb/CEN21LA303.md): Aeronca 15AC · Hastings, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 30, 2021 · N1175H · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN21LA112](https://openairdocs.org/ntsb/CEN21LA112.md): Piper PA-32R-301 · Sparta, MI · Accident · No injuries · Class 3 · Limited · Final report · Jan 12, 2021 · N35718 · Substantial damage
  > The pilot’s failure to maintain the proper glideslope during final approach, which resulted in contact with a snowbank at the approach end of the runway.
- [NTSB CEN21LA104](https://openairdocs.org/ntsb/CEN21LA104.md): Piper PA-24-250 · New Hudson, MI · Accident · 3 fatal · Class 3 · Limited · Final report · Jan 2, 2021 · N8347P · Destroyed
  > The pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…
- [NTSB CEN21LA048](https://openairdocs.org/ntsb/CEN21LA048.md): Piper PA-28-140 · Greenville, MI · Accident · No injuries · Class 3 · Limited · Final report · Nov 7, 2020 · N9993W · Substantial damage
  > The loss of engine power due to fuel starvation during a low approach over the airport, which resulted in a forced landing and impact with terrain.
- [NTSB CEN20LA399](https://openairdocs.org/ntsb/CEN20LA399.md): Vans RV9 · Zeeland, MI · Accident · 2 fatal · Class 3 · Limited · Final report · Sep 19, 2020 · N94KJ · Destroyed
  > The pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.
- [NTSB CEN20FA001](https://openairdocs.org/ntsb/CEN20FA001.md): Socata TBM 700 · Lansing, MI · Accident · 5 fatal · Class 3 · Field · Final report · Oct 3, 2019 · N700AQ · Substantial damage
  > The pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.
- [NTSB CEN19LA179](https://openairdocs.org/ntsb/CEN19LA179.md): Piper PA28 · Cottrellville Township, MI · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 21, 2019 · N2360R · Substantial damage
  > The partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…
- [NTSB CEN19LA066](https://openairdocs.org/ntsb/CEN19LA066.md): Piper PA-32R-300 · Adrian, MI · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 2019 · N8892E · Substantial damage
  > The airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.
- [NTSB CEN19LA059](https://openairdocs.org/ntsb/CEN19LA059.md): Cessna T210 · Flint, MI · Accident · No injuries · Limited investigation · Final report · Jan 6, 2019 · N1237M · Substantial damage
  > The failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.
- [NTSB CEN19LA050](https://openairdocs.org/ntsb/CEN19LA050.md): Cessna R172K · Chesaning, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 2018 · N1095V · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB CEN18FA387](https://openairdocs.org/ntsb/CEN18FA387.md): Beech 200 · Oscoda, MI · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2018 · N241CK · Destroyed
  > The pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.
- [NTSB GAA18CA560](https://openairdocs.org/ntsb/GAA18CA560.md): Piper PA22 · Hillsdale, MI · Accident · Minor injuries · Data collection · Final report · Sep 17, 2018 · N3544A · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.
- [NTSB CEN18FA371](https://openairdocs.org/ntsb/CEN18FA371.md): Cessna 340A · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2018 · C-GLKX · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…
- [NTSB GAA18CA466](https://openairdocs.org/ntsb/GAA18CA466.md): Vans RV9 · Holland, MI · Accident · No injuries · Data collection · Final report · Jul 28, 2018 · N899RV · Substantial damage
  > The pilot’s failure to maintain yaw control during a go-around.
- [NTSB CEN18FA236](https://openairdocs.org/ntsb/CEN18FA236.md): Cessna P210N · Detroit, MI · Accident · 2 fatal · Field investigation · Final report · Jun 24, 2018 · N3896P · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…
- [NTSB CEN18LA123](https://openairdocs.org/ntsb/CEN18LA123.md): Mills Michael S1L · Dewitt, MI · Accident · 1 fatal · Limited investigation · Final report · Mar 22, 2018 · N197X · Substantial damage
  > The pilot's failure to see and avoid power lines due to sun glare.
- [NTSB CEN18LA112](https://openairdocs.org/ntsb/CEN18LA112.md): Piper PA 28 · Mackinac Island, MI · Accident · No injuries · Limited investigation · Final report · Feb 26, 2018 · N1722J · Substantial damage
  > The improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.
- [NTSB GAA18CA007](https://openairdocs.org/ntsb/GAA18CA007.md): Cessna T210 · Waterford, MI · Accident · No injuries · Data collection · Final report · Oct 7, 2017 · N5EC · Substantial damage
  > The pilot's unstabilized approach at night, which resulted in collision with trees.
- [NTSB CEN16FA269](https://openairdocs.org/ntsb/CEN16FA269.md): Aeronca 11AC · Ishpeming, MI · Accident · 2 fatal · Field investigation · Final report · Jul 19, 2016 · N85893 · Substantial damage
  > The pilot's failure to maintain airspeed following a loss of engine power due to carburetor icing while turning from base to final at a low altitude, which resulted in the airplane's wing exceeding its critical angle of attack and a subsequent aerodynamic…
- [NTSB CEN16LA252](https://openairdocs.org/ntsb/CEN16LA252.md): Piper PA-22-150 · Houghton Lake Heights, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 2016 · N5788D · Substantial damage
  > The pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.
- [NTSB CEN16LA236](https://openairdocs.org/ntsb/CEN16LA236.md): Cessna 150L · Detroit, MI · Accident · 1 fatal · Limited investigation · Final report · Jun 28, 2016 · N6622G · Substantial damage
  > The pilot’s disregard of the banner-tow operator's policy regarding the maximum allowable flight duration, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN16LA190](https://openairdocs.org/ntsb/CEN16LA190.md): Beech C24R · Marine City, MI · Accident · No injuries · Limited investigation · Final report · May 22, 2016 · N20135 · Substantial damage
  > The misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…
- [NTSB CEN16LA105](https://openairdocs.org/ntsb/CEN16LA105.md): Enstrom TH-180 · Menominee, MI · Accident · No injuries · Limited investigation · Final report · Feb 12, 2016 · N180TH · Substantial damage
  > The failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.
- [NTSB CEN16LA055](https://openairdocs.org/ntsb/CEN16LA055.md): Piper PA 28-181 · Pontiac, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 2015 · N47480 · Substantial damage
  > The pilot’s operation of the airplane below the glideslope and off course during a night, instrument approach, which resulted in a collision with trees and terrain.
- [NTSB CEN16LA035](https://openairdocs.org/ntsb/CEN16LA035.md): Glimn Kitfox 2-3 · Escanaba, MI · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2015 · N93TG · Substantial damage
  > The airplane owner's inadequate maintenance and servicing of the propeller gearbox, which resulted in oil starvation, failure of the gearbox in flight, and a subsequent loss of propeller thrust. Contributing to the outcome was the airplane's low altitude at…
- [NTSB CEN16LA017](https://openairdocs.org/ntsb/CEN16LA017.md): Comp Air CA8 · Ray, MI · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 2015 · N224MS · Substantial damage
  > The pilot's improper use of the trim, which created a cross-controlled situation and resulted in an aerodynamic stall during the attempted go-around.
- [NTSB CEN15FA342](https://openairdocs.org/ntsb/CEN15FA342.md): Piper PA 32R-300 · Harbor Springs, MI · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2015 · N43829 · Substantial damage
  > The pilot's failure to maintain clearance from the trees during the approach in dark, night conditions, which resulted in controlled flight into trees and terrain.
- [NTSB GAA15CA227](https://openairdocs.org/ntsb/GAA15CA227.md): Robinson Helicopter R44 · Sandusky, MI · Accident · No injuries · Data collection · Final report · Jul 15, 2015 · N8337Z · Substantial damage
  > The pilot's failure to monitor the landing environment while operating in a confined off-airport site resulting in a wire strike and substantial damage to the helicopter.
- [NTSB GAA15CA005](https://openairdocs.org/ntsb/GAA15CA005.md): Cessna 208B · Muskegon, MI · Accident · No injuries · Data collection · Final report · Mar 10, 2015 · N12155 · Substantial damage
  > The pilot's improper decision to continue the landing when the airplane was not in a safe position to land, resulting in the collision with ground-based approach lighting.
- [NTSB CEN15LA111](https://openairdocs.org/ntsb/CEN15LA111.md): Cessna 172F · Lowell, MI · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 2015 · N7854U · Substantial damage
  > The student pilot’s loss of airplane control during a go-around after not applying sufficient engine power.
- [NTSB CEN15FA087](https://openairdocs.org/ntsb/CEN15FA087.md): Piper PA-34-200T · Port Huron, MI · Accident · 1 fatal · Field investigation · Final report · Dec 24, 2014 · N38884 · Destroyed
  > The pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.
- [NTSB CEN15LA064](https://openairdocs.org/ntsb/CEN15LA064.md): Piper PA 24-250 · Berrien Springs, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2014 · N5897P · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN14CA413](https://openairdocs.org/ntsb/CEN14CA413.md): Phantom Phantom X 1 · Three Rivers, MI · Accident · Minor injuries · Data collection · Final report · Aug 6, 2014 · N2552S · Substantial damage
  > The pilot did not maintain adequate airspeed while flying a visual pattern, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB CEN14CA428](https://openairdocs.org/ntsb/CEN14CA428.md): Great Lakes 2T 1A 2 · Frankfort, MI · Accident · Minor injuries · Data collection · Final report · Aug 3, 2014 · N80AM · Substantial damage
  > The pilot's improper recovery from a bounced landing in gusty, crosswind conditions. Contributing to the accident was the pilot lack of recent tail wheel landing experience.

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

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