# NTSB investigations, MI: Taxi

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 4 · 175 cases

## Latest cases

- [NTSB CEN26LA216](https://openairdocs.org/ntsb/CEN26LA216.md): Cessna 182P · Northport, MI · Accident · No injuries · Class 4 · Limited · Final report · May 20, 2026 · N86289 · Substantial damage
  > The pilot's decision to resume taxiing on a turf runway that was unable to adequately support the airplane's weight, which resulted in the nose landing gear sinking into the soft ground and the propeller striking the terrain.
- [NTSB CEN24LA014](https://openairdocs.org/ntsb/CEN24LA014.md): Cirrus SR22 · Saginaw, MI · Accident · No injuries · Class 3 · Limited · Final report · Oct 6, 2023 · N969JB · Substantial damage
  > The failure of the right brake assembly due to excessive brake lining wear, which resulted in a thermally damaged piston O-ring, hydraulic fluid leak, and subsequent fire.
- [NTSB CEN23LA165](https://openairdocs.org/ntsb/CEN23LA165.md): Pipistrel Lsa Sinus · Kingsford, MI · Accident · No injuries · Class 3 · Limited · Final report · Apr 13, 2023 · N413EK · Substantial damage
  > The failure of maintenance personnel to properly secure the left carburetor bowl cover, which resulted in an engine fire before takeoff.
- [NTSB CEN21LA422](https://openairdocs.org/ntsb/CEN21LA422.md): Cessna 195 · Ypsilanti, MI · Accident · No injuries · Class 4 · Limited · Final report · Sep 16, 2021 · N4358V · Substantial damage
  > The pilot’s failure to maintain directional control during taxi, which resulted in a ground loop.
- [NTSB CEN21LA388](https://openairdocs.org/ntsb/CEN21LA388.md): Cessna 172 · Iron Mountain, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 3, 2021 · N6778A · Substantial damage
  > The mechanics’ failure to follow procedures for high-thrust operations at the nontowered airport, which resulted in jet blast damage to an airplane taxiing nearby.
- [NTSB DCA21LA184](https://openairdocs.org/ntsb/DCA21LA184.md): Airbus A321-211 · Romulus, MI · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 22, 2021 · N376DN · No damage
  > While conducting the safety briefing, the forward flight attendant was thrown backwards into the flight deck door due to the sudden stopping of the airplane by the flight crew to prevent a collision with a bus. Contributing to this accident was the bus…
- [NTSB CEN20CA358](https://openairdocs.org/ntsb/CEN20CA358.md): Champion 8GCBC · Three Rivers, MI · Accident · Minor injuries · Class 4 · Data collection · Final report · Aug 20, 2020 · N133PJ · Substantial damage
  > The pilot's failure to maintain clearance from a taxiway sign after landing.
- [NTSB CEN20CA027](https://openairdocs.org/ntsb/CEN20CA027.md): Skystar Kitfox · Williamston, MI · Accident · No injuries · Data collection · Final report · Nov 30, 2019 · N58CD · Substantial damage
  > The pilot's improper decision to continue taxiing the airplane on unsuitable terrain, which resulted in a nose-over.
- [NTSB DCA16CA094](https://openairdocs.org/ntsb/DCA16CA094.md): Boeing 737 · Detroit, MI · Accident · No injuries · Data collection · Final report · Feb 17, 2016 · N925NN · 2 aircraft · Minor damage
  > N925NN flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the winglet with the horizontal stabilizer and elevator of N784SW.
- [NTSB CEN13LA365](https://openairdocs.org/ntsb/CEN13LA365.md): Piper PA-32-301T · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Jun 19, 2013 · N4296T · Substantial damage
  > The pilot’s failure to follow the airplane checklist, which resulted in the parking brake not being released before taxi and a subsequent brake fire.
- [NTSB CEN13CA202](https://openairdocs.org/ntsb/CEN13CA202.md): Cessna 172L · Pontiac, MI · Accident · No injuries · Data collection · Final report · Mar 17, 2013 · N7282Q · Substantial damage
  > The pilot's failure to maintain airplane control after an unexplained increase in engine power while taxiing.
- [NTSB CEN13CA185](https://openairdocs.org/ntsb/CEN13CA185.md): Piper PA22 · Baraga, MI · Accident · Minor injuries · Data collection · Final report · Mar 2, 2013 · N2238A · Substantial damage
  > The pilot’s failure to maintain directional control during taxi.
- [NTSB DCA09FA011](https://openairdocs.org/ntsb/DCA09FA011.md): Bombardier CL-600-2B19 · Detroit, MI · Accident · Minor injuries · Field investigation · Final report · Nov 13, 2008 · N8698A · Substantial damage
  > The lack of vigilance on the part of the ramp agent driving the baggage tug. Contributing factors include the night conditions, and low visibility due to fog and rain.
- [NTSB CHI08CA271](https://openairdocs.org/ntsb/CHI08CA271.md): Cessna T182T · Munising, MI · Accident · No injuries · Data collection · Final report · Sep 2, 2008 · N140NE · Substantial damage
  > The inadequate preflight planning/preparation by the pilot to carry a hazardous material aboard an airplane that resulted in a fire during an after-landing taxi.
- [NTSB CHI08CA298](https://openairdocs.org/ntsb/CHI08CA298.md): Lake LA-4 · Algonac, MI · Accident · No injuries · Data collection · Final report · Aug 23, 2008 · N1147L · Substantial damage
  > The amphibious airplane's collision with submerged debris during taxi for takeoff, and the resulting damage to the hull.
- [NTSB CHI07CA033](https://openairdocs.org/ntsb/CHI07CA033.md): Cessna C-425 · Menominee, MI · Accident · No injuries · Data collection · Final report · Dec 5, 2006 · N425JP · Substantial damage
  > The pilot failed to maintain control of the aircraft while parking the aircraft, and failed to maintain clearance from the building as the airplane taxied forward. A factor was the terminal.
- [NTSB CHI06CA279](https://openairdocs.org/ntsb/CHI06CA279.md): Meyers MAC-145 · Manistique, MI · Accident · No injuries · Data collection · Final report · Aug 6, 2006 · N34360 · Substantial damage
  > The pilot not verifying the landing gear selector position prior to starting the taxi.
- [NTSB CHI05CA090](https://openairdocs.org/ntsb/CHI05CA090.md): Cessna 172R · Kalamazoo, MI · Accident · No injuries · Data collection · Final report · Apr 7, 2005 · N985BT · Substantial damage
  > The pilot's failure to maintain directional control and the excessive taxispeed.
- [NTSB CHI03LA084](https://openairdocs.org/ntsb/CHI03LA084.md): Bell 430 · Highland, MI · Accident · No injuries · Limited investigation · Final report · Mar 17, 2003 · N431UM · Substantial damage
  > The pilot's failure to maintain clearance to the roadway sign. Contributing factors were the failure of the tail rotor gearbox, the roadway sign and the low lighting conditions (night).
- [NTSB CHI00LA158](https://openairdocs.org/ntsb/CHI00LA158.md): Truthan Searey · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Jun 10, 2000 · N89PJ · Substantial damage
  > the pilot's failure to maintain aircraft control when the airplane encountered high winds. Factors which related to this accident were the high crosswind, the wind gusts, and the submerged object.
- [NTSB CHI99LA107](https://openairdocs.org/ntsb/CHI99LA107.md): Piper J4A · Howell, MI · Accident · No injuries · Limited investigation · Final report · Mar 14, 1999 · N30412 · Substantial damage
  > the pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.
- [NTSB CHI99LA038](https://openairdocs.org/ntsb/CHI99LA038.md): Piper PA-28R-200 · Hancock, MI · Accident · No injuries · Limited investigation · Final report · Nov 25, 1998 · N5256T · Substantial damage
  > the pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…
- [NTSB CHI98LA330](https://openairdocs.org/ntsb/CHI98LA330.md): Piper PA-32-260 · Sault Ste Marie, MI · Accident · No injuries · Limited investigation · Final report · Aug 28, 1998 · N4887S · Substantial damage
  > the pilot's failure to maintain clearance between the airplane and the runway marker. A factor contributing to this accident was the runway marker.
- [NTSB CHI96LA081](https://openairdocs.org/ntsb/CHI96LA081.md): Beech 58 · Yipsilanti, MI · Accident · No injuries · Limited investigation · Final report · Jan 25, 1996 · N4108S · Substantial damage
  > was the pilot not maintaining visual separation with the parked airplanes. A factor in this accident was the pilot's over- confidence in his personal ability to taxi onto the parking ramp with the snowfall he was encountering.
- [NTSB CHI96LA058](https://openairdocs.org/ntsb/CHI96LA058.md): Cessna 150B · Grant, MI · Accident · No injuries · Limited investigation · Final report · Dec 16, 1995 · N1219Y · Substantial damage
  > the pilot's selection of unsuitable terrain and the weak ice-covered runway.
- [NTSB CHI94FA262](https://openairdocs.org/ntsb/CHI94FA262.md): Grumman HU-16 · St. Ignace, MI · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1994 · N7025N · Minor damage
  > The pilot's failure to follow good seaplane operating practices by taxiing with power at forward thrust, with a tailwind, at a speed that necessitated using reverse thrust to arrest the excessive speed, and the pilot's misjudgment of his distance from the…
- [NTSB CHI94LA086](https://openairdocs.org/ntsb/CHI94LA086.md): Aeronca 7AC · Dowagiac, MI · Accident · No injuries · Limited investigation · Final report · Feb 13, 1994 · N81616 · Substantial damage
  > Failure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's lack of experience in this make and model of aircraft, the crosswind, and snow beside the runway.
- [NTSB CHI93LA336](https://openairdocs.org/ntsb/CHI93LA336.md): Cessna 172M · Adrian, MI · Accident · No injuries · Limited investigation · Final report · Aug 22, 1993 · N13923 · Substantial damage
  > an excessive taxi speed used by the pilot-in-command. A factor related to the accident was loose gravel on the ramp and inadequate airport maintenance by the airport personnel.
- [NTSB CHI93LA102](https://openairdocs.org/ntsb/CHI93LA102.md): Cessna 172 · Manistique, MI · Accident · No injuries · Limited investigation · Final report · Mar 2, 1993 · N8275L · Substantial damage
  > An excessive taxi speed.
- [NTSB CHI92LA164](https://openairdocs.org/ntsb/CHI92LA164.md): Grumman AA5B · Charlotte, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 7, 1992 · N45199 · No damage
  > The pedestrian's failure to maintain visual outlook and separation from the taxiing aircraft.
- [NTSB CHI92LA006](https://openairdocs.org/ntsb/CHI92LA006.md): Cessna 421B · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Oct 10, 1991 · N100CA · Substantial damage
  > The total failure of the right main landing gear's downlock link assembly.
- [NTSB CHI91LA179](https://openairdocs.org/ntsb/CHI91LA179.md): Lake LA-4-200 · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Jun 1, 1991 · N2596P · Substantial damage
  > Aircraft control by the dual student was not maintained, remedial action by the CFI was delayed, which resulted in a stall/mush. A factor related to the accident was rough water caused by a power boat wake.
- [NTSB CHI91LA132](https://openairdocs.org/ntsb/CHI91LA132.md): Luscombe 8A · Fibre, MI · Accident · No injuries · Limited investigation · Final report · Apr 12, 1991 · CGWGZ · Substantial damage
  > The pilot attempting to taxi on unsuitable terrain.
- [NTSB DCA91MA010](https://openairdocs.org/ntsb/DCA91MA010.md): Mcdonnell Douglas DC-9-14 · Romulus, MI · Accident · 8 fatal · Class 1 · Major · Final report · Dec 3, 1990 · N3313L · 2 aircraft · Destroyed
  > Lack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…
- [NTSB CHI90FA278](https://openairdocs.org/ntsb/CHI90FA278.md): Boeing 727-251 · Detroit, MI · Accident · Serious injuries · Field investigation · Final report · Sep 29, 1990 · N278US · Minor damage
  > The intentional activation of the auxillary power unit by the flight engineer, and the improper evacuation procedures by the pilot in command. An associated factor in the accident was the APU circuit breakers were not pulled by company maintenance personnel.
- [NTSB CHI90LA085](https://openairdocs.org/ntsb/CHI90LA085.md): Piper PA-28-161 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Feb 18, 1990 · N8394D · Substantial damage
  > Overload failure of the left main landing gear attach bolts for an undetermined reason.
- [NTSB CHI88LA112](https://openairdocs.org/ntsb/CHI88LA112.md): Piper PA-28-140 · Sault Ste Marie, MI · Accident · No injuries · Limited investigation · Final report · May 7, 1988 · N15372 · Substantial damage
  > During taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,…
- [NTSB CHI88IA088](https://openairdocs.org/ntsb/CHI88IA088.md): Boeing 727-251 · Detroit, MI · Incident · Minor injuries · Incident investigation · Final report · Mar 28, 1988 · N277US · No damage
- [NTSB CHI88LA063](https://openairdocs.org/ntsb/CHI88LA063.md): Cessna 152 · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Feb 13, 1988 · N49540 · Substantial damage
  > While taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank.
- [NTSB CHI87LA184](https://openairdocs.org/ntsb/CHI87LA184.md): Cessna 172Q · Belleville, MI · Accident · No injuries · Limited investigation · Final report · Aug 2, 1987 · N96593 · Substantial damage
  > Although the plt saw a dark wx area apch the arpt he elected to shoot a touch and go before terminating the flt. After touchdown and during taxi twr advised wind was 270 degrees at 40 KTS. The pilot continued taxi to the south and the wind nosed the acft down.
- [NTSB CHI87LA174](https://openairdocs.org/ntsb/CHI87LA174.md): Cessna 172N · Troy, MI · Accident · No injuries · Limited investigation · Final report · Jul 20, 1987 · N6341D · Substantial damage
  > The plt lndd at ngt & taxied the acft to a hangar area for a passenger stop. After the passenger deplaned, the plt proceeded to make a u-turn around a t-hangar & onto an automobile service road that wasn't normally used for acft. Whilethe plt was attempting…
- [NTSB CHI87LA118](https://openairdocs.org/ntsb/CHI87LA118.md): Piper J3C · Midland, MI · Accident · No injuries · Limited investigation · Final report · Apr 26, 1987 · N6AJ · Substantial damage
  > While taxiing to runway 24 run up area the aircraft flipped over onto its nose. The pilot stated a gust of wind caught the plane from behind. Winds at the tri-city airport, 12 miles southeast of Midland, were reported from 130 degrees at 6 knots.
- [NTSB CHI87LA089](https://openairdocs.org/ntsb/CHI87LA089.md): Cessna 182F · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Feb 21, 1987 · N3513U · Substantial damage
  > While the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture…
- [NTSB CHI87LA025](https://openairdocs.org/ntsb/CHI87LA025.md): Piper PA-34-220T · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Nov 12, 1986 · N8161K · Substantial damage
  > Upon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…
- [NTSB CHI86IA121](https://openairdocs.org/ntsb/CHI86IA121.md): Boeing 727-231 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Apr 17, 1986 · N64324 · No damage
  > While taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her…
- [NTSB CHI86IA037](https://openairdocs.org/ntsb/CHI86IA037.md): Embraer EMB-110P1 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Dec 2, 1985 · N90427 · Minor damage
  > The acft suffered a failure of the left rear axle during taxi to takeoff.
- [NTSB CHI85LA232](https://openairdocs.org/ntsb/CHI85LA232.md): Piper J-3 · Gaylord, MI · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N6544H · Substantial damage
  > The plt attempt to take the float plane across a lake in wind that was from 270 deg at 20 gusting 40 KTS. Subsequently, the acft capsized & was damaged. In a revised statement, the plt reported that he was 'sailing' (letting the wind blow the acft) across the…
- [NTSB CHI85LA098](https://openairdocs.org/ntsb/CHI85LA098.md): Cessna 140A · Three Rivers, MI · Accident · No injuries · Limited investigation · Final report · Jan 27, 1985 · N5603C · Substantial damage
  > The ski equipped aircraft was taxiing on the frozen surface of the lake when the two bottom bolts that attached the right ski to the gear leg failed the overload failed the two top bolts and the ski failed out and up at a forty five degree angle this…
- [NTSB CHI85LA089](https://openairdocs.org/ntsb/CHI85LA089.md): Beech 58P · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N58PC · Substantial damage
  > At 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation…
- [NTSB CHI84LA220](https://openairdocs.org/ntsb/CHI84LA220.md): Leblanc Dragon FLY · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Jun 2, 1984 · N4463L · Substantial damage
  > The acft inadvertently became airborne on a high speed taxi test. The plt lowered the nose resulting in a porpoise & thecanard was damaged. The acft had not been inspected or certified by the FAA. Examination revealed that the right wing had a higher angle of…

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

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