NTSB investigations, 1989, CO
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 45 |
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\") = 1989
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") = 1989 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 DEN90LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The snowbank was a related factor.NTSB DEN90LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Firestone, COPremature liftoff by the pilot which resulted in insufficient airspeed.NTSB DEN90FA033Accident · 2 fatalField investigationFinal reportBeech B35-A33 · Castle Rock, COThe pilot's loss of control as a result of spatial disorientation. Factors related to the accident were: the adverse weather conditions.NTSB DEN90LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spgs, COThe pilot in command attempted a takeoff with the fuel mixture full rich, with a high density altitude, resulting in a partial loss of engine power during initial climb.NTSB DEN90LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Steamboat Spgs, COContinued VFR flight by the pilot into instrument meteorological conditions (IMC) and his delay in diverting or reversing course. The terrain, weather conditions, wing ice, and trees were considered to be contributing factors.NTSB DEN90DTE02Accident · 2 fatalFinal reportBruce Mckinney VARI-EZE · Aspen, COThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A related factor to the accident was: the mountainous terrain.NTSB DEN90DTE01Accident · 1 fatalFinal reportLanier Thorp T-18 · Colorado City, COLoss of engine power with carbon fouling of the spark plugs, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB DEN90LA024Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Dove Creek, COImproper flare by the student pilot, his failure to maintain runway alignment, and a delay by the flight instructor (CFI) in initiating remedial action, which resulted in a loss of airspeed and a stall/mush after the aircraft drifted over a cultivated field…NTSB DEN90LA020Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Broomfield, COLoss of engine power for an unknown reason.NTSB DEN90LA019Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Fort Collins, COInadequate compensation for wind conditons by the pilot which resulted in his failure to maintain directional control. Factors related to the accident were: the unfavorable wind condition and soft terrain.NTSB DEN90LA009Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Del Norte, COThe failure of the pilot to maintain airspeed during climb resulting in an inadvertent stall.NTSB DEN90IA012Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Monte Vista, COThe poor inflight planning and decisions made by the flight crew following the failure of the number two generator constant speed drive unit. Contributing factors to the accident were the failure of the no. 2 generator constant speed drive unit and the crew's…NTSB DEN90LA011Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Sterling, COThe pilot failed to correct a ground loop/swerve during landing roll. A strong crosswind was a contributing factor.NTSB DEN89LA226Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-1 · Hudson, COPartial loss of engine power for an unknown reason. A factor related to the accident was: the alfalfa crop.NTSB DEN89LA220Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COThe pilot failed to extend the landing gear. The pilot's anxiety and/or apprehension about a suspected loss of electrical power, and his attention being diverted by other traffic were contributing factors.NTSB DEN89LA210Accident · 1 fatalLimited investigationFinal reportLet L-13 · Buena Vista, COA premature release of the glider tow line by the glider pilot and his failure to maintain sufficient airspeed, while maneuvering back toward the runway, which resulted in an inadvertent stall.NTSB DEN89FA217Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Louisville, COFailure of the pilot to maintain adequate airspeed, while maneuvering for spacing in the traffic pattern, which resulted in an inadvertent stall at low altitude.NTSB DEN89LA225Accident · No injuriesLimited investigationFinal reportCessna 170 · Cortez, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop.NTSB DEN89LA212Accident · No injuriesLimited investigationFinal reportCessna 172N · Burlington, COImproper use of the rudder by the pilot, which resulted in a loss of directional control. The soft terrain was a related factor.NTSB DEN89LA207Accident · No injuriesLimited investigationFinal reportCessna C-150 · Platteville, COPilot's failure to compensate for the wind conditions and his failure to maintain directional control during the landing roll. Contributing to the accident was the gusting crosswind.NTSB DEN89LA206Accident · No injuriesLimited investigationFinal reportCessna T210M · Rangely, COForced landing in unsuitable terrain as a result of an engine crankshaft failure.NTSB DEN89DTE04Accident · 1 fatalFinal reportCessna A188B · Wiggins, COThe pilot failed to maintain an adequate visual lookout and collided with a standpipe which severed four feet of the right wing, resulting in loss of control inflight and subsequent collision with the terrain.NTSB DEN89LA215Accident · No injuriesLimited investigationFinal reportCessna 180K · Englewood, COFailure of the pilot to maintain directional control, which resulted in a ground swerve. The crosswind was a related factor.NTSB DEN89LA201Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Watkins, COFailure of the left brake assembly, and subsequent loss of directional control by the pilot.NTSB DEN89LA199Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Englewood, COA failure in the hyrdraulic power unit, which prevented operation of either the normal or emergency gear extension systems. The raised runway lip contributed to aircraft damage and pilot injury.NTSB DEN89LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Dove Creek, COImproper planning/decision by the pilot. Factors related to the accident were: high density altitude, uphill sloping runway, failure of the pilot to follow the checklist and use all of the available runway, and the rising terrain and obstruction (power line)…NTSB DCA89IA066Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Denver, COFatigue failure and separation of a first-stage compressor fan blade.NTSB DEN89LA189Accident · Serious injuriesLimited investigationFinal reportBell 206B · Georgetown, COImproper inflight planning/decision by the pilot. The high density altitude, tail wind, gusts, and terrain were related factors.NTSB DEN89LA188Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper planning/decision by the pilot. The wind condition was considered to be a contributing factor.NTSB DEN89LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Louisville, COThe pilot's failure to adequately evaluate the weather prior to takeoff. High winds developed during the Balloon flight which resulted in a rough landing.NTSB DEN89LA191Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COThe student pilot failed to maintain directional control during landing roll due to improper use of the flight controls.NTSB DEN89LA183Accident · No injuriesLimited investigationFinal reportCessna 177RG · Brighton, COFailure of the landing gear down lock, which allowed the landing gear to collapse during the landing.NTSB DEN89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent damage to the wing.NTSB DEN89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Weston, COWater in the fuel and inadequate preflight by the pilot. A contributing factor was the ditch.NTSB DEN89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crested Butte, COFailure of the pilot to maintain sufficient altitude while flying over mountainous terrain. The terrain and weather conditions were related factors.NTSB DEN89LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Haswell, COInadequate visual lookout by the pilot (failed to see & avoid) which resulted in his failure to maintain clearance from the obstruction. Contributing factors were: the unmarked guy wire & the pilot's lack of visual cues (visual perception).NTSB DEN89FA162Accident · 2 fatalField investigationFinal reportCessna 150K · Louisville, COInadequate supervision by the instructor pilot (CFI) and flight in known adverse weather conditions. Factors related to the accident were: inadequate preflight planning/preparation by the CFI, his lack of experience in the type of operation, and the weather…NTSB DEN89LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenwood Spgs, COInadequate compensation for wind conditions by the dual student, resulting in a loss of control and a forced landing. The pilot-in-command, CFI, failed to adequately supervise the operation.NTSB DEN89LA150Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Telluride, COInadequate compensation for wind conditions by the pilot and his failure to maintain runway alignment. Contributing factors were wind conditions, high density altitude, and trees.NTSB DEN89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Telluride, COThe pilot's failure to maintain aircraft control during an encounter with turbulence. Contributing to the accident was the turbulence.NTSB DEN89FA154Accident · 2 fatalField investigationFinal reportCessna 310Q · Crestone, COImproper in-flight planning/decision by the pilot and his failure to attain sufficient altitude to safely clear the mountains. Contributing factors were: mountainous terrain, box canyon, and high density altitude.NTSB DEN89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Durango, COThe pilot failed to maintain directional control, which resulted in an inadvertent groundloop/swerve. A factor related to the accident was: the adverse wind condition.NTSB DEN89LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COInadequate compensation for wind conditions by the (private rated) dual student and his failure to maintain directional control, which resulted in an inadvertent ground swerve, and inadequate supervision by the instructor pilot (CFI). A factor related to the…NTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.NTSB DEN89LA140Accident · No injuriesLimited investigationFinal reportSchweizer 1-26E · Elbert, COThe pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.NTSB DEN89LA134Accident · Serious injuriesLimited investigationFinal reportRyan ST-3KR · La Salle, COForeign material (insect nest) blocking the fuel system vent, which resulted in a restriction of fuel flow and fuel starvation. A related factor was the alfalfa crop in the emergency landing area.NTSB DEN89FA131Accident · 1 fatalField investigationFinal reportBoeing PT-17 · Meeker, COThe inadvertent stall-spin at an altitude insufficient to effect a safe recovery. Contributing factors include high density altitude and wind shear.NTSB DEN89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rangely, COImproper planning/decision by the pilot. The high wind, gusts, the pilot's lack of recent experience, and his lack of familiarity with the aircraft's new handling characteristics were considered to be contributing factors.NTSB DEN89FA123Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Denver, COA right main landing gear vibration of unknown origin, which resulted in a failure of the right main landing gear torque link and side brace.NTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.