NTSB investigations, CO
161 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 5 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 9 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 3 |
| 1995 | 7 |
| 1996 | 6 |
| 1997 | 3 |
| 1998 | 9 |
| 1999 | 5 |
| 2000 | 11 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 8 |
| 2004 | 11 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 6 |
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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.NTSB DEN07CA086Accident · No injuriesData collectionFinal reportCessna 170A · Watkins, COA total failure during landing roll of the right brake caused by severely worn shoes, causing the caliper pins to engaged misaligned. A contributing factor was the pilot's inability to maintain directional control.NTSB DEN07IA066Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries DA-20-C1 · Pueblo, COThe failure of the horizontal stabilizer forward bracket bolts due to insufficent preload during factory installation.NTSB DEN07IA055Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Cripple Creek, COA fatigue fracture, which resulted in the separation of the No.1 engine fan disk. Contributing factors in the accident were the operators' maintenance personnel lack of training to be able to detect arc-out damage on the fan disk, and the fan disk…NTSB DEN07IA048Incident · No injuriesIncident investigationFinal reportRaytheon B300 · Englewood, COThis case was modified 10/30/2007 Failure of the nose landing gear upper torque knee due to overstress, and the pilot's inability to maintain aircraft control.NTSB DEN07CA046Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Walden, COThe pilot experiencing lateral flight control stiffness for undetermined reasons and the pilot's intentional wheels up landing. Factors were the snow covered and rough/uneven terrain.NTSB DEN07CA039Accident · No injuriesData collectionFinal reportCessna T210M · Broomfield, COthe failure of the mechanic to comply with the required replacement schedule resulting in the failure of the hydraulic line and the resulting gear up landing.NTSB DEN07FA008Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COA fractured nose gear assembly spray deflector that blocked the nose gear from extending during landing, and resulted in an intentional nose gear up landing.NTSB DEN06IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COa brake fire for reasons undetermined. A contributing factor was the inadequate inspection by the maintenance crew.NTSB DEN06IA056Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Denver, COthe failure of the elevator down cable due to an improperly routed cable by unknown maintenance personnel. A contributing factor was the improper inspection of the elevator cable by the operator's maintenance personnel.NTSB DEN06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Parker, COthe improper maintenance procedures resulting in the unseating of the number two main bearing. Contributing factors include the mechanic's improper troubleshooting procedures, and the pilot's improper decision to continue operating the airplane with known…NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.NTSB DEN06LA015Accident · No injuriesLimited investigationFinal reportCessna 182 · Broomfield, COthe nose wheel assembly separation for reasons undetermined.NTSB DEN05LA150Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COthe failure of the left rudder cable resulting in a loss of directional control by the pilot. Contributing to the accident was the improper repair procedures on the seat frame.NTSB DEN05LA077Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe failure of the nose gear actuator resulted in penetration of the forward pressure bulkhead and a loss of pressurization.NTSB DEN05TA072Accident · No injuriesFinal reportBell OH-58C · Colorado Sprngs, COthe failure of the N1 tachometer generator which resulted in a precautionary landing. Contributing factors include the frayed wire and the unsuitable terrain for a precautionary landing.NTSB DEN05LA043Accident · No injuriesLimited investigationFinal reportMooney M20E · Telluride, COthe pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.NTSB DEN05LA030Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Eagle, COnose wheel steering system failure due to foreign material substance contamination.NTSB DEN04LA138Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Colorado Spring, COright main tire failure for reasons undetermined.NTSB DEN04LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sterling, COthe failure of the landing gear extension system for undetermined reasons.NTSB DEN04CA122Accident · No injuriesData collectionFinal reportEurocopter France EC-130 B4 · Englewood, COthe pilot's failure to perform a preflight inspection. Contributing to the accident was the transmission cowling that disconnected during the landing.NTSB DEN04LA082Accident · No injuriesLimited investigationFinal reportLockheed TV-2 · Calhan, COthe failure of the fuel tank float which resulted in the draining of fuel out the vents, and a low fuel supply. Contributing factors include the insufficient runway length, the ditch, and the rough, uneven terrain.NTSB DEN04LA075Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Rifle, COthe pilot's failure to verify the manual extension of the landing gear resulting in an inadvertent wheels up landing. Contributing factors include the electrical systems failure for undetermined reasons, the pilot's diverted attention and the pilot's improper…NTSB DEN04IA063Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Colorado Spring, COThe failed air conditioning fan by-pass check valve and the subsequent overtemperature of the air conditioning pack.NTSB DEN04IA060Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2C10 · Denver, COThe total failure of the airplane's number 1 system hydraulic pump.NTSB DEN04IA059Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COarcing of the windshield deicing system. Factors contributing to the incident were the improper inspection of the windshield's exterior seal, deterioration of the windshield seal, and water penetration through the deteriorated seal.NTSB DEN04FA041Accident · No injuriesField investigationFinal reportDassault DA-20 Falcon Jet · Pueblo, COthe pilot's improper in-flight planning/decision to land on the contaminated runway, the stuck thrust reverser solenoid resulting in partial deployment of the right engine thrust reverser, and the pilot's inability to maintain directional control of the…NTSB DEN04IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-3M8 · Denver, COThe restricted movement of the flight control yoke and tiller wheel steering for reasons undetermined.NTSB DEN04IA014Incident · No injuriesIncident investigationFinal reportLearjet 45 · Denver, COthe failure of the airplane's spoiler system when used as speed brakes due to high resistances in the spoilers' actuator coils.NTSB DEN04IA012Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COthe manufacturer's improper installation of the inboard slat drive mechanism's lower left hand anti-torque strut, which resulted in the axial migration of the rod-end bearing, the binding of the anti-torque strut, and the subsequent activation of the slat…NTSB DEN03LA144Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COSeparation of the landing gear tire valve stem resulting in the left main tire deflating, and the pilot's inability to maintain aircraft control.NTSB DEN03LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COthe right seat shifting aft during the take off roll, rendering aircraft control not possible by the flight instructor. Contributing factors include the inboard seat pin which did not engage fully, the outboard seat pin which was installed incorrectly, the…NTSB DEN03FA113Accident · 1 fatalField investigationFinal reportMattison Starduster Too · Ellicott, COthe pilot's improper in-flight planning/decision to perform aerobatics at low altitude and the failed welds at the elevator horn and torque tube. Factors contributing to the accident were the pilot performing aerobatics at low altitude, his inability to…NTSB DEN03LA076Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe failure of the landing gear system and the flight crew's failure to ascertain that the landing gear was down and locked. A contributing factor was the inadequate maintenance inspections performed by maintenance personnel.NTSB DEN03IA032Incident · No injuriesIncident investigationFinal reportHawker Siddeley HS-125-700A · Telluride, COthe overheated and burned venturi fan motor.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 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 DEN02LA107Accident · No injuriesLimited investigationFinal reportCessna 195 · Longmont, COseparation of the tail wheel cables, resulting in a loss of directional control.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 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 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 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 DEN02LA020Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Grand Junction, COthe failure of the tail wheel left steering cable. A contributing factor was the pilot's loss of aircraft control (not possible) and the subsequent inadvertent ground loop.NTSB DEN01FA157Accident · 1 fatalField investigationFinal reportBoeing 777-236 · Denver, COthe overstress fracture of the airplane's refueling adapter ring that resulted from the abnormal angular force applied to it. The applied angular force occurred due to the ground refueler inadequately positioning the hydrant fuel truck (in relation to the…NTSB DEN01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COthe failure of the nose landing gear right drag brace (link assembly) due to fatigue.NTSB DEN01LA119Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COfailure of the nose landing gear hydraulic UP hose, which resulted in a wheels-up landing..NTSB DEN01IA108Incident · No injuriesIncident investigationFinal reportBeech 200 · Greeley, COjamming of the nose landing gear actuator due to improper painting procedures by other maintenance personnel which resulted in a wheels up landing.NTSB DEN01LA089Accident · No injuriesLimited investigationFinal reportCessna 140A · Greeley, COtotal failure of the right main landing gear spring due to fatigue.NTSB DEN01LA062Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Durango, COthe pilot's failure to maintain directional control. A contributing factor was the blown tire.