NTSB investigations, 2020, CO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2020
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") = 2020 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 CEN21LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Peyton, COThe student pilot did not maintain directional control of the airplane while landing. Contributing to the accident was the pilot’s diverted attention to the incorrect flap setting.NTSB CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.NTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…NTSB CEN21LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Canon City, COThe failure of the alternator drive belt, which resulted in insufficient electrical power to extend the landing gear and a subsequent gear-up landing. .NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.NTSB CEN21LA027Accident · Serious injuriesClass 4 · LimitedFinal reportCcx-2000-0081 CCX-2000 · Longmont, COThe pilot failed to maintain control of the airplane during landing.NTSB CEN21LA006Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Salida, COThe student pilot’s loss of directional control during takeoff and the flight instructor’s delayed remedial action which resulted in a runway excursion and impact with a steel object.NTSB CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.NTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.NTSB CEN21LA001Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Cedaredge, COA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Byers, COA partial loss of engine power for undetermined reasons.NTSB CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.NTSB CEN20LA424Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox Speedster · Leadville, COA partial loss of engine power due to fuel starvation as a result of the pilot’s improper maintenance.NTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.NTSB CEN20CA394Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA46 · Englewood, COThe pilot's failure to maintain directional control during landing in gusting winds.NTSB CEN20LA375Accident · 1 fatalClass 3 · LimitedFinal reportTitan Mustang T-51 · Brighton, COThe pilot’s loss of airplane control while maneuvering in the traffic pattern.NTSB CEN20CA366Accident · Minor injuriesClass 4 · Data collectionFinal reportJewett SC-360 · Brighton, COThe pilot’s excessive application of wheel brakes during the landing roll that caused the airplane to nose over.NTSB CEN20LA365Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210 · Peyton, COThe pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.NTSB CEN20LA345Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Glenwood Springs, COThe pilot’s loss of directional control upon landing due to a sheared tailwheel locking pin.NTSB CEN20CA340Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Englewood, COThe student pilot misjudged the landing flare which resulted in a loss of control and a hard bounced landing.NTSB CEN20CA332Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Englewood, COThe flight instructor did not maintain a proper approach path and landing flare during a landing with a tailwind, which resulted in a hard landing and damaged landing gear. During the subsequent landing with damaged landing gear, the flight instructor lost…NTSB CEN20CA311Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT 401 · Burlington, COThe pilot’s failure to maintain clearance from guy-wires during low-altitude agricultural operations.NTSB CEN20CA289Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Glenwood Springs, COThe pilot's failure to maintain airplane control during landing resulting in a nose over.NTSB CEN20CA277Accident · Minor injuriesClass 4 · Data collectionFinal reportKitfox Kitfox Sport · Rand, COThe encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.NTSB CEN20LA273Accident · Serious injuriesClass 3 · LimitedFinal reportAerospatiale AS355 · Rifle, COA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain.NTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…NTSB CEN20LA268Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20TN · Buena Vista, COThe pilot's distraction during takeoff, which resulted in collision with terrain.NTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB CEN20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCX-2000-0086 · Gypsom, COThe pilot's failure to maintain airplane control during landing in gusting wind conditions.NTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.NTSB CEN20LA169Accident · 1 fatalClass 3 · LimitedFinal reportRans S-12 · Delta, COThe pilot’s exceedance of the airplane’s critical angle of attack during a test flight which resulted in an aerodynamic stall and impact with terrain.NTSB CEN20CA163Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Longmont, COThe pilot's loss of control during a go around.NTSB CEN20CA161Accident · No injuriesData collectionFinal reportPiper PA 20 · Colorado Springs, COThe flight instructor's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control.NTSB CEN20LA160Accident · 1 fatalClass 3 · LimitedFinal reportAerostar 601 · Craig, COThe student pilot’s flight into terrain for undetermined reasons.NTSB CEN20CA151Accident · No injuriesData collectionFinal reportEagle Eagle DW 1 · Hudson, COThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and nose-over.NTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.NTSB CEN20CA128Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign.NTSB CEN20CA116Accident · No injuriesData collectionFinal reportCub Crafters CC11-160 · Mack, COThe pilot's failure to reconnoiter the approach area in preparation for an off-airport landing on a sandbar, which necessitated an evasive maneuver to avoid wires and resulted in an unintentional landing in the river short of the sandbar and a subsequent…NTSB CEN20CA094Accident · No injuriesData collectionFinal reportCessna 172 · Boulder, COThe pilot's loss of directional control during the landing roll on the slush-covered runway.NTSB CEN20LA083Accident · No injuriesClass 3 · LimitedFinal reportPiaggio P180 · Broomfield, COThe pilot’s loss of directional control on the snow-covered runway, which resulted in a runway excursion.NTSB CEN20CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-504 · Fort Morgan, COThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in the left main landing gear tire bursting and the tailwheel assembly failing.NTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeNTSB CEN20LA073Accident · No injuriesClass 3 · LimitedFinal reportHiller UH 12E · Dinosaur, COFailure of a S4 compressor blade due to a fatigue crack that likely initiated at a corrosion pit. Contributing to the accident was maintenance personnel’s failure to detect the corrosion pits during maintenance.NTSB CEN20LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Woody Creek, COWater trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing.