Skip to content

NTSB investigations, 1972, AZ

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 LAX73DUJ47Accident · Minor injuriesClosedAmer Avco AA1-A · Show Low, AZDec 30, 1972 · N6370L · Substantial damage NTSB LAX73FUJ45Accident · No injuriesClosedCessna 310G · Phoenix, AZDec 27, 1972 · N8975Z · Substantial damage NTSB LAX73AL026Accident · 1 fatalClosedMooney M20E · Apache Jctn, AZDec 8, 1972 · N6019Q · Destroyed NTSB LAX73AL023Accident · 3 fatalClosedPiper PA-28 · Dragoon, AZDec 5, 1972 · N5009S · Destroyed NTSB LAX73FUJ40Accident · Serious injuriesClosedGrumman G164 · Chandler, AZDec 3, 1972 · N702Y · Destroyed NTSB LAX73DUJ38Accident · No injuriesClosedPiper PA-28 · Yuma, AZNov 25, 1972 · N5414S · Substantial damage NTSB LAX73FUJ41Accident · 1 fatalClosedBeech D18S · Wh.Mtn Lake, AZNov 18, 1972 · N5299C · Destroyed NTSB LAX73FUJ38Accident · Minor injuriesClosedCessna 310Q · Seneca, AZNov 11, 1972 · N7722Q · Destroyed NTSB LAX73DUJ37Accident · Minor injuriesClosedCessna 177 · Carefree, AZNov 11, 1972 · N2244Y · Substantial damage NTSB LAX73FUJ34Accident · Minor injuriesClosedCessna 172 · Scottsdale, AZNov 3, 1972 · N3824Q · Destroyed NTSB LAX73DUJ32Accident · No injuriesClosedCessna 305A · Page, AZOct 28, 1972 · N5189G · Substantial damage NTSB LAX73DUJ76Accident · No injuriesClosedErco 415D · Lk Hvsu Cty, AZOct 14, 1972 · N3618H · Substantial damage NTSB LAX73DUJ35Accident · Minor injuriesClosedAeronca 7AC · Queen Creek, AZOct 14, 1972 · N83769 · Substantial damage NTSB LAX73DUJ31Accident · No injuriesClosedGrumman G-164A · Queen Creek, AZOct 14, 1972 · N970X · Substantial damage NTSB LAX73DUJ30Accident · No injuriesClosedCessna 182 · Tucson, AZOct 13, 1972 · XB-ZUM · Substantial damage NTSB LAX73FUJ25Accident · Minor injuriesClosedCorben Baby ACE B1 · Mesa, AZOct 8, 1972 · N7789C · Substantial damage NTSB LAX73DLJ29Accident · No injuriesClosedPiper PA-25 · Marana, AZOct 8, 1972 · N4817Y · Substantial damage NTSB LAX73DUJ27Accident · No injuriesClosedCessna 172 · Kingman, AZOct 6, 1972 · N7921B · Substantial damage NTSB LAX73AL015Accident · 1 fatalClosedAero Comdr 200D · Wittmann, AZOct 6, 1972 · N2906T · Destroyed NTSB LAX73AL014Accident · 1 fatalClosedCessna 172F · Salome, AZOct 3, 1972 · N8342U · Destroyed NTSB LAX73FUJ33Accident · Serious injuriesClosedBeech V35 · Chinle, AZSep 26, 1972 · N1522W · Substantial damage NTSB LAX73FUJ24Accident · No injuriesClosedPiper PA-22 · Lake Havasu, AZSep 25, 1972 · N5264G · Destroyed NTSB LAX73DUJ23Accident · No injuriesClosedCessna 150 · Chandler, AZSep 17, 1972 · N33CF · Substantial damage NTSB LAX73DUJ22Accident · No injuriesClosedCessna A188 · Yuma, AZSep 16, 1972 · N9960G · Substantial damage NTSB LAX73DUJ26Accident · No injuriesClosedPiper PA-22 · Duncan, AZSep 8, 1972 · N8628C · Substantial damage NTSB LAX73FUJ20Accident · 1 fatalClosedScorpion II · Glendale, AZSep 7, 1972 · N5086 · Destroyed NTSB LAX73DUJ19Accident · No injuriesClosedPiper PA-25 · Poston, AZSep 4, 1972 · N8799Z · Destroyed NTSB LAX73AL009Accident · 1 fatalClosedBell 47G3B1 · Tuba City, AZAug 30, 1972 · N73991 · Destroyed NTSB LAX73FUJ21Accident · No injuriesClosedTaylorcraft BC12-D · Yuma, AZAug 29, 1972 · N5136M · Substantial damage NTSB LAX73DUJ18Accident · No injuriesClosedMooney M20 · Tucson, AZAug 17, 1972 · N7875V · Substantial damage NTSB LAX73DUJ15Accident · No injuriesClosedPiper PA-28R · Glendale, AZAug 15, 1972 · N4579J · Substantial damage NTSB LAX73AL006Accident · 2 fatalClosedAmer Avco AA-1A · Sierra Vsta, AZAug 15, 1972 · N9475L · Destroyed NTSB LAX73FUJ17Accident · Minor injuriesClosedPiper PA-15 · Grnd Canyon, AZAug 13, 1972 · N4651H · Substantial damage NTSB LAX73DUJ16Accident · No injuriesClosedCessna 210A · Phoenix, AZAug 12, 1972 · N6595X · Substantial damage NTSB LAX73FUJ14Accident · No injuriesClosedBoeing A75N1 · Florence, AZAug 6, 1972 · N53131 · Substantial damage NTSB LAX73FUJ11Accident · No injuriesClosedBell 47-G5 · Chandler, AZAug 2, 1972 · N7808S · Substantial damage NTSB LAX73FUJ06Accident · No injuriesClosedGrumman G-164A · Guadalupe, AZJul 31, 1972 · N7842 · Substantial damage NTSB LAX73DUJ09Accident · No injuriesClosedPiper PA-25 · Picacho, AZJul 27, 1972 · N6877Z · Substantial damage NTSB LAX73DUJ13Accident · No injuriesClosedAmerican AA-5 · Phoenix, AZJul 23, 1972 · N5865L · Substantial damage NTSB LAX73DUJ12Accident · No injuriesClosedBeech F35 · Bllhead Cty, AZJul 23, 1972 · N3848B · Substantial damage NTSB LAX73DUJ05Accident · No injuriesClosedCessna 182 · Flagstaff, AZJul 16, 1972 · N2668F · Substantial damage NTSB LAX73FUJ08Accident · No injuriesClosedCessna 150 · Chandler, AZJul 14, 1972 · N60215 · Substantial damage NTSB LAX73DUJ07Accident · No injuriesClosedCessna 206 · San Carlos, AZJul 14, 1972 · N4943F · Substantial damage NTSB LAX73DUJ10Accident · No injuriesClosedCessna 182 · Mesa, AZJul 12, 1972 · N3392U · Substantial damage NTSB LAX73FUJ02Accident · No injuriesClosedCessna 182 · Phoenix, AZJul 4, 1972 · N2628Q · Substantial damage NTSB LAX73DUJ01Accident · Minor injuriesClosedCorbin Baby ACE · Stanfield, AZJul 3, 1972 · N9849Z · Substantial damage NTSB LAX74FUJ03Accident · 2 fatalClosedCessna 172A · Indian Wlls, AZJul 2, 1972 · N7551T · Destroyed NTSB LAX73DUJ04Accident · No injuriesClosedPiper PA-28 · St.Johns, AZJul 1, 1972 · N4305T · Substantial damage NTSB LAX72DUK14Accident · No injuriesClosedHiller Acft FH1100 · Marana, AZJun 28, 1972 · N425FH · Substantial damage NTSB LAX72FUJ09Accident · No injuriesClosedMooney M20F · Phoenix, AZJun 27, 1972 · N9787M · Substantial damage