NTSB investigations, 1990, CO
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1990
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") = 1990 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 DEN91LA029Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Aspen, COFuel exhaustion induced power loss resultant from faulty fuel caps and fuel syphoning.NTSB DEN91IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Denver, COFailure of an engine bearing.NTSB DEN91IA026Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Denver, COThe catastrophic failure of the no.12 blade on the 4th stage turbine wheel, and failure of company maintenance personnel to identify the preexisting crack during maintenance inspection.NTSB DEN91LA021Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Erie, COImproper flare by the pilot, which resulted in a hard landing. A realted factor was: low light condition at dusk.NTSB DEN91IA019Incident · No injuriesIncident investigationFinal reportBeech J-35 · Brighton, COThe failure of the engine fuel feed line resulting in a complete loss of power. Contributing to the incident was improper installation of the fuel feed transducer.NTSB DEN91FA017Accident · 4 fatalField investigationFinal reportCessna T210L · Aspen, COImproper planning/decision by the pilot and his failure to maintain adequate airspeed, while turning over high terrain beside the airport, which resulted in an inadvertent stall. Factors related to the accident were: excessive gross weight of the aircraft,…NTSB DEN91LA016Accident · No injuriesLimited investigationFinal reportFogarty Pitts S1SEW · Bennett, COThe pilot's failure to refuel the airplane and the resultant fuel exhaustion induced power loss. A factor was the soft terrain in which the forced landing was performed.NTSB DEN91LA014Accident · Minor injuriesLimited investigationFinal reportCessna T-210-M · Buena Vista, COThe pilot misjudged the fuel supply resulting in fuel exhaustion.NTSB DEN91FA012Accident · 2 fatalField investigationFinal reportCessna T210M · Carbondale, COFailure of the pilot to see-and-avoid the power line.NTSB DEN91LA011Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, COThe failure of the pilot to flare properly during landing. The pilot's total lack of experience is a factor.NTSB DEN91LA009Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Watkins, COThe pilot's inadvertent retraction of the landing gear. A factor was the pilot's lack of familiarity with the airplane.NTSB DEN91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Englewood, COThe failure of the pilot to maintain directional control.NTSB DEN91LA006Accident · No injuriesLimited investigationFinal reportCessna T210M · Englewood, COEngine failiure resulting from maintenance discrepancies.NTSB DEN91FA005Accident · Serious injuriesField investigationFinal reportBeech P35 · Aurora, COInadvertent stall. Factors were his decision to disregard in-flight weather advisories, continued flight into known adverse weather, and icing conditions and the flight into the known adverse weather.NTSB DEN91DTM01Accident · Serious injuriesFinal reportHistorical A-001 · Durango, COEngine failure due to carburetor ice. A factor in the accident was the lack of carburetor heat equipment installed in the aircraft.NTSB DEN91LA004Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Englewood, COThe pilot's inadequate preflight inspection.NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.NTSB DEN90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Erie, COThe student pilot's misjudgement of distance and altitude, and the instructor's inadequate supervision.NTSB DEN90LA193Accident · Serious injuriesLimited investigationFinal reportCessna 310J · Colorado Spring, COThe loss of power on one engine due to excessive fuel pressure and the pilot's feathering of the wrong propeller. Factor(s) were: operation of aircraft with known deficiencies by pilot and operator.NTSB DEN90FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Marble, COFailure of the private pilot (student pilot) to maintain sufficient altitude and airspeed above mountainous terrain, and inadequate supervision by the instructor pilot (CFI) and her delay in taking remedial action. Factors related to the accident were: the…NTSB DEN90IA189Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Denver, COThe failure of the flight crew to follow emergency procedures/directives. Factors were the failure of the aircraft electrical system (relays) and the failure of the company to provide a jetway operator.NTSB DEN90LA186Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Englewood, COImproper planning/decision by the pilot and inadequate visual lookout by the vehicle driver, which resulted in their failure to assure clearance between the vehicle and aircraft. Factors related to the accident were: sunglare and the pilot's restricted view…NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB DEN90DTE08Accident · No injuriesFinal reportPiper PA-25-235 · Idalia, COThe encounter with an unfavorable wind, a dust devil. A factor was the inability of the pilot to maintain directional control.NTSB DEN90LA181Accident · No injuriesLimited investigationFinal reportCessna T210N · Durango, COThe loss of control of the airplane when the pilot encountered turbulence on short final to land.NTSB DEN90LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Canon City, COThe pilot's failure to maintain an adequate pattern altitude and the possible existence of adverse winds due to the surrounding terrain.NTSB DEN90DTE09Accident · No injuriesFinal reportTrammel Avid Flyer · Trinidad, COThe failure of the pilot to follow published procedures when he inadvertently shut off the magnetos while on final approach.NTSB DEN90LA190Accident · No injuriesLimited investigationFinal reportMooney M20B · Glenwood Spring, COWrong runway selection by the pilot, resulting in an overrun and a collision with a fence during landing roll. The prevailing tailwind, runway information and markings, and the pilot's failure to use the proper touchdown point are factors.NTSB DEN90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28R201T · Longmont, COLoss of engine power due to fuel starvation for undetermined reasons resulting in a forced landing while the landing gear was still in transit.NTSB DEN90DTE06Accident · Serious injuriesFinal reportCessna 188A · Holyoke, COA stall mush which occurred when the pilot retracted the flaps prematurely following takeoff, causing the aircraft to settle into the ground.NTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.NTSB DEN90DTE04Accident · 2 fatalFinal reportOlsen Pursuit · Fowler, COFailure of the pilot to maintain adequate airspeed on final approach to land, which resulted in an inadvertent stall. A factor relate to the accident was: the pilot's physical impairment from carbon monoxide.NTSB DEN90LA165Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Cheyenne Wells, COThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to compensate for the existing cross wind.NTSB FTW90FA141Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Garfield, COThe pilot's decision to fly into the mountain pass and the subsequent inability to maintain adequate ground clearance.NTSB DEN90LA160Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Akron, COThe pilot's failure to correct a swerve during landing roll. A factor was wind gusts.NTSB DEN90IA154Incident · No injuriesIncident investigationFinal reportAerospatiale A-300B4 · Denver, COEngine failure due to turbine wheel failure, induced by fatigue.NTSB DEN90LA148Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Broomfield, COThe failure of the pilot to extend the landing gear for landing. Contributing factors were the pilot diverting his attention from the task at hand and failure to use a checklist.NTSB DEN90LA147Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Center, COThe pilot's failure to maintain flying speed, which resulted in a stall and collsion with the ground.NTSB DEN90LA150Accident · No injuriesLimited investigationFinal reportCessna T 188C · Wray, COThe failure of the pilot to maintain proper alignment proper alignment during landing.NTSB DEN90LA145Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Monte Vista, COThe pilot's premature rotation and liftoff.NTSB DEN90LA142Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Durango, COA pilot induced stall. A factor was the pilot's lack of experience.NTSB DEN90LA144Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Golden, COThe pilot's disregard for airplane performance data. Contributing to the accident were high density altitude and the fact that airplane climb performance capability was exceeded.NTSB DEN90LA134Accident · No injuriesLimited investigationFinal reportCessna A185F · Erie, COFailure of the pilot receiving instruction to choose suitable terrain for the landing. Contributing to the accident was the cfi's inadequate supervision.NTSB DEN90LA126Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder, COThe pilot's failure to touch down at the proper point, his misjudgment of the distance required for takeoff following the touch and go, and his delayed decision to abort the takeoff.NTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.NTSB DEN90FA119Accident · 1 fatalField investigationFinal reportCessna 152 · Longmont, COThe pilot continued into hazardous weather conditions.NTSB DEN90LA114Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Erie, COCfi's failure to ensure that the student pilot maintained sufficient airspeed, resulting in the inadvertent stall/mush. A factor was the downdraft experienced at low altitude after takeoff.NTSB DEN90LA111Accident · Minor injuriesLimited investigationFinal reportErco 415G · Peyton, COPilot's failure to maintain obstacle clearance during a landing.NTSB DEN90FA109Accident · Serious injuriesField investigationFinal reportCessna 210L · Telluride, COThe pilot's ffailure to maintain flying speed which resulted in a stall. Factor was wind shear reported off departure end of rwy.NTSB DEN90LA107Accident · Minor injuriesLimited investigationFinal reportBeech B-55 · Watkins, COExecuting of a simulated single engine approach in wind conditions that exceeded the demonstrated crosswind capability of the airplane with both engines operating.