Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 DEN72AD024Accident · 3 fatalClosedCessna 172 · Opal, WYOct 29, 1971 · N6151E · Destroyed NTSB DEN72AD022Accident · 4 fatalClosedCessna 310L · Jackson, WYOct 28, 1971 · N2217F · Destroyed NTSB DEN72FTC13Accident · No injuriesClosedAero Comdr 520 · Sinclair, WYOct 18, 1971 · N4168B · Substantial damage NTSB DEN72FTC12Accident · Serious injuriesClosedCessna 170B · Sheridan, WYOct 14, 1971 · N4569C · Destroyed NTSB DEN72DTC11Accident · No injuriesClosedCessna 172 · Rawlins, WYOct 14, 1971 · N1303Y · Substantial damage NTSB DEN72FTC09Accident · No injuriesClosedHelio H-395 · Jackson, WYOct 6, 1971 · N4198D · Substantial damage NTSB DEN72DTC10Accident · No injuriesClosedAeronca 65-TL · Recluse, WYOct 3, 1971 · N36520 · Substantial damage NTSB DEN72DTC08Accident · No injuriesClosedPiper PA-24 · Gillette, WYOct 3, 1971 · N5149P · Substantial damage NTSB DEN72DTC06Accident · No injuriesClosedCessna 182C · Lusk, WYSep 9, 1971 · N8672T · Substantial damage NTSB DEN72AD010Accident · 1 fatalClosedPiper PA-28 · Evanston, WYSep 9, 1971 · N3643R · Substantial damage NTSB DEN72DTC07Accident · Minor injuriesClosedForney F1 · Hulett, WYAug 28, 1971 · N7524C · Destroyed NTSB DEN72FTC05Accident · No injuriesClosedPiper PA-23 · Cody, WYAug 21, 1971 · N4599P · Substantial damage NTSB DEN72DTC04Accident · No injuriesClosedChampion 7KCAB · Jackson, WYAug 18, 1971 · N9065L · Destroyed NTSB DEN72FTC03Accident · Serious injuriesClosedPiper J3C-65 · Midwest, WYAug 9, 1971 · N70128 · Substantial damage NTSB DEN72AD003Accident · 2 fatalClosedCessna 210G · Torrington, WYJul 23, 1971 · N5911F · Destroyed NTSB DEN72FTC02Accident · Serious injuriesClosedStinson 108 · Rock Springs, WYJul 11, 1971 · N40103 · Substantial damage NTSB DEN72DTC01Accident · No injuriesClosedCessna 182E · Gillette, WYJul 1, 1971 · N9364X · Substantial damage NTSB DEN71DTC05Accident · No injuriesClosedCessna 175 · Sheridan, WYJun 24, 1971 · N6556E · Substantial damage NTSB DEN71DTC04Accident · No injuriesClosedPiper PA-18A · Lingle, WYJun 9, 1971 · N9850D · Substantial damage NTSB DEN71FTC03Accident · Serious injuriesClosedPiper PA-25 · Rawlins, WYJun 8, 1971 · N7395Z · Destroyed NTSB DEN71DTC06Accident · No injuriesClosedPiper PA-11 · Aladdin, WYMay 23, 1971 · N4955M · Substantial damage NTSB DEN71AD043Accident · 2 fatalClosedPiper PA-24 · Lander, WYMay 21, 1971 · N7535P · Destroyed NTSB DEN71FTC02Accident · Serious injuriesClosedCessna 140 · Cheyenne, WYMay 20, 1971 · N2287N · Destroyed NTSB DEN71DTC01Accident · No injuriesClosedCessna 150B · Powell, WYMay 15, 1971 · N1134Y · Substantial damage NTSB DEN71DXA24Accident · No injuriesClosedCessna 140 · Cody, WYMay 8, 1971 · N72426 · Substantial damage NTSB DEN71DXA23Accident · Minor injuriesClosedPiper PA-18 · Meeteetse, WYMay 3, 1971 · N3285Z · Substantial damage NTSB DEN71DXA22Accident · No injuriesClosedPiper PA-25 · Casper, WYApr 14, 1971 · N7395Z · Substantial damage NTSB DEN71DXA21Accident · No injuriesClosedPiper PA-18 · Seely, WYApr 12, 1971 · N1979P · Destroyed NTSB DEN71DXA20Accident · No injuriesClosedPiper PA-25 · Casper, WYApr 2, 1971 · N7685Z · Substantial damage NTSB DEN71DXA19Accident · No injuriesClosedCessna 150J · Cheyenne, WYMar 28, 1971 · N60027 · Substantial damage NTSB DEN71DXA18Accident · No injuriesClosedHughes 269A-1 · Laramie, WYMar 3, 1971 · N8891F · Substantial damage NTSB DEN71DXA16Accident · No injuriesClosedTaylorcraft BC1265 · Wheatland, WYFeb 14, 1971 · N29881 · Substantial damage NTSB DEN71DXA17Accident · No injuriesClosedCessna 206 · Gillette, WYFeb 10, 1971 · N5210U · Substantial damage NTSB DEN71DXA15Accident · Minor injuriesClosedBell 47G3B2 · Saratoga, WYJan 14, 1971 · N2205W · Substantial damage