Skip to content

NTSB investigations, 1969, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1969, CO per year, 1963–2026: 4,940 cases
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

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") = 1969 AND c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1969
    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") = 1969
  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 DEN70F0163Accident · No injuriesClosedBeech D18S · Boulder, CODec 23, 1969 · N177V · Substantial damage NTSB DEN70A0049Accident · Serious injuriesClosedBoeing 720 · Denver, CODec 21, 1969 · N17207 · No damage NTSB DEN70D0159Accident · No injuriesClosedCessna 172 · Colorado Spg, CODec 16, 1969 · N2395U · Substantial damage NTSB DEN70F0158Accident · No injuriesClosedPiper PA-30 · Denver, CONov 27, 1969 · N7973Y · Substantial damage NTSB DEN70A0035Accident · 1 fatalClosedTaylorcraft BC-65 · Boulder, CONov 26, 1969 · N66619 · Destroyed NTSB DEN70F0160Accident · Minor injuriesClosedFairchild 24W · Colo.Spgs, CONov 16, 1969 · N28686 · Substantial damage NTSB DEN70D0145Accident · No injuriesClosedCessna 120 · Akron, CONov 16, 1969 · N3044N · Substantial damage NTSB DEN70D0147Accident · No injuriesClosedCessna 172 · Sedalia, CONov 15, 1969 · N2643L · Substantial damage NTSB DEN70A0034Accident · 3 fatalClosedCessna 310F · Elbert, CONov 12, 1969 · N5821X · Destroyed NTSB DEN70D0144Accident · No injuriesClosedBellanca 14-192 · Akron, CONov 9, 1969 · N7682B · Substantial damage NTSB DEN70D0129Accident · No injuriesClosedLuscombe 8A · Aurora, CONov 9, 1969 · N1220K · 2 aircraft · Substantial damage NTSB DEN70D0135Accident · No injuriesClosedPiper PA-24 · Littleton, CONov 5, 1969 · N9242P · Substantial damage NTSB DEN70A0032Accident · 2 fatalClosedCessna 150D · Denver, CONov 4, 1969 · N6068T · 2 aircraft · Destroyed NTSB DEN70F0128Accident · No injuriesClosedBeech JRB-6 · Denver, CONov 3, 1969 · N72405 · Substantial damage NTSB DEN70F0124Accident · Minor injuriesClosedPiper PA-28 · Broomfield, CONov 3, 1969 · N7130R · Substantial damage NTSB DEN70A0031Accident · 1 fatalClosedCessna 150J · Eldora, COOct 31, 1969 · N50938 · Destroyed NTSB DEN70D0112Accident · No injuriesClosedCessna 172 · Pagosa Spgs, COOct 27, 1969 · N3726F · Substantial damage NTSB DEN70A0028Accident · 1 fatalClosedNavion G · Hudson, COOct 26, 1969 · N2466T · Destroyed NTSB DEN70F0150Accident · Serious injuriesClosedBensen B-8M · Aurora, COOct 25, 1969 · N1598 · Substantial damage NTSB DEN70AD029Accident · 4 fatalClosedPiper PA-28 · Cuchara, COOct 23, 1969 · N5752W · Destroyed NTSB DEN70D0157Accident · No injuriesClosedCessna 172 · Englewood, COOct 21, 1969 · N4310L · Substantial damage NTSB DEN70A0027Accident · 2 fatalClosedPiper PA-30 · Greeley, COOct 17, 1969 · N8584Y · Destroyed NTSB DEN70A0026Accident · 1 fatalClosedCessna 180 · Center, COOct 17, 1969 · N2808D · Destroyed NTSB DEN70D0127Accident · Serious injuriesClosedCessna 207 · Aspen, COOct 12, 1969 · N91042 · Substantial damage NTSB DEN70A0023Accident · 5 fatalClosedBeech 65-B80 · Denver, COOct 3, 1969 · N590CA · Destroyed NTSB DEN70F0107Accident · No injuriesClosedAeronca 7ECA · Lyons, COSep 28, 1969 · N2571F · Substantial damage NTSB DEN70D0162Accident · Minor injuriesClosedCessna 150 · Hugo, COSep 27, 1969 · N6257R · Substantial damage NTSB DEN70A0022Accident · 1 fatalClosedCessna 172 · Walsenburg, COSep 27, 1969 · N78284 · Substantial damage NTSB DEN70D0105Accident · No injuriesClosedAero Comdr 680FP · Grand Junctn, COSep 24, 1969 · N222AA · Substantial damage NTSB DEN70D0096Accident · No injuriesClosedPiper PA-18 · Hayden, COSep 20, 1969 · N3760Z · Substantial damage NTSB DEN70A0021Accident · 2 fatalClosedCessna 150F · Aurora, COSep 15, 1969 · N8803S · Substantial damage NTSB DEN70A0019Accident · 1 fatalClosedPiper PA-28 · Eads, COSep 9, 1969 · N4173J · Destroyed NTSB DEN70D0111Accident · No injuriesClosedPiper PA-23 · Greeley, COSep 8, 1969 · N1034P · Substantial damage NTSB DEN70D0116Accident · No injuriesClosedCessna 150F · Calhan, COSep 6, 1969 · N7808F · Substantial damage NTSB DEN70D0091Accident · No injuriesClosedPiper PA-18 · Aspen, COSep 6, 1969 · N3572P · Substantial damage NTSB DEN70D0093Accident · No injuriesClosedCessna 182 · Englewood, COAug 29, 1969 · N71514 · Substantial damage NTSB DEN70A0015Accident · No injuriesClosedDouglas DC-9 · Denver, COAug 29, 1969 · N8917 · Substantial damage NTSB DEN70D0085Accident · No injuriesClosedLuscombe 8E · Fountain, COAug 24, 1969 · N2304K · Substantial damage NTSB DEN70D0146Accident · No injuriesClosedBell 47J-2A · Montrose, COAug 23, 1969 · N73202 · Substantial damage NTSB DEN70D0106Accident · No injuriesClosedBeech 95-55 · Salida, COAug 16, 1969 · N1209Z · Substantial damage NTSB DEN70D0081Accident · No injuriesClosedCessna 177 · Fountain, COAug 16, 1969 · N29543 · Substantial damage NTSB DEN70D0086Accident · No injuriesClosedCessna 177 · Aurora, COAug 14, 1969 · N29486 · Substantial damage NTSB DEN70D0058Accident · No injuriesClosedCessna 172 · Fruita, COAug 14, 1969 · N35371 · Substantial damage NTSB DEN70A0011Accident · 3 fatalClosedBeech 23 · Colo.Springs, COAug 13, 1969 · N2349J · Destroyed NTSB DEN70D0084Accident · Serious injuriesClosedBeech 95-55 · Walden, COAug 11, 1969 · N127Z · Destroyed NTSB DEN70D0095Accident · Minor injuriesClosedPiper PA-22 · Arriba, COAug 10, 1969 · N2477A · Destroyed NTSB DEN70F0092Accident · No injuriesClosedBeech 23 · Aspen, COAug 9, 1969 · N5672S · Substantial damage NTSB DEN70F0083Accident · No injuriesClosedBeech S35 · Denver, COAug 7, 1969 · N8551Q · Substantial damage NTSB DEN70D0114Accident · No injuriesClosedPiper J3C-65 · Denver, COAug 7, 1969 · N77553 · Substantial damage NTSB DEN70F0067Accident · No injuriesClosedAero Comdr S-2R · Johnstown, COAug 4, 1969 · N8871Q · Substantial damage