Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 DEN69A0029Accident · 2 fatalClosedCessna 310C · Rock Springs, WYDec 25, 1968 · N1872H · Destroyed NTSB DEN69D0164Accident · No injuriesClosedPiper PA-24 · Alpine, WYDec 1, 1968 · N8571P · Substantial damage NTSB DEN69A0023Accident · 1 fatalClosedPiper PA-23 · Cheyenne, WYNov 13, 1968 · N4877P · Destroyed NTSB DEN69D0136Accident · Minor injuriesClosedZalewski Mong · Rock Sprgs, WYOct 30, 1968 · N4955E · Substantial damage NTSB DEN69F0135Accident · No injuriesClosedCessna 172 · Laramie, WYOct 25, 1968 · N7909B · Substantial damage NTSB DEN69A0021Accident · 2 fatalClosedChampion 7GCBC · Osage, WYOct 22, 1968 · N5131T · Destroyed NTSB DEN69D0159Accident · No injuriesClosedCessna 172 · Hulett, WYOct 11, 1968 · N8214B · Substantial damage NTSB DEN69D0140Accident · No injuriesClosedCessna 172 · Gillette, WYOct 7, 1968 · N1638F · Substantial damage NTSB DEN69A0016Accident · 2 fatalClosedBeech A35 · Edgerton, WYOct 6, 1968 · N8770A · Destroyed NTSB DEN69D0134Accident · No injuriesClosedPiper PA-18 · Gillette, WYSep 30, 1968 · N7573K · Substantial damage NTSB DEN69D0108Accident · No injuriesClosedCessna 150 · Laramie, WYSep 30, 1968 · N2955J · Substantial damage NTSB DEN69A0012Accident · 1 fatalClosedInterstate S-1A · Bitter Creek, WYSep 16, 1968 · N37455 · 2 aircraft · Destroyed NTSB DEN69D0081Accident · No injuriesClosedPiper PA-18 · Buffalo, WYAug 27, 1968 · N8109Y · Substantial damage NTSB DEN69D0080Accident · No injuriesClosedNavion B · Cheyenne, WYAug 23, 1968 · N5334K · Substantial damage NTSB DEN69D0076Accident · No injuriesClosedChampion 7FC · Wheatland, WYAug 19, 1968 · N8512E · Substantial damage NTSB DEN69D0120Accident · No injuriesClosedCessna 182 · Casper, WYAug 15, 1968 · N9993T · Substantial damage NTSB DEN69D0073Accident · No injuriesClosedCessna 140 · Grass Creek, WYAug 14, 1968 · N5686C · Substantial damage NTSB DEN69A0008Accident · 3 fatalClosedPiper PA-28 · Wheatland, WYAug 10, 1968 · N7151W · Destroyed NTSB DEN69A0007Accident · 2 fatalClosedCessna 180 · Casper, WYAug 9, 1968 · N4794B · Destroyed NTSB DEN69D0071Accident · No injuriesClosedBell 47G3B1 · Dubois, WYAug 4, 1968 · N8471E · Substantial damage NTSB DEN69A0005Accident · 6 fatalClosedBeech K35 · Rock River, WYAug 1, 1968 · N3069C · 2 aircraft · Destroyed NTSB DEN69D0070Accident · No injuriesClosedLuscombe T-8F · Rock Springs, WYJul 31, 1968 · N1859B · Substantial damage NTSB DEN69D0072Accident · No injuriesClosedPiper PA-23 · Jackson, WYJul 28, 1968 · N690B · Substantial damage NTSB DEN69D0056Accident · No injuriesClosedHughes 269B · Buffalo, WYJul 25, 1968 · N9460F · Substantial damage NTSB DEN69F0057Accident · No injuriesClosedPiper PA-18A · Yoder, WYJul 9, 1968 · N9850D · Substantial damage NTSB DEN69D0042Accident · Minor injuriesClosedPiper PA-28 · Jackson, WYJul 5, 1968 · N5668W · Substantial damage NTSB DEN69D0029Accident · No injuriesClosedBeech V35 · Buffalo, WYJun 19, 1968 · N118V · Substantial damage NTSB DEN68A0056Accident · 2 fatalClosedCessna 182 · Thermopolis, WYJun 8, 1968 · N3195Q · Destroyed NTSB DEN69F0028Accident · 1 fatalClosedBoeing E75 · Cody, WYJun 7, 1968 · N66305 · Destroyed NTSB DEN69F0010Accident · No injuriesClosedBell 47G-3B · Baggs, WYJun 6, 1968 · N8532F · Substantial damage NTSB DEN68D0262Accident · No injuriesClosedCessna 182 · Alpine, WYMay 15, 1968 · N5686B · Substantial damage NTSB DEN68F0268Accident · Serious injuriesClosedMooney M20E · Alcova, WYMay 9, 1968 · N9238M · Destroyed NTSB DEN68F0269Accident · Serious injuriesClosedCessna 170B · Cheyenne, WYApr 28, 1968 · N4660C · Substantial damage NTSB DEN68A0047Accident · No injuriesClosedBeech E18S · Cheyenne, WYApr 22, 1968 · N40K · Substantial damage NTSB DEN68F0233Accident · No injuriesClosedCessna 150 · Cheyenne, WYApr 13, 1968 · N23098 · Substantial damage NTSB DEN68A0045Accident · 1 fatalClosedBeech V35 · Kemmerer, WYApr 11, 1968 · N4818J · Destroyed NTSB DEN68D0232Accident · No injuriesClosedHughes 269A · Fox Park, WYApr 4, 1968 · N8891F · Substantial damage NTSB DEN68F0221Accident · 1 fatalClosedPiper PA-32 · Douglas, WYFeb 26, 1968 · N4090W · Destroyed NTSB DEN68D0231Accident · Minor injuriesClosedPiper PA-22 · Glendo, WYFeb 24, 1968 · N1668A · Substantial damage NTSB DEN68D0210Accident · No injuriesClosedPiper PA-18 · Buffalo, WYFeb 8, 1968 · N1668P · Substantial damage NTSB DEN68D0209Accident · No injuriesClosedChampion 7GCBC · Powell, WYFeb 6, 1968 · N8363V · Substantial damage NTSB DEN68A0035Accident · No injuriesClosedBell 47G-3 · Yellowstone P, WYFeb 3, 1968 · N8416E · Substantial damage NTSB DEN68D0205Accident · No injuriesClosedCessna 170 · Medicine Bow, WYJan 27, 1968 · N2742D · Substantial damage NTSB DEN68A0034Accident · No injuriesClosedHughes 269B · Sundance, WYJan 26, 1968 · N9397F · Substantial damage NTSB DEN68D0204Accident · No injuriesClosedCessna 182 · Cowley, WYJan 17, 1968 · N8835T · Substantial damage NTSB DEN68D0181Accident · No injuriesClosedPiper PA-18A · Douglas, WYJan 6, 1968 · N474GF · Substantial damage NTSB DEN68D0214Accident · No injuriesClosedBeech T-34 · Crowheart, WYJan 4, 1968 · N6846D · Substantial damage