NTSB investigations, 1965, 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
Latest 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\") = 1965
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") = 1965 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 DEN66D0212Accident · No injuriesClosedCessna 150 · Littleton, CONTSB DEN66A0048Accident · 3 fatalClosedLockheed L-1049 · Alamosa, CONTSB DEN66A0045Accident · 3 fatalClosedBeech B95 · Aspen, CONTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CONTSB DEN66F0173Accident · No injuriesClosedBeechcraft D35 · Broomfield, CONTSB DEN66D0190Accident · No injuriesClosedPiper PA-28 · Fountain, CONTSB DEN66D0182Accident · No injuriesClosedPiper PA-28 · Avondale, CONTSB DEN66D0189Accident · No injuriesClosedCessna 170 · Montrose, CONTSB DEN66F0188Accident · No injuriesClosedMooney M20C · Denver, CONTSB DEN66F0162Accident · Minor injuriesClosedLuscombe T-8F · Greely, CONTSB DEN66F0156Accident · No injuriesClosedCessna 172 · Usaf Academy, CONTSB DEN66F0155Accident · No injuriesClosedLuscombe 8A · Rocky Ford, CONTSB DEN66F0148Accident · No injuriesClosedPiper PA-22 · Broomfield, CONTSB DEN66D0146Accident · No injuriesClosedCessna 180 · Fort Collins, CONTSB DEN66F0183Accident · No injuriesClosedCessna 150 · Pueblo, CONTSB DEN66A0031Accident · Minor injuriesClosedBell 204B · Georgetown, CONTSB DEN66D0143Accident · No injuriesClosedMooney M20E · Aspen, CONTSB DEN66F0149Accident · No injuriesClosedPiper PA-22 · Fountain, CONTSB DEN66F0132Accident · Minor injuriesClosedAero Cmdr 680 · Meeker, CONTSB DEN66A0030Accident · 4 fatalClosedCessna 182 · Sapinero, CONTSB DEN66A0028Accident · Serious injuriesClosedBoeing 707 320C · Glenwood Spgs, CONTSB FTW66D0417Accident · No injuriesClosedPiper PA-22 · Sand Springs, CONTSB DEN66F0164Accident · Serious injuriesClosedPiper PA18 · Grd Junction, CONTSB DEN66D0202Accident · No injuriesClosedCessna 210 · Denver, CONTSB DEN66D0119Accident · No injuriesClosedCessna 120 · Castle Rock, CONTSB DEN66F0118Accident · No injuriesClosedMooney M20C · Boulder, CONTSB DEN66F0117Accident · Serious injuriesClosedMonocoupe 110SPL · Grd Junction, CONTSB DEN66A0022Accident · No injuriesClosedBrantly B2B · Denver, CONTSB DEN66F0100Accident · No injuriesClosedPiper PA-20 · Akron, CONTSB DEN66A0021Accident · Minor injuriesClosedBell 47G3 · South Fork, CONTSB UNK65X1533Accident · 1 fatalClosedCallair A-9 · La Veta, CONTSB DEN66A0020Accident · No injuriesClosedBell 47G3B1 · Commerce Cty, CONTSB DEN66F0133Accident · No injuriesClosedCessna 310 · Pueblo, CONTSB DEN66D0107Accident · No injuriesClosedBellanca 14-13 · Security, CONTSB DEN66D0089Accident · No injuriesClosedBeechcraft 35-B33 · Watkins, CONTSB DEN66A0018Accident · Serious injuriesClosedBell 47G3B · Durango, CONTSB DEN66F0094Accident · No injuriesClosedCessna 140 · Aurora, CONTSB DEN66D0114Accident · No injuriesClosedBeechcraft 25 · Greely, CONTSB DEN66F0113Accident · Minor injuriesClosedLuscombe 8A · Greely, CONTSB DEN66A0017Accident · No injuriesClosedBell 47G3B1 · Salida, CONTSB DEN66D0142Accident · No injuriesClosedLuscombe 8E · Glenwood Sps, CONTSB DEN66D0090Accident · No injuriesClosedPiper PA-30 · Delta, CONTSB DEN66D0099Accident · No injuriesClosedN American P-51D · Grand Junctn, CONTSB DEN66D0083Accident · No injuriesClosedCessna 180 · Alamosa, CONTSB DEN66D0076Accident · No injuriesClosedBeechcraft C-35 · Denver, CONTSB DEN66D0073Accident · No injuriesClosedBeechcraft 35 · Denver, CONTSB DEN66D0084Accident · No injuriesClosedLuscombe 8E · Greeley, CONTSB DEN66D0081Accident · No injuriesClosedTaylorcraft BC-12D · Orchard, CONTSB DEN66D0079Accident · Minor injuriesClosedMooney M20C · Pueblo, CONTSB DEN66D0061Accident · No injuriesClosedPiper PA-24 · Taylor, CO