Skip to content

NTSB investigations, 1974, WY

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 DEN75FTC12Accident · Minor injuriesClosedCessna 182 · Gillette, WYDec 16, 1974 · N3087Q · Substantial damage NTSB DEN75FTC11Accident · No injuriesClosedPiper PA-18 · Casper, WYDec 2, 1974 · N2154A · Substantial damage NTSB DEN75DTC10Accident · No injuriesClosedPiper PA-18 · Rock Springs, WYNov 28, 1974 · N1379A · Substantial damage NTSB DEN75AD011Accident · 1 fatalClosedCessna 310 · Rawlins, WYSep 12, 1974 · N7643Q · Destroyed NTSB DEN75FTC09Accident · No injuriesClosedPiper PA-28 · Rawlins, WYAug 28, 1974 · N427AS · Substantial damage NTSB DEN75AD006Accident · Minor injuriesClosedHiller Acft FH1100 · Pinedale, WYAug 28, 1974 · N8673 · Substantial damage NTSB DEN75FTC07Accident · Serious injuriesClosedPiper PA-28 · Yellowstone, WYAug 18, 1974 · N15276 · Destroyed NTSB DEN75DTC08Accident · No injuriesClosedCessna 172 · Sheridan, WYAug 15, 1974 · N13774 · Substantial damage NTSB DEN75DTC06Accident · No injuriesClosedCessna 170 · Gillette, WYAug 14, 1974 · N2618D · Substantial damage NTSB DEN75FTC05Accident · No injuriesClosedMooney M20C · Sheridan, WYAug 5, 1974 · N6874U · Substantial damage NTSB DEN75DTC02Accident · No injuriesClosedCessna 120 · Douglas, WYJul 10, 1974 · N1749N · Substantial damage NTSB DEN75FTC01Accident · Serious injuriesClosedPiper PA-25 · Wheatland, WYJul 6, 1974 · N7230Z · Destroyed NTSB DEN75DTC03Accident · No injuriesClosedMaule M-4 · Gillette, WYJul 4, 1974 · N2054U · Substantial damage NTSB DEN74DTC41Accident · No injuriesClosedCessna 401 · Saratoga, WYJun 30, 1974 · N3208Q · Substantial damage NTSB DEN74DTC42Accident · Minor injuriesClosedPiper PA-22 · Rock Springs, WYJun 29, 1974 · N2855P · Substantial damage NTSB DEN74DTC40Accident · Minor injuriesClosedChampion 7GCBC · Lingle, WYJun 28, 1974 · N5138X · Substantial damage NTSB DEN74DTC39Accident · Minor injuriesClosedHughes 269A · Douglas, WYJun 22, 1974 · N8859F · Substantial damage NTSB DEN74AD058Accident · 2 fatalClosedCessna 170A · Dubois, WYJun 18, 1974 · N5787C · Destroyed NTSB DEN74DTC38Accident · No injuriesClosedPiper PA-18 · Laramie, WYJun 13, 1974 · N7190D · Substantial damage NTSB DEN74FTC37Accident · Serious injuriesClosedErco 415-C · Casper, WYJun 12, 1974 · N2803H · Substantial damage NTSB DEN74DTC36Accident · No injuriesClosedAlon A-2 · Rawlins, WYJun 11, 1974 · N5990F · Substantial damage NTSB DEN74AD057Accident · 4 fatalClosedPiper PA-28R · Laramie, WYJun 8, 1974 · N15418 · Destroyed NTSB DEN74AD055Accident · 2 fatalClosedPiper PA-18 · Bill, WYMay 26, 1974 · N8238P · Destroyed NTSB DEN74DTC35Accident · No injuriesClosedCessna 180 · Saratoga, WYMay 23, 1974 · N52032 · Substantial damage NTSB DEN74DTC34Accident · No injuriesClosedCessna 182J · Wheatland, WYMay 18, 1974 · N3155F · Substantial damage NTSB DEN74DTC33Accident · No injuriesClosedCessna 150L · Riverton, WYMay 6, 1974 · N10950 · Substantial damage NTSB DEN74DTC32Accident · No injuriesClosedCessna 421B · Jeffrey City, WYApr 26, 1974 · N5962M · Substantial damage NTSB DEN74FTC31Accident · Minor injuriesClosedAmer Avco AA5 · Cheyenne, WYApr 16, 1974 · N5474L · Substantial damage NTSB DEN74AD050Accident · Minor injuriesClosedBeech E18S · Cheyenne, WYApr 12, 1974 · N40K · Destroyed NTSB DEN74AD046Accident · No injuriesClosedBeech 95-B55 · Lander, WYMar 25, 1974 · N7700N · Substantial damage NTSB DEN74DTC29Accident · No injuriesClosedMaule M4220C · Gillette, WYMar 6, 1974 · N2080 · Substantial damage NTSB DEN74DTC28Accident · No injuriesClosedCessna 182L · Cheyenne, WYMar 2, 1974 · N3439R · Substantial damage NTSB DEN74DTC27Accident · No injuriesClosedWaco RNF · Gillette, WYFeb 18, 1974 · N613Y · Substantial damage NTSB DEN74FTC25Accident · No injuriesClosedCessna 172 · Pt.Of Rocks, WYFeb 16, 1974 · N8638U · Substantial damage NTSB DEN74FTC24Accident · No injuriesClosedCessna 180H · Lander, WYJan 30, 1974 · N2461F · Substantial damage NTSB DEN74DTC23Accident · No injuriesClosedCessna 172G · Newcastle, WYJan 13, 1974 · N3730L · Substantial damage NTSB DEN74AD033Accident · Serious injuriesClosedConvair 580 · Cheyenne, WYJan 13, 1974 · N73145 · No damage