# NTSB investigations, MO: 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 15 · 714 cases

## Latest cases

- [NTSB CEN26LA324](https://openairdocs.org/ntsb/CEN26LA324.md): Magni M16 · Annapolis, MO · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Sep 23, 2026 · N109MG · Substantial damage
  > On September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was…
- [NTSB CEN26LA318](https://openairdocs.org/ntsb/CEN26LA318.md): Vans RV4 · Harrisonville, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 13, 2026 · N254MM · Substantial damage
  > On September 13, 2026, about 0930 central daylight time, a Vans Aircraft Inc, RV-4, N254MM, was substantially damaged when it was involved in an accident near Harrisonville, Missouri. The pilot and passenger were not injured. The airplane was operated as a…
- [NTSB CEN26FA280](https://openairdocs.org/ntsb/CEN26FA280.md): Piper PA-24-250 · Bethany, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 4, 2026 · N8422P · Destroyed
  > On August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal…
- [NTSB CEN26LA179](https://openairdocs.org/ntsb/CEN26LA179.md): Cessna 421C · Kirksville, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · May 4, 2026 · N6161X · Substantial damage
  > On May 4, 2026, about 1759 central daylight time, a Cessna 421C airplane, N6161X, was substantially damaged during an accident near Kirksville, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…
- [NTSB CEN26LA066](https://openairdocs.org/ntsb/CEN26LA066.md): Cirrus Design SR22 · Springfield, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 20, 2025 · N242AZ · Substantial damage
  > On December 20, 2025, about 1302 central standard time, a Cirrus SR22 airplane, N242AZ, was substantially damaged when it was involved in an accident near Springfield, Missouri. The pilot and passenger were not injured. The airplane was operated as a Title 14…
- [NTSB CEN25LA327](https://openairdocs.org/ntsb/CEN25LA327.md): Marshall Allen L RV6A · Centerview, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 19, 2025 · N692AC · Substantial damage
  > On August 19, 2025, at 1640 central daylight time, a Vans RV-6A airplane, N692AC, was substantially damaged when it was involved in an accident near Centerview, Missouri. The commercial pilot sustained minor injuries and the passenger was uninjured. The…
- [NTSB CEN25LA326](https://openairdocs.org/ntsb/CEN25LA326.md): Robinson Helicopter R44 II · Cape Girardeau, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 16, 2025 · N24DF · Substantial damage
  > On August 16, 2025, at 1150 central daylight time, a Robinson R44 II helicopter, N24DF was substantially damaged when it was involved in an accident near Cape Girardeau, Missouri. The pilot and three passengers were not injured. The helicopter was operated as…
- [NTSB CEN25LA180](https://openairdocs.org/ntsb/CEN25LA180.md): Excalibur Excalibur · Mountain View Airport, MO · Accident · No injuries · Class 4 · Limited · Final report · May 18, 2025 · N4831A · Substantial damage
  > An in-flight collision with a bird while enroute.
- [NTSB DCA25LA041](https://openairdocs.org/ntsb/DCA25LA041.md): Boeing 757-231 · Cooper Hill, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 18, 2024 · N717TW · No damage
  > An encounter with convective induced turbulence which resulted in a flight attendant serious injury.
- [NTSB CEN24LA333](https://openairdocs.org/ntsb/CEN24LA333.md): Zenith Zodiac CH601 XL · Odessa, MO · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 2, 2024 · N624RJ · Substantial damage
  > Overheating of the engine coolant for reasons that could not be determined, which resulted in a precautionary off-airport landing, during which the airplane sustained substantial damage.
- [NTSB DCA24LA254](https://openairdocs.org/ntsb/DCA24LA254.md): Boeing 777-223 · Linneus, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 4, 2024 · N793AN · No damage
  > An inadvertent encounter with convectively induced turbulence during cruise.
- [NTSB CEN24LA241](https://openairdocs.org/ntsb/CEN24LA241.md): Air Tractor AT-301 · Andover, MO · Accident · No injuries · Class 4 · Limited · Final report · Jun 27, 2024 · N3165C · Substantial damage
  > The pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.
- [NTSB CEN24FA160](https://openairdocs.org/ntsb/CEN24FA160.md): Piper PA 46-350P · Hartsburg, MO · Accident · 1 fatal · Class 3 · Field · Final report · Apr 16, 2024 · N451MA · Destroyed
  > The pilot’s encounter with convective weather conditions, which resulted in a loss of airplane control, the exceedance of the airplane’s never exceed speed, and the resulting overload failure of the horizontal stabilizer and subsequent failure of the…
- [NTSB CEN24LA155](https://openairdocs.org/ntsb/CEN24LA155.md): Piper PA-32-301 · Sullivan, MO · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 11, 2024 · N651ED · Substantial damage
  > A bearing failure that resulted in fatigue failure of the crankshaft and a subsequent total loss of engine power.
- [NTSB DCA24LA051](https://openairdocs.org/ntsb/DCA24LA051.md): Boeing 737 · St. Louis, MO · Accident · No injuries · Class 4 · Limited · Final report · Dec 19, 2023 · N8514F · Substantial damage
  > A bird strike during climbout.
- [NTSB CEN24LA039](https://openairdocs.org/ntsb/CEN24LA039.md): Piper PA32 · Ozark, MO · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 17, 2023 · N16253 · Substantial damage
  > A reported total loss of engine power for undetermined reasons.
- [NTSB CEN23LA399](https://openairdocs.org/ntsb/CEN23LA399.md): Beech 35-B33 · Ava, MO · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2023 · N9522Y · Substantial damage
  > A loss of engine oil due for undetermined reasons, which resulted in failed connecting rods and total loss of engine power.
- [NTSB CEN23LA221](https://openairdocs.org/ntsb/CEN23LA221.md): Quad City Challenger · Doniphan, MO · Accident · No injuries · Class 3 · Limited · Final report · May 28, 2023 · N265JW · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB DCA22LA125](https://openairdocs.org/ntsb/DCA22LA125.md): Airbus Industrie A320-232 · Springfield, MO · Accident · Serious injuries · Class 4 · Limited · Final report · May 25, 2022 · N483UA · No damage
  > The flight’s encounter with clear air moderate turbulence.
- [NTSB CEN22FA096](https://openairdocs.org/ntsb/CEN22FA096.md): Beech 58 · Defiance, MO · Accident · 2 fatal · Class 3 · Field · Final report · Jan 9, 2022 · N585CK · Destroyed
  > The pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.
- [NTSB CEN21FA125](https://openairdocs.org/ntsb/CEN21FA125.md): Cessna 177RG · Galt, MO · Accident · 2 fatal · Class 3 · Field · Final report · Feb 8, 2021 · N8080G · Destroyed
  > The pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.
- [NTSB CEN20LA412](https://openairdocs.org/ntsb/CEN20LA412.md): Zenith CH 750 · Montrose, MO · Accident · No injuries · Class 3 · Limited · Final report · Sep 20, 2020 · N210WP · Substantial damage
  > A total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.
- [NTSB CEN20LA360](https://openairdocs.org/ntsb/CEN20LA360.md): Cessna 180 · St Louis, MO · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 22, 2020 · N7620A · Substantial damage
  > A total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.
- [NTSB CEN20LA288](https://openairdocs.org/ntsb/CEN20LA288.md): Beech 36 · Independence, MO · Accident · No injuries · Class 3 · Limited · Final report · Jul 16, 2020 · N630JL · Substantial damage
  > Failure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.
- [NTSB CEN20LA189](https://openairdocs.org/ntsb/CEN20LA189.md): Piper PA28 · Steele, MO · Accident · No injuries · Class 3 · Limited · Final report · May 22, 2020 · N7355W · Substantial damage
  > The loss of oil pressure for a reason that could not be determined leading to failure of the engine connecting rod.
- [NTSB CEN20LA113](https://openairdocs.org/ntsb/CEN20LA113.md): Bell 206 · Clark, MO · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2020 · N32AE · Substantial damage
  > The fatigue failure of the pneumatic line for reasons that could not be determined, which resulted in a loss of engine power and subsequent hard landing.
- [NTSB CEN20LA107](https://openairdocs.org/ntsb/CEN20LA107.md): Zenith CH601 · Cabool, MO · Accident · No injuries · Class 3 · Limited · Final report · Feb 29, 2020 · N601ND · Substantial damage
  > The loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.
- [NTSB DCA20CA050](https://openairdocs.org/ntsb/DCA20CA050.md): Boeing 737 · Kansas City, MO · Accident · No injuries · Class 4 · Data collection · Final report · Dec 22, 2019 · N7739A · Substantial damage
  > a bird strike during descent
- [NTSB CEN20FA003](https://openairdocs.org/ntsb/CEN20FA003.md): Lancair Legacy · Bixby, MO · Accident · 1 fatal · Class 3 · Field · Final report · Oct 6, 2019 · N10LG · Substantial damage
  > The pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CEN19LA319](https://openairdocs.org/ntsb/CEN19LA319.md): Lancair LC41-550FG · Branson, MO · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 2, 2019 · N405JA · Substantial damage
  > A total loss of engine power after takeoff for undetermined reasons.
- [NTSB CEN19FA161](https://openairdocs.org/ntsb/CEN19FA161.md): Cessna 425 · Butler, MO · Accident · 1 fatal · Class 3 · Field · Final report · Jun 10, 2019 · N622MM · Destroyed
  > The pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.
- [NTSB CEN19LA127](https://openairdocs.org/ntsb/CEN19LA127.md): Beech 50 · Sheldon, MO · Accident · No injuries · Class 3 · Limited · Final report · Apr 26, 2019 · N29Y · Substantial damage
  > A partial loss of engine power on both engines due to detonation for undetermined reasons.
- [NTSB CEN19FA093](https://openairdocs.org/ntsb/CEN19FA093.md): Piper PA28 · Summersville, MO · Accident · 1 fatal · Class 3 · Field · Final report · Mar 6, 2019 · N7369W · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight fuel planning and in-flight fuel monitoring.
- [NTSB DCA18CA049](https://openairdocs.org/ntsb/DCA18CA049.md): Embraer S A ERJ170-200LR · Saint Louis, MO · Accident · Serious injuries · Data collection · Final report · Dec 18, 2017 · N128SY · No damage
  > the abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.
- [NTSB CEN18FA054](https://openairdocs.org/ntsb/CEN18FA054.md): Piper PA28 · Reeds Spring, MO · Accident · 2 fatal · Field investigation · Final report · Dec 18, 2017 · N6433J · Destroyed
  > The noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain.
- [NTSB CEN17LA352](https://openairdocs.org/ntsb/CEN17LA352.md): Cessna 210G · Hallsville, MO · Accident · No injuries · Limited investigation · Final report · Sep 13, 2017 · N5906F · Substantial damage
  > The total loss of engine power due to a fatigue failure of the engine mixture control cable.
- [NTSB CEN17FA288](https://openairdocs.org/ntsb/CEN17FA288.md): Zenith CH701SP · Laddonia, MO · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2017 · N701XL · Destroyed
  > The pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…
- [NTSB CEN17FA252](https://openairdocs.org/ntsb/CEN17FA252.md): Airbus Helicopters Deutschland MBB-BK 117 B-2 · Perryville, MO · Accident · Minor injuries · Field investigation · Final report · Jul 2, 2017 · N238BK · Substantial damage
  > Fuel starvation due to the pilot’s failure to turn on the fuel transfer pump switches during takeoff, which led to a total loss of engine power. Contributing to the accident was the pilot's improper decision to activate the annunciator panel’s dimming…
- [NTSB GAA17CA361](https://openairdocs.org/ntsb/GAA17CA361.md): Cessna 182 · Doniphan, MO · Accident · No injuries · Data collection · Final report · Jun 23, 2017 · N1800M · Substantial damage
  > The pilot’s improper decision to take off with a known fuel leak, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN17LA110](https://openairdocs.org/ntsb/CEN17LA110.md): Aerostar Acft Corp Of Texas M20E · Clever, MO · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2017 · N6807V · Substantial damage
  > The failure of the engine No. 2 connecting rod bearing for reasons that could not be determined due to the extensive secondary engine damage.
- [NTSB CEN17LA066](https://openairdocs.org/ntsb/CEN17LA066.md): Gosselin Charles Glastar · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2016 · N120CG · Substantial damage
  > Partial failure of the electric system due to a battery short, which resulted in a total loss of engine power.
- [NTSB CEN16LA355](https://openairdocs.org/ntsb/CEN16LA355.md): Republic RC3 · Post Oak, MO · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2016 · N6490K · Substantial damage
  > A partial loss of engine power due to low cylinder compression. Contributing to the loss of engine power was rust formation in the cylinders due to inactivity.
- [NTSB CEN16LA229](https://openairdocs.org/ntsb/CEN16LA229.md): Cessna 182P · Humansville, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 2016 · N9434M · Substantial damage
  > A partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power.
- [NTSB CEN16LA079](https://openairdocs.org/ntsb/CEN16LA079.md): Piper 28-140 · Republic, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2015 · N4643R · Destroyed
  > The pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.
- [NTSB DCA16CA026](https://openairdocs.org/ntsb/DCA16CA026.md): Boeing 737 7H4 · St Louis, MO · Accident · Serious injuries · Data collection · Final report · Nov 29, 2015 · N467WN · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB CEN16FA037](https://openairdocs.org/ntsb/CEN16FA037.md): Cessna 182Q · Richmond, MO · Accident · 1 fatal · Field investigation · Final report · Nov 11, 2015 · N96381 · Substantial damage
  > The airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…
- [NTSB CEN15LA396](https://openairdocs.org/ntsb/CEN15LA396.md): Burns Mini 500 · Butler, MO · Accident · No injuries · Limited investigation · Final report · Aug 21, 2015 · UNREG · Substantial damage
  > The pilot's failure to attain a proper landing flare following an autorotation for reasons that could not be determined based on available information.
- [NTSB CEN15LA369](https://openairdocs.org/ntsb/CEN15LA369.md): Cessna 182P · Bolivar, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2015 · N6KW · Substantial damage
  > Total electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.
- [NTSB CEN15FA268](https://openairdocs.org/ntsb/CEN15FA268.md): Piper PA 32 · Cuba, MO · Accident · 1 fatal · Field investigation · Final report · Jun 14, 2015 · N2966X · Destroyed
  > The pilot's continued flight into thunderstorm activity, which resulted in his loss of airplane control, the exceedance of the airplane's design limits, and its subsequent in-flight breakup. Contributing to the accident was the pilot's reliance on onboard…
- [NTSB GAA15CA091](https://openairdocs.org/ntsb/GAA15CA091.md): Lefever Paul M RV12 · Caledonia, MO · Accident · Minor injuries · Data collection · Final report · May 23, 2015 · N198PR · Substantial damage
  > The pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a nose over.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=MO&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" = 'MO' 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=MO

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