Skip to content

NTSB investigations, 1980, 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, 1980, 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") = 1980 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\") = 1980
    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") = 1980
  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 LAX81FA027Accident · Serious injuriesClosedDouglas DC-8 · Phoenix, AZDec 29, 1980 · N8089U · Substantial damage NTSB LAX81DUQ09Accident · No injuriesClosedCessna 150 · San Fernando, AZDec 24, 1980 · N5620E · Substantial damage NTSB LAX81FUJ16Accident · Minor injuriesClosedWaco BSO · Scottsdale, AZDec 19, 1980 · N8543 · Substantial damage NTSB LAX81DUJ17Accident · No injuriesClosedPiper PA-38 · Wickenburg, AZDec 19, 1980 · N2595D · Substantial damage NTSB LAX81FUJ15Accident · Serious injuriesClosedMonerai S · Eloy, AZDec 14, 1980 · N54980 · Destroyed NTSB LAX81FUJ13Accident · No injuriesClosedCessna 150 · Chandler, AZDec 8, 1980 · N9154U · Substantial damage NTSB LAX81DUJ20Accident · Minor injuriesClosedCessna 172N · Tucson, AZDec 2, 1980 · N738YA · Substantial damage NTSB LAX81FUJ12Accident · Minor injuriesClosedBell 47D-1 · Horseshoe Lk, AZNov 30, 1980 · N8272E · Substantial damage NTSB LAX81FUJ11Accident · 1 fatalClosedBellanca 8KCAB · Bouse, AZNov 27, 1980 · N50409 · Destroyed NTSB LAX81FUJ09Accident · No injuriesClosedRockwell 112TCA · Wenden, AZNov 18, 1980 · N4629W · Substantial damage NTSB LAX81DUJ18Accident · No injuriesClosedRaven S-55A · Sun City West, AZNov 15, 1980 · N5702T · Substantial damage NTSB LAX80DUJ22Accident · No injuriesClosedPiper PA-28 · Kingman, AZNov 15, 1980 · N2089N · Substantial damage NTSB LAX81DUJ08Accident · Serious injuriesClosedTailwind Wittma · Payson, AZNov 4, 1980 · N2732 · Substantial damage NTSB LAX81FUJ10Accident · No injuriesClosedPiper PA-24 · Holbrook, AZOct 30, 1980 · N5983P · Substantial damage NTSB LAX80FUJ07Accident · Minor injuriesClosedPiper PA-32 · Scottsdale, AZOct 24, 1980 · N8257A · Substantial damage NTSB LAX81FA009Accident · Minor injuriesClosedBellanca 17-30A · Phoenix, AZOct 23, 1980 · N28088 · Destroyed NTSB LAX81DUJ24Accident · No injuriesClosedPiper PA-34 · Whiteriver, AZOct 22, 1980 · N5463F · Substantial damage NTSB LAX81FUJ06Accident · Serious injuriesClosedBell 47G-5 · San Luis Rey, AZOct 18, 1980 · N4151W · Destroyed NTSB LAX81DUJ19Accident · Serious injuriesClosedRaven S-55A · Sedona, AZOct 18, 1980 · N5714R · Substantial damage NTSB LAX81FUJ04Accident · No injuriesClosedMooney M20C · Willcox, AZOct 16, 1980 · N9350V · Substantial damage NTSB LAX81DUJ05Accident · No injuriesClosedCessna 185 · Phoenix, AZOct 15, 1980 · N4939Q · Substantial damage NTSB LAX81FUJ03Accident · No injuriesClosedBell 47G-5 · Roll, AZOct 3, 1980 · N7869S · Destroyed NTSB LAX81FUJ02Accident · Serious injuriesClosedBeech S35 · Chandler, AZOct 2, 1980 · N5806S · Substantial damage NTSB LAX81FUJ01Accident · No injuriesClosedBeech F33A · Arlington, AZOct 1, 1980 · N6742D · Substantial damage NTSB LAX80DUK05Accident · Serious injuriesClosedGrumman AA-5B · Phoenix, AZSep 27, 1980 · N1576R · Substantial damage NTSB LAX80DUK06Accident · No injuriesClosedBell 47G3B1 · Seligam, AZSep 24, 1980 · N7901S · Destroyed NTSB LAX80FUK04Accident · Serious injuriesClosedPiper PA-28 · Show Low, AZSep 22, 1980 · N9819W · Substantial damage NTSB LAX80FUJ97Accident · Serious injuriesClosedCessna A188B · Casa Blanca, AZSep 16, 1980 · N53388 · Substantial damage NTSB LAX80DUK03Accident · No injuriesClosedCessna I77RG · Kingman, AZSep 15, 1980 · N1601H · Substantial damage NTSB LAX80DUK02Accident · Minor injuriesClosedCessna A188 · Parker, AZSep 15, 1980 · N731VU · Substantial damage NTSB LAX80FUK01Accident · No injuriesClosedBell 47G-5A · Yuma, AZSep 11, 1980 · N7990J · Destroyed NTSB LAX80FUJ99Accident · No injuriesClosedCessna TR182 · New River, AZSep 11, 1980 · N736HF · Substantial damage NTSB LAX80DUJ96Accident · No injuriesClosedBellanca 7KCAB · Page, AZSep 7, 1980 · N8845 · Substantial damage NTSB LAX80FUJ95Accident · Minor injuriesClosedPiper PA-28R · Lakeside, AZSep 4, 1980 · N40690 · Destroyed NTSB LAX80FUJ98Accident · Serious injuriesClosedScamp Turben · Phoenix, AZAug 30, 1980 · N37690 · Destroyed NTSB LAX80DUJ94Accident · No injuriesClosedPiper PA-36 · Tacna, AZAug 29, 1980 · N57840 · Substantial damage NTSB LAX80DUJ93Accident · No injuriesClosedCessna 172N · Florence, AZAug 26, 1980 · N6305J · Substantial damage NTSB LAX80DUJ89Accident · No injuriesClosedCessna 188B · Hyder, AZAug 8, 1980 · N4786R · Substantial damage NTSB LAX80FUJ90Accident · No injuriesClosedPiper PA-18 · Mesa, AZAug 6, 1980 · N82016 · Substantial damage NTSB LAX80FUJ87Accident · Minor injuriesClosedAyers S-2R · Coolidge, AZAug 6, 1980 · N7796V · Substantial damage NTSB LAX80FUJ92Accident · No injuriesClosedRockwell 600S2R · Buckeye, AZAug 4, 1980 · N5696X · Substantial damage NTSB LAX80DUJ91Accident · No injuriesClosedHiller Acft UH-12E · Sommerton, AZJul 31, 1980 · N9278Z · Substantial damage NTSB LAX80FUJ83Accident · Minor injuriesClosedBell 47G-5 · Sommerton, AZJul 25, 1980 · N7907S · Substantial damage NTSB LAX80DUJ88Accident · No injuriesClosedCessna 177B · Lake Havasu, AZJul 19, 1980 · N20124 · Substantial damage NTSB LAX80DUJ84Accident · No injuriesClosedCessna 210-5 · Prescott, AZJul 18, 1980 · N8335Z · Substantial damage NTSB LAX80FA122Accident · 1 fatalClosedLaister LP-15 · Tucson, AZJul 16, 1980 · N8EM · Substantial damage NTSB LAX80DUJ81Accident · No injuriesClosedGrum-Amer AA-5A · Bisbee, AZJul 8, 1980 · N26721 · Substantial damage NTSB LAX80DUJ79Accident · No injuriesClosedPiper PA-24 · Grand Canyon, AZJul 7, 1980 · N6274P · Substantial damage NTSB LAX80DUJ85Accident · No injuriesClosedCessna 320 · Holbrook, AZJul 6, 1980 · N5748X · Substantial damage NTSB LAX81FUJ80Accident · Minor injuriesClosedCessna 172N · Green Valley, AZJul 5, 1980 · N4819D · Substantial damage