Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1971, CO per year, 1963–2026: 4,939 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	43

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") = 1971 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\") = 1971
    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") = 1971
  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 DEN72DTE52Accident · Minor injuriesClosedCessna 150 · Walsenburg, CODec 27, 1971 · N3082S · Substantial damage NTSB DEN72FTE49Accident · No injuriesClosedCessna 150 · Littleton, CODec 15, 1971 · N6812F · Substantial damage NTSB DEN72AD026Accident · 1 fatalClosedN.American AT-6G · Eldora, CODec 14, 1971 · N160JN · Destroyed NTSB DEN72DTE47Accident · No injuriesClosedCessna 172B · Erie, CONov 28, 1971 · N7909X · Substantial damage NTSB DEN72AD025Accident · No injuriesClosedBeech 99A · Greeley, CONov 24, 1971 · N21FW · Substantial damage NTSB DEN72DTE45Accident · Minor injuriesClosedPiper PA-22 · Pagosa Sprgs, CONov 21, 1971 · N6127D · Substantial damage NTSB DEN72DTE44Accident · Minor injuriesClosedCessna 172 · Fountain, CONov 20, 1971 · N4339Q · Substantial damage NTSB DEN72DTE43Accident · No injuriesClosedCessna 150G · Broomfield, CONov 13, 1971 · N3484J · Substantial damage NTSB DEN72DTE46Accident · No injuriesClosedPiper PA-18 · Denver, CONov 12, 1971 · N8476Y · Substantial damage NTSB DEN72FTE40Accident · No injuriesClosedStinson 108-2 · Watkins, CONov 4, 1971 · N97086 · Substantial damage NTSB DEN72FTE41Accident · No injuriesClosedCessna 182F · Aurora, CONov 3, 1971 · N3553U · Substantial damage NTSB DEN72DTE42Accident · No injuriesClosedCessna 182H · Sterling, CONov 2, 1971 · N1877X · Substantial damage NTSB DEN72AD021Accident · 4 fatalClosedBeech D50C · Brandon, COOct 29, 1971 · N9968R · Destroyed NTSB DEN72FTE38Accident · Minor injuriesClosedCessna 421 · Englewood, COOct 28, 1971 · N3178K · Substantial damage NTSB DEN72AD020Accident · 1 fatalClosedErco 415-CD · Kit Carson, COOct 28, 1971 · N3902H · Destroyed NTSB DEN72FTE36Accident · Minor injuriesClosedPiper PA-28 · Denver, COOct 25, 1971 · N7708N · Substantial damage NTSB DEN72DTE37Accident · No injuriesClosedPiper PA-22 · Arboles, COOct 25, 1971 · N1504P · Substantial damage NTSB DEN72AD019Accident · No injuriesClosedCessna 310B · Creede, COOct 25, 1971 · N6636B · Substantial damage NTSB DEN72FTE34Accident · No injuriesClosedCessna 150 · Aurora, COOct 20, 1971 · N3731J · Substantial damage NTSB DEN72DTE33Accident · No injuriesClosedCessna 180 · Hayden, COOct 14, 1971 · N4500B · Substantial damage NTSB DEN72FTE39Accident · Serious injuriesClosedBell 47G3B2 · Idaho Sprngs, COOct 5, 1971 · N590P · Substantial damage NTSB DEN72DTE30Accident · No injuriesClosedLuscombe 8F · Greeley, COOct 2, 1971 · N1370B · Substantial damage NTSB DEN72DTE26Accident · No injuriesClosedLake LA-4 · Longmont, COSep 27, 1971 · N7640L · Substantial damage NTSB MKC72AK021Accident · 4 fatalClosedCessna 320D · Aspen, COSep 26, 1971 · N4157T · Destroyed NTSB DEN72DTE32Accident · No injuriesClosedMooney M20F · Flagler, COSep 26, 1971 · N6307Q · Substantial damage NTSB DEN72AD016Accident · 2 fatalClosedCessna 150 · Bennett, COSep 25, 1971 · N6117T · Destroyed NTSB DEN72DTE25Accident · Minor injuriesClosedPiper PA-23 · Aspen, COSep 20, 1971 · N4313P · Substantial damage NTSB DEN72AD013Accident · 3 fatalClosedBeech 70 · Fowler, COSep 17, 1971 · N1384A · Destroyed NTSB DEN72DTE25Accident · No injuriesClosedBeech 95-C55 · Lamar, COSep 14, 1971 · N5946S · Substantial damage NTSB DEN72AD012Accident · 2 fatalClosedCessna 172L · Lake City, COSep 14, 1971 · N7920G · Destroyed NTSB DEN72FTE31Accident · No injuriesClosedPiper PA-28 · Littleton, COSep 11, 1971 · N9162W · Substantial damage NTSB DEN72DTE23Accident · No injuriesClosedBeech N35 · Alamosa, COSep 11, 1971 · N9470Y · Substantial damage NTSB DEN72DTE28Accident · No injuriesClosedPiper PA-28 · Ft.Collins, COSep 8, 1971 · N5846U · Substantial damage NTSB DEN72FTE21Accident · Minor injuriesClosedPiper PA-28 · Parker, COSep 4, 1971 · N2150R · Substantial damage NTSB DEN72DTE22Accident · No injuriesClosedDiamant HBV165 · Elbert, COSep 4, 1971 · N11LE · Substantial damage NTSB DEN72FTE27Accident · No injuriesClosedTemco D-16 · Trinidad, COSep 1, 1971 · N79S · Substantial damage NTSB DEN72DTE24Accident · No injuriesClosedBell 204B · Dillon, COSep 1, 1971 · N7937S · Substantial damage NTSB DEN72DTE26Accident · No injuriesClosedCessna 150 · Hillrose, COAug 31, 1971 · N6859G · Substantial damage NTSB DEN72DTE29Accident · No injuriesClosedCessna 150H · Aurora, COAug 28, 1971 · N23175 · Substantial damage NTSB DEN72DTE18Accident · No injuriesClosedBeech B23 · Granby, COAug 26, 1971 · N6561T · Substantial damage NTSB DEN72FTE16Accident · No injuriesClosedHughes 269A · Aurora, COAug 24, 1971 · N8764F · Substantial damage NTSB DEN72AD007Accident · 2 fatalClosedSchweizer SGS232 · Colo.Springs, COAug 22, 1971 · N9862E · Substantial damage NTSB DEN72AD006Accident · 1 fatalClosedCessna T210G · Grand Junctn, COAug 21, 1971 · N6893R · Minor damage NTSB DEN72DTE20Accident · No injuriesClosedCessna 180 · Stmboat Spgs, COAug 15, 1971 · N2466C · Substantial damage NTSB DEN72DTE14Accident · No injuriesClosedCessna 172E · Brandon, COAug 15, 1971 · N5718T · Substantial damage NTSB DEN72FTE15Accident · No injuriesClosedMooney M20C · Littleton, COAug 14, 1971 · N6812U · Substantial damage NTSB DEN72DTE19Accident · No injuriesClosedBell 47G3B1 · Minturn, COAug 13, 1971 · N73978 · Substantial damage NTSB DEN72FTE11Accident · No injuriesClosedPiper PA-32 · Leadville, COAug 7, 1971 · N3649W · Substantial damage NTSB DEN72DTE10Accident · No injuriesClosedHughes 269A · Ft Collins, COAug 7, 1971 · N8891F · Substantial damage NTSB DEN72DTE09Accident · No injuriesClosedPiper PA-25 · Center, COAug 7, 1971 · N7496Z · Substantial damage