# NTSB investigations, CO: Takeoff

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 8 · 399 cases

## Latest cases

- [NTSB CEN27LA003](https://openairdocs.org/ntsb/CEN27LA003.md): Socata TB 9 Tampico · Loveland, CO · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 3, 2026 · N167GT · Substantial damage
  > On October 13, 2026, at 1412 mountain daylight time, a Socata TB 9 Tampico, N167GT, sustained substantial damage when it was involved in an accident near Loveland, Colorado. The private pilot and a passenger were uninjured. The airplane was operated as a…
- [NTSB CEN26LA303](https://openairdocs.org/ntsb/CEN26LA303.md): American Champion 8GCBC · Westminster, CO · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 28, 2026 · N125WB · Substantial damage
- [NTSB WPR26LA259](https://openairdocs.org/ntsb/WPR26LA259.md): Vans RV8 · Monte Vista, CO · Accident · No injuries · Class 4 · Limited · Final report · Jul 7, 2026 · N425GB · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.
- [NTSB CEN26LA243](https://openairdocs.org/ntsb/CEN26LA243.md): Evolution Revolt · Peyton, CO · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 30, 2026 · N672BB · Substantial damage
  > The flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.
- [NTSB CEN26LA210](https://openairdocs.org/ntsb/CEN26LA210.md): Cessna 172S · Colorado Springs, CO · Accident · No injuries · Class 4 · Limited · Final report · May 29, 2026 · N386SP · Substantial damage
  > The student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.
- [NTSB CEN26LA169](https://openairdocs.org/ntsb/CEN26LA169.md): Luscombe 8E · Meeker, CO · Accident · No injuries · Class 4 · Limited · Final report · Apr 19, 2026 · N1398K · Substantial damage
  > The pilot’s inability to maintain climb performance and clearance from terrain due to the airplane’s encounter with windshear during takeoff.
- [NTSB CEN26LA152](https://openairdocs.org/ntsb/CEN26LA152.md): Ela ELA10 · Boulder, CO · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2026 · N510EA · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.
- [NTSB CEN26LA067](https://openairdocs.org/ntsb/CEN26LA067.md): Mark O Treidel American Ranger AR-1 · Denver, CO · Accident · No injuries · Class 4 · Limited · Final report · Dec 16, 2025 · N529MW · Substantial damage
  > The pilot’s failure to attain rotor RPM and maintain proper rotor disc angle during takeoff which resulted in a rotor strike with the rudder.
- [NTSB CEN26LA017](https://openairdocs.org/ntsb/CEN26LA017.md): Rans S20 · Springfield, CO · Accident · No injuries · Class 4 · Limited · Final report · Oct 12, 2025 · N319WD · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff with a right crosswind.
- [NTSB CEN25LA405](https://openairdocs.org/ntsb/CEN25LA405.md): Sukhoi SU-26MX · Longmont, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 30, 2025 · N25SU · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB DCA25LA275](https://openairdocs.org/ntsb/DCA25LA275.md): Boeing 737-8 · Denver, CO · Accident · No injuries · Class 4 · Limited · Final report · Jul 26, 2025 · N306SW · Substantial damage
  > The failure of the airplane’s left main landing gear tires and wheels during the takeoff roll due to the thermal relief plugs melting and releasing tire pressure, which resulted in abnormal airplane handling characteristics and led the flight crew to reject…
- [NTSB CEN25LA118](https://openairdocs.org/ntsb/CEN25LA118.md): Just Superstol · Paonia, CO · Accident · No injuries · Class 4 · Limited · Final report · Mar 12, 2025 · N45TW · Substantial damage
  > The pilot’s failure to maintain the airplane’s directional control during the takeoff roll.
- [NTSB CEN25LA074](https://openairdocs.org/ntsb/CEN25LA074.md): Cessna 560 · Pagosa Springs, CO · Accident · No injuries · Class 3 · Limited · Final report · Dec 27, 2024 · N753MB · Substantial damage
  > The pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…
- [NTSB CEN25LA027](https://openairdocs.org/ntsb/CEN25LA027.md): Cessna 172P · Falcon, CO · Accident · No injuries · Class 4 · Limited · Final report · Oct 24, 2024 · N62740 · Substantial damage
  > The student pilot’s failure to maintain aircraft control and the flight instructor’s delayed remedial action during takeoff, which resulted in a collision with a taxiway sign.
- [NTSB CEN24LA328](https://openairdocs.org/ntsb/CEN24LA328.md): Hawker Beechcraft Hawker 900XP · Telluride, CO · Accident · No injuries · Class 3 · Limited · Final report · Jul 20, 2024 · N526FC · Substantial damage
  > The flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…
- [NTSB CEN24LA244](https://openairdocs.org/ntsb/CEN24LA244.md): Desert Fox 1 · Ellicott, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 27, 2024 · N10ZR · Substantial damage
  > The pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.
- [NTSB CEN24LA133](https://openairdocs.org/ntsb/CEN24LA133.md): Schweizer SGS 2-33A · Falcon, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 12, 2024 · N2905H · Substantial damage
  > The flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.
- [NTSB CEN24FA083](https://openairdocs.org/ntsb/CEN24FA083.md): Just Highlander · Dolores, CO · Accident · 2 fatal · Class 3 · Field · Final report · Jan 6, 2024 · N712DG · Destroyed
  > The pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.
- [NTSB CEN24LA018](https://openairdocs.org/ntsb/CEN24LA018.md): Cessna 210B · Pueblo, CO · Accident · No injuries · Class 3 · Limited · Final report · Oct 18, 2023 · N9597X · Substantial damage
  > The fatigue failure of the right main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position.
- [NTSB DCA23LA468](https://openairdocs.org/ntsb/DCA23LA468.md): Boeing 737-9 · Denver, CO · Accident · No injuries · Class 4 · Limited · Final report · Sep 30, 2023 · N37560 · Substantial damage
  > Overheated brakes due to the extended taxi at a higher power setting in an attempt to burn off fuel to achieve the proper takeoff weight that resulted in a wheel fire during takeoff.
- [NTSB CEN23LA277](https://openairdocs.org/ntsb/CEN23LA277.md): Piper J3C-50 · Elbert, CO · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 26, 2023 · N23161 · Substantial damage
  > The pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.
- [NTSB CEN23LA211](https://openairdocs.org/ntsb/CEN23LA211.md): W10 Tailwind · Penrose, CO · Accident · No injuries · Class 3 · Limited · Final report · May 31, 2023 · N456TW · Substantial damage
  > The failure of the right rudder pedal stop due to an inadequate weld, which resulted in a loss of control on the ground.
- [NTSB CEN23LA102](https://openairdocs.org/ntsb/CEN23LA102.md): Cessna 172S · Limon, CO · Accident · No injuries · Class 4 · Limited · Final report · Feb 1, 2023 · N5163H · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB CEN22LA390](https://openairdocs.org/ntsb/CEN22LA390.md): Aero Commander 100-180 · Pueblo, CO · Accident · No injuries · Class 4 · Limited · Final report · Aug 13, 2022 · N3727X · Substantial damage
  > The flight instructor’s failure to maintain adequate airspeed during the demonstrated soft-field takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB CEN22LA130](https://openairdocs.org/ntsb/CEN22LA130.md): Raytheon Hawker 800XP · Aspen, CO · Accident · No injuries · Class 3 · Limited · Final report · Feb 21, 2022 · N99AP · Substantial damage
  > The flight crew’s decision to takeoff in tailwind conditions that were consistently above the airplane’s tailwind limitation, which resulted in a runway overrun following an aborted takeoff. Contributing was the flight crew’s use of the instantaneous wind…
- [NTSB DCA22LA069](https://openairdocs.org/ntsb/DCA22LA069.md): Airbus A320-232 · Hayden, CO · Accident · No injuries · Class 4 · Limited · Final report · Jan 22, 2022 · N760JB · Substantial damage
  > The captain’s rotation of the airplane pitch before the rotation speed on takeoff due to his surprise about encountering head on landing traffic, which resulted in an exceedance of the airplane’s pitch limit and a subsequent tail strike. Contributing to the…
- [NTSB CEN22LA010](https://openairdocs.org/ntsb/CEN22LA010.md): Piper PA-24 · Loveland, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 7, 2021 · N5585P · Substantial damage
  > The pilot’s failure to recognize the degraded engine power and abort the takeoff in a timely manner.
- [NTSB CEN21LA425](https://openairdocs.org/ntsb/CEN21LA425.md): Kolb Mark III · Steamboat Springs, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 14, 2021 · N4365E · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB CEN21LA383](https://openairdocs.org/ntsb/CEN21LA383.md): Piper PA-28-181 · Gypsum, CO · Accident · No injuries · Class 4 · Limited · Final report · Aug 24, 2021 · N46MD · Substantial damage
  > A loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.
- [NTSB CEN21LA315](https://openairdocs.org/ntsb/CEN21LA315.md): Cessna 421C · Longmont, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 10, 2021 · N66NC · Substantial damage
  > The loss of performance for reasons that could not be determined.
- [NTSB CEN21LA160](https://openairdocs.org/ntsb/CEN21LA160.md): Cessna 172 · Watkins, CO · Accident · No injuries · Class 4 · Limited · Final report · Mar 17, 2021 · N786CP · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff and the instructor pilot’s inadequate supervision of the pilot’s takeoff.
- [NTSB CEN21LA006](https://openairdocs.org/ntsb/CEN21LA006.md): Aeronca 7AC · Salida, CO · Accident · No injuries · Class 4 · Limited · Final report · Oct 5, 2020 · N3370E · Substantial damage
  > The student pilot’s loss of directional control during takeoff and the flight instructor’s delayed remedial action which resulted in a runway excursion and impact with a steel object.
- [NTSB CEN20LA424](https://openairdocs.org/ntsb/CEN20LA424.md): Kitfox Speedster · Leadville, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 24, 2020 · N525PP · Substantial damage
  > A partial loss of engine power due to fuel starvation as a result of the pilot’s improper maintenance.
- [NTSB CEN20CA404](https://openairdocs.org/ntsb/CEN20CA404.md): Cubcrafters CC11 · Larkspur, CO · Accident · No injuries · Class 4 · Data collection · Final report · Sep 18, 2020 · N55JV · Substantial damage
  > The pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.
- [NTSB CEN20CA277](https://openairdocs.org/ntsb/CEN20CA277.md): Kitfox Kitfox Sport · Rand, CO · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 12, 2020 · N702KS · Substantial damage
  > The encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.
- [NTSB CEN20LA268](https://openairdocs.org/ntsb/CEN20LA268.md): Mooney M20TN · Buena Vista, CO · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 7, 2020 · C-GTVS · Substantial damage
  > The pilot's distraction during takeoff, which resulted in collision with terrain.
- [NTSB CEN20CA128](https://openairdocs.org/ntsb/CEN20CA128.md): Cessna 172 · Denver, CO · Accident · No injuries · Data collection · Final report · Mar 18, 2020 · N1132W · Substantial damage
  > The pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign.
- [NTSB GAA20CA014](https://openairdocs.org/ntsb/GAA20CA014.md): Piper PA38 · Colorado Springs, CO · Accident · No injuries · Data collection · Final report · Oct 15, 2019 · N9708T · Substantial damage
  > The pilot's failure to maintain the runway heading while taking off with a gusting tailwind, which resulted in impact with a fence.
- [NTSB GAA19CA440](https://openairdocs.org/ntsb/GAA19CA440.md): Cessna 172 · Denver, CO · Accident · No injuries · Data collection · Final report · Jul 19, 2019 · N403FR · Substantial damage
  > The student pilot's failure to maintain lateral control during a soft-field takeoff, which resulted in the left wing striking the runway and a runway excursion.
- [NTSB GAA19CA208](https://openairdocs.org/ntsb/GAA19CA208.md): Airframes Unlimited Outlaw · Elizabeth, CO · Accident · Serious injuries · Data collection · Final report · Apr 15, 2019 · N5622D · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his subsequent decision to initiate a turn, which resulted in the powered parachute’s descent and impact with a fence.
- [NTSB WPR19TA034](https://openairdocs.org/ntsb/WPR19TA034.md): Cessna 172 · Colorado Springs, CO · Accident · Minor injuries · Class 3 · Final report · Nov 20, 2018 · N27LA · Substantial damage
  > The pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…
- [NTSB CEN18LA335](https://openairdocs.org/ntsb/CEN18LA335.md): Cessna R172E · Colorado Springs, CO · Accident · No injuries · Limited investigation · Final report · Aug 16, 2018 · N146AC · Substantial damage
  > The airplane’s failure to maintain a climb after takeoff, which resulted in a forced landing on unsuitable terrain; the reason for the airplane’s failure to climb could not be determined based on the available evidence.
- [NTSB GAA18CA486](https://openairdocs.org/ntsb/GAA18CA486.md): Bushby Mustang II · Akron, CO · Accident · No injuries · Data collection · Final report · Aug 11, 2018 · N527JT · Substantial damage
  > The pilot’s improper preflight planning that did not identify the unserviceable runway; his subsequent decision to attempt to takeoff from the rough, grassy runway; and his selection of an abort point with insufficient runway remaining, which resulted in a…
- [NTSB CEN17LA327](https://openairdocs.org/ntsb/CEN17LA327.md): Greene R/Greene S Rans S 17 · Erie, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 2017 · N117BE · Substantial damage
  > The pilot's failure to maintain control following a rejected takeoff for a perceived loss of engine power. Contributing to the accident was the pilot's lack of training and experience in the airplane.
- [NTSB CEN17LA274](https://openairdocs.org/ntsb/CEN17LA274.md): Endler Glasair/Glasair 1-Td SH2 · Colorado Springs, CO · Accident · No injuries · Limited investigation · Final report · Jul 15, 2017 · N181AL · Destroyed
  > The pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…
- [NTSB CEN17LA122](https://openairdocs.org/ntsb/CEN17LA122.md): Piper PA 28R-200 · Centennial, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2017 · N2702R · Substantial damage
  > The loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN17LA123](https://openairdocs.org/ntsb/CEN17LA123.md): Beech C 99 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Jan 24, 2017 · N216CS · Substantial damage
  > The pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.
- [NTSB GAA16CA394](https://openairdocs.org/ntsb/GAA16CA394.md): Alon A2 · Alamosa, CO · Accident · No injuries · Data collection · Final report · Jul 27, 2016 · N5690F · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.
- [NTSB CEN16LA267](https://openairdocs.org/ntsb/CEN16LA267.md): Aeronca 7BCM · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2016 · N2576E · Substantial damage
  > The pilot's decision to continue the takeoff after observing a partial loss of engine power, the reason for which could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures.
- [NTSB GAA16CA146](https://openairdocs.org/ntsb/GAA16CA146.md): Beech D17 · Brighton, CO · Accident · Minor injuries · Data collection · Final report · Mar 11, 2016 · N9290H · Substantial damage
  > The pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.

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

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