# NTSB investigations, CO: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 12 · 570 cases

## Latest cases

- [NTSB CEN26LA156](https://openairdocs.org/ntsb/CEN26LA156.md): Cessna 150G · Ellicott, CO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 21, 2026 · N6305S · Substantial damage
  > On March 21, 2026, about 1023 mountain daylight time, a Cessna 150G airplane, N6305S, was substantially damaged when it was involved in an accident near Ellicott, Colorado. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26FA023](https://openairdocs.org/ntsb/CEN26FA023.md): JMB VL-3LSA-912 · Erie, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 19, 2025 · N594TT · Substantial damage
  > On October 19, 2025, about 1531 mountain daylight time, a JMB Aircraft VL-3LSA-912, N594TT, was substantially damaged when it was involved in an accident near Erie, Colorado. The pilot receiving instruction and the flight instructor were fatally injured. The…
- [NTSB CEN25FA366](https://openairdocs.org/ntsb/CEN25FA366.md): Beech P35 · Englewood, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 5, 2025 · N463T · Destroyed
  > On September 5, 2025, about 0623 mountain daylight time, a Beech P35 airplane, N463T, was destroyed when it was involved in an accident near Englewood, Colorado. The pilot receiving instruction and flight instructor were both fatally injured. The airplane was…
- [NTSB WPR25FA268](https://openairdocs.org/ntsb/WPR25FA268.md): Cessna 172M · Fort Morgan, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 31, 2025 · N61657 · 2 aircraft · Destroyed
  > On August 31, 2025, about 1040 mountain daylight time, a Cessna 172M, N61657, and an Extra Flugzeugproduktions-UND EA 300/LC, N330AN, were both destroyed when they collided midair near Fort Morgan, Colorado. The pilot and safety pilot of the Cessna received…
- [NTSB CEN25FA178](https://openairdocs.org/ntsb/CEN25FA178.md): Beech 95-B55 (T42A) · Broomfield, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 17, 2025 · N4321Z · Destroyed
  > On May 17, 2025, about 1003 mountain daylight time, a Beechcraft 95-B55, was destroyed when it was involved in an accident near Broomfield, Colorado. The pilot and pilot-rated passenger sustained fatal injuries. The flight was being operated as a Title 14…
- [NTSB CEN25LA168](https://openairdocs.org/ntsb/CEN25LA168.md): Cessna 172N · Longmont, CO · Accident · No injuries · Class 3 · Limited · Final report · May 4, 2025 · N75775 · Substantial damage
  > The disconnected throttle control that resulted in a loss of engine power due to improper maintenance.
- [NTSB CEN25LA146](https://openairdocs.org/ntsb/CEN25LA146.md): Piper PA28 · Ault, CO · Accident · No injuries · Class 4 · Limited · Final report · Apr 7, 2025 · N8282V · Substantial damage
  > The flight instructor’s failure to maintain terrain clearance during an attempted go-around, which resulted in a collision with a fence post.
- [NTSB CEN25LA088](https://openairdocs.org/ntsb/CEN25LA088.md): Cessna 172S · Air Force Academy, CO · Accident · No injuries · Class 4 · Limited · Final report · Jan 27, 2025 · N51387 · Substantial damage
  > The pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.
- [NTSB CEN24LA373](https://openairdocs.org/ntsb/CEN24LA373.md): Piper PA-18-150 · Delta, CO · Accident · No injuries · Class 4 · Limited · Final report · Sep 28, 2024 · N4155W · Substantial damage
  > The pilot’s loss of aircraft control during a bounced landing and go-around, during which the right main landing gear struck a large rock, which damaged it such that it collapsed during the following landing, which caused the airplane to impact the ground…
- [NTSB CEN24FA228](https://openairdocs.org/ntsb/CEN24FA228.md): Cessna 421 · Steamboat Springs, CO · Accident · 2 fatal · Class 3 · Field · Final report · Jun 17, 2024 · N245T · Destroyed
  > The pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.
- [NTSB CEN24LA206](https://openairdocs.org/ntsb/CEN24LA206.md): Piper PA-24-250 · Colorado Springs, CO · Accident · Minor injuries · Class 3 · Limited · Final report · May 31, 2024 · N7500P · Substantial damage
  > The pilot’s failure to use the carburetor heat during a descent that resulted in the loss of engine power due to carburetor icing.
- [NTSB CEN24LA198](https://openairdocs.org/ntsb/CEN24LA198.md): Brant T Phillips Super Cub EXP · Franktown, CO · Accident · No injuries · Class 4 · Limited · Final report · May 26, 2024 · N983SB · Substantial damage
  > The pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.
- [NTSB CEN24LA129](https://openairdocs.org/ntsb/CEN24LA129.md): American Eurocopter AS350B3 · Fort Morgan, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 5, 2024 · N853MB · Substantial damage
  > An inflight collision with birds while on approach.
- [NTSB CEN23FA391](https://openairdocs.org/ntsb/CEN23FA391.md): Schleicher Alexander ASH 26 E · Wellington, CO · Accident · 1 fatal · Class 3 · Field · Final report · Aug 31, 2023 · N50FU · Substantial damage
  > The pilot’s loss of glider control during approach for reasons that could not be determined, which resulted in an aerodynamic stall at an altitude too low for recovery.
- [NTSB CEN23LA082](https://openairdocs.org/ntsb/CEN23LA082.md): Cessna 182R · Las Animas, CO · Accident · No injuries · Class 3 · Limited · Final report · Jan 14, 2023 · N9393H · Substantial damage
  > The student pilot’s loss of control during approach for landing and the flight instructor’s inadequate supervision of the approach and delay in ensuring a go-around was performed at the onset of a stall warning.
- [NTSB CEN22LA362](https://openairdocs.org/ntsb/CEN22LA362.md): Cessna 172N · Longmont, CO · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2022 · N6587E · Substantial damage
  > The flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.
- [NTSB CEN22LA297](https://openairdocs.org/ntsb/CEN22LA297.md): Cub Crafters CC18-180 · Air Force Academy, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 1, 2022 · N469AK · Substantial damage
  > The pilot’s failure to maintain airplane control during the go-around, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment from the effects of alcohol consumption.
- [NTSB CEN22FA240](https://openairdocs.org/ntsb/CEN22FA240.md): HPH Spol Sro Glasflugel 304 MS · Rifle, CO · Accident · 1 fatal · Class 3 · Field · Final report · Jun 9, 2022 · N249SD · Destroyed
  > The glider’s encounter with gusting tailwind and downdraft conditions that the pilot was unable to overcome.
- [NTSB CEN22FA197](https://openairdocs.org/ntsb/CEN22FA197.md): Cessna 172 · Broomfield, CO · Accident · 1 fatal · Class 3 · Field · Final report · May 11, 2022 · N73670 · Destroyed
  > The pilot’s failure to maintain control of the airplane for reasons that could not be determined.
- [NTSB CEN22LA171](https://openairdocs.org/ntsb/CEN22LA171.md): Cirrus Design SR22 · Peyton, CO · Accident · No injuries · Class 4 · Limited · Final report · Apr 8, 2022 · N248G · Substantial damage
  > The pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.
- [NTSB CEN22LA110](https://openairdocs.org/ntsb/CEN22LA110.md): Diamond Aircraft Ind DA20-C1 · Fort Carson, CO · Accident · No injuries · Class 4 · Limited · Final report · Jan 25, 2022 · N974DA · Substantial damage
  > The windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.
- [NTSB CEN22FA069](https://openairdocs.org/ntsb/CEN22FA069.md): Piper PA46-500TP · Steamboat Springs, CO · Accident · 1 fatal · Class 3 · Field · Final report · Dec 11, 2021 · N744Z · Substantial damage
  > The pilot’s failure to adhere to the published instrument approach procedure, which resulted in controlled flight into terrain.
- [NTSB CEN21LA281](https://openairdocs.org/ntsb/CEN21LA281.md): Schweizer SGS 1-35 · Wellington, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 20, 2021 · N2851H · Substantial damage
  > The glider pilot’s loss of visual references during the landing approach resulting in an off-airport landing on rough sloping terrain.
- [NTSB CEN21FA272](https://openairdocs.org/ntsb/CEN21FA272.md): Antenor Velazco Lancair Evolution · Parker, CO · Accident · 2 fatal · Class 3 · Field · Final report · Jun 16, 2021 · N704AK · Destroyed
  > The pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…
- [NTSB CEN21FA215](https://openairdocs.org/ntsb/CEN21FA215.md): Swearingen SA226TC · Englewood, CO · Accident · No injuries · Class 3 · Field · Final report · May 12, 2021 · N280KL · 2 aircraft · Substantial damage
  > The Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…
- [NTSB CEN21LA067](https://openairdocs.org/ntsb/CEN21LA067.md): Vans RV4 · Telluride, CO · Accident · 2 fatal · Class 3 · Limited · Final report · Nov 26, 2020 · N87LW · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…
- [NTSB CEN21LA002](https://openairdocs.org/ntsb/CEN21LA002.md): Cessna 182 · Byers, CO · Accident · No injuries · Class 3 · Limited · Final report · Oct 3, 2020 · N9901E · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB CEN20LA375](https://openairdocs.org/ntsb/CEN20LA375.md): Titan Mustang T-51 · Brighton, CO · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 2, 2020 · N153JW · Substantial damage
  > The pilot’s loss of airplane control while maneuvering in the traffic pattern.
- [NTSB CEN20LA365](https://openairdocs.org/ntsb/CEN20LA365.md): Cessna T210 · Peyton, CO · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 26, 2020 · N64EM · Destroyed
  > The pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.
- [NTSB CEN20LA169](https://openairdocs.org/ntsb/CEN20LA169.md): Rans S-12 · Delta, CO · Accident · 1 fatal · Class 3 · Limited · Final report · May 3, 2020 · N427LB · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during a test flight which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN20FA072](https://openairdocs.org/ntsb/CEN20FA072.md): Piper PA28 · Florence, CO · Accident · 1 fatal · Class 3 · Field · Final report · Feb 2, 2020 · N5969W · Substantial damage
  > The pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitude
- [NTSB GAA20CA092](https://openairdocs.org/ntsb/GAA20CA092.md): Czech Aircraft Works Spol Sro Sportscruiser · Lamar, CO · Accident · No injuries · Data collection · Final report · Nov 23, 2019 · N595SC · Substantial damage
  > The pilot's distraction due to an open canopy during final approach, which resulted in a loss of altitude and ground impact short of the runway.
- [NTSB GAA19CA490](https://openairdocs.org/ntsb/GAA19CA490.md): Diamond DA20 · Pueblo, CO · Accident · No injuries · Data collection · Final report · Aug 7, 2019 · N979DA · Substantial damage
  > The student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.
- [NTSB GAA19CA409](https://openairdocs.org/ntsb/GAA19CA409.md): Diamond DA 40 · Denver, CO · Accident · No injuries · Data collection · Final report · Jul 13, 2019 · N388JP · Substantial damage
  > The pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.
- [NTSB CEN19FA143](https://openairdocs.org/ntsb/CEN19FA143.md): Beech 60 · Loveland, CO · Accident · 1 fatal · Field investigation · Final report · May 15, 2019 · N60RK · Destroyed
  > A loss of control due to an inflight right engine fire due to the loose fuel hose between the engine-driven fuel pump and the flow transducer.
- [NTSB CEN19LA107](https://openairdocs.org/ntsb/CEN19LA107.md): Cessna R172E · Loveland, CO · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2019 · N7879N · Substantial damage
  > An inflight loss of control on landing approach due to encountering a down-draft, and the pilot's failure to take timely action to abandon the approach and perform a go-around.
- [NTSB CEN19FA022](https://openairdocs.org/ntsb/CEN19FA022.md): Mustang II · Broomfield, CO · Accident · 2 fatal · Field investigation · Final report · Nov 2, 2018 · N287BM · Substantial damage
  > The pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.
- [NTSB CEN19LA006](https://openairdocs.org/ntsb/CEN19LA006.md): Cessna 120 · Hudson, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2018 · N1881N · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18CA323](https://openairdocs.org/ntsb/CEN18CA323.md): Cessna 172 · Greeley, CO · Accident · No injuries · Data collection · Final report · Aug 9, 2018 · N20JA · Substantial damage
  > The pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…
- [NTSB CEN18LA087](https://openairdocs.org/ntsb/CEN18LA087.md): Robinson Helicopter R44 II · Loveland, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2018 · N878BC · 2 aircraft · Substantial damage
  > The airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…
- [NTSB GAA18CA075](https://openairdocs.org/ntsb/GAA18CA075.md): Jones Kent C Vans RV-10 · Limon, CO · Accident · Minor injuries · Data collection · Final report · Dec 8, 2017 · N9738J · Substantial damage
  > The pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.
- [NTSB CEN18CA021](https://openairdocs.org/ntsb/CEN18CA021.md): Cessna T210N · Eagle, CO · Accident · No injuries · Data collection · Final report · Oct 23, 2017 · N5129C · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN17LA247](https://openairdocs.org/ntsb/CEN17LA247.md): Cessna P210N · Eagle, CO · Accident · No injuries · Limited investigation · Final report · Jun 30, 2017 · N210HG · Substantial damage
  > The loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17LA192](https://openairdocs.org/ntsb/CEN17LA192.md): Robinson Helicopter R66 · Canon City, CO · Accident · No injuries · Limited investigation · Final report · May 20, 2017 · N778TL · Substantial damage
  > The pilot’s loss of helicopter control on approach to land due to a vortex ring state (settling with power) condition, which resulted in a hard landing.
- [NTSB CEN17LA185](https://openairdocs.org/ntsb/CEN17LA185.md): Mooney M20TN · Grandby, CO · Accident · No injuries · Limited investigation · Final report · May 13, 2017 · N9306 · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN17LA162](https://openairdocs.org/ntsb/CEN17LA162.md): Cessna 210 · Salida, CO · Accident · No injuries · Limited investigation · Final report · Apr 20, 2017 · N9589T · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA17CA197](https://openairdocs.org/ntsb/GAA17CA197.md): Cessna R182 · Colorado Springs, CO · Accident · No injuries · Data collection · Final report · Mar 18, 2017 · N747AB · Substantial damage
  > The pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.
- [NTSB GAA17CA131](https://openairdocs.org/ntsb/GAA17CA131.md): Cessna T210 · Loveland, CO · Accident · Minor injuries · Data collection · Final report · Feb 5, 2017 · N4853U · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB GAA16CA201](https://openairdocs.org/ntsb/GAA16CA201.md): Helicycle/Morrisey RR RM-1 · Denver, CO · Accident · Minor injuries · Data collection · Final report · Apr 22, 2016 · N867TV · Substantial damage
  > The pilot's failure to maintain control of the helicopter yaw while operating in conditions conducive to loss of tail rotor effectiveness, resulting in an uncommanded rapid right yaw and ground impact.
- [NTSB CEN16LA053](https://openairdocs.org/ntsb/CEN16LA053.md): Pipistrel Virus · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Dec 2, 2015 · N145VS · Substantial damage
  > The total loss of engine power due to fuel starvation as a result of contamination in the right fuel tank and fuel lines, which prevented fuel from flowing to the engine.

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

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