Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 LAX80FA114Accident · 2 fatalClosedPiper PA-32R · Safford, AZDec 20, 1979 · N9877K · Destroyed NTSB LAX80FUJ20Accident · No injuriesClosedCessna 180J · Chandler, AZDec 16, 1979 · N91K · Substantial damage NTSB LAX80DUJ24Accident · No injuriesClosedCessna 172M · Window Rock, AZDec 14, 1979 · N841JW · Substantial damage NTSB LAX80DUJ41Accident · No injuriesClosedCessna 150 · Sedona, AZDec 12, 1979 · N3575L · Substantial damage NTSB LAX80FA022Accident · 2 fatalClosedBeech V35B · Show Low, AZDec 6, 1979 · N1863L · Destroyed NTSB LAX80DUJ16Accident · No injuriesClosedPiper PA-30 · Chandler, AZDec 6, 1979 · N7420Y · Substantial damage NTSB LAX80DUJ19Accident · Minor injuriesClosedCessna 152 · Phoenix, AZDec 3, 1979 · N25763 · Destroyed NTSB LAX80FUJ15Accident · No injuriesClosedBeech 95-A55 · Phoenix, AZDec 2, 1979 · N1040T · Substantial damage NTSB LAX80FUJ13Accident · Minor injuriesClosedPiper PA-28 · Yuma, AZDec 2, 1979 · N1773T · Substantial damage NTSB LAX80DUJ17Accident · No injuriesClosedCessna 120 · Peoria, AZDec 1, 1979 · N4009N · Substantial damage NTSB LAX80FA021Accident · 2 fatalClosedCessna 152 · Flagstaff, AZNov 27, 1979 · N48835 · Destroyed NTSB LAX80DUM06Accident · No injuriesClosedBeech B35 · Yuma, AZNov 23, 1979 · N5116C · Substantial damage NTSB LAX80DUJ10Accident · No injuriesClosedCessna 182 · Scottsdale, AZNov 23, 1979 · N92844 · Substantial damage NTSB LAX80DUJ12Accident · No injuriesClosedLear 35 · Douglas, AZNov 22, 1979 · XA-ELU · Substantial damage NTSB DCA80AA021Accident · FatalClosedMartin 404 · Tusayan, AZNov 16, 1979 · N40438 · Destroyed NTSB LAX80DUJ03Accident · Minor injuriesClosedPiper PA-28 · Winslow, AZNov 14, 1979 · N6332J · Substantial damage NTSB LAX80DUJ18Accident · No injuriesClosedPiper PA-22 · Bullhead City, AZNov 12, 1979 · N9009D · Substantial damage NTSB LAX80FA012Accident · 2 fatalClosedPiper PA-28 · Phoenix, AZNov 10, 1979 · N6350W · Destroyed NTSB LAX80FUJ09Accident · No injuriesClosedCessna P210N · Phoenix, AZNov 9, 1979 · N6287P · Substantial damage NTSB LAX80DUJ21Accident · No injuriesClosedPiper PA-28 · Prescott, AZNov 9, 1979 · N47749 · Substantial damage NTSB LAX80DUJ11Accident · No injuriesClosedRyan ST-A · Phoenix, AZNov 6, 1979 · N14985 · Substantial damage NTSB LAX80FUJ08Accident · No injuriesClosedAero Comdr 560 · Tucson, AZNov 3, 1979 · N814V · Substantial damage NTSB LAX80FUJ07Accident · No injuriesClosedHughes 369D · Sun City, AZNov 3, 1979 · N58305 · Substantial damage NTSB LAX80FUJ05Accident · 1 fatalClosedBellanca 8KCAB · Chino Valley, AZOct 27, 1979 · N5030F · Destroyed NTSB LAX80DUJ06Accident · Minor injuriesClosedHughes 369D · Phoenix, AZOct 23, 1979 · N8673F · Substantial damage NTSB LAX80DUJ31Accident · No injuriesClosedGrumman AA-5B · Flagstaff, AZOct 16, 1979 · N28709 · Destroyed NTSB LAX80FUJ01Accident · No injuriesClosedPiper PA-24 · Goodyear, AZOct 12, 1979 · N9258P · Substantial damage NTSB LAX80DUJ02Accident · No injuriesClosedCessna 177RG · Vicksburg, AZOct 2, 1979 · N7583V · Substantial damage NTSB LAX80DUJ04Accident · No injuriesClosedCessna 152 · Springerville, AZOct 1, 1979 · N714XW · Substantial damage NTSB LAX79FUK23Accident · Serious injuriesClosedGrumman G-164A · Roll, AZSep 29, 1979 · N5404 · Substantial damage NTSB LAX79DUK24Accident · No injuriesClosedPiper PA-24 · Yuma, AZSep 28, 1979 · N7430P · Substantial damage NTSB LAX79DUK20Accident · Minor injuriesClosedPiper PA-36 · Safford, AZSep 28, 1979 · N57759 · Substantial damage NTSB LAX80DUJ14Accident · No injuriesClosedPiper PA-28 · Show Low, AZSep 24, 1979 · N47921 · Substantial damage NTSB LAX79DA090Incident · No injuriesClosedCessna 402B · Grand Canyon, AZSep 24, 1979 · N61SA · Minor damage NTSB LAX79IA082Incident · 1 fatalClosedCessna 210 · Tucson, AZSep 14, 1979 · N6125F · No damage NTSB LAX79DUK15Accident · No injuriesClosedCessna 172 · Payson, AZSep 13, 1979 · N7633T · Substantial damage NTSB LAX79FUK19Accident · No injuriesClosedHughes 269A · Phoenix, AZSep 11, 1979 · N87592 · Substantial damage NTSB LAX79IA078Incident · No injuriesClosedCessna TU206C · Peach Springs, AZSep 7, 1979 · N3000B · No damage NTSB LAX79DUK16Accident · Minor injuriesClosedSchweizer SGS126 · Casa Grande, AZSep 4, 1979 · N7797S · Destroyed NTSB LAX80DA138Accident · No injuriesClosedMooney M-20J · Yuma, AZSep 1, 1979 · N201TU · Substantial damage NTSB LAX79DUK21Accident · No injuriesClosedBeech S35 · Elfrida, AZAug 27, 1979 · N7988K · Substantial damage NTSB LAX79FUK10Accident · 1 fatalClosedHiller UH-12E · Somerton, AZAug 24, 1979 · N62902 · Destroyed NTSB LAX79DUK18Accident · Minor injuriesClosedCessna 150 · Page, AZAug 24, 1979 · N6142G · Substantial damage NTSB LAX79DUK17Accident · No injuriesClosedPiper PA-28 · Shonto, AZAug 23, 1979 · N7231W · Substantial damage NTSB LAX79DUK09Accident · No injuriesClosedBell M-74 · Ehrenberg, AZAug 21, 1979 · N38105 · Substantial damage NTSB LAX79DUK12Accident · No injuriesClosedPiper PA-24 · Cottonwood, AZAug 18, 1979 · N7725P · Substantial damage NTSB LAX79DUK14Accident · No injuriesClosedCessna 170B · Phoenix, AZAug 16, 1979 · N4664C · Substantial damage NTSB LAX79DUK07Accident · Minor injuriesClosedCessna 182Q · Springerville, AZAug 16, 1979 · N97381 · Substantial damage NTSB LAX79DUK06Accident · No injuriesClosedCessna 150 · Sunflower, AZAug 13, 1979 · N3196X · Substantial damage NTSB LAX79FUK01Accident · Serious injuriesClosedCessna 182F · Munds Park, AZAug 12, 1979 · N3529U · Substantial damage