Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 DEN68D0177Accident · No injuriesClosedCessna 210 · Kemmerer, WYDec 27, 1967 · N3957Y · Substantial damage NTSB DEN68D0194Accident · No injuriesClosedPiper PA-18A · Gillette, WYDec 16, 1967 · N4594A · Substantial damage NTSB DEN68D0164Accident · No injuriesClosedCessna 180 · Casper, WYDec 9, 1967 · N3178D · Substantial damage NTSB DEN68D0163Accident · No injuriesClosedCessna 150 · Gillette, WYDec 5, 1967 · N8183F · Substantial damage NTSB DEN68D0165Accident · No injuriesClosedCessna 172 · Casper, WYNov 28, 1967 · N3901R · Substantial damage NTSB DEN68F0145Accident · Serious injuriesClosedPiper PA-24 · Rock Springs, WYNov 3, 1967 · N7356P · Destroyed NTSB DEN68D0133Accident · No injuriesClosedStinson 108-5 · Medicine Bow, WYOct 28, 1967 · N5576V · Substantial damage NTSB DEN68D0132Accident · No injuriesClosedPiper PA-18 · Riverton, WYOct 25, 1967 · N4152Z · Substantial damage NTSB DEN68D0131Accident · No injuriesClosedPiper J-3 · Edgerton, WYOct 21, 1967 · N71046 · Substantial damage NTSB DEN68F0120Accident · No injuriesClosedCessna 170 · Cody, WYOct 19, 1967 · N4242V · No damage NTSB DEN68D0125Accident · No injuriesClosedChampion 7GCB · Evanston, WYOct 16, 1967 · N9953Y · Substantial damage NTSB DEN68D0124Accident · Minor injuriesClosedCessna 150 · Casper, WYOct 15, 1967 · N4574U · Substantial damage NTSB DEN68D0103Accident · No injuriesClosedMooney M20B · Sundance, WYOct 3, 1967 · N74720 · Substantial damage NTSB DEN68D0099Accident · No injuriesClosedPiper PA-28 · Cheyenne, WYSep 20, 1967 · N4288J · Substantial damage NTSB DEN68F0101Accident · No injuriesClosedChampion 7GCBC · Buffalo, WYAug 23, 1967 · N6327N · Substantial damage NTSB DEN68D0100Accident · No injuriesClosedAeronca 7GCBC · Ten Sleep, WYAug 23, 1967 · N9698S · Substantial damage NTSB DEN68D0060Accident · No injuriesClosedCessna-Wren 460 · Buffalo, WYAug 19, 1967 · N7919R · Substantial damage NTSB DEN68D0070Accident · Minor injuriesClosedPiper PA-18 · Recluse, WYAug 18, 1967 · N7573K · Substantial damage NTSB DEN68D0064Accident · No injuriesClosedCessna 182 · Riverton, WYAug 18, 1967 · N8619T · Substantial damage NTSB DEN68F0080Accident · No injuriesClosedCessna 180 · Lander, WYAug 13, 1967 · N9122T · Substantial damage NTSB DEN68F0066Accident · No injuriesClosedCessna 411 · Worland, WYAug 3, 1967 · N7366U · Substantial damage NTSB DEN68D0065Accident · No injuriesClosedCessna 172 · Casper, WYAug 1, 1967 · N3901R · Substantial damage NTSB DEN68A0008Accident · 2 fatalClosedBell 47G3B1 · Bondurant, WYJul 27, 1967 · N8471E · Destroyed NTSB DEN68D0046Accident · No injuriesClosedPiper PA-18 · Midwest, WYJul 20, 1967 · N3770P · Substantial damage NTSB DEN68D0047Accident · No injuriesClosedPiper PA-11 · Sheridan, WYJul 11, 1967 · N5570H · Substantial damage NTSB DEN68F0045Accident · Minor injuriesClosedCallair A-9B · Fox Park, WYJul 10, 1967 · N7614V · Destroyed NTSB DEN68D0031Accident · No injuriesClosedCessna 180 · Moorcroft, WYJul 10, 1967 · N3335D · Substantial damage NTSB DEN68D0023Accident · No injuriesClosedPiper PA-18 · Garrett, WYJul 2, 1967 · N1851P · Substantial damage NTSB DEN68F0022Accident · No injuriesClosedBeech D18S · Cheyenne, WYJun 28, 1967 · N631B · Substantial damage NTSB DEN67A0081Accident · 2 fatalClosedPiper PA-18 · Arminto, WYJun 24, 1967 · N3470Z · Destroyed NTSB DEN67A0079Accident · No injuriesClosedHiller UH-12E · Lovell, WYJun 10, 1967 · N90474 · Substantial damage NTSB DEN68F0001Accident · No injuriesClosedBeech C-45 · Saratoga, WYMay 26, 1967 · N9846Z · Substantial damage NTSB DEN67A0072Accident · 1 fatalClosedGrumman TBM3E · Upton, WYMay 23, 1967 · N6823C · Destroyed NTSB DEN67A0070Accident · No injuriesClosedKaman H43-A · Lander, WYMay 17, 1967 · N2856J · Substantial damage NTSB DEN67D0268Accident · No injuriesClosedPiper PA-18 · Gillette, WYMay 3, 1967 · N3578P · Substantial damage NTSB DEN67D0283Accident · No injuriesClosedPiper PA-28 · Wheatland, WYApr 27, 1967 · N9773J · Substantial damage NTSB DEN67D0250Accident · No injuriesClosedCessna 140 · Burns, WYApr 15, 1967 · N5388C · Substantial damage NTSB DEN67A0064Accident · No injuriesClosedBeech 65-90 · Alcova, WYApr 12, 1967 · N827T · Substantial damage NTSB DEN67D0259Accident · No injuriesClosedPiper PA-18 · Arvada, WYApr 8, 1967 · N7573K · Substantial damage NTSB DEN67D0247Accident · No injuriesClosedChampion 7GCAA · Gilette, WYApr 7, 1967 · N5115T · Substantial damage NTSB DEN67D0248Accident · No injuriesClosedCessna 182C · Lander, WYApr 5, 1967 · N8941T · Substantial damage NTSB DEN67D0249Accident · No injuriesClosedMooney M20A · Wheatland, WYApr 1, 1967 · N6064X · Substantial damage NTSB DEN68F0087Accident · No injuriesClosedBeech H35 · Sheridan, WYMar 31, 1967 · N7951D · Substantial damage NTSB DEN67A0059Accident · Serious injuriesClosedBoeing B-720 · Sheridan, WYMar 29, 1967 · N7220U · Minor damage NTSB DEN67F0261Accident · Minor injuriesClosedCessna 172 · Cheyenne, WYMar 27, 1967 · N8865U · Substantial damage NTSB DEN67D0236Accident · No injuriesClosedCessna 172B · Powell, WYMar 26, 1967 · N8222A · Substantial damage NTSB DEN67A0052Accident · Minor injuriesClosedBell 47G3B1 · Cody, WYMar 10, 1967 · N8537F · Destroyed NTSB DEN67D0237Accident · No injuriesClosedInterstate S-1A · Afton, WYMar 7, 1967 · N37307 · Substantial damage NTSB DEN67F0233Accident · No injuriesClosedBeech 35 · Cheyenne, WYMar 2, 1967 · N444V · Substantial damage NTSB DEN67D0234Accident · No injuriesClosedChampion 7GCBC · Gillette, WYFeb 28, 1967 · N8363V · Substantial damage