Final NTSB investigations, CO

259 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
Final NTSB investigations, CO per year, 2008–2026: 259 cases
200828
200913
20109
201122
201218
201316
201422
201515
201612
201715
201817
201914
202015
202110
20229
20235
20249
20255
20265

Latest cases

Query with SQL
duckdb -csv -c "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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.Aug 21, 2026 · N464PM · Substantial damageNTSB WPR26LA259Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Monte Vista, COThe pilot’s failure to maintain directional control during takeoff in gusty crosswind conditions.Jul 7, 2026 · N425GB · Substantial damageNTSB WPR26LA243Accident · No injuriesClass 4 · LimitedFinal reportValerie Westedt Zenith Zodiac 650B · Colorado Springs, COThe pilot’s improper flare which resulted in a hard landing and their subsequent loss control of during a go-around. Contributing to the accident was the flight instructor’s inadequate remedial action.Jul 5, 2026 · N452VC · Substantial damageNTSB CEN26LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-236 · Glenwood Springs, COThe pilot’s failure to maintain clearance from a fuel farm fence while taxiing.May 3, 2026 · N2904R · Substantial damageNTSB CEN26LA169Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Meeker, COThe pilot’s inability to maintain climb performance and clearance from terrain due to the airplane’s encounter with windshear during takeoff.Apr 19, 2026 · N1398K · Substantial damageNTSB CEN26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Colorado Springs, COThe pilot’s failure to maintain directional control during the landing.Nov 26, 2025 · N4588Z · Substantial damageNTSB CEN26LA017Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Springfield, COThe pilot's failure to maintain directional control during the takeoff with a right crosswind.Oct 12, 2025 · N319WD · Substantial damageNTSB CEN25LA334Accident · No injuriesClass 4 · LimitedFinal reportKaman Aerospace K-1200 · Eagle, COThe pilot’s failure to maintain helicopter control which resulted in an uncontrolled descent and impact with terrain.Aug 22, 2025 · N171PL · Substantial damageNTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.Mar 15, 2025 · N237DB · Substantial damageNTSB CEN25LA118Accident · No injuriesClass 4 · LimitedFinal reportJust Superstol · Paonia, COThe pilot’s failure to maintain the airplane’s directional control during the takeoff roll.Mar 12, 2025 · N45TW · Substantial damageNTSB CEN24LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta, COThe 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…Sep 28, 2024 · N4155W · Substantial damageNTSB CEN24LA374Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Kremmling, COThe pilot’s failure to maintain directional control of the airplane during an aborted landing.Sep 19, 2024 · N822TL · Substantial damageNTSB CEN24LA350Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Englewood, COA partial loss of engine power due to fuel-oil contamination of the fuel injection servo.Sep 11, 2024 · N20747 · Substantial damageNTSB CEN24LA329Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Leadville, COA loss of brake fluid for reasons that could not be determined, which resulted in a loss of braking effectiveness during landing.Jul 4, 2024 · N1652T · Substantial damageNTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.Jun 17, 2024 · N245T · DestroyedNTSB CEN24LA224Accident · No injuriesClass 4 · LimitedFinal reportJonker Sailplanes JS3 RES · Elbert, COThe pilot’s failure to maintain directional control during the landing with a right crosswind.Jun 16, 2024 · N37JG · Substantial damageNTSB CEN24LA227Accident · Minor injuriesClass 4 · LimitedFinal reportBeech D55 · Colorado Springs, COThe deflated right main landing gear tire due to a sidewall puncture made by an unknown object, which led to the pilot’s loss of directional control and the landing gear collapse during landing roll.Jun 11, 2024 · N321N · Substantial damageNTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.May 26, 2024 · N983SB · Substantial damageNTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.Mar 12, 2024 · N2905H · Substantial damageNTSB CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.Dec 6, 2023 · N7790Y · Substantial damageNTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.Nov 9, 2023 · N1817E · Substantial damageNTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.Jul 6, 2023 · N100PB · DestroyedNTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe 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…May 6, 2023 · N15188 · DestroyedNTSB CEN23LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Las Animas, COThe 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.Jan 14, 2023 · N9393H · Substantial damageNTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure 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.Nov 5, 2022 · N6051U · Substantial damageNTSB CEN23LA017Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Loveland, COThe pilot’s loss of control after encountering windshear while landing in a strong, gusting crosswind. Contributing was pilot’s decision to continue the landing with a 90-degree crosswind at 30 knots.Oct 23, 2022 · N25HW · Substantial damageNTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.Sep 25, 2022 · N18NH · Substantial damageNTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe 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.Jul 30, 2022 · N6587E · Substantial damageNTSB WPR22FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna T337G · Gold Hill, COThe 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.Jul 17, 2022 · N337KN · DestroyedNTSB CEN22LA297Accident · Minor injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Air Force Academy, COThe 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.Jul 1, 2022 · N469AK · Substantial damageNTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.May 22, 2022 · N85CT · Substantial damageNTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.May 11, 2022 · N73670 · DestroyedNTSB CEN22LA130Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Aspen, COThe 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…Feb 21, 2022 · N99AP · Substantial damageNTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…Dec 8, 2021 · N456MC · Substantial damageNTSB CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.Nov 17, 2021 · N802NZ · Substantial damageNTSB CEN21LA425Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Mark III · Steamboat Springs, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Sep 14, 2021 · N4365E · Substantial damageNTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.Jul 27, 2021 · N6162R · Substantial damageNTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.Jun 27, 2021 · N7714E · Substantial damageNTSB CEN21LA291Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Loveland, COThe flight instructor’s failure to maintain aircraft control during the landing flare and subsequent attempted go-around with a strong quartering crosswind.Jun 25, 2021 · N9277J · Substantial damageNTSB CEN21LA281Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-35 · Wellington, COThe glider pilot’s loss of visual references during the landing approach resulting in an off-airport landing on rough sloping terrain.Jun 20, 2021 · N2851H · Substantial damageNTSB CEN21LA251Accident · Minor injuriesClass 4 · LimitedFinal reportKevin Lippert Zenith CH 750 · Montrose, COThe loss of engine power due to fuel vapor lock.Jun 5, 2021 · N902KL · Substantial damageNTSB CEN21LA248Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · Denver, COThe pilot’s failure to properly configure the airplane for landing, which resulted in a gear-up landing.Jun 3, 2021 · N219VP · Substantial damageNTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.Mar 17, 2021 · N2849M · Substantial damageNTSB CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.Dec 14, 2020 · N686TM · Substantial damageNTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe 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…Nov 26, 2020 · N87LW · Substantial damageNTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.Nov 6, 2020 · N418DE · Substantial damageNTSB CEN21LA006Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Salida, COThe 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.Oct 5, 2020 · N3370E · Substantial damageNTSB CEN21LA001Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Cedaredge, COA partial loss of engine power for reasons that could not be determined based on available evidence.Oct 4, 2020 · N9568X · DestroyedNTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.Sep 18, 2020 · N55JV · Substantial damageNTSB CEN20CA394Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA46 · Englewood, COThe pilot's failure to maintain directional control during landing in gusting winds.Sep 15, 2020 · N596ST · Substantial damage