Skip to content

NTSB investigations, 1972, WY

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

19642026

NTSB investigations, 1972, WY per year, 1964–2026: 1,568 cases
1964	47
1965	52
1966	50
1967	55
1968	47
1969	53
1970	42
1971	34
1972	38
1973	45
1974	37
1975	42
1976	38
1977	48
1978	45
1979	34
1980	43
1981	40
1982	47
1983	44
1984	32
1985	20
1986	31
1987	16
1988	22
1989	14
1990	18
1991	21
1992	18
1993	24
1994	24
1995	15
1996	16
1997	12
1998	21
1999	21
2000	20
2001	17
2002	16
2003	19
2004	16
2005	17
2006	13
2007	13
2008	18
2009	4
2010	9
2011	26
2012	18
2013	15
2014	11
2015	14
2016	10
2017	11
2018	13
2019	11
2020	9
2021	5
2022	13
2023	6
2024	16
2025	9
2026	13

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" = 'WY' 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\" = 'WY' 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" = 'WY' 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 DEN73DTC15Accident · No injuriesClosedPiper PA-28 · Lamont, WYDec 23, 1972 · N8185N · Substantial damage NTSB DEN73DTC14Accident · No injuriesClosedPiper PA-28 · Cheyenne, WYDec 17, 1972 · N470FL · Substantial damage NTSB DEN73FTC13Accident · No injuriesClosedPiper PA-30 · Riverton, WYDec 14, 1972 · N7657Y · Substantial damage NTSB DEN73ADO24Accident · 1 fatalClosedLuscombe 8A · Cody, WYNov 23, 1972 · N28409 · Destroyed NTSB DEN73AD023Accident · 1 fatalClosedPiper PA-24 · Cheyenne, WYNov 19, 1972 · N6944P · Destroyed NTSB DEN73DTC12Accident · No injuriesClosedCessna 170B · Hanna, WYNov 1, 1972 · N7681 · Substantial damage NTSB DEN73FTC11Accident · Minor injuriesClosedCessna T210F · Cheyenne, WYOct 13, 1972 · N6185R · Destroyed NTSB DEN73DTC10Accident · No injuriesClosedCessna 180B · Glendo, WYOct 11, 1972 · N9122T · Substantial damage NTSB DEN73DTC09Accident · No injuriesClosedPiper PA-18 · Kaycee, WYSep 26, 1972 · N3086Z · Substantial damage NTSB DEN73AD013Accident · 1 fatalClosedCessna 170A · Midwest, WYSep 25, 1972 · N1253D · Destroyed NTSB DEN73AD007Accident · 3 fatalClosedCessna 180 · Casper, WYAug 18, 1972 · N3354D · Destroyed NTSB DEN73FTC07Accident · No injuriesClosedBeech A23-24 · Casper, WYAug 14, 1972 · N7994L · Substantial damage NTSB DEN73DTC06Accident · No injuriesClosedMaule M4220C · Jackson, WYAug 12, 1972 · N40331 · Substantial damage NTSB DEN73FTC05Accident · Serious injuriesClosedAlouette III · Greybull, WYAug 8, 1972 · N6874 · Substantial damage NTSB DEN73FTC04Accident · No injuriesClosedHughes 269B · Buffalo, WYAug 5, 1972 · N9460F · Destroyed NTSB DEN73DTC03Accident · Minor injuriesClosedPiper PA-24 · Cheyenne, WYJul 30, 1972 · N5505P · Substantial damage NTSB DEN73FTC01Accident · Serious injuriesClosedPiper PA-22 · Casper, WYJul 15, 1972 · N3603Z · Substantial damage NTSB DEN72DTC28Accident · Minor injuriesClosedCessna TP206D · Wheatland, WYJun 23, 1972 · N8777Z · Substantial damage NTSB DEN72DTC29Accident · No injuriesClosedCessna 170A · Burns, WYJun 16, 1972 · N1746D · Substantial damage NTSB DEN72DTC27Accident · No injuriesClosedPiper PA-18 · Clark, WYJun 13, 1972 · N3954Z · Substantial damage NTSB DEN72DTC26Accident · Minor injuriesClosedCessna 150L · Hillsdale, WYMay 27, 1972 · N6726G · Substantial damage NTSB DEN72DTC25Accident · Minor injuriesClosedPiper PA22 · Glenrock, WYMay 26, 1972 · N7513D · Substantial damage NTSB DEN72DTC24Accident · No injuriesClosedPiper PA-24 · Grass Creek, WYMay 15, 1972 · N6944P · Substantial damage NTSB DEN72FTC23Accident · No injuriesClosedFairchild M-62C · Rock Springs, WYMay 14, 1972 · N52221 · Substantial damage NTSB DEN72AD053Accident · 2 fatalClosedPiper PA-30 · Rawlins, WYMay 11, 1972 · N8654Y · Destroyed NTSB DEN72AD045Accident · 7 fatalClosedBeech C-18S · Mcfadden, WYApr 2, 1972 · N1322M · Destroyed NTSB DEN72AD044Accident · 1 fatalClosedMooney M20A · Lander, WYApr 1, 1972 · N6041X · Destroyed NTSB DEN72DTC22Accident · Minor injuriesClosedPiper PA-28R · Gillette, WYMar 25, 1972 · N2120T · Substantial damage NTSB DEN72ADO43Accident · 1 fatalClosedCessna 180H · Medicine Bow, WYMar 20, 1972 · N9050M · Destroyed NTSB DEN72DTC21Accident · Serious injuriesClosedAeronca 15AC · Gillette, WYMar 19, 1972 · N1453H · Substantial damage NTSB DEN72DTC20Accident · No injuriesClosedCessna U206 · Rawlins, WYMar 6, 1972 · N5210U · Substantial damage NTSB DEN72AD039Accident · 1 fatalClosedPiper PA-24 · Jackson, WYFeb 29, 1972 · N8978P · Destroyed NTSB DEN72DTC19Accident · No injuriesClosedPiper PA-18 · Rock Springs, WYFeb 22, 1972 · N1106A · Substantial damage NTSB DEN72DTC18Accident · No injuriesClosedCessna 180D · Cheyenne, WYFeb 19, 1972 · N6452X · Substantial damage NTSB DEN72DTC17Accident · No injuriesClosedPiper PA-18 · Yellowstn Prk, WYJan 29, 1972 · N3293Z · Substantial damage NTSB DEN72DTC16Accident · No injuriesClosedCessna 172A · Cheyenne, WYJan 28, 1972 · N9725T · Substantial damage NTSB DEN72DTC15Accident · No injuriesClosedPiper PA-18 · Dayton, WYJan 17, 1972 · N3989P · Substantial damage NTSB DEN72DTC14Accident · No injuriesClosedCessna 172 · Evanston, WYJan 9, 1972 · N3245G · Substantial damage