Skip to content

NTSB investigations, 1978, WY

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 DEN79FTC05Accident · 1 fatalClosedCessna 172 · Rawlings, WYDec 17, 1978 · N7015A · Destroyed NTSB DEN79DTC04Accident · No injuriesClosedCessna 172 · Cheyenne, WYNov 28, 1978 · C-GZDD · Substantial damage NTSB DEN79FTC03Accident · No injuriesClosedBellanca 7GCBC · Laramie, WYNov 11, 1978 · N8802 · Substantial damage NTSB DEN79FA007Accident · 4 fatalClosedGrum-Amer AA-5B · Meeteetse, WYNov 8, 1978 · N28406 · Destroyed NTSB DEN79FTC01Accident · No injuriesClosedCessna 310P · Pinedale, WYOct 26, 1978 · N5752M · Substantial damage NTSB DEN78DTC39Accident · No injuriesClosedCessna 180 · Jackson, WYSep 16, 1978 · N1624C · Substantial damage NTSB DEN78FTC38Accident · No injuriesClosedPiper PA-18 · Casper, WYAug 29, 1978 · N82727 · Substantial damage NTSB DEN78FTC37Accident · No injuriesClosedCessna 170 · Douglas, WYAug 25, 1978 · N3475 · Substantial damage NTSB DEN78FTC36Accident · No injuriesClosedCessna 185F · Cheyenne, WYAug 15, 1978 · N3RS · Substantial damage NTSB DEN78FA060Accident · 2 fatalClosedPiper PA-28 · Edgerton, WYAug 14, 1978 · N40439 · Destroyed NTSB DEN78FTC35Accident · Serious injuriesClosedDyke Delta JD11 · Ft.Bridger, WYAug 5, 1978 · N99DD · Substantial damage NTSB DEN78FTC34Accident · No injuriesClosedHughes 269C · Douglas, WYAug 5, 1978 · N9682F · Destroyed NTSB DEN78FA055Accident · Serious injuriesClosedCessna 340 · Riverton, WYJul 30, 1978 · N1381G · Destroyed NTSB DEN78FTC33Accident · No injuriesClosedCessna 152 · Gillette, WYJul 23, 1978 · N67417 · Substantial damage NTSB DEN78DTC32Accident · No injuriesClosedCessna 140 · Evanston, WYJul 23, 1978 · N76495 · Substantial damage NTSB DEN78FA053Accident · 1 fatalClosedCessna TU206 · Canyon, WYJul 3, 1978 · N8478Q · Destroyed NTSB DEN78FTC29Accident · Serious injuriesClosedCessna 182 · Tipton, WYJun 28, 1978 · N3559F · Substantial damage NTSB DEN78DTC28Accident · No injuriesClosedCessna 170B · Rock Springs, WYJun 28, 1978 · N2619D · Substantial damage NTSB DEN78FTC30Accident · No injuriesClosedPiper PA-28 · Casper, WYJun 25, 1978 · N4151J · Substantial damage NTSB DEN78FTC27Accident · No injuriesClosedGrum Amer AA-5A · Evanston, WYJun 25, 1978 · N9568U · Substantial damage NTSB DEN78DTC31Accident · No injuriesClosedGrumman AA-5 · Rawlins, WYJun 25, 1978 · N7130L · Substantial damage NTSB DEN78DTC26Accident · Minor injuriesClosedPiper PA-25 · Saratoga, WYJun 23, 1978 · N8635U · Substantial damage NTSB DEN78FTM25Accident · Minor injuriesClosedAerospatial SA315B · Evanston, WYJun 22, 1978 · N218RM · Substantial damage NTSB DEN78FTC25Accident · No injuriesClosedCessna 185 · Lander, WYJun 17, 1978 · N1QE · Substantial damage NTSB DEN78FTC24Accident · No injuriesClosedBeech V35 · Jackson Hole, WYJun 11, 1978 · N4856J · Substantial damage NTSB DEN78FA049Accident · 3 fatalClosedFairchild C-119G · Greybull, WYJun 10, 1978 · N3560 · Substantial damage NTSB DEN78FA047Accident · 2 fatalClosedBellanca 8KCAB · Green River, WYJun 8, 1978 · N777DW · Substantial damage NTSB DEN78FA045Accident · Serious injuriesClosedBoeing 737 · Cheyenne, WYMay 30, 1978 · N4518W · Minor damage NTSB DEN78FTC23Accident · No injuriesClosedPiper PA-28 · Yellowstone Pk, WYMay 28, 1978 · N54471 · Substantial damage NTSB DEN78FTC22Accident · Serious injuriesClosedBell 206B · Kemmerer, WYMay 15, 1978 · N4066G · Substantial damage NTSB DEN78FA040Accident · 4 fatalClosedBeech D50C · Wheatland, WYMay 4, 1978 · N320Z · Destroyed NTSB DEN78FTC21Accident · Minor injuriesClosedPiper PA-22 · Ulm, WYApr 23, 1978 · N3267Z · Substantial damage NTSB DEN78FTC20Accident · No injuriesClosedPiper PA-34 · Cheyenne, WYApr 4, 1978 · N6646F · Substantial damage NTSB DEN78FTC19Accident · No injuriesClosedBeech D35 · Douglas, WYMar 30, 1978 · N3447B · Substantial damage NTSB DEN78DTC18Accident · No injuriesClosedPiper PA-18 · Worland, WYMar 30, 1978 · N1879P · Substantial damage NTSB DEN78FTC17Accident · 1 fatalClosedCessna 172 · Alta, WYMar 18, 1978 · N25435 · Destroyed NTSB DEN78FTC16Accident · No injuriesClosedCessna 177 · Rock Springs, WYMar 10, 1978 · N35181 · Substantial damage NTSB DEN78DTC15Accident · Minor injuriesClosedHughes 269B · Douglas, WYMar 3, 1978 · N9427F · Substantial damage NTSB DEN78FA027Accident · 6 fatalClosedBeech A90 · Big Piney, WYFeb 27, 1978 · N878T · Destroyed NTSB DEN78FTC13Accident · No injuriesClosedCessna 172N · Pinedale, WYFeb 26, 1978 · N13604 · Substantial damage NTSB DEN78DTC14Accident · Minor injuriesClosedGrum Amer AA1A · Laramie, WYFeb 26, 1978 · N9472L · Substantial damage NTSB DEN78FA024Accident · 6 fatalClosedAero Comdr 560A · Glenrock, WYFeb 19, 1978 · N2639B · Destroyed NTSB DEN78DTC12Accident · No injuriesClosedCessna 152 · Cheyenne, WYFeb 13, 1978 · N25444 · Substantial damage NTSB DEN78DTC11Accident · No injuriesClosedBellanca 7GCBC · Casper, WYJan 7, 1978 · N1813 · Substantial damage NTSB DEN78FTC10Accident · No injuriesClosedCessna 182P · Buffalo, WYJan 3, 1978 · N52974 · Substantial damage