NTSB investigations, 2002, CO
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2002
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") = 2002 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 DEN03FA028Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Steamboat Spgs, COthe pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density…NTSB DEN03LA029Accident · No injuriesLimited investigationFinal reportBeech F33A · Durango, COthe pilot's failure to extend the landing gear. A contributing factor is the pilot's failure to follow the checklist.NTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…NTSB DEN03LA024Accident · No injuriesLimited investigationFinal reportMooney M20K · Eagle, COthe pilot's failure to remove protective coverings from the engine air scoops during the preflight inspection, resulting in air starvation and a loss of engine power shortly after takeoff. A contributing factor was the lack of suitable terrain for a forced…NTSB DEN03LA019Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-70 · Montrose, COthe unforecasted increase in wind velocity. A contributing factor was the fence that the basket struck, subsequently spilling the occupants onto the ground.NTSB DEN03LA022Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Creede, COthe pilot's inadequate compensation for wind. Contributing factors are the crosswind and the pilot's lack of experience.NTSB DEN03LA018Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Morrison, COthe pilot not maintaining clearance from the telephone lines during landing. Factors contributing to the accident were the pilot not being able to see the telephone lines, the low altitude, and the dark night.NTSB DEN03LA016Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Elbert, COoverload failure of the cable between the left rudder pedal and the tail wheel, rendering directional control impossible and resulting in an inadvertent ground loop and nose over. Contributing factors were the crosswind and the soft, wet ground.NTSB DEN03LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Grand Junction, COthe collapse of the left main landing gear during landing roll resulting in loss of control/ground loop/swerve and subsequent impact with a sign. Contributing factors include, the airplane's total loss of electrical power due to an alternator failure and the…NTSB DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…NTSB DEN03LA011Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Fort Collins, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airspeed resulting in a stall.NTSB DEN03LA008Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-C1 · Grand Junction, COThe pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.NTSB DEN03LA010Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Watkins, COthe pilot's failure to use the checklist, resulting in his forgetting to lower the nose landing gear. Contributing factors included the pilot's attention being diverted by the loss of oil pressure on the rear engine due to a broken oil pressure sensor line,…NTSB DEN03LA007Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COthe complete collapse of the landing gear, during landing roll, for undetermined reasons.NTSB DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.NTSB DEN03LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COthe pilot misjudging the clearance between the airplane and a fixed object during taxi. Contributing factors were the pilot's attention being diverted and sunglare.NTSB FTW02FA262Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chromo, COThe flight instructor's failure to maintain clearance with the mountainous terrain during the cross-country flight. A contributing factor was the dark night light conditions.NTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…NTSB DEN02LA103Accident · 1 fatalLimited investigationFinal reportAdler SA-1 · Mead, COthe pilot's failure to maintain main rotor rpm, resulting in blade flapping, subsequent blade contact with the airframe, and loss of control.NTSB DEN02LA107Accident · No injuriesLimited investigationFinal reportCessna 195 · Longmont, COseparation of the tail wheel cables, resulting in a loss of directional control.NTSB DEN02LA104Accident · No injuriesLimited investigationFinal reportBeech D95A · Broomfield, COthe dual student pilot's inadvertent retraction of the landing gear. Contributing factors included the dual student's lack of familiarity with the airplane, and inadequate supervision by the flight instructor.NTSB DEN02GA102Accident · 1 fatalFinal reportCessna A185F · Howard, COthe pilot's failure to maintain clearance of the terrain. Contributing factors were the clear air turbulent weather condition, and the high density altitude condition.NTSB DEN02LA101Accident · Serious injuriesLimited investigationFinal reportBell 206L-III · Canon City, COthe pilot's failure to maintain clearance of a static wire, and the subsequent loss of aircraft control due to the main rotor pitch change tubes being severed.NTSB DEN02TA100Accident · Serious injuriesFinal reportBell 206L-3 · Saguache, COthe pilot's inadequate in-flight planning and decision making, and the loss of tail rotor effectiveness. A contributing factor was the right quartering tailwind.NTSB DEN02LA099Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Erie, COfailure of the normal braking system, resulting in the airplane departing the end of the runway. A contributing factor was the airplane's slow acceleration during the takeoff roll.NTSB DEN02LA098Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Broomfield, COmaintenance personnel's failure to secure the landing skid oleo strut bolt during the last 50-hour inspection, causing the left rear skid to collapse and the tail rotor to strike the ground.NTSB DEN02LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COthe pilot's inadequate preflight preparation, which resulted in fuel exhaustion and a subsequent loss of engine power, and his failure to maintain adequate airspeed during the forced landing, which resulted in an inadvertent stall/mush. Factors included the…NTSB DEN02TA092Accident · Minor injuriesFinal reportAir Tractor AT-802A · Broomfield, COthe airplane's left main landing gear tire separated from its wheel during takeoff roll for an undetermined reason. Contributing factors were the pilot's inability to maintain aircraft control during takeoff roll and the subsequent impact with the Visual…NTSB DEN02LA091Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Watkins, COthe pilot's improper recovery from a bounced landing, resulting in an inadvertent ground loop. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN02LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Victor, COthe pilot's failure to refuel, resulting in fuel exhaustion and a subsequent loss of engine power. Contributing factors were the pilot's use of inappropriate medication, and the unsuitable terrain on which to make a forced landing.NTSB DEN02LA093Accident · No injuriesLimited investigationFinal reportCessna 310N · Grand Junction, COThe dual student's inadequate aircraft control resulting in a hard landing. Contributing factors include, the dual student's inadequate airspeed and high flare, the inadequate supervision by the instructor, the in-flight separation of the right main landing…NTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.NTSB FTW02FA222Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Gypsum, COThe pilot's failure to perform remedial action and maintain clearance with the rising mountainous terrain. Contributing factors were the pilot's poor planning/decision, the rising terrain, and the high density altitude.NTSB DEN02LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COthe student pilot's failure to maintain aircraft control and subsequent inadvertent stall/mush into terrain during a soft field take off. Contributing factors include the pilot's lack of experience and the high density altitude conditions.NTSB DEN02GA085Accident · 1 fatalFinal reportAerospatiale SA315B · Estes Park, COthe pilot's abrupt collective input during water application to a forest fire. Contributing factors were encountering a vortex ring state, the inadvertent settling with power, the low altitude, and the mountainous terrain.NTSB DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.NTSB DEN02LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Georgetown, COthe pilot's inadequate preflight planning for a flight through high mountainous terrain, and the pilot committing himself to a mountainous flight path where terrain clearance was not possible. Contributing factors were the high density altitude weather…NTSB DEN02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COA loss of engine power due to fuel exhaustion as a result of leaking fuel caps. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN02LA081Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Two Buttes, COthe failure of the right main landing wheel master brake cylinder and the subsequent inadvertent ground loop during the landing roll by the pilot.NTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.NTSB DEN02GA074Accident · 2 fatalFinal reportConsolidated-Vultee P4Y-2 · Estes Park, COthe inflight failure of the left wing due to fatigue cracking in the left wing's forward spar and wing skin. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.NTSB DEN02FA070Accident · No injuriesField investigationFinal reportBoone Rotorway 162-F · Englewood, COthe pilot encountering settling with power. A factor contributing to the accident was the tailwind.NTSB DEN02LA072Accident · No injuriesLimited investigationFinal reportMooney M20C · Watkins, COthe pilot's failure to use the pre-landing checklist, resulting in an inadvertent wheels up landing.NTSB DEN02LA063Accident · 1 fatalLimited investigationFinal reportRich RV-4 · Grand Junction, COthe pilot failing to maintain aircraft control during the pull up maneuver. A factor relating to the accident was the inadvertent stall spin.NTSB DEN02LA062Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falcon, COthe pilot's failure to maintain aircraft control during the takeoff roll and subsequent abort. Factors relating to the accident were the gusting crosswinds and the unsuitable terrain encountered when the airplane departed the runway.NTSB DEN02LA064Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Cortez, COan inadvertent stall as the pilot attempted to clear a cliff and ravine and avoid power lines, resulting in a collision with the ground. Contributing factors were a loss of engine power for undetermined reasons, a leaking carburetor and fuel pump, and the…NTSB DEN02LA068Accident · No injuriesLimited investigationFinal reportBeech K35 · Montrose, COThe pilot's failure to follow published aircraft operating procedures, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN02LA057Accident · No injuriesLimited investigationFinal reportBeech 58P · Broomfield, COthe pilot's failure to follow procedures for a balked landing which resulted in a stall/mush.NTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…NTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.