NTSB investigations, CO
15 cases where the defining event was Collision during takeoff/land.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490')
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.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '490') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN27LA003Accident · No injuriesClass 3 · LimitedPreliminary reportSocata TB 9 Tampico · Loveland, COOn 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 CEN25FA216Accident · 2 fatalClass 3 · FieldPreliminary reportMurphy Aircraft Manufacturing Moose · Montrose, COOn June 23, 2025, about 1021 mountain daylight time, a Murphy Aircraft Manufacturing Limited Moose airplane, N250MK, was destroyed when it was involved in an accident near Montrose, Colorado. The pilot and the pilot-rated passenger sustained fatal injuries.…NTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.NTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.NTSB CEN20LA268Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20TN · Buena Vista, COThe pilot's distraction during takeoff, which resulted in collision with terrain.NTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.NTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe 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 CEN14CA166Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Hudson, COThe pilot's inadequate monitoring of his glide path resulting in a collision with a berm prior to landing.NTSB CEN14FA141Accident · 3 fatalField investigationFinal reportBeech 35/33 · Telluride, COThe airplane’s failure to obtain a positive climb rate, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.NTSB CEN13LA347Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Arvada, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…NTSB CEN10LA487Accident · No injuriesLimited investigationFinal reportShpakow Thomas SA 750 · Brighton, COThe radio-controlled airplane operator’s decision to maneuver his airplane outside of the designated operating area, resulting in a collision with a bi-plane. Contributing to the accident was the lack of a formally designated spotter.NTSB CEN10LA047Accident · No injuriesLimited investigationFinal reportCessna T182T · Loveland, COThe pilot's failure to attain the proper touchdown point during dusk light conditions, and his failure to execute a go-around.NTSB CEN09LA165Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Steamboat Springs, COThe pilot's failure to apply brakes in a timely manner while landing on a snow-packed, ice-covered runway, and his delay in executing a go-around.NTSB DEN08CA157Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Boulder, COThe pilot's failure to use the dive brake during landing resulting in a long landing and collision.