# NTSB investigations, CO: 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 20 · 998 cases

## Latest cases

- [NTSB CEN27LA005](https://openairdocs.org/ntsb/CEN27LA005.md): Diamond Aircraft Ind DA 40 · Eldorado Springs, CO · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Oct 5, 2026 · N162GL · Destroyed
  > On October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…
- [NTSB ANC26FA097](https://openairdocs.org/ntsb/ANC26FA097.md): Cessna T206H · Dunton, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 3, 2026 · N919CW · Destroyed
  > On September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of…
- [NTSB WPR26LA266](https://openairdocs.org/ntsb/WPR26LA266.md): Maule M-4-180V · Creede, CO · Accident · No injuries · Class 4 · Limited · Final report · Jul 18, 2026 · N489LA · Substantial damage
  > The pilot’s exceedance of the airplane’s performance capabilities in mountainous terrain, which resulted in a forced landing.
- [NTSB CEN26LA251](https://openairdocs.org/ntsb/CEN26LA251.md): Vans RV-12 · Grand Junction, CO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 10, 2026 · N812MM · Substantial damage
  > On July 10, 2026, about 1023 mountain daylight time, an experimental amateur-built Vans Aircraft Inc RV-12 airplane, N812MM, sustained substantial damage when it was involved in an accident near Grand Junction, Colorado. The pilot and a passenger were…
- [NTSB DCA26LA270](https://openairdocs.org/ntsb/DCA26LA270.md): Airbus A321-231 · Somerset, CO · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 6, 2026 · N943JT · No damage
- [NTSB DCA26WA249](https://openairdocs.org/ntsb/DCA26WA249.md): Airbus Canada BD500 · Berthoud, CO · Occurrence · No injuries · Class 5 · Foreign · Jun 24, 2026 · CGJYI
- [NTSB CEN26LA165](https://openairdocs.org/ntsb/CEN26LA165.md): Pipistrel Alpha Trainer · Peyton, CO · Accident · No injuries · Class 4 · Limited · Final report · Apr 14, 2026 · N495LP · Substantial damage
  > The pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing to a field.
- [NTSB CEN26FA115](https://openairdocs.org/ntsb/CEN26FA115.md): Epic E1000 · Steamboat Springs, CO · Accident · 4 fatal · Class 3 · Field · Preliminary report · Feb 13, 2026 · N98FK · Substantial damage
  > On February 13, 2026, about 0019 mountain standard time, an Epic E1000 airplane, N98FK, was substantially damaged when it was involved in an accident near Steamboat Springs, Colorado. The pilot and three passengers were fatally injured. The airplane was…
- [NTSB CEN26LA042](https://openairdocs.org/ntsb/CEN26LA042.md): Piper PA-28-235 · Castle Rock, CO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 11, 2025 · N9143W · Substantial damage
  > On November 10, 2025, about 1815 mountain standard time, a Piper PA-28-235 airplane, N9143W, was substantially damaged when it was involved in an accident near Castle Rock, Colorado. The pilot and one passenger reported no injuries. A second passenger…
- [NTSB CEN26LA032](https://openairdocs.org/ntsb/CEN26LA032.md): Just Highlander · Delta, CO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Nov 2, 2025 · N622SC · Substantial damage
  > On November 2, 2025, about 1630 mountain standard time, an experimental amateur-built Just Highlander airplane, N622SC, was substantially damaged when it was involved in an accident near Delta, Colorado. The flight instructor and student pilot were seriously…
- [NTSB CEN25LA403](https://openairdocs.org/ntsb/CEN25LA403.md): Aeronca 11AC · Longmont, CO · Accident · No injuries · Class 4 · Limited · Final report · Sep 29, 2025 · N86326 · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.
- [NTSB CEN25LA310](https://openairdocs.org/ntsb/CEN25LA310.md): Cirrus Design SR22 · Jaroso, CO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 7, 2025 · N412DJ · Substantial damage
  > On August 7, 2025 at 0935 mountain daylight time, a Cirrus SR22 airplane, N412DJ, was substantially damaged when it was involved in an accident near Jaroso, Colorado. The pilot receiving instruction and a passenger were seriously injured, and the flight…
- [NTSB WPR25FA190](https://openairdocs.org/ntsb/WPR25FA190.md): MD Helicopters 369E · Meeker, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 25, 2025 · N411WJ · Substantial damage
  > On June 25, 2025, about 1001 mountain daylight time, an MD Helicopters 369E, N411WJ, was substantially damaged when it was involved in an accident near Meeker, Colorado. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA349](https://openairdocs.org/ntsb/CEN25LA349.md): Cessna 650 · Westplains, CO · Accident · Class 4 · Limited · Final report · Jun 14, 2025 · N682RS · Substantial damage
  > The pilot’s improper judgment to circumnavigate convective activity which resulted in extensive hail damage to the airplane.
- [NTSB CEN25LA129](https://openairdocs.org/ntsb/CEN25LA129.md): Stemme S10-VT · Kiowa, CO · Accident · No injuries · Class 4 · Limited · Final report · Mar 15, 2025 · N237DB · Substantial damage
  > The pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN24LA362](https://openairdocs.org/ntsb/CEN24LA362.md): Cessna 172N · Arboles, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 17, 2024 · N739JU · Substantial damage
  > A loss of engine power due to carburetor ice.
- [NTSB CEN24LA344](https://openairdocs.org/ntsb/CEN24LA344.md): Bellanca 7GCAA · Rifle, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 8, 2024 · N36008 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN24FA212](https://openairdocs.org/ntsb/CEN24FA212.md): Beech V35A · Arvada, CO · Accident · 1 fatal · Class 3 · Field · Final report · Jun 7, 2024 · N150WR · Destroyed
  > A total loss of engine power due to oil starvation as a result of loose turbocharger oil line fittings.
- [NTSB CEN24LA210](https://openairdocs.org/ntsb/CEN24LA210.md): Cessna 182 · Gypsum, CO · Accident · No injuries · Class 4 · Limited · Final report · Jun 5, 2024 · N5755B · Substantial damage
  > The failure of the flight instructor and the pilot to visually confirm the airplane’s fuel quantity during preflight, which resulted in a loss of engine power due to fuel exhaustion and an off-airport forced landing in rough terrain.
- [NTSB CEN24LA030](https://openairdocs.org/ntsb/CEN24LA030.md): Mooney M20K · Lamar, CO · Accident · No injuries · Class 4 · Limited · Final report · Oct 31, 2023 · N1167J · Substantial damage
  > The pilot's inadequate fuel planning and improper in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN23FA285](https://openairdocs.org/ntsb/CEN23FA285.md): Piper PA-60-601P · Burlington, CO · Accident · 1 fatal · Class 3 · Field · Final report · Jul 6, 2023 · N100PB · Destroyed
  > The pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.
- [NTSB CEN23LA206](https://openairdocs.org/ntsb/CEN23LA206.md): Cessna 172B · Divide, CO · Accident · Minor injuries · Class 3 · Limited · Final report · May 29, 2023 · N8098X · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined.
- [NTSB CEN23FA174](https://openairdocs.org/ntsb/CEN23FA174.md): Pool Cessna R172 · Victor, CO · Accident · 4 fatal · Class 3 · Field · Final report · May 6, 2023 · N15188 · Destroyed
  > The pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…
- [NTSB DCA23LA086](https://openairdocs.org/ntsb/DCA23LA086.md): Boeing 737 · Denver, CO · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 30, 2022 · N946WN · No damage
  > The flight’s encounter with mechanical turbulence.
- [NTSB CEN23LA027](https://openairdocs.org/ntsb/CEN23LA027.md): Cessna R172E · Aguilar, CO · Accident · No injuries · Class 3 · Limited · Final report · Nov 5, 2022 · N6051U · Substantial damage
  > Failure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.
- [NTSB DCA23LA008](https://openairdocs.org/ntsb/DCA23LA008.md): Boeing 737 · Denver, CO · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 29, 2022 · N7881A · No damage
  > An encounter with clear air turbulence during cruise flight.
- [NTSB CEN22FA424](https://openairdocs.org/ntsb/CEN22FA424.md): Cessna 172S · Longmont, CO · Accident · 3 fatal · Class 3 · Field · Final report · Sep 17, 2022 · N2117Y · 2 aircraft · Destroyed
  > The pilots’ inability to see and avoid each other, resulting in a midair collision.
- [NTSB DCA22LA196](https://openairdocs.org/ntsb/DCA22LA196.md): Boeing 737-824 · Denver, CO · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 1, 2022 · N76529 · No damage
  > An encounter with clear air turbulence, which resulted in a serious injury as a flight attendant was lowering her jumpseat.
- [NTSB CEN22FA376](https://openairdocs.org/ntsb/CEN22FA376.md): Cessna 182Q · Centennial, CO · Accident · 1 fatal · Class 3 · Field · Final report · Aug 9, 2022 · N727PC · Destroyed
  > The loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.
- [NTSB WPR22FA256](https://openairdocs.org/ntsb/WPR22FA256.md): Cessna T337G · Gold Hill, CO · Accident · 4 fatal · Class 3 · Field · Final report · Jul 17, 2022 · N337KN · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering with one engine inoperative, which resulted in an aerodynamic stall/spin and impact with terrain.
- [NTSB CEN22LA176](https://openairdocs.org/ntsb/CEN22LA176.md): Cirrus Design SR22 · Twin Lakes, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 13, 2022 · N112TR · Substantial damage
  > The failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…
- [NTSB CEN22LA093](https://openairdocs.org/ntsb/CEN22LA093.md): Zenith CH750 · Montrose, CO · Accident · No injuries · Class 3 · Limited · Final report · Jan 2, 2022 · N750DP · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN22FA011](https://openairdocs.org/ntsb/CEN22FA011.md): Beech 58TC · Mesa, CO · Accident · 1 fatal · Class 3 · Field · Final report · Oct 11, 2021 · N6748V · Destroyed
  > The maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…
- [NTSB CEN21FA305](https://openairdocs.org/ntsb/CEN21FA305.md): Hawker Beechcraft G36 · Aspen, CO · Accident · 2 fatal · Class 3 · Field · Final report · Jul 4, 2021 · N36JJ · Destroyed
  > The pilot’s failure to navigate through mountainous terrain, which resulted in controlled flight into terrain.
- [NTSB CEN21LA261](https://openairdocs.org/ntsb/CEN21LA261.md): Piper PA32 · Lafayette, CO · Accident · No injuries · Class 4 · Limited · Final report · Jun 11, 2021 · N3793W · Substantial damage
  > The flight crew’s improper fuel management that resulted in fuel starvation and the loss of engine power.
- [NTSB CEN21LA251](https://openairdocs.org/ntsb/CEN21LA251.md): Kevin Lippert Zenith CH 750 · Montrose, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 5, 2021 · N902KL · Substantial damage
  > The loss of engine power due to fuel vapor lock.
- [NTSB CEN21LA241](https://openairdocs.org/ntsb/CEN21LA241.md): Pipistrel Alpha Trainer · Fort Collins, CO · Accident · Serious injuries · Class 3 · Limited · Final report · May 28, 2021 · N119JP · Substantial damage
  > A partial loss of engine power due to the failure of the throttle control cable, which resulted in the loss of control of the dual carburetor system. The cable failure was a result of improper soldering at the throttle cable input terminal on the splitter…
- [NTSB DCA21LA120](https://openairdocs.org/ntsb/DCA21LA120.md): Vans RV-7 · Boulder, CO · Accident · No injuries · Class 4 · Limited · Final report · Apr 10, 2021 · N137RV · Substantial damage
  > a bird strike.
- [NTSB CEN21LA065](https://openairdocs.org/ntsb/CEN21LA065.md): Piper PA32R · Canon City, CO · Accident · No injuries · Class 3 · Limited · Final report · Nov 20, 2020 · N4187H · Substantial damage
  > The failure of the alternator drive belt, which resulted in insufficient electrical power to extend the landing gear and a subsequent gear-up landing..
- [NTSB CEN21FA007](https://openairdocs.org/ntsb/CEN21FA007.md): Beech S35 · Telluride, CO · Accident · 2 fatal · Class 3 · Field · Final report · Oct 5, 2020 · N4444K · Substantial damage
  > The pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.
- [NTSB CEN21LA001](https://openairdocs.org/ntsb/CEN21LA001.md): Cessna 210 · Cedaredge, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 4, 2020 · N9568X · Destroyed
  > A partial loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB CEN20LA160](https://openairdocs.org/ntsb/CEN20LA160.md): Aerostar 601 · Craig, CO · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 24, 2020 · N601X · Destroyed
  > The student pilot’s flight into terrain for undetermined reasons.
- [NTSB CEN20LA069](https://openairdocs.org/ntsb/CEN20LA069.md): Cirrus SR22 · Woody Creek, CO · Accident · No injuries · Class 3 · Limited · Final report · Jan 27, 2020 · N288WT · Substantial damage
  > Water trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing.
- [NTSB CEN19LA313](https://openairdocs.org/ntsb/CEN19LA313.md): Jackson Velocity · Mack, CO · Accident · No injuries · Class 3 · Limited · Final report · Sep 3, 2019 · N2XF · Substantial damage
  > A propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.
- [NTSB DCA19CA206](https://openairdocs.org/ntsb/DCA19CA206.md): Airbus A320 · Denver, CO · Accident · Serious injuries · Data collection · Final report · Aug 27, 2019 · N328FR · No damage
  > an encounter with mountain wave turbulence.
- [NTSB CEN19LA260](https://openairdocs.org/ntsb/CEN19LA260.md): Moth DH60GM · Cortez, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 8, 2019 · N919DH · Substantial damage
  > A partial loss of engine power due to carburetor ice accumulation, which resulted in a loss of altitude and impact with trees.
- [NTSB CEN18LA142](https://openairdocs.org/ntsb/CEN18LA142.md): Cessna T210N · Colorado Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2018 · N6988N · Substantial damage
  > The pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN18FA266](https://openairdocs.org/ntsb/CEN18FA266.md): Cessna 210 · Alma, CO · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2018 · N68640 · Substantial damage
  > The noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.…
- [NTSB CEN18LA068](https://openairdocs.org/ntsb/CEN18LA068.md): Barnes Steven D Steve Barnes RV 4 · Montrose, CO · Accident · No injuries · Limited investigation · Final report · Jan 4, 2018 · N83SB · Substantial damage
  > The total loss of engine power for reasons that could not be determined because a postaccident examination of the engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN18LA042](https://openairdocs.org/ntsb/CEN18LA042.md): Motley Gary W Zenith CH750 Cruzer · Louviers, CO · Accident · No injuries · Limited investigation · Final report · Nov 27, 2017 · N956GM · Substantial damage
  > The engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.

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

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