Skip to content

NTSB investigations, 1976, AZ

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 LAX77DUJ16Accident · No injuriesClosedCessna 150 · Bagdad, AZDec 28, 1976 · N6682F · Destroyed NTSB LAX77DUJ15Accident · No injuriesClosedCessna 120 · Salome, AZDec 21, 1976 · N120Y · Substantial damage NTSB LAX77DUJ21Accident · No injuriesClosedPiper PA-24 · Tucson, AZDec 16, 1976 · N8699P · Substantial damage NTSB LAX77PUJ13Accident · No injuriesClosedCessna 150 · Parker, AZDec 15, 1976 · N1040M · Substantial damage NTSB LAX77DUJ01Accident · No injuriesClosedCessna 206 · Taylor, AZDec 9, 1976 · N8051Z · Substantial damage NTSB LAX77FUJ11Accident · Minor injuriesClosedCessna 150 · Mesa, AZDec 8, 1976 · N5433Q · Substantial damage NTSB LAX77DUJ14Accident · No injuriesClosedPiper PA-18 · Phoenix, AZDec 5, 1976 · N83480 · Substantial damage NTSB LAX77FA016Accident · 2 fatalClosedPiper PA-28R · Scottsdale, AZDec 4, 1976 · N298CC · Destroyed NTSB LAX77DUJ18|LAX77DUG18Accident · No injuriesClosedCessna 182 · Phoenix, AZDec 2, 1976 · N1998M · 2 aircraft · Substantial damage NTSB LAX77DUJ29Accident · Minor injuriesClosedTaylorcraft BC12-D · Laveen, AZNov 19, 1976 · N95641 · Substantial damage NTSB LAX77FA009Accident · 1 fatalClosedBeech 19A · Grand Canyon, AZNov 13, 1976 · N5084T · Destroyed NTSB LAX77DUJ12Accident · No injuriesClosedMidget Mustan · Wickenburg, AZNov 7, 1976 · N4115B · Substantial damage NTSB LAX77FUJ09Accident · No injuriesClosedPiper PA-28 · Springerville, AZNov 6, 1976 · N9253W · Substantial damage NTSB LAX77DUJ10Accident · No injuriesClosedCessna 172 · Queen Creek, AZOct 29, 1976 · N35723 · Substantial damage NTSB LAX77FA006Accident · 2 fatalClosedCessna 172 · Flagstaff, AZOct 28, 1976 · N5591R · Destroyed NTSB LAX77FA005Accident · 1 fatalClosedCessna U206 · Joseph City, AZOct 27, 1976 · N3945G · Destroyed NTSB LAX77DUJ17Accident · No injuriesClosedBeech D18S · Yucca, AZOct 26, 1976 · N14437 · No damage NTSB LAX77DUJ08Accident · No injuriesClosedPiper PA-23 · San Carlos, AZOct 21, 1976 · N424MC · Substantial damage NTSB LAX77FUJ05Accident · No injuriesClosedCessna 172D · Green Valley, AZOct 19, 1976 · N2151Y · Substantial damage NTSB LAX77FUJ04Accident · Minor injuriesClosedCessna U206E · Yucca, AZOct 16, 1976 · N9462G · Destroyed NTSB LAX77DWJ07Accident · No injuriesClosedPiper PA-28 · Tucson, AZOct 11, 1976 · N5574F · Substantial damage NTSB LAX77FA002Accident · 2 fatalClosedMooney M20C · Phoenix, AZOct 9, 1976 · N2734W · Destroyed NTSB LAX77FUJ03Accident · No injuriesClosedBeech D18S · Buckeye, AZOct 8, 1976 · N587CP · Destroyed NTSB LAX77DUJ06Accident · No injuriesClosedGrum Amer AA-5B · Toyei, AZOct 8, 1976 · N74667 · Substantial damage NTSB LAX77FUJ02Accident · 2 fatalClosedCessna A188A · Buckeye, AZOct 5, 1976 · N9997G · Destroyed NTSB LAX77FA001Accident · 4 fatalClosedBeech 35 · Bagdad, AZOct 2, 1976 · N362TC · Destroyed NTSB LAX76DUK16Accident · No injuriesClosedGrumman G-164 · Sun City, AZSep 30, 1976 · N638U · Substantial damage NTSB LAX76FNK13Accident · 1 fatalClosedPitts Spcl SIS · Prescott, AZSep 29, 1976 · N9RS · Destroyed NTSB LAX76DUK12Accident · Minor injuriesClosedPiper PA-25 · Safford, AZSep 27, 1976 · N7670Z · Substantial damage NTSB LAX76DUK15Accident · No injuriesClosedCessna 188B · Quail Mesa, AZSep 26, 1976 · N5647J · Substantial damage NTSB LAX76AL096Accident · 1 fatalClosedPiper PA-28 · Grand Canyon, AZSep 21, 1976 · N40722 · Destroyed NTSB LAX76FUK10Accident · No injuriesClosedCessna 172F · Chandler, AZSep 14, 1976 · N8749U · Substantial damage NTSB LAX76DUK08Accident · No injuriesClosedHickey SE5A · Phoenix, AZSep 12, 1976 · N596 · Substantial damage NTSB LAX76DUK11Accident · No injuriesClosedCessna 170A · Carefree, AZSep 6, 1976 · N9219A · Substantial damage NTSB LAX76AL093Accident · 2 fatalClosedPiper PA-34 · Phoenix, AZSep 6, 1976 · N15075 · Destroyed NTSB LAX76DUK07Accident · No injuriesClosedCessna 188 · Poston, AZSep 2, 1976 · N53219 · Substantial damage NTSB LAX76DVK14Accident · No injuriesClosedPiper PA-28 · Gila Bend, AZAug 30, 1976 · N32030 · Substantial damage NTSB LAX76DUK04Accident · No injuriesClosedCessna 150 · Prescott, AZAug 28, 1976 · N12944 · Substantial damage NTSB LAX76DUK17Accident · No injuriesClosedCessna 210 · Wilcox, AZAug 24, 1976 · N3374S · Substantial damage NTSB LAX76DUK09Accident · No injuriesClosedBeech V35 · Payson, AZAug 15, 1976 · N7966M · Substantial damage NTSB LAX76DUK01Accident · Serious injuriesClosedPiper PA-28 · Winslow, AZAug 14, 1976 · N41495 · Destroyed NTSB LAX76DUK05Accident · No injuriesClosedCessna 182 · Young, AZAug 13, 1976 · N2633Q · Destroyed NTSB LAX76DUK03Accident · No injuriesClosedGrumman G-164A · Gila Bend, AZAug 12, 1976 · N4529 · Destroyed NTSB LAX76DUJ01Accident · No injuriesClosedNaval Fcty N3N-3 · Tempe, AZAug 12, 1976 · N44744 · Substantial damage NTSB LAX76FUJ99Accident · No injuriesClosedBellanca 14-132 · Sedona, AZAug 11, 1976 · N74405 · Substantial damage NTSB LAX76DUJ98Accident · No injuriesClosedPiper PA-28 · Roll, AZAug 11, 1976 · N6495J · Substantial damage NTSB LAX76FUJ97Accident · No injuriesClosedNaval Fcty N3N-3 · Coolidge, AZAug 5, 1976 · N44738 · Substantial damage NTSB LAX76FUJ95Accident · No injuriesClosedCessna 150F · Springerville, AZJul 31, 1976 · N8434G · Substantial damage NTSB LAX76DUJ94Accident · No injuriesClosedTaylorcraft BC12-D · Laveen, AZJul 26, 1976 · N5208M · Substantial damage NTSB LAX76AL090Accident · 1 fatalClosedChampion 7ECA · Black Canyon, AZJul 24, 1976 · N9043L · Destroyed