Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 DEN78FTE21Accident · Serious injuriesClosedBeech A23-19 · Kings Canyon, CODec 30, 1977 · N3610Q · Destroyed NTSB DEN78FTE20Accident · No injuriesClosedCessna 152 · Colorado Sprgs, CODec 29, 1977 · N25508 · Substantial damage NTSB DEN78FTE19Accident · No injuriesClosedErco 415-C · Peyton, CODec 14, 1977 · N3503H · Substantial damage NTSB DEN78FTE18Accident · No injuriesClosedCessna 152 · Ft.Collins, CODec 13, 1977 · N714ZW · Substantial damage NTSB DEN78FI012Incident · No injuriesClosedDehavilland DHC-7 · Denver, CODec 6, 1977 · N27RM · Minor damage NTSB DEN78FTE17Accident · Serious injuriesClosedPiper J3 · Greeley, CODec 4, 1977 · N32648 · Destroyed NTSB DEN78DTE15Accident · Serious injuriesClosedBarnes DF-6 · Del Norte, CONov 30, 1977 · N2053 · Substantial damage NTSB DEN78IA009Incident · No injuriesClosedConvair 540 · Denver, CONov 28, 1977 · N73143 · Minor damage NTSB DEN78FA010Accident · 1 fatalClosedCessna 414 · Aspen, CONov 27, 1977 · N1682T · Destroyed NTSB DEN78DTE15Accident · No injuriesClosedDyke Delta · Denver, CONov 26, 1977 · N14SA · Substantial damage NTSB DEN78DTE13Accident · No injuriesClosedPiper PA-28R · Paonia, CONov 26, 1977 · N41373 · Substantial damage NTSB DEN78FA011Accident · 2 fatalClosedCessna 175 · Leadville, CONov 25, 1977 · N9413B · Destroyed NTSB DEN78DTE16Accident · No injuriesClosedCessna 150K · Longmont, CONov 23, 1977 · N5717G · Substantial damage NTSB DEN78IA015Incident · No injuriesClosedDouglas DC-9 · Denver, CONov 22, 1977 · UNK/NR · No damage NTSB DEN78FTE12Accident · Serious injuriesClosedLuscombe 8E · Woodland Park, CONov 13, 1977 · N2683K · Substantial damage NTSB DEN78DTE11Accident · No injuriesClosedCessna 206 · Pueblo, CONov 8, 1977 · N5259U · Substantial damage NTSB DEN78FTE10Accident · No injuriesClosedCessna T210J · Glenwood Sprgs, CONov 4, 1977 · N2280R · Substantial damage NTSB DEN78DTE09Accident · No injuriesClosedCessna 150H · Durango, CONov 1, 1977 · N7248S · Substantial damage NTSB DEN78DTE08Accident · Minor injuriesClosedMooney M20F · Colorado Sprgs, COOct 31, 1977 · N32LL · Substantial damage NTSB DEN78FTE07Accident · Minor injuriesClosedCessna T337E · Peyton, COOct 30, 1977 · N1289M · Substantial damage NTSB DEN78FA005Accident · 1 fatalClosedCessna 150G · Kiowa, COOct 28, 1977 · N3373J · Destroyed NTSB DEN78FTE06Accident · Serious injuriesClosedPiper PA-24 · Lake City, COOct 25, 1977 · N7083P · Destroyed NTSB DEN78FTE05Accident · No injuriesClosedDehavilland DH82A · Lasalle, COOct 16, 1977 · N200D · Substantial damage NTSB DEN78FI014Incident · No injuriesClosedBoeing 747 · Denver, COOct 12, 1977 · N4727U · No damage NTSB DEN77FTE03Accident · No injuriesClosedCessna 182P · Peyton, COOct 10, 1977 · N1464S · Substantial damage NTSB DEN78FTE02Accident · No injuriesClosedCessna 172M · Broomfield, COOct 7, 1977 · N73452 · Substantial damage NTSB DEN78DTE04Accident · No injuriesClosedGrum Amer AA-5B · Peyton, COOct 7, 1977 · N74056 · Substantial damage NTSB DEN78FTE01Accident · Serious injuriesClosedTaylorcraft 12-65 · Aurora, COOct 1, 1977 · N36125 · Substantial damage NTSB DEN77FTE90Accident · No injuriesClosedMooney M20A · Colorado Spgs, COSep 30, 1977 · N1069B · Substantial damage NTSB DEN77DTE89Accident · No injuriesClosedBell 47G3B1 · Crestone, COSep 28, 1977 · N30676 · Substantial damage NTSB DEN77FA058Accident · 6 fatalClosedCessna U206 · Salida, COSep 23, 1977 · N1452M · Destroyed NTSB DEN77FTE88Accident · Minor injuriesClosedCessna 172 · Wray, COSep 16, 1977 · N8316U · Substantial damage NTSB DEN77FTE87Accident · No injuriesClosedCessna A185F · Boulder, COSep 16, 1977 · N1479F · Substantial damage NTSB DEN77FTE86Accident · No injuriesClosedCessna 172 · Ignacio, COSep 14, 1977 · N75821 · Substantial damage NTSB DEN77DTE84Accident · No injuriesClosedPorterfield 35-70 · Falcon, COSep 8, 1977 · N968WC · Substantial damage NTSB DEN77DTE85Accident · No injuriesClosedCaproni A-21 · Fondis, COSep 4, 1977 · N210CA · Substantial damage NTSB DEN77DTE83Accident · No injuriesClosedPiper PA-22 · Leadville, COAug 30, 1977 · N5938D · Substantial damage NTSB DEN77DTE80Accident · No injuriesClosedBlanik L-13 · Waverly, COAug 28, 1977 · N666FB · Substantial damage NTSB MKC77FCQ57Accident · No injuriesClosedMooney M2OF · Holly, COAug 27, 1977 · N3554N · Substantial damage NTSB DEN77DTE81Accident · No injuriesClosedPiper PA-22 · Peyton, COAug 27, 1977 · N33477 · Substantial damage NTSB DEN77FTE69Accident · Serious injuriesClosedBeech A-36 · Breckenridge, COAug 26, 1977 · N17635 · Destroyed NTSB DEN77FTE76Accident · No injuriesClosedStinson 108-2 · Boulder, COAug 20, 1977 · N9389K · Substantial damage NTSB DEN77FTE75Accident · Minor injuriesClosedPiper PA-22 · Denver, COAug 19, 1977 · N3379B · Substantial damage NTSB DEN77FA053Accident · 2 fatalClosedMaule M4 · Estes Park, COAug 16, 1977 · N4132C · Destroyed NTSB DEN77DTE72Accident · No injuriesClosedCessna 140 · Platner, COAug 16, 1977 · N2259N · Substantial damage NTSB DEN77FTE73Accident · Minor injuriesClosedCessna 150 · Two Buttes, COAug 15, 1977 · N714AE · Substantial damage NTSB DEN77FTE70Accident · Minor injuriesClosedBeech A19-23 · Peyton, COAug 14, 1977 · N4755J · Substantial damage NTSB DEN77FTE74Accident · No injuriesClosedBell 214B-1 · Silverthorne, COAug 13, 1977 · N226RM · No damage NTSB DEN77FTE71Accident · No injuriesClosedMooney M20C · Aurora, COAug 12, 1977 · N6725N · Substantial damage NTSB DEN77FA056Accident · Minor injuriesClosedPiper PA-32T · Colorado Spgs, COAug 5, 1977 · N4864S · Substantial damage