NTSB investigations, 2013, CO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 117 |
| 1965 | 112 |
| 1966 | 149 |
| 1967 | 145 |
| 1968 | 130 |
| 1969 | 123 |
| 1970 | 100 |
| 1971 | 118 |
| 1972 | 91 |
| 1973 | 107 |
| 1974 | 130 |
| 1975 | 104 |
| 1976 | 100 |
| 1977 | 121 |
| 1978 | 118 |
| 1979 | 120 |
| 1980 | 98 |
| 1981 | 94 |
| 1982 | 105 |
| 1983 | 106 |
| 1984 | 94 |
| 1985 | 88 |
| 1986 | 71 |
| 1987 | 95 |
| 1988 | 86 |
| 1989 | 80 |
| 1990 | 78 |
| 1991 | 89 |
| 1992 | 90 |
| 1993 | 71 |
| 1994 | 63 |
| 1995 | 74 |
| 1996 | 85 |
| 1997 | 69 |
| 1998 | 66 |
| 1999 | 86 |
| 2000 | 74 |
| 2001 | 70 |
| 2002 | 73 |
| 2003 | 65 |
| 2004 | 73 |
| 2005 | 75 |
| 2006 | 54 |
| 2007 | 63 |
| 2008 | 60 |
| 2009 | 51 |
| 2010 | 47 |
| 2011 | 54 |
| 2012 | 57 |
| 2013 | 48 |
| 2014 | 49 |
| 2015 | 39 |
| 2016 | 31 |
| 2017 | 34 |
| 2018 | 33 |
| 2019 | 35 |
| 2020 | 44 |
| 2021 | 47 |
| 2022 | 34 |
| 2023 | 38 |
| 2024 | 31 |
| 2025 | 43 |
| 2026 | 43 |
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 year(c.\"eventDate\") = 2013
AND c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2013 AND c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' 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 CEN14FA084Accident · 3 fatalField investigationFinal reportPiper PA 24-250 · Collbran, COThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB CEN14FA071Accident · 1 fatalField investigationFinal reportCessna 182E · Delta, COThe student pilot’s decision to attempt flight into instrument meteorological conditions, which resulted in a loss of control and ground impact.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 CEN14LA054Accident · No injuriesLimited investigationFinal reportQuicksilver Mxii Sport · Erie, COA loss of engine power due to a crankshaft failure, which resulted in a forced landing.NTSB CEN14CA049Accident · No injuriesData collectionFinal reportMooney M20R · Fort Collins, COThe pilot did not maintain control of the airplane during the go around.NTSB CEN14CA037Accident · No injuriesData collectionFinal reportRaytheon A36 · Hayden, COThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control and runway excursion.NTSB CEN14CA055Accident · Minor injuriesData collectionFinal reportCessna 172N · Loveland, COA dragging right brake, which resulted in an un-commanded right turn, and subsequent ground loop.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 CEN14LA011Accident · No injuriesLimited investigationFinal reportDavenport Long EZ · Boulder, COThe sudden loss of tire pressure during takeoff roll, which resulted in a loss of directional control.NTSB CEN14CA018Accident · No injuriesData collectionFinal reportBeech A36 · Telluride, COThe pilot's decision to take off in gusting tailwinds resulting in exceeding the performance capabilities of the airplane and subsequent loss of control.NTSB CEN13CA564Accident · Serious injuriesData collectionFinal reportTreidel Mark/R F D Dominator · Watkins, COThe pilot's loss of control of the gyroplane during takeoff roll, following his inadvertent release of the cyclic control.NTSB CEN13LA562Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Mack, COA total loss of engine power due to the failure of the engine crankshaft, which resulted from maintenance personnel’s application of insufficient torque on the engine case through bolts.NTSB CEN13CA532Accident · No injuriesData collectionFinal reportCessna 150G · Denver, COThe pilot's failure to maintain directional control during landing which resulted in an impact with the runway surface. A contributing factor was the certified flight instructor delayed response to the pilot's improper landing.NTSB CEN13LA539Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Colorado Springs, COThe pilot’s failure to establish the proper pitch attitude and airspeed during takeoff with the engine at maximum power, which resulted in the exceedance of the airplane’s climb performance capability.NTSB DCA13FA148Accident · No injuriesField investigationFinal reportBeech 1900D · Telluride, COFailure of the left main landing gear actuator internal lock to engage in the locked position for undetermined reasons.NTSB CEN13LA525Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Boulder, COThe pilot's failure to adequately clear carburetor icing, resulting in a loss of engine power on final approach following a descent at idle power.NTSB CEN13LA488Accident · No injuriesLimited investigationFinal reportGriffith E/Boyd W E Lancair 360 · Nucla, COThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN13LA443Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monte Vista, COThe partial loss of engine power due to a fatigue failure of the engine cylinder exhaust rocker housing as a result of an excessively torqued rocker assembly.NTSB CEN13CA435Accident · No injuriesData collectionFinal reportCessna 182S · Steamboat Springs, COThe pilot's delay in reacting to the adverse wind conditions.NTSB CEN13CA419Accident · Minor injuriesData collectionFinal reportCessna 162 · Broomfield, COThe pilot’s improper recovery from a bounced landing, which resulted in a loss of control.NTSB CEN13FA415Accident · 1 fatalField investigationFinal reportBell UH-1H · Dove Creek, COPilot-induced oscillations caused by the loss of hydraulic assist of the flight controls due to an excessive loss of hydraulic fluid during a critical phase of flight, which resulted in ground impact. Contributing to the accident was an inadequate analysis of…NTSB CEN13LA388Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Hudson, COThe pilot's improper fuel management, which resulted in the loss of engine power due to fuel starvation.NTSB CEN13LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Eagle, COThe pilots’ improper fuel management, which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was worn and corroded fuel senders, which transmitted inaccurate fuel readings to the fuel monitoring system.NTSB CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.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 CEN13LA358Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Durango, COThe pilot's improper decision to take off with a tailwind at a high-density altitude, which resulted in the airplane’s failure to maintain the initial climb rate.NTSB CEN13CA410Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Elbert, COThe pilot's failure to maintain aircraft control while landing in gusting crosswind conditions. Contributing to the accident was the pilot's delayed return to the airport.NTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.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 CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.NTSB CEN13LA291Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Englewood, COThe in-flight separation of the engine throttle lever and throttle cable due to maintenance personnel not applying sufficient torque to the self-locking nut or improperly reusing a degraded self-locking nut.NTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.NTSB CEN13LA310Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · La Junta, COThe pilot's inadequate compensation for wind during low-altitude operations, which resulted in a loss of tail rotor effectiveness.NTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.NTSB CEN13LA258Accident · No injuriesLimited investigationFinal reportCessna 182T · Delta, COThe loss of propeller control for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation and the airplane’s subsequent collision with power lines during the forced landing.NTSB CEN13CA236Accident · No injuriesData collectionFinal reportCessna T182T · Colorado Springs, COThe pilot’s improper recovery from a bounced landing.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 CEN13CA200Accident · No injuriesData collectionFinal reportCessna 172 · Kremmling, COThe student pilot’s failure to maintain directional control while landing.NTSB CEN13LA199Accident · No injuriesLimited investigationFinal reportRyan Navion · Broomfield, COThe pilot's inadequate preflight planning and decision to take off at a high density altitude and in gusting wind conditions.NTSB CEN13FA182Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Broomfield, COLoss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the fuel gauge to indicate the actual amount of fuel on board the airplane and the design of the airplane's fuel system, which precluded a visual confirmation of the…NTSB CEN13LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Akron, COThe pilot’s physical impairment due to alcohol intoxication, which resulted in an aerodynamic stall during landing.NTSB DCA13CA043Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD11 · Denver, COthe flight crews failure to perform a takeoff performance data briefing following the final entries into the Flight Management System, which would have alerted them to the incorrect weight entry and resulting incorrect landing speeds. Contributing to the…NTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.