Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 DEN70A0037Accident · Serious injuriesClosedCessna 206 · Rawlins, WYDec 4, 1969 · N4973F · Substantial damage NTSB DEN70F0136Accident · No injuriesClosedBeech G-18-S · Laramie, WYOct 24, 1969 · N1500Z · Substantial damage NTSB DEN70F0143Accident · Serious injuriesClosedLockheed 402-2 · Midwest, WYSep 29, 1969 · N144U · Substantial damage NTSB DEN70F0108Accident · Minor injuriesClosedHughes 269B · Cheyenne, WYSep 29, 1969 · N9484F · Substantial damage NTSB DEN70D0122Accident · No injuriesClosedErco 415-C · Cody, WYSep 27, 1969 · N87080 · Substantial damage NTSB DEN70D0089Accident · No injuriesClosedPiper PA-18 · La Barge, WYSep 15, 1969 · N3477Z · Substantial damage NTSB DEN70D0130Accident · No injuriesClosedHughes 269B · Douglas, WYSep 13, 1969 · N9460F · Substantial damage NTSB DEN70F0121Accident · 2 fatalClosedConsolidatd P4Y-2 · Greybull, WYSep 3, 1969 · N1911H · Destroyed NTSB DEN70D0098Accident · No injuriesClosedBeech S35 · Rawlins, WYSep 3, 1969 · N5713K · Substantial damage NTSB DEN70A0017Accident · 1 fatalClosedBell 47G3B1 · Jackson, WYSep 3, 1969 · N73287 · Destroyed NTSB DEN70A0016Accident · Minor injuriesClosedConvair 240 · Encampment, WYSep 2, 1969 · N8410H · Substantial damage NTSB DEN70D0064Accident · No injuriesClosedBell 47G3B2 · Midwest, WYAug 18, 1969 · N1486W · Substantial damage NTSB DEN70D0076Accident · Minor injuriesClosedBeech T-34A · Fort Bridger, WYAug 16, 1969 · N7745C · Substantial damage NTSB DEN70F0088Accident · Serious injuriesClosedCessna 170 · Worland, WYAug 10, 1969 · N4242V · Destroyed NTSB DEN70D0047Accident · No injuriesClosedCessna 182 · Cody, WYAug 6, 1969 · N3483R · Substantial damage NTSB DEN70A0009Accident · No injuriesClosedCessna 180 · Gillette, WYAug 5, 1969 · N2327C · Substantial damage NTSB DEN70F0075Accident · No injuriesClosedBell 47G3B1 · Cheyenne, WYJul 27, 1969 · N8575F · Substantial damage NTSB DEN70D0087Accident · No injuriesClosedCulver V · Casper, WYJul 26, 1969 · N3130K · Destroyed NTSB DEN70F0077Accident · No injuriesClosedCessna 180 · Casper, WYJul 24, 1969 · N134H · Substantial damage NTSB DEN70F0046Accident · 1 fatalClosedPiper PA-18A · Slater, WYJul 13, 1969 · N7782D · Destroyed NTSB DEN70F0034Accident · 1 fatalClosedHiller UH-12E · Graybull, WYJul 10, 1969 · N5369V · Destroyed NTSB DEN70D0044Accident · No injuriesClosedBellanca 14-13 · Douglas, WYJul 5, 1969 · N568CD · Substantial damage NTSB DEN70D0040Accident · No injuriesClosedBell 47G-3B · Casper, WYJul 1, 1969 · N6225N · Substantial damage NTSB DEN70F0048Accident · Minor injuriesClosedNavion A · Medicine Bow, WYJun 27, 1969 · N4821K · Substantial damage NTSB DEN70D0029Accident · No injuriesClosedPiper PA-18 · Bosler, WYJun 27, 1969 · N3594P · Substantial damage NTSB DEN70D0028Accident · No injuriesClosedCessna 182 · Lusk, WYJun 25, 1969 · N8672T · Substantial damage NTSB DEN70F0045Accident · Serious injuriesClosedCessna 172 · Laramie, WYJun 20, 1969 · N7132A · Destroyed NTSB DEN70D0030Accident · No injuriesClosedPiper PA-22 · Rawlins, WYJun 17, 1969 · N3152Z · Substantial damage NTSB DEN70D0031Accident · No injuriesClosedPiper PA-18 · Deaver, WYJun 13, 1969 · N3293Z · Substantial damage NTSB DEN69A0050Accident · 2 fatalClosedBeech 95-55 · Lander, WYJun 13, 1969 · N1242Z · Destroyed NTSB DEN70D0026Accident · No injuriesClosedChampion 7KCAB · Cody, WYJun 6, 1969 · N16046 · Substantial damage NTSB DEN70D0027Accident · No injuriesClosedCessna 182 · Rozet, WYJun 3, 1969 · N3189Y · Substantial damage NTSB DEN70D0022Accident · No injuriesClosedCessna 180 · Pine Bluffs, WYMay 31, 1969 · N2904C · Substantial damage NTSB DEN69A0049Accident · 1 fatalClosedChampion 7GCAA · Jackson, WYMay 22, 1969 · N8381V · Destroyed NTSB DEN70D0015Accident · No injuriesClosedAero Comdr 100 · Farson, WYMay 21, 1969 · N2942T · Destroyed NTSB DEN70D0014Accident · Minor injuriesClosedTaylorcraft BC12-D · Lyman, WYMay 11, 1969 · N39916 · Substantial damage NTSB DEN69A0047Accident · Serious injuriesClosedLockheed 12A · Casper, WYMay 9, 1969 · N399X · Substantial damage NTSB DEN70F0039Accident · Serious injuriesClosedBoeing A-75 · Buffalo, WYMay 8, 1969 · N57445 · Substantial damage NTSB DEN70D0016Accident · No injuriesClosedPiper PA-22 · Cokeville, WYMay 4, 1969 · N8585C · Substantial damage NTSB DEN69D0239Accident · No injuriesClosedCessna 180H · Riverton, WYApr 24, 1969 · N91299 · Substantial damage NTSB DEN69F0247Accident · No injuriesClosedCessna 150F · Cheyenne, WYApr 20, 1969 · N8071F · Substantial damage NTSB DEN69F0240Accident · No injuriesClosedCessna 150 · Cheyenne, WYApr 20, 1969 · N23216 · Substantial damage NTSB DEN69D0236Accident · No injuriesClosedPiper PA-24 · Gillette, WYApr 19, 1969 · N8664P · Substantial damage NTSB DEN69D0221Accident · No injuriesClosedPiper PA-18 · Gillette, WYApr 3, 1969 · N9941D · Substantial damage NTSB DEN69D0207Accident · No injuriesClosedPiper J-3 · Greybull, WYMar 30, 1969 · N42581 · Substantial damage NTSB DEN69D0201Accident · No injuriesClosedCessna 182C · Casper, WYMar 26, 1969 · N8561T · Substantial damage NTSB DEN69D0213Accident · Minor injuriesClosedBell 47G3B1 · Albany, WYMar 25, 1969 · N73285 · Substantial damage NTSB DEN69A0039Accident · 2 fatalClosedHiller Acft FH1100 · Sinclair, WYMar 25, 1969 · N617 · Destroyed NTSB DEN69A0033Accident · 3 fatalClosedCessna 182L · Cheyenne, WYFeb 16, 1969 · N3334R · Destroyed NTSB DEN69D0178Accident · No injuriesClosedBeech D-17S · Cheyenne, WYFeb 13, 1969 · N1030 · Substantial damage