Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 LAX76DUJ50Accident · Minor injuriesClosedCessna 206 · Holbrook, AZDec 27, 1975 · N3927G · Substantial damage NTSB LAX76DUJ51Accident · Minor injuriesClosedCessna U206B · Queen Creek, AZDec 26, 1975 · N3805G · Substantial damage NTSB LAX76DUJ48Accident · Serious injuriesClosedLuscombe 8F · Mcnary, AZDec 23, 1975 · N9946C · Destroyed NTSB LAX76DUJ57Accident · No injuriesClosedCessna 182 · Lukeville, AZDec 21, 1975 · N91592 · Substantial damage NTSB LAX76AUJ49Accident · Serious injuriesClosedCessna 310A · Glendale, AZDec 15, 1975 · N222EH · Destroyed NTSB LAX76DUJ45Accident · No injuriesClosedPiper PA-22 · Aguila, AZNov 29, 1975 · N8932D · Substantial damage NTSB LAX76DUJ47Accident · No injuriesClosedPiper PA-28 · Polacca, AZNov 23, 1975 · N8751N · Substantial damage NTSB LAX76AL037Accident · 2 fatalClosedPiper PA-12 · Chandler, AZNov 21, 1975 · N2974M · Destroyed NTSB LAX76FUJ43Accident · Serious injuriesClosedCessna 140A · Goodyear, AZNov 20, 1975 · N5330C · Substantial damage NTSB LAX76FUJ42Accident · No injuriesClosedCessna 310 · Page, AZNov 5, 1975 · N8090M · Substantial damage NTSB LAX76AL033Accident · 2 fatalClosedPiper PA-32 · Coolidge, AZNov 5, 1975 · N43475 · Destroyed NTSB LAX76AUJ41Accident · No injuriesClosedBellanca 7KCAB · Mesa, AZOct 30, 1975 · N8727V · Substantial damage NTSB LAX76DUJ46Accident · No injuriesClosedMooney M20C · Camp Verde, AZOct 29, 1975 · N9661M · Substantial damage NTSB LAX76FUJ39Accident · Serious injuriesClosedCessna 205 · Scottsdale, AZOct 25, 1975 · N8129Z · Substantial damage NTSB LAX7LDUJ38Accident · No injuriesClosedPiper PA-28 · Chandler, AZOct 23, 1975 · N33417 · Substantial damage NTSB LAX76AL026Accident · 2 fatalClosedPiper PA-32 · Tucson, AZOct 15, 1975 · N15876 · Destroyed NTSB LAX76DUJ37Accident · 1 fatalClosedStinson V-77 · House Rock, AZOct 12, 1975 · N69395 · Substantial damage NTSB LAX76DUJ34Accident · No injuriesClosedPiper PA-28 · Bagdad, AZOct 2, 1975 · N1593X · Substantial damage NTSB LAX76DUJ36Accident · No injuriesClosedCessna 188 · Glendale, AZSep 29, 1975 · N8199V · Substantial damage NTSB LAX76DUJ35Accident · No injuriesClosedCessna 172M · Nelson, AZSep 28, 1975 · N61841 · Substantial damage NTSB LAX76DUJ33Accident · No injuriesClosedBeech B35 · Sedona, AZSep 28, 1975 · N8928A · Substantial damage NTSB LAX76DUJ32Accident · No injuriesClosedGrumman G-164A · Buckeye, AZSep 25, 1975 · N6559 · Substantial damage NTSB LAX76DUJ31Accident · Serious injuriesClosedSnow 600S2R · Stanfield, AZSep 25, 1975 · N8959Q · Destroyed NTSB LAX76FUJ30Accident · No injuriesClosedHughes 269C · Phoenix, AZSep 24, 1975 · N9666F · Substantial damage NTSB LAX76AL021Accident · 1 fatalClosedSchweizer SGS135 · Maricopa, AZSep 21, 1975 · N34087 · Destroyed NTSB LAX76DUJ27Accident · No injuriesClosedPiper PA-28 · Show Low, AZSep 19, 1975 · N8858J · Substantial damage NTSB LAX76AL020Accident · Minor injuriesClosedCessna 206 · Wickenburg, AZSep 18, 1975 · N70594 · Substantial damage NTSB LAX76FUJ23Accident · 1 fatalClosedGrumman F8F-2 · Flagstaff, AZSep 16, 1975 · N7701C · Substantial damage NTSB LAX76DWJ25Accident · No injuriesClosedCessna 150 · Seligman, AZSep 15, 1975 · N16094 · Substantial damage NTSB LAX76DUJ26Accident · No injuriesClosedCessna A188B · Coolidge, AZSep 14, 1975 · N9765G · Substantial damage NTSB LAX76DUJ40Accident · No injuriesClosedCessna 172 · Ft.Grant, AZSep 13, 1975 · N9154B · Substantial damage NTSB LAX76AL018Accident · 2 fatalClosedCessna 310Q · Show Low, AZSep 12, 1975 · N7518Q · Destroyed NTSB LAX76DUJ29Accident · No injuriesClosedBell 47G-5 · Chandler, AZSep 8, 1975 · N4099G · Substantial damage NTSB LAX76FUJ21Accident · No injuriesClosedGrumman G-164A · Litchfld Park, AZAug 29, 1975 · N988X · Substantial damage NTSB LAX76FUJ20Accident · No injuriesClosedBeech E18S · Grand Canyon, AZAug 24, 1975 · N203C · Substantial damage NTSB LAX76DUJ24Accident · No injuriesClosedCessna 180 · Page, AZAug 24, 1975 · N1750C · Substantial damage NTSB LAX76DUJ22Accident · No injuriesClosedErco 415-C · Camp Verde, AZAug 24, 1975 · N2723H · Substantial damage NTSB LAX76AL013Accident · 1 fatalClosedCessna 150L · Camp Verde, AZAug 23, 1975 · N1383Q · Substantial damage NTSB LAX76FUJ15Accident · No injuriesClosedPiper PA-36 · Roll, AZAug 20, 1975 · N43667 · Destroyed NTSB LAX7LFUJ11Accident · Serious injuriesClosedCessna 172 · Payson, AZAug 16, 1975 · N921CR · Substantial damage NTSB LAX76DUJ13Accident · Minor injuriesClosedNaval Fcty N3N-1 · Mesa, AZAug 16, 1975 · N44756 · Destroyed NTSB LAX76DUJ19Accident · No injuriesClosedCessna 180 · Glendale, AZAug 14, 1975 · N2952C · Substantial damage NTSB LAX76DUJ12Accident · Serious injuriesClosedBell 47G-5 · Chandler, AZAug 10, 1975 · N8558F · Substantial damage NTSB LAX76DUJ10Accident · No injuriesClosedCessna 172F · Flagstaff, AZAug 10, 1975 · N5141F · Substantial damage NTSB LAX76DUJ08Accident · No injuriesClosedChampion 7GCBC · Phoenix, AZAug 9, 1975 · N57395 · Substantial damage NTSB LAX76DUJ28Accident · No injuriesClosedCessna 170 · Page, AZAug 8, 1975 · N4114V · Substantial damage NTSB LAX76DUJ14Accident · Minor injuriesClosedBlanik L-13 · Carefree, AZAug 7, 1975 · N99970 · Substantial damage NTSB LAX76DUJ09Accident · No injuriesClosedStinson 108 · Prescott, AZAug 6, 1975 · N97324 · Substantial damage NTSB LAX76AL063Accident · 3 fatalClosedPiper PA-28R · Page, AZAug 3, 1975 · N16312 · Destroyed NTSB LAX76AL008Accident · Serious injuriesClosedCessna 210K · Grand Canyon, AZAug 2, 1975 · N9496M · Substantial damage