Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 DEN71AD028Accident · 1 fatalClosedCessna T310P · Cheyenne, WYDec 18, 1970 · N5810M · Destroyed NTSB DEN71AD026Accident · Serious injuriesClosedLockheed TV-2 · Cheyenne, WYDec 4, 1970 · N156 · Destroyed NTSB DEN71FXA14Accident · No injuriesClosedCessna U206 · Casper, WYNov 25, 1970 · N5123U · Substantial damage NTSB DEN71FXA13Accident · No injuriesClosedMooney M20E · Chugwater, WYOct 26, 1970 · N2725W · Substantial damage NTSB DEN71AD016Accident · 5 fatalClosedPiper PA-32 · Douglas, WYOct 10, 1970 · N4796S · Destroyed NTSB DEN71AD015Accident · 2 fatalClosedBeech B35 · Evanston, WYOct 6, 1970 · N8817A · Destroyed NTSB DEN71DXA12Accident · No injuriesClosedPiper PA-18 · Shell, WYOct 5, 1970 · N4227Z · Substantial damage NTSB DEN71FXA11Accident · No injuriesClosedCessna TP206 · Wallcott, WYOct 2, 1970 · N8670Z · Substantial damage NTSB DEN71FXA10Accident · Minor injuriesClosedCessna 182E · Rock Springs, WYSep 23, 1970 · N3189Y · Substantial damage NTSB DEN71FXT10Accident · No injuriesClosedPiper PA-20 · Evanston, WYSep 15, 1970 · N7414K · Substantial damage NTSB DEN71DAZ09Accident · No injuriesClosedHelio Acft H-295 · Rock Springs, WYSep 2, 1970 · N6327V · Substantial damage NTSB DEN71DXA08Accident · No injuriesClosedPiper PA-28 · Fort Laramie, WYAug 29, 1970 · N6113W · Substantial damage NTSB DEN71DXA07Accident · No injuriesClosedCessna 180 · Cody, WYAug 24, 1970 · N4773B · Substantial damage NTSB DEN71DXA06Accident · No injuriesClosedCessna U206 · Jackson, WYAug 23, 1970 · N206KA · Substantial damage NTSB DEN71AD006Accident · No injuriesClosedCessna Wren · Fort Washakie, WYAug 23, 1970 · N1929X · Substantial damage NTSB DEN71AD008Accident · 4 fatalClosedCessna 210D · Yellowstn Prk, WYAug 22, 1970 · N3952Y · Destroyed NTSB DEN71FXA05Accident · 2 fatalClosedBoeing TB-17F · Dubois, WYAug 18, 1970 · N1340N · Destroyed NTSB DEN71DXA04Accident · No injuriesClosedCessna 172 · Laramie, WYAug 17, 1970 · N2133Y · Substantial damage NTSB DEN71AD005Accident · 2 fatalClosedMooney M20E · Cody, WYAug 17, 1970 · N6937U · Destroyed NTSB DEN71AD003Accident · 1 fatalClosedBeech C50 · Kemmerer, WYJul 31, 1970 · N7704 · Destroyed NTSB DEN71DXA03Accident · No injuriesClosedHughes 269B · Buffalo, WYJul 20, 1970 · N9460F · Substantial damage NTSB DEN71DXA01Accident · Minor injuriesClosedCessna 182 · Aladdin, WYJul 6, 1970 · N8301S · Substantial damage NTSB DEN70AD060Accident · 1 fatalClosedCessna 150H · Manderson, WYJun 28, 1970 · N22097 · Destroyed NTSB DEN70DXA16Accident · No injuriesClosedPiper PA-25 · Cokeville, WYJun 27, 1970 · N6758Z · Substantial damage NTSB DEN70FXA15Accident · Serious injuriesClosedPiper P-18A · Dubois, WYJun 24, 1970 · N8886D · Destroyed NTSB DEN70DXA14Accident · No injuriesClosedCessna 140A · Casper, WYJun 20, 1970 · N9623A · Substantial damage NTSB DEN70DXA17Accident · No injuriesClosedPiper PA-24 · Rawlins, WYJun 19, 1970 · N6944P · Substantial damage NTSB DEN70DXA13Accident · No injuriesClosedPiper PA-18 · Big Piney, WYJun 2, 1970 · N3973P · Substantial damage NTSB SEA70DXM17Accident · No injuriesClosedPiper PA-18 · Border, WYMay 29, 1970 · N3289Z · Substantial damage NTSB DEN70AD057Accident · 2 fatalClosedPiper PA-18 · Keeline, WYMay 29, 1970 · N2871Z · Destroyed NTSB DEN70DXA12Accident · No injuriesClosedCessna 170 · Rawlins, WYMay 24, 1970 · N8074A · Substantial damage NTSB DEN70FXA11Accident · No injuriesClosedStinson 108-2 · Casper, WYMay 17, 1970 · N9505K · Substantial damage NTSB DEN70DXA10Accident · No injuriesClosedChampion 7ECA · Newcastle, WYMay 7, 1970 · N9049L · Substantial damage NTSB DEN70DXA09Accident · No injuriesClosedCessna 182 · Laramie, WYApr 15, 1970 · N2076X · Substantial damage NTSB DEN70DXA08Accident · No injuriesClosedPiper PA-18 · Sheridan, WYMar 28, 1970 · N1112A · Substantial damage NTSB DEN70FXA07Accident · No injuriesClosedAero Comdr 680FLP · Wheatland, WYMar 22, 1970 · N22BR · Substantial damage NTSB DEN70DXA06Accident · No injuriesClosedBell 47G · Casper, WYMar 19, 1970 · N612X · Substantial damage NTSB DEN70FXA05Accident · Serious injuriesClosedPiper PA-22 · Saratoga, WYFeb 16, 1970 · N3320A · Substantial damage NTSB DEN70FXA04Accident · Minor injuriesClosedPiper PA-24 · Casper, WYJan 18, 1970 · N8757P · Substantial damage NTSB DEN70DXA02Accident · No injuriesClosedPiper PA-22 · Guernsey, WYJan 12, 1970 · N2221A · Substantial damage NTSB DEN70DXA03Accident · No injuriesClosedCessna 182F · Ft Bridger, WYJan 8, 1970 · N3273U · Substantial damage NTSB DEN70DXA01Accident · No injuriesClosedBeech K35 · Medicine Bow, WYJan 1, 1970 · N5050T · Substantial damage