Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 LAX78FUJ19Accident · No injuriesClosedCessna 185F · Mesa, AZDec 21, 1977 · N183Z · Substantial damage NTSB LAX78FUJ18Accident · No injuriesClosedPiper PA-30 · Tucson, AZDec 14, 1977 · N7194Y · Substantial damage NTSB LAX78DUJ15Accident · Minor injuriesClosedMooney M20F · Red Mesa, AZDec 4, 1977 · N4047N · Destroyed NTSB LAX78FA011Accident · 4 fatalClosedCessna 177B · Tucson, AZDec 3, 1977 · N34100 · 2 aircraft · Destroyed NTSB LAX78DUJ16Accident · No injuriesClosedBeech V35A · Rio Rico, AZDec 3, 1977 · N5912S · Substantial damage NTSB LAX78FA010Accident · No injuriesClosedCessna U206F · Camp Verde, AZNov 28, 1977 · N60566 · Destroyed NTSB LAX78DUJ17Accident · No injuriesClosedPiper PA-32 · Holbrook, AZNov 28, 1977 · N8629N · Substantial damage NTSB LAX78DUJ14Accident · Minor injuriesClosedNavion A · Greasewood, AZNov 27, 1977 · N4140K · Substantial damage NTSB LAX78FA009Accident · 2 fatalClosedMooney M20B · Tucson, AZNov 26, 1977 · N74771 · Destroyed NTSB LAX78DUJ12Accident · Minor injuriesClosedMaule M-5 · Tucson, AZNov 24, 1977 · N9207E · Substantial damage NTSB LAX78FUJ13Accident · Minor injuriesClosedCessna 175A · Flagstaff, AZNov 22, 1977 · N6871E · Substantial damage NTSB LAX78DUJ11Accident · No injuriesClosedPiper PA-28 · Phoenix, AZNov 12, 1977 · N9004J · Substantial damage NTSB LAX78DUJ10Accident · Minor injuriesClosedCessna 210K · Benson, AZNov 12, 1977 · N9484M · Substantial damage NTSB LAX78FUJ09Accident · No injuriesClosedHelio Acft H-295 · Scottsdale, AZNov 8, 1977 · N99PM · Substantial damage NTSB LAX78FUJ08Accident · Minor injuriesClosedCessna 150 · Tucson, AZNov 4, 1977 · N3092J · Substantial damage NTSB LAX78DUJ02Accident · No injuriesClosedPiper PA-25 · Arizona City, AZNov 4, 1977 · N8465Z · Substantial damage NTSB LAX78FA003Accident · 1 fatalClosedCessna 182J · Buckeye, AZOct 30, 1977 · N3531F · Destroyed NTSB LAX78DUJ07Accident · No injuriesClosedCessna 150 · Mesa, AZOct 27, 1977 · N2890V · Substantial damage NTSB LAX78FUJ06Accident · No injuriesClosedCessna 140 · Tonopah, AZOct 22, 1977 · N90075 · Substantial damage NTSB LAX78FUJ05Accident · No injuriesClosedCessna 182J · Phoenix, AZOct 20, 1977 · N3427F · Substantial damage NTSB LAX78FUJ03Accident · No injuriesClosedLockheed 18 · Globe, AZOct 12, 1977 · N29L · Substantial damage NTSB LAX78FUJ04Accident · Serious injuriesClosedPiper PA-28R · Stanfield, AZOct 7, 1977 · N2881T · Destroyed NTSB LAX78FUJ01Accident · No injuriesClosedCessna 150M · Mesa, AZOct 6, 1977 · N714LM · Substantial damage NTSB LAX77DUK06Accident · No injuriesClosedPiper PA-32 · Marble Canyon, AZSep 25, 1977 · N1929H · Substantial damage NTSB LAX77DUK07Accident · No injuriesClosedPiper PA-24 · Globe, AZSep 21, 1977 · N6691P · Substantial damage NTSB LAX77FUK04Accident · Minor injuriesClosedStinson 10A · Tucson, AZSep 19, 1977 · N36748 · Substantial damage NTSB LAX77DUK05Accident · No injuriesClosedBeech C23 · Tucson, AZSep 19, 1977 · N9249S · Destroyed NTSB LAX77FUK03Accident · No injuriesClosedPiper PA-25 · Maricopa, AZSep 14, 1977 · N6601Z · No damage NTSB LAX77DUK02Accident · No injuriesClosedBell 47D1 · Poston, AZSep 14, 1977 · N8060E · Substantial damage NTSB LAX77FUJ98Accident · No injuriesClosedAero Comdr S2R · Stanfield, AZSep 5, 1977 · N8961Q · Substantial damage NTSB LAX77FUJ99Accident · Serious injuriesClosedGrumman G-164A · Casa Grande, AZSep 3, 1977 · N968X · Substantial damage NTSB LAX77FUJ96Accident · No injuriesClosedLuscombe 8E · Mormon Lake, AZSep 3, 1977 · N2612K · Substantial damage NTSB LAX77FUJ94Accident · No injuriesClosedGrumman G-164A · Buckeye, AZAug 30, 1977 · N5297 · Substantial damage NTSB LAX77FUJ93Accident · No injuriesClosedScheibe 25E · Scottsdale, AZAug 30, 1977 · N250BA · Substantial damage NTSB LAX77FUJ88Accident · Minor injuriesClosedGrumman G-164 · Chandler, AZAug 30, 1977 · N597Y · Substantial damage NTSB LAX77DUJ95Accident · No injuriesClosedCessna 150 · Tucson, AZAug 30, 1977 · N63237 · Substantial damage NTSB LAX77FUJ92Accident · Minor injuriesClosedCessna 172 · Wickenburg, AZAug 27, 1977 · N8014L · Substantial damage NTSB LAX77DUK01Accident · No injuriesClosedCessna 150 · Roosevelt Lk, AZAug 24, 1977 · N3273J · Substantial damage NTSB LAX77FUJ91Accident · No injuriesClosedHughes 269C · Grand Canyon, AZAug 23, 1977 · N7484F · Substantial damage NTSB LAX77FUJ90Accident · No injuriesClosedHiller UH-12E · Mesa, AZAug 22, 1977 · N28877 · Substantial damage NTSB LAX77FUJ59Accident · No injuriesClosedPiper PA-20 · New River, AZAug 20, 1977 · N7707K · Substantial damage NTSB LAX77FUJ86Accident · No injuriesClosedCessna 310Q · Scottsdale, AZAug 19, 1977 · N69724 · Substantial damage NTSB LAX77DUJ85Accident · No injuriesClosedCessna 401A · Valle, AZAug 15, 1977 · N401AC · Substantial damage NTSB LAX77FUJ79Accident · No injuriesClosedLuscombe 8A · Scottsdale, AZAug 9, 1977 · N77881 · Substantial damage NTSB LAX77DUJ80Accident · No injuriesClosedBeech C23 · Tucson, AZAug 9, 1977 · N1932L · Substantial damage NTSB LAX77FUJ87Accident · Serious injuriesClosedCessna 182 · Wellton, AZAug 8, 1977 · N1367S · Substantial damage NTSB LAX77FUJ78Accident · 3 fatalClosedBellanca 14-13 · Mesa, AZAug 7, 1977 · N86769 · Destroyed NTSB LAX77FUJ84Accident · No injuriesClosedCessna 177B · Casa Grande, AZAug 4, 1977 · N35166 · Substantial damage NTSB LAX77FUJ74Accident · No injuriesClosedCessna 207 · Willcox, AZAug 3, 1977 · N9440G · Substantial damage NTSB LAX77FUJ83Accident · No injuriesClosedGrumman G-164B · Queen Creek, AZJul 31, 1977 · N6729Q · Substantial damage