NTSB investigations, 2007, CO
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 | 44 |
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\") = 2007
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") = 2007 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 DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.NTSB DEN08IA044Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Aspen, COThe failure of the crankshaft due to fatigue. The fatigue crack initiation was not determined.NTSB DEN08CA046Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Pueblo, COthe pilot's failure to maintain aircraft control resulting in a hard landing.NTSB DEN08LA031Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot's failure to maintain directional control during landing. Contributing factors were the delayed remedial action and inadequate supervision by the flight instructor, and the ditch.NTSB DEN08CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cortez, COThe passenger's inadvertent application of brakes, causing the airplane to nose over on landing. A contributing factor was the pilot's failure top adequately brief the passenger.NTSB DEN08CA023Accident · Minor injuriesData collectionFinal reportCessna TP206A · Boulder, COThe pilot's misjudgment of altitude. Contributing factors in this accident were the pilot's intentional low airspeed, his failure to execute a go-around, and the soft terrain.NTSB DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.NTSB DEN08LA017Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Salida, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain.NTSB DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.NTSB DEN08LA014Accident · No injuriesLimited investigationFinal reportCessna 210 · Canon City, COThe failure of the engine throttle cable resulting in a lack of engine power when commanded.NTSB DEN08LA010Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Denver, COthe in-flight collision with geese shortly after takeoff.NTSB DEN08LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Trinidad, COThe pilot's failure to extend the landing gear.NTSB DEN08FA003Accident · 3 fatalField investigationFinal reportRaytheon C90A · Pagosa Springs, COThe pilot's failure to maintain clearance from mountainous terrain. Contributing to the accident was the pilot's inadequate preflight planning, improper in-flight planning and decision making, the dark night, and the controller's failure to issue a safety…NTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.NTSB DEN07CA163Accident · Serious injuriesData collectionFinal reportAerostar S81A · Hartsel, COthe pilot's inability to maintain the proper descent rate. A factor contributing to the accident was the unfavorable wind conditions.NTSB DEN07CA162Accident · Minor injuriesData collectionFinal reportCessna 182Q · Glenwood Spring, COThe pilot's failure to go around when it became apparent that he could not land and stop the airplane on the remaining runway. Factors contributing to the accident were the tailwind and the gusts.NTSB DEN07FA158Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik a.s. SportStar · Erie, COThe flight instructor's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/spin. Contributing to the accident was the flight instructor's inadequate preflight planning, his failure to calculate the airplane's weight and…NTSB DEN07LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Avondale, COThe pilot's failure to attain translational lift and his improper flare. A contributing factor in this accident was the sudden wind shift.NTSB DEN07FA157Accident · Serious injuriesField investigationFinal reportCessna 180 · Englewood, COThe pilot's failure to maintain control of the airplane during the force landing attempt resulting in a stall-spin and the subsequent impact with the ground. A factor contributing to the accident was the engine failure for undetermined reasons.NTSB DEN07IA144Incident · No injuriesIncident investigationFinal reportNunn KR2 · Pueblo, COThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions . A contributing factor in this accident was the crosswind.NTSB DEN07CA141Accident · Minor injuriesData collectionFinal reportEaa Biplane P · Parker, COThe loss of engine power for undetermined reasons. A contributing factor was the pilot's intentional maneuver into a piece of machinery.NTSB DEN07CA139Accident · No injuriesData collectionFinal reportCessna A185F · Lake City, COThe pilot's improper preflight planning, his inability to attain short field takeoff performance, and his intentional maneuvering of the airplane into bushes and a fence during the aborted takeoff. Factors contributing to the accident were the high density…NTSB DEN07LA138Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Alamosa, COThe failure of the number one cylinder due to fatigue. Contributing to the accident was the pilot's diminished visual lookout due to the oil covered windscreen.NTSB DEN07CA154Accident · No injuriesData collectionFinal reportCessna 172R · Fort Collins, COThe student pilot's improper flare and recovery from a bounced landing.NTSB DEN07LA132Accident · Minor injuriesLimited investigationFinal reportBell 206B · Broomfield, COThe pilot's failure to maintain control of the helicopter, resulting in an inadvertent dynamic rollover.NTSB DEN07CA131Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Erie, COThe student pilot's failure to maintain rotor rpm resulting in a loss of aircraft control during a simulated 180 degree auto-rotation. Contributing to the accident was the inadequate flight status supervision by the flight instructor and the student pilot's…NTSB DEN07CA128Accident · No injuriesData collectionFinal reportCessna 182T · Grand Junction, COThe pilot's failure to maintain aircraft control during the landing.NTSB DEN07CA123Accident · No injuriesData collectionFinal reportHorton Aviat ChristEagle II · Salida, COThe pilot's failure to maintain aircraft control during the landing, causing the airplane to depart the runway and impact the VASIs.NTSB DEN07CA126Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C2 · Crested Butte, COThe pilot's failure to maintain directional control during the landing roll.NTSB DEN07LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Englewood, COThis case was revised 10/31/2007. Low compression in number 2 cylinder, which reduced the airplane's climb capability. Contributing factors in this accident were the high density altitude conditions, and the tree.NTSB DEN07LA122Accident · Serious injuriesLimited investigationFinal reportBeech C-45H · Longmont, COThe instructor pilot's improper preflight in that he failed to close the rocker box recovery system drain valves, resulting in a total loss of lubricating oil and subsequent oil starvation to both engines. A contributing factor was the trees.NTSB DEN07CA121Accident · No injuriesData collectionFinal reportCessna 180 · Marble, COThe pilot misjudging his altitude and his failure to maintain control of the airplane, resulting in a hard landing. Factors contributing to the accident were the excessive descent rate, and the pilot's improper recovery from a bounced landing.NTSB DEN07LA119Accident · Serious injuriesLimited investigationFinal reportCessna T206H · Gunnison, COAn inadvertent stall during takeoff/initial climb. Contributing factors in this accident were a partial loss of engine power for reasons undetermined, and high density altitude conditions.NTSB DEN07CA120Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Peyton, COThe pilot's improper flare and failure to maintain control and subsequent hard landing. Contributing factors in this accident were the gusty winds, hot temperature, and high density altitude.NTSB DEN07CA112Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Joes, COthe pilot's improper takeoff planning and subsequent failure to maintain aircraft control during the takeoff. Contributing factors were the high density altitude and tailwind.NTSB DEN07CA116Accident · No injuriesData collectionFinal reportCessna T210N · Loveland, COThe pilot's failure to lower the landing gear. Contributing factors were the pilot's attention being diverted, and his failure to use the BEFORE LANDING checklist.NTSB DEN07CA111Accident · No injuriesData collectionFinal reportCessna 180A · Loveland, COThe pilot's failure to maintain directional control of the airplane during landing.NTSB DEN07CA110Accident · No injuriesData collectionFinal reportCessna T206H · Steamboat Spngs, COThe pilot's inadvertent encounter with adverse weather conditions (dirt devils/whirlwinds) and his inability to control the airplane during that encounter resulting in the airplane impacting the runway, subsequently going off the side of the runway, and…NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB DEN07CA102Accident · Minor injuriesData collectionFinal reportEagle RND Helicycle · Erie, COThe pilot's failure to maintain aircraft control resulting in the helicopter impacting onto the airport ramp. A contributing factor to the accident was the pilot's failure to establish the landing flare in time.NTSB DEN07CA104Accident · No injuriesData collectionFinal reportBeech B36TC · Hudson, COThe pilot's improper in-flight decision, and his failure to maintain proper aircraft control during takeoff resulting in an inadvertent stall and the subsequent impact with the runway and terrain.NTSB DEN07CA099Accident · No injuriesData collectionFinal reportAeronca 7AC · Erie, COThe student pilot's failure to maintain direction control during the landing roll.NTSB DEN07LA098Accident · Serious injuriesLimited investigationFinal reportBoeing 757-251 · Denver, COThe inadvertent encounter with moderate turbulence during the approach which resulted in a serious injury to the flight attendantNTSB DEN07CA094Accident · Minor injuriesData collectionFinal reportCessna 180H · Grand Junction, COThe pilot's failure to maintain directional control during the take-off roll. A factor contributing to the accident was the crosswind.NTSB DEN07FA089Accident · 1 fatalField investigationFinal reportSchleicher Alexander ASH 26E · Castle Rock, COthe pilot's failure to maintain aircraft control resulting in an inadvertent stall/mush.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 DEN07LA078Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900C · Rifle, COThe pilot's improper decision to land with excessive airspeed during the approach and failure to obtain the proper touchdown point, which resulted in a runway overrun. Contributing factors were the pilot's failure execute a missed approach, to use available…NTSB DEN07LA074Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pueblo, COThe pilot of the North American SNJ-5 warbird's inadequate visual lookout while taxiing, resulting in an on-ground collision with the stationary Grob motor glider.NTSB DEN07CA073Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Norwood, COThe inflight collision with a bird(s).NTSB DEN07CA072Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Broomfield, COThe instructor's failure to maintain aircraft control. A contributing factor was the windshear.