# NTSB investigations, MN: Enroute

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 11 · 546 cases

## Latest cases

- [NTSB CEN26LA295](https://openairdocs.org/ntsb/CEN26LA295.md): Aviat A-1B · Pilot Grove, MN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 17, 2026 · N299CA · Substantial damage
  > On August 17, 2026, about 1446 central daylight time, an Aviat Aircraft Inc A-1B airplane, N299CA, was substantially damaged when it was involved in an accident near Pilot Grove, Minnesota. The two pilots received minor injuries. The airplane was operated as…
- [NTSB CEN26LA250](https://openairdocs.org/ntsb/CEN26LA250.md): Glasair I RG · Utica, MN · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 9, 2026 · N141CG · Substantial damage
  > On July 9, 2026, about 1805 central daylight time, a Glasair 1RG airplane, N141CG, sustained substantial damage when it was involved in an accident near Utica, Minnesota. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ENG26LA011](https://openairdocs.org/ntsb/ENG26LA011.md): Bombardier CL-600-2C11 · Hibbing, MN · Incident · No injuries · Class 4 · Limited · Final report · Nov 23, 2025 · N707EV · No damage
  > The elevator control restriction was caused by the failure of an elevator autopilot servo control cable which failed due to cyclic fatigue. The slack in the cable wrapped around the servo mount in such a way that it interfered with the rotation of the servo…
- [NTSB CEN25FA269](https://openairdocs.org/ntsb/CEN25FA269.md): Aero Vodochody L-39C · Granite Falls, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 21, 2025 · N339L · Substantial damage
  > On July 21, 2025, about 1728 central daylight time, an Aero Vodochody L-39C airplane, N339L, was substantially damaged during an accident near Granite Falls, Minnesota. The flight instructor, seated in the front seat, sustained serious injuries after ejecting…
- [NTSB CEN24LA376](https://openairdocs.org/ntsb/CEN24LA376.md): Piper PA-32-300 · Pierz, MN · Accident · No injuries · Class 4 · Limited · Final report · Sep 30, 2024 · N2032M · Substantial damage
  > The pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.
- [NTSB CEN24LA372](https://openairdocs.org/ntsb/CEN24LA372.md): Piper PA-46-310P · Eden Prairie, MN · Accident · No injuries · Class 4 · Limited · Final report · Sep 27, 2024 · N62VM · Substantial damage
  > The bird strike during cruise flight that resulted in substantial damage to the airplane.
- [NTSB CEN24FA125](https://openairdocs.org/ntsb/CEN24FA125.md): Globe GC-1B · Afton, MN · Accident · 2 fatal · Class 3 · Field · Final report · Mar 2, 2024 · N2387B · Destroyed
  > The pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.
- [NTSB CEN24LA053](https://openairdocs.org/ntsb/CEN24LA053.md): Airbus Helicopters Deutschland EC135T3 · Dodge Center, MN · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 22, 2023 · N423NM · Substantial damage
  > An in-flight collision with a flock of birds.
- [NTSB ENG23LA034](https://openairdocs.org/ntsb/ENG23LA034.md): Hall Lester R Legacy · Rochester, MN · Incident · No injuries · Class 3 · Limited · Final report · Jul 20, 2023 · N707MM · Minor damage
  > Mechanically distressed reduction gears causing an engine overspeed and turbine blade tensile overload and subsequent uncontainment. Contributing to the uncontainment was the operator’s use of the engine after knowingly purchasing the engine in an…
- [NTSB CEN23LA101](https://openairdocs.org/ntsb/CEN23LA101.md): Bellanca 7ACA · Bayport, MN · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 4, 2023 · N9111L · Substantial damage
  > The pilot’s poor inflight fuel monitoring that resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN23LA010](https://openairdocs.org/ntsb/CEN23LA010.md): Zenith CH 750 · Libby, MN · Accident · No injuries · Class 4 · Limited · Final report · Oct 7, 2022 · N550ZF · Substantial damage
  > The total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.
- [NTSB CEN21LA461](https://openairdocs.org/ntsb/CEN21LA461.md): Piper PA-32-260 · Hancock, MN · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 29, 2021 · N130GH · Substantial damage
  > A total loss of engine power as a result of fuel starvation. Contributing to the accident was the pilot’s failure to properly manage the fuel on board the airplane and his failure to perform an adequate preflight inspection.
- [NTSB CEN21LA128](https://openairdocs.org/ntsb/CEN21LA128.md): Agustawestland Philadelphia AW119MKII · Alexandria, MN · Accident · No injuries · Class 4 · Limited · Final report · Feb 13, 2021 · N352LL · Substantial damage
  > The helicopter’s impact with an object on departure that could not be determined.
- [NTSB CEN21LA073](https://openairdocs.org/ntsb/CEN21LA073.md): Bellanca 17-30A · Arden Hills, MN · Accident · No injuries · Class 3 · Limited · Final report · Dec 3, 2020 · N28067 · Substantial damage
  > Incorrect connecting rod installation, which resulted in the failure of the nos. 5 and 6 connecting rods and subsequent total loss of engine power.
- [NTSB CEN20LA374](https://openairdocs.org/ntsb/CEN20LA374.md): Piper PA28 · Walker, MN · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 2, 2020 · N8957W · Substantial damage
  > The pilot’s impairment from the effects of an undiagnosed brain tumor.
- [NTSB CEN20LA354](https://openairdocs.org/ntsb/CEN20LA354.md): Lancair Lancair Super ES · Ely, MN · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 21, 2020 · N997S · Destroyed
  > The non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.
- [NTSB CEN20LA263](https://openairdocs.org/ntsb/CEN20LA263.md): Piper PA32 · Eveleth, MN · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 5, 2020 · N4079R · Destroyed
  > The seizure of the airplane’s engine-driven fuel pump due to internal contamination, which led to a total loss of engine power. The source of the contamination could not be determined based on available evidence.
- [NTSB CEN20FA096](https://openairdocs.org/ntsb/CEN20FA096.md): Beech A36 · Rogers, MN · Accident · 1 fatal · Class 3 · Field · Final report · Feb 22, 2020 · N3266Q · Destroyed
  > Inadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain.
- [NTSB CEN18LA349](https://openairdocs.org/ntsb/CEN18LA349.md): North American T-28B · Minneapolis, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2018 · N215SF · Destroyed
  > The fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.
- [NTSB CEN18LA300](https://openairdocs.org/ntsb/CEN18LA300.md): Continental Copters Tomcat MK5A · Le Sueur, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 2018 · N9005T · Substantial damage
  > The pilot's inadequate preflight and in-flight fuel planning, during which he did not visually check the fuel quantity in the fuel tanks and instead relied on the fuel gauges that were showing erroneous fuel quantity indications, which resulted in fuel…
- [NTSB DCA18CA102](https://openairdocs.org/ntsb/DCA18CA102.md): Airbus A330 323 · Minneapolis, MN · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 24, 2018 · N817NW · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB DCA17CA155](https://openairdocs.org/ntsb/DCA17CA155.md): Embraer S A ERJ170-200LR · Minneapolis, MN · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 20, 2017 · N427YX · No damage
  > An encounter with convective turbulence.
- [NTSB CEN17LA101](https://openairdocs.org/ntsb/CEN17LA101.md): Mooney M20C · Ellendale, MN · Accident · Serious injuries · Limited investigation · Final report · Feb 3, 2017 · N9149V · Substantial damage
  > The pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.
- [NTSB CEN17LA058](https://openairdocs.org/ntsb/CEN17LA058.md): Bellanca 17 30A · Blaine, MN · Accident · No injuries · Limited investigation · Final report · Dec 18, 2016 · N4204B · Substantial damage
  > A total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.
- [NTSB CEN17FA012](https://openairdocs.org/ntsb/CEN17FA012.md): Fairchild Hiller FH 1100 · Lino Lakes, MN · Accident · 2 fatal · Field investigation · Final report · Oct 6, 2016 · N4035G · Destroyed
  > The separation of the main rotor assembly due to mast bumping.
- [NTSB CEN16LA391](https://openairdocs.org/ntsb/CEN16LA391.md): Cessna 177RG · Cloquet, MN · Accident · No injuries · Limited investigation · Final report · Sep 30, 2016 · N1528H · Substantial damage
  > A lack of lubrication in the engine for reasons that could not be determined based on the available information, which resulted in a failure of the No. 4 connecting rod and a subsequent total loss of engine power.
- [NTSB CEN16LA369](https://openairdocs.org/ntsb/CEN16LA369.md): Stinson V77 · Jordan, MN · Accident · No injuries · Limited investigation · Final report · Sep 14, 2016 · N715FB · Substantial damage
  > A partial loss of engine power due to carburetor icing.
- [NTSB CEN16LA287](https://openairdocs.org/ntsb/CEN16LA287.md): Stinson 108 · Dodge Center, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2016 · N8019K · Substantial damage
  > A partial loss of engine power due to carburetor ice.
- [NTSB GAA16LA325](https://openairdocs.org/ntsb/GAA16LA325.md): MD Helicopter 369E · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Jun 17, 2016 · N155NR · Substantial damage
  > The failure of the helicopter’s windscreen for reasons that could not be determined based on the available information, which resulted in substantial damage to the main rotor blades and horizontal stabilizer.
- [NTSB DCA16CA089](https://openairdocs.org/ntsb/DCA16CA089.md): Airbus Industrie A319 132 · Minneapolis, MN · Accident · Serious injuries · Data collection · Final report · Feb 14, 2016 · N827AW · No damage
  > an encounter with turbulence that resulted in a serious injury to a passenger who was standing when the fasten seatbelt sign was illuminated.
- [NTSB GAA15CA151](https://openairdocs.org/ntsb/GAA15CA151.md): Flight Design Ctls · Andover, MN · Accident · No injuries · Data collection · Final report · Jun 21, 2015 · N799CT · Substantial damage
  > The pilot's improper fuel management and preflight planning, which resulted in the total loss of engine power due to fuel exhaustion and a forced landing in a field where the airplane nosed over.
- [NTSB CEN15CA041](https://openairdocs.org/ntsb/CEN15CA041.md): Cessna 510 · Faribault, MN · Accident · No injuries · Data collection · Final report · Oct 27, 2014 · N510PT · Substantial damage
  > An inflight collision with a goose while descending to land at the destination airport.
- [NTSB CEN14LA486](https://openairdocs.org/ntsb/CEN14LA486.md): Cirrus Design SR22 · Langola Township, MN · Accident · No injuries · Limited investigation · Final report · Sep 7, 2014 · N22WX · Substantial damage
  > Maintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.
- [NTSB CEN14CA479](https://openairdocs.org/ntsb/CEN14CA479.md): Quicksilver 2S · Frontenac, MN · Accident · No injuries · Data collection · Final report · Aug 20, 2014 · UNREG · Substantial damage
  > The loss of engine power during cruise due to fuel exhaustion resulting in a forced landing on a cornfield.
- [NTSB CEN14LA417](https://openairdocs.org/ntsb/CEN14LA417.md): Stinson 108 1 · Bruno, MN · Accident · No injuries · Limited investigation · Final report · Jul 18, 2014 · N9034K · Substantial damage
  > The total loss of engine power due to an anomaly with the carburetor system that could not be determined during postaccident examination.
- [NTSB CEN14FA306](https://openairdocs.org/ntsb/CEN14FA306.md): Brumwell RV-6 · Sauk Rapids, MN · Accident · 2 fatal · Field investigation · Final report · Jun 21, 2014 · N135BB · Destroyed
  > The pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.
- [NTSB CEN14FA278](https://openairdocs.org/ntsb/CEN14FA278.md): Hermann Bjorn Lancair IV · Duluth, MN · Accident · 1 fatal · Field investigation · Final report · Jun 7, 2014 · N86NW · Substantial damage
  > The pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…
- [NTSB CEN14LA244](https://openairdocs.org/ntsb/CEN14LA244.md): Crawford Preceptor Ultra PUP · Mabel, MN · Accident · Minor injuries · Limited investigation · Final report · May 17, 2014 · N1171Q · Substantial damage
  > The loss of engine power as a result of carburetor icing.
- [NTSB CEN13LA417](https://openairdocs.org/ntsb/CEN13LA417.md): Piper PA-22-125 · Mapleton, MN · Accident · No injuries · Limited investigation · Final report · Jul 16, 2013 · N663A · Substantial damage
  > The total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing to unsuitable terrain.
- [NTSB CEN13FA214](https://openairdocs.org/ntsb/CEN13FA214.md): Cessna 152 · Hawley, MN · Accident · 1 fatal · Field investigation · Final report · Mar 29, 2013 · N5367B · Substantial damage
  > The noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.
- [NTSB CEN13FA172](https://openairdocs.org/ntsb/CEN13FA172.md): Maule MXT-7-180 · Parkers Parairie, MN · Accident · 1 fatal · Field investigation · Final report · Feb 21, 2013 · N9229Y · Substantial damage
  > The pilot’s failure to transfer fuel from the auxiliary fuel tanks to the main fuel tanks in a timely manner, which resulted in fuel starvation to the engine.
- [NTSB CEN12FA196](https://openairdocs.org/ntsb/CEN12FA196.md): Beech 35 · Glencoe, MN · Accident · 3 fatal · Field investigation · Final report · Mar 21, 2012 · N3871N · Substantial damage
  > The non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.
- [NTSB CEN12LA128](https://openairdocs.org/ntsb/CEN12LA128.md): Sanderson Pitts Special SPS-1 · Revere, MN · Accident · No injuries · Limited investigation · Final report · Jan 5, 2012 · N330BL · Substantial damage
  > The total loss of engine power during cruise flight due to fuel contamination and the inadequate design of the fuel system.
- [NTSB CEN12CA035](https://openairdocs.org/ntsb/CEN12CA035.md): Houts Avid Mark IV · Hibbing, MN · Accident · Minor injuries · Data collection · Final report · Oct 21, 2011 · N43280 · Substantial damage
  > The improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.
- [NTSB CEN11LA499](https://openairdocs.org/ntsb/CEN11LA499.md): Air Tractor AT-502 · Fergus Falls, MN · Accident · No injuries · Limited investigation · Final report · Jul 22, 2011 · N1516G · Substantial damage
  > The total loss of engine power for reasons that could not be determined because the airplane came to rest inverted in water.
- [NTSB CEN11FA133](https://openairdocs.org/ntsb/CEN11FA133.md): Piper PA-46-310P · Milaca, MN · Accident · 2 fatal · Field investigation · Final report · Dec 30, 2010 · N9103N · Substantial damage
  > The pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…
- [NTSB CEN11LA117](https://openairdocs.org/ntsb/CEN11LA117.md): Piper PA-46-350P · Lake Elmo, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 2010 · N92358 · Substantial damage
  > The pilot's improper fuel management which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the distraction of the cabin depressurization.
- [NTSB CEN11LA120](https://openairdocs.org/ntsb/CEN11LA120.md): Beech 300 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Dec 10, 2010 · N206K · Substantial damage
  > The pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.
- [NTSB CEN11LA072](https://openairdocs.org/ntsb/CEN11LA072.md): Embraer ERJ 170-200 LR · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Nov 15, 2010 · N604CZ · Substantial damage
  > The in-flight collision with a flock of birds during climb.
- [NTSB CEN10LA484](https://openairdocs.org/ntsb/CEN10LA484.md): Rammel Thomas W Searey · Cokato, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2010 · N452TR · Substantial damage
  > Separation of the composite skin on one of the three propeller blades that resulted in an in-flight vibration, and the pilot's failure to maintain clearance with the water while maneuvering to avoid obstacles in preparation for a precautionary landing.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=MN&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" = 'MN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.