Skip to content

NTSB investigations, 1978, AZ

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 LAX79DUJ39Accident · Serious injuriesClosedAeronca 0-58B · Flagstaff, AZDec 31, 1978 · N33323 · Substantial damage NTSB LAX79FA021Accident · 1 fatalClosedBeech 95-55 · Flagstaff, AZDec 29, 1978 · N6118V · Destroyed NTSB LAX79DUJ40Accident · No injuriesClosedCessna 150 · Tucson, AZDec 27, 1978 · N4816X · Substantial damage NTSB LAX79DUJ32Accident · No injuriesClosedCessna 152 · Phoenix, AZDec 27, 1978 · N25058 · Substantial damage NTSB LAX79DUJ25Accident · No injuriesClosedMidget Mustng · Prescott, AZDec 27, 1978 · N86DL · Substantial damage NTSB LAX79FA019Accident · 2 fatalClosedPiper PA-32 · Sun City, AZDec 24, 1978 · N4008R · Destroyed NTSB LAX79FUJ24Accident · Serious injuriesClosedBell 206 · Phoenix, AZDec 21, 1978 · N2964W · Destroyed NTSB LAX79DUJ29Accident · No injuriesClosedCessna 152 · Phoenix, AZDec 21, 1978 · N48600 · Substantial damage NTSB LAX79DUJ27Accident · No injuriesClosedPiper PA-18 · Pinon, AZDec 21, 1978 · N2883Z · Substantial damage NTSB LAX79FUJ26Accident · No injuriesClosedCurtis-Wrt D-4000 · Phoenix, AZDec 20, 1978 · N8708 · Substantial damage NTSB LAX79FA022Accident · 4 fatalClosedPiper PA-24 · Springerville, AZDec 20, 1978 · N5734P · Destroyed NTSB LAX79DUJ38Accident · No injuriesClosedGrum Amer AA1-A · Aguila, AZDec 17, 1978 · N9426L · Substantial damage NTSB LAX79DUJ23Accident · No injuriesClosedCessna 210K · Show Low, AZDec 14, 1978 · N8262M · Substantial damage NTSB LAX79FUJ28Accident · No injuriesClosedCessna 170B · Grnd Cyn Cvrns, AZDec 13, 1978 · N1956C · Substantial damage NTSB LAX79FUJ19Accident · Minor injuriesClosedCessna 152 · Scottsdale, AZDec 12, 1978 · N24475 · Substantial damage NTSB LAX79FUJ17Accident · No injuriesClosedCessna 152 · Willcox, AZDec 8, 1978 · N757HL · Substantial damage NTSB LAX79FA015Accident · 3 fatalClosedPiper PA-28 · Peach Springs, AZDec 1, 1978 · N15899 · Destroyed NTSB LAX79DUJ31Accident · No injuriesClosedBellanca 7KCAB · Tucson, AZNov 30, 1978 · N86651 · Substantial damage NTSB LAX79DUJ21Accident · No injuriesClosedGrumman AA-5B · Prescott, AZNov 28, 1978 · N28959 · Substantial damage NTSB LAX79DUJ20Accident · No injuriesClosedPiper PA-18 · Eloy, AZNov 27, 1978 · N4090E · Substantial damage NTSB LAX79DUJ18Accident · No injuriesClosedBell 47G-5 · Yuma, AZNov 16, 1978 · N7907S · Substantial damage NTSB LAX79FUJ14Accident · Minor injuriesClosedMooney M20C · Scottsdale, AZNov 13, 1978 · N1346W · Substantial damage NTSB LAX79FUJ13Accident · 1 fatalClosedBell 47G3B · Springerville, AZNov 10, 1978 · N8483E · Destroyed NTSB LAX79FA012Accident · No injuriesClosedBeech E18S · Grand Canyon, AZNov 9, 1978 · N3781B · Substantial damage NTSB LAX79DUJ35Accident · No injuriesClosedCessna U206 · Littlefield, AZNov 7, 1978 · N60838 · Substantial damage NTSB LAX79DUJ16Accident · No injuriesClosedCessna 152 · Goodyear, AZNov 6, 1978 · N24864 · Substantial damage NTSB LAX79DUJ15Accident · No injuriesClosedCessna 188 · Maricopa, AZNov 6, 1978 · N21613 · Substantial damage NTSB LAX79DUJ36Accident · No injuriesClosedHiller UH12E · Yuma, AZNov 4, 1978 · N62349 · Destroyed NTSB LAX79FUJ10Accident · Serious injuriesClosedCessna 182 · Buckeye, AZOct 30, 1978 · N1800M · Substantial damage NTSB LAX79FUJ11Accident · No injuriesClosedKnight Twst WHB-1 · Marana, AZOct 28, 1978 · N67P · Substantial damage NTSB LAX79FUJ09Accident · Minor injuriesClosedCessna 172N · Scottsdale, AZOct 25, 1978 · N733WM · Substantial damage NTSB LAX79FA007Accident · 2 fatalClosedCessna 182P · Whiteriver, AZOct 25, 1978 · N96060 · Destroyed NTSB LAX79FUJ06Accident · Minor injuriesClosedMaule M-4 · Phoenix, AZOct 23, 1978 · N626M · Substantial damage NTSB LAX79FUJ05Accident · Minor injuriesClosedCessna T337B · Marana, AZOct 22, 1978 · N2343S · Substantial damage NTSB LAX79DUJ08Accident · No injuriesClosedCessna TU206G · Gila Bend, AZOct 22, 1978 · N7520N · Substantial damage NTSB LAX79DUJ07Accident · No injuriesClosedPiper PA-32 · Sun City, AZOct 22, 1978 · N4167W · Substantial damage NTSB LAX79FA005Accident · 3 fatalClosedBeech 35 · Williams, AZOct 20, 1978 · N2734V · Destroyed NTSB LAX79DUJ12Accident · No injuriesClosedCessna 310I · Yuma, AZOct 20, 1978 · N8071M · Substantial damage NTSB LAX79FUJ02Accident · No injuriesClosedVarga 2150 · Chandler, AZOct 14, 1978 · N5108V · Substantial damage NTSB LAX79DUJ04Accident · Minor injuriesClosedHiller UH-12E · Queen Creek, AZOct 14, 1978 · N518HA · Destroyed NTSB LAX79FUJ03Accident · No injuriesClosedCessna 140 · Mesa, AZOct 7, 1978 · N72930 · Substantial damage NTSB LAX79FA002Accident · 2 fatalClosedCessna 152 · Scottsdale, AZOct 7, 1978 · N67408 · Destroyed NTSB LAX79DUJ01Accident · No injuriesClosedGrumman G-164B · Poston, AZOct 2, 1978 · N6747Q · Substantial damage NTSB LAX78FUK09Accident · Serious injuriesClosedEnstrom 280C · Kingman, AZSep 24, 1978 · N665H · Destroyed NTSB LAX78IA078Incident · No injuriesClosedCessna 402B · Phoenix, AZSep 21, 1978 · N98685 · Minor damage NTSB LAX78FUK06Accident · No injuriesClosedPiper PA-32 · Yuma, AZSep 20, 1978 · N55679 · Substantial damage NTSB LAX78DUK05Accident · No injuriesClosedCessna 188 · Parker, AZSep 16, 1978 · N9393R · Substantial damage NTSB LAX78DUK07Accident · No injuriesClosedCessna 172 · Mesa, AZSep 10, 1978 · N734SB · Substantial damage NTSB LAX78FUK04Accident · Serious injuriesClosedScorpion 133 · Tempe, AZSep 9, 1978 · N31222 · Destroyed NTSB LAX78DUK03Accident · Serious injuriesClosedPiper PA-22 · Seligman, AZSep 9, 1978 · N8547C · Substantial damage