Skip to content

NTSB investigations, 1978, CO

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 DEN79FTE14Accident · 1 fatalClosedMidget Mustng · Aurora, CODec 26, 1978 · N5785N · Substantial damage NTSB DEN79FTE11Accident · No injuriesClosedCessna 150 · Ft.Collins, CODec 21, 1978 · N9489U · Substantial damage NTSB DEN79FTE13Accident · No injuriesClosedBeech 35 · Greeley, CODec 20, 1978 · N3512B · Substantial damage NTSB DEN79FTE07Accident · No injuriesClosedPiper PA-30 · Englewood, CODec 15, 1978 · N5EE · Substantial damage NTSB DEN79FTE09Accident · No injuriesClosedPiper PA-28R · Ft Collins, CODec 13, 1978 · N1562X · Substantial damage NTSB DEN79FTE12Accident · No injuriesClosedAero Comm 680F · Lajunta, CODec 12, 1978 · N11VM · Substantial damage NTSB DEN79FTE05Accident · Serious injuriesClosedCessna 414 · Aspen, CODec 10, 1978 · N6604C · Substantial damage NTSB DEN79FTE06Accident · No injuriesClosedCessna 172 · Longmont, CODec 9, 1978 · N738AA · Substantial damage NTSB DCA79AA003Accident · 2 fatalClosedDehavilland DHC-6 · Steamboat Spgs, CODec 4, 1978 · N25RM · Destroyed NTSB DEN79FTE08Accident · No injuriesClosedPiper PA28R · Englewood, CODec 1, 1978 · N6507J · Substantial damage NTSB DEN79DTE10Accident · No injuriesClosedCessna 120 · Englewood, CONov 28, 1978 · N2757N · Substantial damage NTSB DEN79DTE04Accident · No injuriesClosedCessna 172N · Pritchett, CONov 19, 1978 · N738JP · Substantial damage NTSB DEN79FTE03Accident · No injuriesClosedCessna 421C · Br00mfield, CONov 10, 1978 · N6771C · Substantial damage NTSB DEN79FTE02Accident · Minor injuriesClosedGrumman AA-5A · Colorado Spgs, COOct 22, 1978 · N26392 · Substantial damage NTSB DEN79FTE01Accident · No injuriesClosedPiper PA-22 · Olney Springs, COOct 16, 1978 · N3921P · Substantial damage NTSB DEN79FA002Accident · 2 fatalClosedGrum Amer AA5 · Littleton, COOct 4, 1978 · N6071L · Destroyed NTSB DEN79FA001Accident · 1 fatalClosedSikorsky S58ET · Steamboat Spgs, COOct 1, 1978 · N47783 · Destroyed NTSB DEN78DTF03Accident · Minor injuriesClosedThorpe T-18 · Durango, COSep 30, 1978 · N7FF · Substantial damage NTSB DEN78FTF02Accident · No injuriesClosedCessna 172 · Mancos, COSep 27, 1978 · N5329V · Substantial damage NTSB DEN78FTF01Accident · No injuriesClosedCessna T337 · Calhan, COSep 23, 1978 · N47789 · Substantial damage NTSB DEN78FTE98Accident · No injuriesClosedBellanca 7GCBC · Thorton, COSep 15, 1978 · N8663V · Substantial damage NTSB DEN78FTE97Accident · No injuriesClosedCessna 172N · Englewood, COSep 11, 1978 · N734PJ · Substantial damage NTSB DEN78FA067Accident · 1 fatalClosedAeronca 11AC · Wray, COSep 10, 1978 · N9366E · Destroyed NTSB DEN78FTE99Accident · Serious injuriesClosedSchweizer 2-33A · Black Forest, COSep 8, 1978 · N1232 · Destroyed NTSB DEN78DTE96Accident · Minor injuriesClosedSchweizer SGS134 · Boulder, COSep 2, 1978 · N7596 · Substantial damage NTSB DEN78FTE94Accident · No injuriesClosedHughes 269A · Crook, COAug 31, 1978 · N8892F · Substantial damage NTSB DEN78IA066Incident · No injuriesClosedDouglas DC-10 · Denver, COAug 29, 1978 · N1829U · Minor damage NTSB DEN78DTE95Accident · No injuriesClosedPiper PA-25 · Walsh, COAug 28, 1978 · N9854P · Substantial damage NTSB DEN78FTE93Accident · No injuriesClosedGrum Amer AA-1C · Aurora, COAug 26, 1978 · N4681U · Substantial damage NTSB DEN78FTE92Accident · No injuriesClosedSchweizer 2-33A · Boulder, COAug 26, 1978 · N2624H · Substantial damage NTSB DEN78FA064Incident · No injuriesClosedBeech E-55 · Pueblo, COAug 23, 1978 · N9327Q · Minor damage NTSB DEN78FTE91Accident · Minor injuriesClosedAerospatle SA316B · Norwood, COAug 22, 1978 · N4246 · Substantial damage NTSB DEN78DTE90Accident · No injuriesClosedCessna 152 · Ellicott, COAug 22, 1978 · N757TN · Substantial damage NTSB DEN78FTE89Accident · Serious injuriesClosedCessna 150 · Broomfield, COAug 21, 1978 · N18551 · Substantial damage NTSB DEN78DTE88Accident · No injuriesClosedPiper PA-25 · Center, COAug 20, 1978 · N5KL · Substantial damage NTSB DEN78FI063Incident · No injuriesClosedBeech 65-80 · Pueblo, COAug 18, 1978 · N20 · Minor damage NTSB DEN78FA062Accident · No injuriesClosedAero Comdr 560A · Broomfield, COAug 16, 1978 · N560S · Substantial damage NTSB DEN78FA058Accident · No injuriesClosedHiller UH12E · Berthoud, COAug 14, 1978 · N143HA · Substantial damage NTSB DEN78FTE86Accident · No injuriesClosedBeech B60 · Alamosa, COAug 12, 1978 · N4315W · Substantial damage NTSB DEN78FA057Accident · 5 fatalClosedPiper PA-28 · Silverplume, COAug 12, 1978 · N8719W · Destroyed NTSB DEN78FTE84Accident · No injuriesClosedPiper PA-28 · Denver, COAug 9, 1978 · N47378 · Substantial damage NTSB DEN78FTE82Accident · No injuriesClosedCessna 172 · Aurora, COAug 6, 1978 · N577DB · Substantial damage NTSB DEN78FTE83Accident · Serious injuriesClosedCessna 401A · Aspen, COAug 3, 1978 · N555SH · Destroyed NTSB DEN78FTE81Accident · No injuriesClosedCessna 320 · Montrose, COJul 30, 1978 · N5735X · Substantial damage NTSB DEN78FTE80Accident · No injuriesClosedBell 47G3B2 · Mesa, COJul 28, 1978 · N7927J · Substantial damage NTSB DEN78FTE77Accident · No injuriesClosedWeatherly 201C · Lucerne, COJul 26, 1978 · N1289W · Substantial damage NTSB DEN78FTE79Accident · No injuriesClosedTaylorcraft BC1265 · Boulder, COJul 24, 1978 · N29639 · Substantial damage NTSB DEN78FTE78Accident · No injuriesClosedBede 5-B · Longmont, COJul 22, 1978 · N250TH · Substantial damage NTSB DEN78FTE76Accident · No injuriesClosedPiper PA-18 · Durango, COJul 22, 1978 · N8268P · Substantial damage NTSB DEN78FTE75Accident · Minor injuriesClosedCessna 150 · Elbert, COJul 20, 1978 · N9288U · Substantial damage