Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 DEN73FTE53Accident · No injuriesClosedAero Comdr 680 · Greeley, CODec 25, 1972 · N6830S · Substantial damage NTSB DEN73FTE40Accident · No injuriesClosedCessna 150E · Aurora, CODec 18, 1972 · N3918U · Substantial damage NTSB DEN73FTE39Accident · No injuriesClosedCessna 150 · Broomfield, CODec 12, 1972 · N18551 · Substantial damage NTSB DEN73DTE43Accident · No injuriesClosedCessna 182L · Littleton, CODec 11, 1972 · N3188R · Substantial damage NTSB DEN73AD028Accident · Serious injuriesClosedConvair 580 · Alamosa, CODec 4, 1972 · N73112 · No damage NTSB DEN73AD025Accident · 1 fatalClosedPiper PA-23 · Nederland, CONov 25, 1972 · N6767Y · Destroyed NTSB DEN73FTE38Accident · No injuriesClosedPiper PA-28 · Rangely, CONov 13, 1972 · N5521F · Substantial damage NTSB DEN73ADO22Accident · 1 fatalClosedPiper PA-28 · Rangley, CONov 13, 1972 · N9958W · Destroyed NTSB DEN73FTE36Accident · No injuriesClosedCessna 310L · Springfield, CONov 10, 1972 · N3355Q · Substantial damage NTSB DEN73ADO20Accident · 3 fatalClosedCessna 172 · Paonia, CONov 10, 1972 · N6611A · Destroyed NTSB DEN73AD021Accident · 1 fatalClosedBeech F35 · Lindon, CONov 6, 1972 · N5006B · Destroyed NTSB DEN73DTE35Accident · No injuriesClosedCessna 170B · Woodrow, COOct 29, 1972 · N8251A · Substantial damage NTSB DEN73ID018Incident · No injuriesClosedBeech 95-A55 · Aspen, COOct 26, 1972 · N8530M · Minor damage NTSB DEN73AD016Accident · 1 fatalClosedCessna 182 · Denver, COOct 20, 1972 · N2458R · Destroyed NTSB DEN73DTE33Accident · No injuriesClosedChampion 7KCAB · Salida, COOct 14, 1972 · N5270X · Substantial damage NTSB DEN73FTE31Accident · Serious injuriesClosedCessna P206A · Nucla, COOct 13, 1972 · N2685X · Substantial damage NTSB DEN73FTE34Accident · No injuriesClosedChampion 7KCAB · Rangley, COOct 12, 1972 · N11652 · Substantial damage NTSB DEN73DTE37Accident · No injuriesClosedGrumman G-164 · Joes, COOct 10, 1972 · N520Y · Substantial damage NTSB DEN73FTE32Accident · No injuriesClosedCessna 210D · Broomfield, COOct 6, 1972 · N3845Y · Substantial damage NTSB DEN73AD015Accident · No injuriesClosedBell 47G3B1 · Hayden, COOct 3, 1972 · N1397X · Substantial damage NTSB DEN73FTE29Accident · Serious injuriesClosedBeech C23 · Larkspur, COSep 24, 1972 · N9785L · Destroyed NTSB DEN73FTE28Accident · Serious injuriesClosedBeech D35 · Denver, COSep 22, 1972 · N737D · Destroyed NTSB DEN73FTE26Accident · Minor injuriesClosedPiper PA-28 · Littleton, COSep 10, 1972 · N5821U · Destroyed NTSB DEN73FTE24Accident · No injuriesClosedCessna 182 · Englewood, COSep 5, 1972 · N9334X · Destroyed NTSB DEN73AD011Accident · 1 fatalClosedHiller Acft 1100 · Drake, COSep 3, 1972 · N542FH · Destroyed NTSB DEN73FTE23Accident · Serious injuriesClosedTed Smith 601 · Bennett, COAug 31, 1972 · N44JV · Substantial damage NTSB DEN73AD010Accident · 1 fatalClosedCessna 182J · Eldora, COAug 30, 1972 · N3057F · Destroyed NTSB DEN73DTE25Accident · No injuriesClosedBeech C23 · Ft.Carson, COAug 27, 1972 · N9758L · Substantial damage NTSB DEN73FTE19Accident · No injuriesClosedCessna 182G · Aurura, COAug 26, 1972 · N3779U · Substantial damage NTSB DEN73DTE30Accident · No injuriesClosedCessna 182K · Colo Sprgs, COAug 26, 1972 · N2511Q · Substantial damage NTSB DEN73AD009Accident · 1 fatalClosedPiper PA-28 · Buffalo Crk, COAug 23, 1972 · N3777R · Destroyed NTSB DEN73DTE22Accident · No injuriesClosedPiper PA-25 · Eckley, COAug 22, 1972 · N7705Z · Substantial damage NTSB DEN73DTE21Accident · No injuriesClosedPiper PA-25 · Eckley, COAug 22, 1972 · N77562 · Substantial damage NTSB DEN73FTE20Accident · No injuriesClosedBeech C-45H · Boulder, COAug 20, 1972 · N139V · Substantial damage NTSB DEN73FTE18Accident · Serious injuriesClosedBeech P35 · Aspen, COAug 20, 1972 · N1435G · Substantial damage NTSB DEN73AD006Accident · Minor injuriesClosedBell 205-A1 · Maybell, COAug 14, 1972 · N2236W · Destroyed NTSB DEN73DTE17Accident · No injuriesClosedCessna 172K · Glenwood Spg, COAug 10, 1972 · N79529 · Substantial damage NTSB DEN73FTE13Accident · Serious injuriesClosedPiper J3C-65 · Berthoud, COAug 6, 1972 · N92602 · Destroyed NTSB DEN73DTE15Accident · No injuriesClosedStinson 108-2 · Pueblo, COAug 6, 1972 · N9416K · Substantial damage NTSB DEN73DTE14Accident · No injuriesClosedPiper PA-28 · Steamboat Sp, COAug 6, 1972 · N1279T · Substantial damage NTSB DEN73DTE16Accident · No injuriesClosedCessna 182 · Eaglewood, COAug 3, 1972 · N71754 · Substantial damage NTSB DEN73DTE12Accident · No injuriesClosedPiper PA-25 · Rocky Ford, COAug 2, 1972 · N8825L · Substantial damage NTSB DEN73AD005Accident · 3 fatalClosedCessna 310D · Denver, COAug 2, 1972 · N771J · Destroyed NTSB DEN73FTE10Accident · Serious injuriesClosedSnow 600S2C · Wray, COJul 26, 1972 · N1611S · Destroyed NTSB DEN73DTE11Accident · No injuriesClosedMooney M20 · La Junta, COJul 24, 1972 · N6091X · Substantial damage NTSB DEN73AD003Accident · 4 fatalClosedCessna U206 · Aspen, COJul 24, 1972 · N5290U · Destroyed NTSB DEN73DTE09Accident · No injuriesClosedCessna 188 · Pritchett, COJul 19, 1972 · N21613 · Substantial damage NTSB DEN73DTE08Accident · No injuriesClosedPiper PA-28 · Littleton, COJul 15, 1972 · N5821U · Substantial damage NTSB DEN73DTE06Accident · Minor injuriesClosedPiper PA-22 · Monument, COJul 15, 1972 · N6828D · Substantial damage NTSB DEN73AD002Accident · 1 fatalClosedCessna T210L · Monument, COJul 15, 1972 · N8269M · Destroyed