Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 LAX74DUJ38Accident · No injuriesClosedGrumman G-164A · Tonopah, AZDec 31, 1973 · N5363 · Substantial damage NTSB LAX74DUJ39Accident · No injuriesClosedPiper PA-28 · Douglas, AZDec 5, 1973 · N8858N · Substantial damage NTSB LAX74DUJ35Accident · Minor injuriesClosedCessna 210 · Sedona, AZDec 5, 1973 · N9581T · Substantial damage NTSB LAX74DUJ36Accident · No injuriesClosedPiper PA-28R · Gila Bend, AZNov 24, 1973 · N4995S · Substantial damage NTSB LAX74FUJ31Accident · No injuriesClosedAmer Avco AA5 · Phoenix, AZNov 21, 1973 · N9434L · Substantial damage NTSB LAX74FUJ33Accident · No injuriesClosedCessna 150L · Florence, AZNov 20, 1973 · N1613Q · Substantial damage NTSB LAX74DUJ34Accident · No injuriesClosedBell 206B · Tucson, AZNov 19, 1973 · N42AL · Substantial damage NTSB LAX74AL038Accident · 1 fatalClosedBeech 95-C55 · Kayenta, AZNov 18, 1973 · N2077W · Destroyed NTSB LAX74AL035Accident · 2 fatalClosedCessna 172F · Kingman, AZNov 8, 1973 · N1FH · Destroyed NTSB LAX74FUJ32Accident · Serious injuriesClosedAmer Avco AA1-A · Douglas, AZNov 7, 1973 · N9286L · Destroyed NTSB LAX74DUJ29Accident · No injuriesClosedCessna 140 · Willcox, AZNov 3, 1973 · N2256N · Substantial damage NTSB LAX74DUJ27Accident · Minor injuriesClosedAmer Avco AA1-B · Mesa, AZOct 23, 1973 · N9949L · Destroyed NTSB LAX74FUJ30Accident · No injuriesClosedEea Biplane P-1 · Yuma, AZOct 19, 1973 · N4091 · Destroyed NTSB LAX74DUJ28Accident · No injuriesClosedCessna 182M · Tucson, AZOct 19, 1973 · N91558 · Substantial damage NTSB LAX74DUJ26Accident · Minor injuriesClosedHiller Acft FH1100 · Sunflower, AZOct 16, 1973 · N436FH · Destroyed NTSB LAX74FUJ23Accident · Minor injuriesClosedCessna 150E · Sun City, AZOct 14, 1973 · N6231T · Substantial damage NTSB LAX74AL026Accident · 2 fatalClosedPiper PA-18 · Tacna, AZOct 4, 1973 · N4265Z · Substantial damage NTSB LAX74FUJ22Accident · Serious injuriesClosedMooney M20A · Overgaard, AZSep 30, 1973 · N8163E · Destroyed NTSB LAX74FUJ25Accident · 1 fatalClosedCessna 150 · Scottsdale, AZSep 28, 1973 · N1361Q · Destroyed NTSB LAX74DUJ24Accident · No injuriesClosedHiller Acft UH-12B · Tucson, AZSep 28, 1973 · N7299 · Substantial damage NTSB LAX74DUJ21Accident · No injuriesClosedCessna 170 · Apache Junc, AZSep 28, 1973 · N4037V · Substantial damage NTSB LAX74FUJ20Accident · Minor injuriesClosedBowers Fly Baby · Ashfork, AZSep 22, 1973 · N247AF · Substantial damage NTSB LAX74DUJ18Accident · No injuriesClosedPiper PA-28 · White Mt Lk, AZSep 9, 1973 · N1449T · Destroyed NTSB LAX74FUJ15Accident · Minor injuriesClosedCessna 182 · Bagdad, AZSep 3, 1973 · N2563G · Substantial damage NTSB LAX74DUJ19Accident · No injuriesClosedCessna 182 · Mesa, AZSep 2, 1973 · N21520 · Destroyed NTSB LAX74DUJ13Accident · No injuriesClosedStearman E75 · Wellton, AZSep 1, 1973 · N1263N · Destroyed NTSB LAX74DUJ17Accident · No injuriesClosedAeronca 11AC · Scottsdale, AZAug 30, 1973 · N86210 · Substantial damage NTSB LAX74DUJ14Accident · No injuriesClosedPiper PA-25 · Picacho, AZAug 28, 1973 · N6661Z · Substantial damage NTSB LAX74AL018Accident · 2 fatalClosedAmer Avco AA1-A · Yuma, AZAug 28, 1973 · N7258L · Destroyed NTSB LAX74DUJ16Accident · No injuriesClosedGrumman G-164A · Arlington, AZAug 27, 1973 · N4897 · Substantial damage NTSB LAX74DUJ12Accident · No injuriesClosedLet-Np-K L-13 · Tucson, AZAug 25, 1973 · N3460 · Substantial damage NTSB LAX74AL012Accident · 1 fatalClosedMooney M-20C · Roosevlt Lk, AZAug 8, 1973 · N1390W · Destroyed NTSB LAX74FUJ11Accident · Serious injuriesClosedPiper PA-32 · Grnd Canyon, AZAug 5, 1973 · N4291R · Substantial damage NTSB LAX74DUJ07Accident · Serious injuriesClosedCessna 188A · San Simon, AZJul 30, 1973 · N9784V · Destroyed NTSB LAX74DUJ05Accident · No injuriesClosedBell 47G-5 · Yuma, AZJul 27, 1973 · N2294W · Substantial damage NTSB LAX74DUJ10Accident · No injuriesClosedTravel Air 4000 · Tollison, AZJul 26, 1973 · N359M · Destroyed NTSB LAX74DUJ08Accident · Serious injuriesClosedStinson 108 · San Carlos, AZJul 25, 1973 · N97409 · Substantial damage NTSB LAX74DUJ04Accident · Minor injuriesClosedGrumman G-164A · Tonapah, AZJul 19, 1973 · N7232 · Substantial damage NTSB LAX74FUJ06Accident · Minor injuriesClosedPiper PA-28 · Prescott, AZJul 13, 1973 · N95173 · Substantial damage NTSB LAX74AL004Accident · 2 fatalClosedCessna 310F · Phoenix, AZJul 12, 1973 · N6798X · Destroyed NTSB LAX74DUJ09Accident · No injuriesClosedCessna 177A · Sierra Vsta, AZJul 10, 1973 · N30404 · Substantial damage NTSB LAX74DUJ03Accident · Minor injuriesClosedLet-Np-K L-13 · Phoenix, AZJul 9, 1973 · N5573 · Substantial damage NTSB LAX74FUJ02Accident · Minor injuriesClosedPiper PA-24 · Phoenix, AZJul 8, 1973 · N5747P · Destroyed NTSB LAX74DUJ01Accident · No injuriesClosedCessna 170A · Douglas, AZJul 1, 1973 · N9922A · Destroyed NTSB LAX73AL064Accident · 3 fatalClosedCessna 172 · Cottonwood, AZJun 29, 1973 · N8291B · Destroyed NTSB LAX73FUJ86Accident · Minor injuriesClosedHughes 269B · Chandler, AZJun 23, 1973 · N9569F · Destroyed NTSB LAX73DUJ91Accident · No injuriesClosedErco 415-C · Cottonwood, AZJun 16, 1973 · N87311 · Destroyed NTSB LAX73DUJ90Accident · No injuriesClosedGrumman G-164A · Chandlr Hts, AZJun 15, 1973 · N72PB · Destroyed NTSB LAX73DUJ89Accident · Minor injuriesClosedCessna 150 · Safford, AZJun 14, 1973 · N6275T · Destroyed NTSB LAX73FUJ84Accident · Serious injuriesClosedBeech G33 · Flagstaff, AZJun 13, 1973 · N1740W · Substantial damage