Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 LAX71AL041Accident · 5 fatalClosedPiper PA-24 · Sacaton, AZDec 28, 1970 · N6664P · 2 aircraft · Destroyed NTSB LAX71FUJ50Accident · No injuriesClosedBeech D-17S · Phoenix, AZDec 23, 1970 · N20753 · Substantial damage NTSB LAX71FUJ48Accident · Serious injuriesClosedBoeing B75N1 · Wikieup, AZDec 14, 1970 · N68992 · Destroyed NTSB LAX71DUJ47Accident · No injuriesClosedPiper PA-28 · Phoenix, AZDec 13, 1970 · N9078J · Substantial damage NTSB LAX71AL038Accident · 3 fatalClosedBellanca 17-30 · Queen Creek, AZDec 13, 1970 · N7384V · Destroyed NTSB LAX71FUJ49Accident · No injuriesClosedCessna 310 · Phoenix, AZDec 2, 1970 · N5234A · Substantial damage NTSB LAX72AL021Accident · 2 fatalClosedPiper PA-28 · Mcnary, AZNov 26, 1970 · N7509W · Destroyed NTSB LAX71DUJ45Accident · No injuriesClosedPiper PA-23 · Tucson, AZNov 21, 1970 · N3033P · Substantial damage NTSB LAX71FUJ51Accident · No injuriesClosedBell 47G3B1 · Page, AZNov 20, 1970 · N612 · Substantial damage NTSB LAX71FUJ46Accident · No injuriesClosedCessna 310N · Tucson, AZNov 14, 1970 · N713JR · Substantial damage NTSB LAX71FUJ44Accident · No injuriesClosedCessna 150 · Mesa, AZNov 1, 1970 · N7976Z · Substantial damage NTSB LAX71FUJ40Accident · Serious injuriesClosedBell 47G-5 · El Mirage, AZOct 24, 1970 · N1375X · Destroyed NTSB LAX71DUJ38Accident · No injuriesClosedCessna 150H · Chandler, AZOct 20, 1970 · N23106 · Substantial damage NTSB LAX71AL022Accident · No injuriesClosedPiper PA-28 · Gila Bend, AZOct 17, 1970 · N5071W · 2 aircraft · Substantial damage NTSB LAX71DUJ36Accident · No injuriesClosedCessna 150J · Tucson, AZOct 15, 1970 · N60068 · Substantial damage NTSB LAX71DUJ35Accident · No injuriesClosedCessna 182L · Colordo Cty, AZOct 15, 1970 · N42124 · Substantial damage NTSB LAX71DUJ37Accident · Minor injuriesClosedBeech 36 · Tucson, AZOct 14, 1970 · N7452N · Substantial damage NTSB LAX71DUJ32Accident · No injuriesClosedPiper PA-28 · Grnd Canyon, AZOct 10, 1970 · N8737N · Substantial damage NTSB LAX71DUJ41Accident · Minor injuriesClosedPiper PA-28 · Bisbee, AZOct 7, 1970 · N8896N · Substantial damage NTSB LAX71FUJ30Accident · Minor injuriesClosedBeech 35-33 · Morristown, AZOct 3, 1970 · N8923M · Substantial damage NTSB LAX71DUJ28Accident · Minor injuriesClosedHughes 269B · Willcox, AZSep 25, 1970 · N9384F · Substantial damage NTSB LAX71DUJ25Accident · No injuriesClosedCessna 177 · Scottsdale, AZSep 22, 1970 · N3186T · Substantial damage NTSB LAX71DUJ34Accident · No injuriesClosedPiper PA-25 · Rillito, AZSep 21, 1970 · N4587Y · Substantial damage NTSB LAX71DUJ27Accident · Minor injuriesClosedCessna 150E · Safford, AZSep 18, 1970 · N6276T · Substantial damage NTSB LAX71DUJ31Accident · Minor injuriesClosedPiper PA-25 · Poston, AZSep 16, 1970 · N4917Y · Destroyed NTSB LAX71DUJ36Accident · No injuriesClosedNaval Fcty N3N · Queen Creek, AZSep 11, 1970 · N9831Z · Substantial damage NTSB LAX71DUJ26Accident · No injuriesClosedAeronca 11AC · Scottsdale, AZSep 10, 1970 · N86210 · Substantial damage NTSB LAX71AL011Accident · 3 fatalClosedPiper PA-22 · Alpine, AZSep 6, 1970 · N1968A · Destroyed NTSB LAX71DUJ33Accident · No injuriesClosedTaylorcraft BC-65 · Dateland, AZSep 5, 1970 · N27590 · Substantial damage NTSB LAX71AL010Accident · 2 fatalClosedGlobe GC-1B · Morristown, AZSep 5, 1970 · N3317K · Destroyed NTSB LAX71DUJ20Accident · No injuriesClosedPiper PA-28 · Mayer, AZSep 4, 1970 · N133SF · Substantial damage NTSB LAX71DUJ21Accident · No injuriesClosedPiper PA-24 · Flagstaff, AZSep 2, 1970 · N7336P · Substantial damage NTSB LAX71DUJ18Accident · Serious injuriesClosedHP 11 · Winslow, AZAug 30, 1970 · N502D · Substantial damage NTSB LAX71DUJ29Accident · No injuriesClosedHughes 269B · Williams, AZAug 28, 1970 · N9554F · Substantial damage NTSB LAX71AL008Accident · 1 fatalClosedPiper PA-12 · Bulhead Cty, AZAug 20, 1970 · N2714M · Destroyed NTSB LAX71DUJ17Accident · Minor injuriesClosedAero Comdr 100 · Flagstaff, AZAug 19, 1970 · N3736X · Substantial damage NTSB LAX71FUJ23Accident · No injuriesClosedCessna 182K · Phoenix, AZAug 14, 1970 · N2594R · Substantial damage NTSB LAX71FUJ16Accident · 1 fatalClosedGrumman G-164 · Yuma, AZAug 12, 1970 · N10233 · Destroyed NTSB LAX71AL006Accident · 2 fatalClosedBeech 36 · Tucson, AZAug 11, 1970 · N6215 · Destroyed NTSB LAX71FUJ12Accident · 1 fatalClosedBoeing A75N1 · Somerton, AZAug 5, 1970 · N58098 · Destroyed NTSB LAX71FUJ11Accident · Serious injuriesClosedCessna 177 · Sedona, AZAug 1, 1970 · N2884X · Destroyed NTSB LAX71DUJ19Accident · No injuriesClosedBell 47G · Queen Creek, AZJul 27, 1970 · N5237A · Substantial damage NTSB LAX71DUJ14Accident · No injuriesClosedPiper PA-25 · Poston, AZJul 22, 1970 · N4976Y · Substantial damage NTSB LAX71FUJ08Accident · 1 fatalClosedSnow S2B · Phoenix, AZJul 21, 1970 · N8873Q · Destroyed NTSB LAX71DUJ15Accident · No injuriesClosedHiller Acft SL-4 · Williams, AZJul 21, 1970 · N9728C · Substantial damage NTSB LAX71DUJ07Accident · No injuriesClosedStearman PT-17 · Mesa, AZJul 17, 1970 · N70074 · Substantial damage NTSB LAX71DUJ06Accident · No injuriesClosedBell 47G3B1 · Elfrida, AZJul 13, 1970 · N1358X · Substantial damage NTSB LAX71DUJ05Accident · Minor injuriesClosedAeronca 7AC · Coolidge, AZJul 13, 1970 · N85606 · Substantial damage NTSB LAX71DUJ02Accident · No injuriesClosedCessna 150 · Cottonwood, AZJul 7, 1970 · N8840S · Substantial damage NTSB LAX71AL002Accident · No injuriesClosedLockheed 18 · Phoenix, AZJul 5, 1970 · N34E · Substantial damage