Skip to content

NTSB investigations, 1981, 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, 1981, 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") = 1981 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\") = 1981
    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") = 1981
  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 LAX82FA029Accident · 1 fatalClosedCessna 172 · Vernon, AZDec 21, 1981 · N6525E · Destroyed NTSB LAX82DUJ23Accident · No injuriesClosedCessna 172 · Roll, AZDec 18, 1981 · N733DN · Substantial damage NTSB LAX82DUJ21Accident · Minor injuriesClosedPiper PA-28 · Show Low, AZDec 17, 1981 · N9404J · Substantial damage NTSB LAX82FUJ18Accident · No injuriesClosedCessna 172 · Tucson, AZDec 9, 1981 · N5384R · Substantial damage NTSB LAX82FUJ17Accident · 2 fatalClosedPiper PA-23 · Tucson, AZDec 6, 1981 · N13792 · Destroyed NTSB LAX82FUJ14Accident · No injuriesClosedCessna 150 · Scottsdale, AZDec 6, 1981 · N4655M · Destroyed NTSB LAX82FUJ16Accident · Serious injuriesClosedCessna 140 · Cottonwood, AZDec 3, 1981 · N2040N · Destroyed NTSB LAX82FA023Accident · 3 fatalClosedCessna 210L · Douglas, AZDec 3, 1981 · N93956 · Destroyed NTSB LAX82DUJ19Accident · No injuriesClosedMooney M20E · Chandler, AZDec 2, 1981 · N9159V · Substantial damage NTSB LAX82FUJ20Accident · Minor injuriesClosedAerospatle AS350D · Carefree, AZNov 28, 1981 · N3595M · Substantial damage NTSB LAX82DUJ13Accident · No injuriesClosedPiper PA-23 · Phoenix, AZNov 27, 1981 · N1303P · Substantial damage NTSB LAX82FA021Accident · 3 fatalClosedBeech J35 · Lake Havasu, AZNov 25, 1981 · N12LJ · Destroyed NTSB LAX82DUJ11Accident · Minor injuriesClosedCessna 152 · Wikieup, AZNov 22, 1981 · N69196 · Substantial damage NTSB LAX82DUJ10Accident · Minor injuriesClosedBell 206B · Grand Canyon, AZNov 22, 1981 · N2163X · Destroyed NTSB LAX82FUJ07Accident · No injuriesClosedRaven AX-7 · Phoenix, AZNov 14, 1981 · N5730M · Substantial damage NTSB LAX82DUJ09Accident · No injuriesClosedMaule M-5 · Black Canyon, AZNov 14, 1981 · N6266M · Substantial damage NTSB LAX82DUJ06Accident · No injuriesClosedCessna 172 · Marana, AZNov 8, 1981 · N738MQ · Substantial damage NTSB LAX82DUJ05Accident · No injuriesClosedCessna A185F · Prescott, AZNov 7, 1981 · N3308S · Substantial damage NTSB LAX82FA011Accident · 1 fatalClosedCessna 152 · Avondale, AZNov 5, 1981 · N24727 · Destroyed NTSB LAX82DUJ22Accident · No injuriesClosedCessna 150K · Sedona, AZNov 1, 1981 · N6264G · Substantial damage NTSB LAX82FUJ04Accident · No injuriesClosedCessna P210 · Phoenix, AZOct 30, 1981 · N4773P · Substantial damage NTSB LAX82DUJ15Accident · No injuriesClosedCessna 150 · Lk Havasu Cy, AZOct 30, 1981 · N3018V · Substantial damage NTSB LAX82FA008Accident · 1 fatalClosedCessna 172N · Prescott, AZOct 28, 1981 · N733BB · Destroyed NTSB LAX82DUJ03Accident · No injuriesClosedHughes 369HS · Salome, AZOct 28, 1981 · N9084F · Substantial damage NTSB LAX82DUJ02Accident · No injuriesClosedPiper PA-38 · Show Low, AZOct 22, 1981 · N2425A · Substantial damage NTSB LAX82DUJ01Accident · No injuriesClosedPiper PA-23 · Show Low, AZOct 10, 1981 · N1322P · Substantial damage NTSB LAX81DUK06Accident · Minor injuriesClosedCessna T210M · Yuma, AZSep 28, 1981 · N761UL · Substantial damage NTSB LAX81DUK08Accident · Minor injuriesClosedCessna 177 · Winslow, AZSep 27, 1981 · N3242T · Substantial damage NTSB LAX81DUJ81Accident · No injuriesClosedAyers S2R · Poston, AZSep 27, 1981 · N4025K · Substantial damage NTSB LAX81DUK10Accident · No injuriesClosedTexas Hel OH-13H · Yuma, AZSep 25, 1981 · N51853 · Substantial damage NTSB LAX81DUK07Accident · No injuriesClosedCessna 172 · Wahweap, AZSep 25, 1981 · N6586J · Substantial damage NTSB DEN81FA067Accident · No injuriesClosedSwearingen SA266 · Flagstaff, AZSep 24, 1981 · N161SW · 2 aircraft · Substantial damage NTSB LAX81FUK04Accident · Minor injuriesClosedCessna 402B · Kayenta, AZSep 23, 1981 · N3826C · Substantial damage NTSB LAX81DUK03Accident · No injuriesClosedHiller Acft UH-12E · Gadsden, AZSep 20, 1981 · N62903 · Substantial damage NTSB LAX81FA128Accident · 2 fatalClosedErco 415-D · Carefree, AZSep 19, 1981 · N3123H · Destroyed NTSB LAX81DUK09Accident · No injuriesClosedSchweizer 1-26 · Sun City, AZSep 14, 1981 · N7754S · Substantial damage NTSB LAX81DUK05Accident · No injuriesClosedCessna 170A · Cottonwood, AZSep 13, 1981 · N9164A · Substantial damage NTSB LAX81FUK01Accident · Minor injuriesClosedAero Comdr 500A · Flagstaff, AZSep 10, 1981 · N6JB · Substantial damage NTSB LAX81DUK02Accident · No injuriesClosedBell 47G-5 · Yuma, AZSep 4, 1981 · N2294W · Substantial damage NTSB LAX81DUJ99Accident · Serious injuriesClosedGlasflugel H301B · Maricopa, AZSep 1, 1981 · N71949 · Substantial damage NTSB LAX81DUJ91Accident · Minor injuriesClosedGrumman G-164B · Tonapah, AZAug 29, 1981 · N6776K · Destroyed NTSB LAX81DUJ78Accident · No injuriesClosedCessna TR182 · Grand Canyon, AZAug 27, 1981 · N2518S · Substantial damage NTSB LAX81DUJ97Accident · No injuriesClosedCessna 150 · Douglas, AZAug 24, 1981 · N10896 · Substantial damage NTSB LAX81DUJ96Accident · No injuriesClosedCessna 210 · Prescott, AZAug 23, 1981 · N9585T · Substantial damage NTSB LAX81DUJ95Accident · No injuriesClosedNavion A · Prescott, AZAug 23, 1981 · N5110K · Substantial damage NTSB LAX81DUJ94Accident · Minor injuriesClosedPiper PA-24 · Williams, AZAug 23, 1981 · N9496P · Substantial damage NTSB LAX81FA121Accident · 6 fatalClosedPiper PA-32R · Grand Canyon, AZAug 21, 1981 · N9822C · Destroyed NTSB LAX81DUJ92Accident · No injuriesClosedCessna 182 · Yuma, AZAug 21, 1981 · N5535B · Substantial damage NTSB LAX81FUJ88Accident · 1 fatalClosedAir Tractor AT-302 · Phoenix, AZAug 19, 1981 · N5232S · Destroyed NTSB LAX81FA120Accident · Serious injuriesClosedCessna T207A · Tusayan, AZAug 18, 1981 · N6441H · Substantial damage