NTSB investigations, CO
81 cases where NTSB found Performance/control parameters, general.
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 12 |
| 2012 | 9 |
| 2013 | 10 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 1 |
Where
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062000')) 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 CEN26LA067Accident · No injuriesClass 4 · LimitedFinal reportMark O Treidel American Ranger AR-1 · Denver, COThe 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 CEN25LA027Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Falcon, COThe 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 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 CEN23FA391Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Wellington, COThe 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 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.NTSB 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.NTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe 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 CEN21LA449Accident · No injuriesClass 4 · LimitedFinal reportColumbia Aircraft Mfg LC41-550FG · Granby, COThe pilot’s loss of control during landing in high density altitude conditions.NTSB CEN20LA169Accident · 1 fatalClass 3 · LimitedFinal reportRans S-12 · Delta, COThe 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 CEN20LA160Accident · 1 fatalClass 3 · LimitedFinal reportAerostar 601 · Craig, COThe student pilot’s flight into terrain for undetermined reasons.NTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeNTSB CEN19FA143Accident · 1 fatalField investigationFinal reportBeech 60 · Loveland, COA 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 CEN18FA168Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Lone Tree, COThe pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions.NTSB CEN18FA266Accident · 1 fatalField investigationFinal reportCessna 210 · Alma, COThe 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 CEN17FA354Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Glenwood Springs, COThe non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…NTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.NTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe 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 CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…NTSB CEN15LA275Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Pueblo, COThe student pilot’s decision to continue the approach and landing despite recognizing that the wind speed was above the published limit for solo flight, which resulted in a porpoised landing. Contributing to the accident was the failure of the flight…NTSB CEN15FA257Accident · 1 fatalField investigationFinal reportMorse Frank L Rebel · Eagle, CO, COThe pilot’s failure to maintain control of the airplane while landing in gusty, crosswind conditions that likely exceeded the recommended limitation of the airplane.NTSB GAA15CA053Accident · Minor injuriesData collectionFinal reportAero SP Z O O AT 4 LSA · Colorado Springs, COThe pilot's decision to perform aerobatic maneuvers in an airplane not certified for aerobatic flight, which resulted in a loss of control and collision with terrain.NTSB CEN15FA141Accident · 2 fatalField investigationFinal reportRichard Lacourse Wheeler Express · Kersey, COThe pilot's failure to maintain airplane control during an off-airport forced landing following a total loss of engine power for reasons that could not be determined during postaccident examination of the engine. Contributing to the accident was the pilots'…NTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…NTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.NTSB CEN14FA173Accident · 1 fatalField investigationFinal reportWorthington Donald Wayne Sonerai II LT · Highlands Ranch, COThe pilot’s loss of control during a forced landing following a loss of engine power for reasons that could not be determined due to postimpact fire damage.NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB CEN14TA126Accident · Minor injuriesFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe flight instructor's loss of control after takeoff following a wake turbulence encounter from a preceding helicopter. Contributing to the accident were the flight instructor's misidentification of the helicopter type and a lack of Federal Aviation…NTSB CEN14FA072Accident · 1 fatalField investigationFinal reportBiesemeier David I Smyth Sidewinder · Boulder, COThe pilot’s abrupt maneuver, which exceeded the structural limits of the left wing and resulted in its in-flight separation.NTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…NTSB CEN14CA049Accident · No injuriesData collectionFinal reportMooney M20R · Fort Collins, COThe pilot did not maintain control of the airplane during the go around.NTSB CEN14FA032Accident · Serious injuriesField investigationFinal reportGlasair Aviation USA Sportsman GS-2 · Castle Rock, COThe pilot’s improper decision to continue flight into known icing conditions, which adversely affected the airplane’s performance and resulted in a loss of airplane control.NTSB CEN13LA368Accident · 2 fatalLimited investigationFinal reportNanchang China CJ-6 · Wolcott, COThe pilots decision to perform an aerobatic maneuver at a low altitude from which he was unable to recover.NTSB CEN13LA356Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Golden, 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 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 CEN13IA350Incident · Minor injuriesIncident investigationFinal reportUltramagic M-105 · Louisville, 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 CEN13IA349Incident · Minor injuriesIncident investigationFinal reportUltramagic T210 · Boulder, 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 CEN13FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Castle Rock, COThe pilot's loss of airplane control while maneuvering between two convective storms that likely produced low-level windshear. Contributing to the accident was the pilot's relatively low overall flight experience and low night flight experience, which…NTSB CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.NTSB CEN13FA066Accident · 1 fatalField investigationFinal reportBrian P North RAF SE5A Replica · Watkins, COThe pilot’s loss of airplane control and inadvertent stall while attempting to return for landing.NTSB CEN12FA571Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Milner, COThe student pilot's impairment from alcohol, marijuana, and hypoxia, which adversely affected his ability to maintain control of the airplane.NTSB CEN12CA511Accident · Serious injuriesData collectionFinal reportAerostar International S81A · Colorado Springs, COThe pilot's encounter with an unexpected shift of wind direction and velocity, which resulted in a hard landing and passenger injury.NTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.NTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.NTSB CEN12CA442Accident · Minor injuriesData collectionFinal reportDoppelt Fredric F F. 8L Falco · Durango, COThe pilot's failure to maintain control of the airplane and the instructor's delayed remedial action.NTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.NTSB CEN11FA572Accident · Serious injuriesField investigationFinal reportFerguson Fergy 1 · Falcon, COA loss of control for undetermined reasons.NTSB CEN11CA550Accident · Serious injuriesData collectionFinal reportAttaway Robert H RV6A · Colorado Springs, COThe pilot's failure to maintain control while landing.NTSB CEN11CA519Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · Colorado Springs, COThe pilot's failure to maintain proper approach speed and his inadequate recovery from a bounced landing.