Skip to content

NTSB investigations, 1975, WY

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

19642026

NTSB investigations, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 DEN76FTC22Accident · Serious injuriesClosedPiper J-3 · Gillette, WYDec 13, 1975 · N98698 · Substantial damage NTSB DEN76FTC21Accident · No injuriesClosedCessna 172C · Casper, WYDec 4, 1975 · N1432Y · Substantial damage NTSB DEN76FTC20Accident · No injuriesClosedPiper PA-18 · Casper, WYNov 12, 1975 · N4498Z · Substantial damage NTSB DEN76DTC19Accident · No injuriesClosedGrum Amer AA5 · Fort Bridger, WYNov 1, 1975 · N7198L · Substantial damage NTSB DEN76DTC18Accident · No injuriesClosedCessna 180 · Kaycee, WYOct 9, 1975 · N7944V · Substantial damage NTSB DEN76FTC17Accident · Serious injuriesClosedBeech 95-C55 · Four Corners, WYOct 8, 1975 · N2787T · Substantial damage NTSB DEN76DTC16Accident · No injuriesClosedAerospatle SA315B · Jackson, WYSep 20, 1975 · N6390 · Substantial damage NTSB DEN7LAD017Accident · 1 fatalClosedAmer Avco AA1-A · Rawlins, WYSep 17, 1975 · N6360L · Destroyed NTSB DEN7LDTC15Accident · No injuriesClosedPiper PA-32 · Saratoga, WYSep 13, 1975 · N4185R · Substantial damage NTSB DEN7LFTC14Accident · No injuriesClosedBeech S35 · Laramie, WYSep 7, 1975 · N8651Q · Substantial damage NTSB DEN76DTC13Accident · No injuriesClosedChampion 7ECA · Gillette, WYSep 3, 1975 · N1628G · Substantial damage NTSB DEN7LFTC11Accident · Minor injuriesClosedCessna T210 · Riverton, WYAug 26, 1975 · N6850R · Destroyed NTSB DEN76DTC10Accident · No injuriesClosedCessna 180 · Wheatland, WYAug 6, 1975 · N3657C · Substantial damage NTSB DEN76FTC08Accident · Minor injuriesClosedMooney M20G · Douglas, WYAug 4, 1975 · N3967N · Substantial damage NTSB DEN76DTC09Accident · No injuriesClosedCessna 185A · Casper, WYAug 3, 1975 · N101LL · Substantial damage NTSB DEN7LFTC07Accident · Serious injuriesClosedSmith Mini · Casper, WYAug 2, 1975 · N412T · Destroyed NTSB DEN7LFTC06Accident · Serious injuriesClosedNavion A · Cheyenne, WYJul 31, 1975 · N91449 · Substantial damage NTSB DEN76DTC05Accident · No injuriesClosedCessna 170 · Newcastle, WYJul 25, 1975 · N8127A · Destroyed NTSB DEN76FTC03Accident · No injuriesClosedBeech A60 · Afton, WYJul 15, 1975 · N8RH · Substantial damage NTSB DEN76FTC02Accident · Minor injuriesClosedHiller Acft UH12L4 · Wapiti, WYJul 11, 1975 · N9727C · Destroyed NTSB DEN76DTC01Accident · No injuriesClosedCessna 172 · Laramie, WYJul 11, 1975 · N12699 · Substantial damage NTSB DEN75DTC28Accident · No injuriesClosedPiper PA-18 · Jackson Hole, WYJun 23, 1975 · N3882Z · Substantial damage NTSB DEN76FTC04Accident · No injuriesClosedCessna 180 · Sun Ranch, WYJun 19, 1975 · N5163E · Substantial damage NTSB DEN75DTC27Accident · No injuriesClosedCessna 177 · Laramie, WYJun 15, 1975 · N3159T · Substantial damage NTSB DEN75DTC26Accident · Minor injuriesClosedPiper PA-18 · Gillette, WYJun 13, 1975 · N1255A · Substantial damage NTSB DEN75FTC29Accident · 1 fatalClosedCessna A188 · Wheatland, WYJun 2, 1975 · N8139V · Destroyed NTSB DEN75FTC25Accident · No injuriesClosedCessna 182K · Casper, WYMay 24, 1975 · N3100R · Substantial damage NTSB DEN75DTC24Accident · No injuriesClosedPiper PA-18 · Lander, WYMay 18, 1975 · N472GF · Substantial damage NTSB DEN75FTC23Accident · No injuriesClosedPiper PA-22 · Rawlins, WYMay 12, 1975 · N7546D · Substantial damage NTSB DEN75DTC22Accident · No injuriesClosedPiper PA-18 · Shell, WYMay 9, 1975 · N4069Z · Substantial damage NTSB DEN75DTC21Accident · No injuriesClosedPiper PA-18 · Cassa, WYMay 3, 1975 · N2873P · Substantial damage NTSB DEN75FTC20Accident · No injuriesClosedBellanca 17-30 · Sinclair, WYApr 30, 1975 · N7394V · Substantial damage NTSB DEN75FTC19Accident · No injuriesClosedCessna 180 · Jackson, WYApr 25, 1975 · N8817 · Substantial damage NTSB DEN75AD053Accident · 1 fatalClosedPiper PA-18 · Rock Springs, WYApr 15, 1975 · N13833 · Destroyed NTSB DEN75DTC18Accident · No injuriesClosedPiper PA-18 · Douglas, WYApr 7, 1975 · N7153K · Substantial damage NTSB DEN75AD050Accident · Serious injuriesClosedBoeing 737 · Casper, WYMar 31, 1975 · N4527W · Substantial damage NTSB DEN75FTC17Accident · No injuriesClosedPiper PA-22 · Sundance, WYMar 16, 1975 · N5863D · Substantial damage NTSB DEN75FTC16Accident · No injuriesClosedCessna 180H · Gillette, WYMar 15, 1975 · N9068M · Substantial damage NTSB DEN75FTC15Accident · Serious injuriesClosedPiper PA-18A · Wamsutter, WYMar 12, 1975 · N2599P · Substantial damage NTSB DEN75FTC14Accident · No injuriesClosedCessna 120 · Cheyenne, WYMar 2, 1975 · N2838N · Substantial damage NTSB DEN75FTC13Accident · No injuriesClosedCessna 182 · Casper, WYJan 5, 1975 · N7197E · Substantial damage NTSB DEN75AD037Accident · 1 fatalClosedMooney M20A · Rock Springs, WYJan 5, 1975 · N8124E · Destroyed