NTSB investigations, 2012, 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\") = 2012
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") = 2012 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 CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.NTSB CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.NTSB CEN13FA066Accident · 1 fatalField investigationFinal reportBrian P North RAF SE5A Replica · Watkins, COThe pilot’s loss of airplane control and inadvertent stall while attempting to return for landing.NTSB CEN13CA026Accident · Minor injuriesData collectionFinal reportMace Justin I Dragonfly · Durango, COThe pilot’s delayed decision to perform a go-around, which resulted in the airplane impacting trees. Contributing to the accident was the pilot’s inexperience in the accident airplane and his encounter with conditions that exceeded his capabilities.NTSB CEN13CA005Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to maintain airspeed during the landing with known structural icing, which resulted in the airplane’s stall. Contributing to the accident was the pilot’s failure to divert to an area where conditions were not conducive to icing.NTSB CEN12LA675Accident · No injuriesLimited investigationFinal reportBeech E33 · Greeley, COThe loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB CEN12IA662Incident · No injuriesIncident investigationFinal reportCanadair CL-600 Challenger · Denver, COThe internal failure of the galley heater mat’s thermostat, which resulted in an overheat condition.NTSB CEN12LA668Accident · No injuriesLimited investigationFinal reportThompson RV-6 · Pagosa Springs, COThe pilot’s failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of landing experience at high density altitudes.NTSB CEN12FA653Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Kiowa, COA catastrophic engine failure due to unrecognized and unrepaired corrosion within the engine, which was consistent with engine operations after an extended period of inactivity.NTSB CEN12FA638Accident · 1 fatalField investigationFinal reportMchenry George B JR KR2S · Pueblo, COThe pilot’s loss of airplane control while maneuvering to land, which resulted in a stall and uncontrolled descent.NTSB CEN12FA639Accident · 2 fatalField investigationFinal reportMooney M20J · Teddys Peak, COThe pilot's decision to continue flight into deteriorating weather conditions, including fog and mountain obscuration, and his failure to maintain clearance with known rising terrain along the route of flight, which resulted in controlled flight into terrain.NTSB CEN12CA641Accident · No injuriesData collectionFinal reportPiper PA-11 · Ft. Morgan, COThe pilot's loss of control during landing after encountering an unexpected wind gust.NTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.NTSB CEN12LA655Accident · No injuriesLimited investigationFinal reportTL Ultralight Sro Stingsport · Longmont, COThe failure of the wood propeller blades in flight. Contributing to the accident was the owner/operator’s failure to complete required inspections on the propeller within the specified interval, which reduced the likelihood of detecting the cracks and may…NTSB CEN12FA594Accident · 2 fatalField investigationFinal reportPiper PA-12 · Rye, COThe pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.NTSB CEN12FA572Accident · Serious injuriesField investigationFinal reportEberle John S Fokker DR-1 Triplane · Parker, COThe pilot's loss of control of the airplane due to the airplane’s reduced climb performance during high density altitude operations.NTSB CEN12CA576Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Watkins, COThe pilot did not maintain control of the airplane while landing in gusty wind conditions.NTSB CEN12FA571Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Milner, COThe student pilot's impairment from alcohol, marijuana, and hypoxia, which adversely affected his ability to maintain control of the airplane.NTSB CEN12CA564Accident · Minor injuriesData collectionFinal reportCessna T210N · Boulder, COThe pilot’s decision to continue the unstable approach, which resulted in a loss of control during landing and a runway excursion.NTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.NTSB CEN12LA543Accident · Serious injuriesLimited investigationFinal reportCross David L Glasair III · Westcliffe, COThe loss of oil pressure due to the failure of an oil filter gasket, which resulted in a total loss of engine power.NTSB CEN12CA511Accident · Serious injuriesData collectionFinal reportAerostar International S81A · Colorado Springs, COThe pilot's encounter with an unexpected shift of wind direction and velocity, which resulted in a hard landing and passenger injury.NTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.NTSB CEN12LA513Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor G-164A · La Salle, COThe loss of engine power due to the detached distributor rotor.NTSB CEN12IA502Incident · No injuriesIncident investigationFinal reportBoeing 737-924ER · Denver, COAn in-flight collision with a bird during descent to land, which resulted in damage to the left pitot tube and loss of airspeed information to the left and right primary flight displays (PFD). The reason for the total loss of indications on the left PFD could…NTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.NTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.NTSB CEN12LA420Accident · No injuriesLimited investigationFinal reportCessna T210M · Colorado Springs, COThe failure of the right hydraulic main gear down-lock actuator hose in flight.NTSB CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.NTSB CEN12CA442Accident · Minor injuriesData collectionFinal reportDoppelt Fredric F F. 8L Falco · Durango, COThe pilot's failure to maintain control of the airplane and the instructor's delayed remedial action.NTSB CEN12LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glenwood Springs, COThe pilot's decision to fly into a mountainous area where conditions were such that the airplane was unable to climb above rising terrain. Contributing to the accident was the pilot's insufficient pilot-in-command experience and inadequate training in…NTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.NTSB CEN12LA374Accident · No injuriesLimited investigationFinal reportYakovlev Yak-52 · Loveland, COThe pilot’s inadvertent closure of the pneumatic system valve, which resulted in the nose landing gear not fully extending before landing. Contributing to the accident was the pilot's reliance on the mechanical landing gear position indicators instead of the…NTSB CEN12CA370Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.NTSB CEN12LA350Accident · No injuriesLimited investigationFinal reportGriffiths James Sydney Kokopelli SuperPacer · Kremmling, COThe low spring tension of the rudder and tailwheel cable, which resulted in the loss of control as the airplane decelerated after landing.NTSB CEN12LA345Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe first officer’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the final approach in known low-level windshear conditions, which resulted in an aerodynamic stall. Contributing to the accident…NTSB CEN12LA343Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Denver, COThe inadequately overhauled landing gear dampers that allowed initiation of a ground resonance event from which the pilot was unable to recover. Contributing to the accident was the overhaul facility's failure to identify the overcharged dampers and a lack of…NTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.NTSB CEN12LA298Accident · Minor injuriesLimited investigationFinal reportPool Murphy Moose · Steamboat Springs, COA locked left brake for reasons that could not be determined because independent observations of the postaccident condition of the airplane could not be performed, and the pilot’s subsequent loss of control.NTSB CEN12CA263Accident · No injuriesData collectionFinal reportCampbell David Legacy · Durango, COThe pilot’s improper flare and subsequent aerodynamic stall, which resulted in a hard landing.NTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.NTSB DCA12CA062Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319-132 · Buena Vista, COan inadvertent encounter with mountain wave turbulence.NTSB CEN12LA234Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Telluride, COThe pilot's decision to land with a direct tailwind, which resulted in a loss of directional control, and his subsequent decision to attempt a go-around so late in the landing roll, which resulted in a stall.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB CEN12CA200Accident · Minor injuriesData collectionFinal reportCessna 172P · Colorado Springs, COThe pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.NTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.NTSB CEN12CA264Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Cheyenne Wells, COThe pilot’s inadequate compensation for the wind conditions during takeoff.NTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.NTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.