Skip to content

NTSB investigations, 1971, AZ

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

19632026

NTSB investigations, 1971, AZ per year, 1963–2026: 5,130 cases
1963	1
1964	130
1965	107
1966	128
1967	138
1968	114
1969	115
1970	102
1971	128
1972	101
1973	105
1974	101
1975	121
1976	105
1977	123
1978	149
1979	130
1980	114
1981	132
1982	123
1983	114
1984	84
1985	78
1986	77
1987	76
1988	61
1989	79
1990	68
1991	86
1992	88
1993	68
1994	65
1995	73
1996	68
1997	71
1998	54
1999	64
2000	61
2001	63
2002	76
2003	93
2004	72
2005	81
2006	77
2007	66
2008	73
2009	74
2010	63
2011	67
2012	61
2013	54
2014	62
2015	42
2016	40
2017	50
2018	60
2019	47
2020	36
2021	44
2022	53
2023	43
2024	41
2025	45
2026	45

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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 LAX72DUJ61Accident · No injuriesClosedCessna 172 · Tucson, AZDec 27, 1971 · N78220 · Destroyed NTSB DEN72AD027Accident · 1 fatalClosedAmer Avco AA1A · Tucson, AZDec 19, 1971 · N9249L · Destroyed NTSB LAX72DUJ60Accident · No injuriesClosedMooney M20E · Keam Canyon, AZDec 11, 1971 · N6697R · Substantial damage NTSB LAX72DUJ59Accident · No injuriesClosedCessna 172 · Bllhead Cty, AZDec 5, 1971 · N6497E · Substantial damage NTSB LAX72DUJ62Accident · No injuriesClosedCessna 150F · Litchfld Pk, AZDec 4, 1971 · N8355G · Substantial damage NTSB LAX72AL038Accident · 1 fatalClosedPiper PA-22 · Chloride, AZNov 23, 1971 · N2565P · Destroyed NTSB LAX72DUJ58Accident · Minor injuriesClosedPiper J3C-65 · Pearce, AZNov 20, 1971 · N70524 · Destroyed NTSB ANC72AA024Accident · 1 fatalClosedChampion 7GCBC · Prescott, AZNov 20, 1971 · N9002L · Destroyed NTSB LAX72AL035Accident · 2 fatalClosedCessna 150C · Tonopah, AZNov 16, 1971 · N7802Z · Destroyed NTSB LAX72DUJ56Accident · No injuriesClosedPiper PA-28 · Tucson, AZNov 13, 1971 · N8598N · Substantial damage NTSB LAX72DUJ55Accident · Minor injuriesClosedBeech B35 · Phoenix, AZNov 13, 1971 · N5078C · Substantial damage NTSB LAX72AL030Accident · 1 fatalClosedCessna 172A · Bagdad, AZOct 25, 1971 · N7570T · Destroyed NTSB LAX72AL029Accident · 1 fatalClosedTemco D-16A · Dragoon, AZOct 24, 1971 · N709T · Destroyed NTSB LAX72DUJ54Accident · No injuriesClosedCessna 206 · St Johns, AZOct 18, 1971 · N9411G · Substantial damage NTSB LAX72AL026Accident · 1 fatalClosedCessna 182 · Tucson, AZOct 18, 1971 · N6493A · No damage NTSB LAX72AL024Accident · 10 fatalClosedCessna 402 · Colorado Cty, AZOct 16, 1971 · N3250Q · Destroyed NTSB LAX72DUJ51Accident · Minor injuriesClosedCessna 150 · Scottsdale, AZOct 13, 1971 · N6390G · Destroyed NTSB LAX72DUJ52Accident · No injuriesClosedHughes 269B · Lake Havasu, AZOct 10, 1971 · N9526F · Substantial damage NTSB LAX72FUJ50Accident · 1 fatalClosedPiper PA-25 · Wellton, AZOct 9, 1971 · N6979Z · Destroyed NTSB LAX72DUJ47Accident · No injuriesClosedMooney M20A · Yuma, AZOct 5, 1971 · N6566B · Substantial damage NTSB LAX72DUJ48Accident · No injuriesClosedCessna 172 · Sprngrville, AZOct 1, 1971 · N2813Q · Substantial damage NTSB LAX72DUJ49Accident · No injuriesClosedPiper PA-28 · Prescott, AZSep 25, 1971 · N8186W · Substantial damage NTSB LAX72DUJ53Accident · No injuriesClosedLuscombe 8A · Mesa, AZSep 20, 1971 · N1153B · Substantial damage NTSB LAX72DUJ45Accident · No injuriesClosedCommonwlth 185 · Mesa, AZSep 20, 1971 · N93290 · Substantial damage NTSB LAX72DUJ44Accident · Minor injuriesClosedBeech B23 · Kearny, AZSep 19, 1971 · N9129T · Substantial damage NTSB LAX72DUJ46Accident · No injuriesClosedNaval Fcty N3N-1 · Gadsden, AZSep 14, 1971 · N45065 · Substantial damage NTSB LAX72DUJ57Accident · No injuriesClosedCessna 182A · Kayenta, AZSep 12, 1971 · N5181D · Substantial damage NTSB LAX72FUJ43Accident · No injuriesClosedPiper PA-22 · Casa Grande, AZSep 10, 1971 · N3848P · Substantial damage NTSB LAX72DUJ41Accident · Minor injuriesClosedCessna 310 · Marana, AZSep 5, 1971 · N5262A · Destroyed NTSB LAX72FUJ39Accident · No injuriesClosedNaval Fcty N3N-3 · Phoenix, AZSep 4, 1971 · N45117 · Substantial damage NTSB LAX72FUJ38Accident · Serious injuriesClosedBeech F35 · Moon Valley, AZSep 4, 1971 · N4263B · Substantial damage NTSB LAX72FUJ40Accident · Minor injuriesClosedPiper PA-32 · Nogales, AZSep 2, 1971 · N4080W · Substantial damage NTSB LAX72DUJ35Accident · Minor injuriesClosedStinson 108 · Page, AZSep 2, 1971 · N998D · Substantial damage NTSB LAX72AL018Accident · Minor injuriesClosedHiller Acft UH12L4 · Grnd Canyon, AZSep 1, 1971 · N90486 · Destroyed NTSB LAX72FUJ34Accident · No injuriesClosedCessna 172L · Phoenix, AZAug 29, 1971 · N7548G · Substantial damage NTSB LAX72AL017Accident · 4 fatalClosedVolpar C-45G · Prescott, AZAug 29, 1971 · N74Q · Destroyed NTSB LAX72DUJ36Accident · No injuriesClosedPiper PA-28 · Flagstaff, AZAug 27, 1971 · N5016W · Substantial damage NTSB LAX72FUJ29Accident · 1 fatalClosedCessna 172 · Stanfield, AZAug 22, 1971 · N8249B · Substantial damage NTSB LAX72DUJ31Accident · No injuriesClosedCallair A-9 · Casa Grande, AZAug 22, 1971 · N3612G · Substantial damage NTSB LAX72FUJ32Accident · No injuriesClosedCessna 170A · Mesa, AZAug 18, 1971 · N1756D · Substantial damage NTSB LAX72FUJ30Accident · No injuriesClosedNaval Fcty N3N-3 · Phoenix, AZAug 17, 1971 · N9611 · Substantial damage NTSB LAX72AL013Accident · 2 fatalClosedTaylorcraft BC12-D · Jerome, AZAug 17, 1971 · N96321 · Destroyed NTSB LAX72FUJ37Accident · No injuriesClosedPiper PA-30 · Tucson, AZAug 13, 1971 · N8778Y · Substantial damage NTSB LAX72DUJ23Accident · No injuriesClosedNaval Fcty N3N-3 · Stanfield, AZAug 11, 1971 · N44713 · No damage NTSB LAX72FUJ26Accident · No injuriesClosedPiper PA-28R · Buckeye, AZAug 10, 1971 · N3121R · Substantial damage NTSB LAX72FUJ25Accident · Minor injuriesClosedCessna 402A · Scottsdale, AZAug 7, 1971 · N4598Q · Substantial damage NTSB LAX72DUJ22Accident · No injuriesClosedPiper PA-25 · Parker, AZAug 5, 1971 · N6570Z · Substantial damage NTSB LAX72FUJ20Accident · No injuriesClosedCessna 188A · Queen Creek, AZJul 30, 1971 · N3570Q · Destroyed NTSB LAX72DUJ28Accident · No injuriesClosedCessna 150 · Tempe, AZJul 25, 1971 · N2065Z · Substantial damage NTSB LAX72FUJ42Accident · 1 fatalClosedPiper PA-25 · Wellton, AZJul 24, 1971 · N6626Z · Destroyed