Skip to content

NTSB investigations, 1964, 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, 1964, 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") = 1964 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\") = 1964
    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") = 1964
  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 UNK65X1119Accident · 2 fatalClosedMooney M20E · Show Low, AZDec 24, 1964 · N7831V · Destroyed NTSB UNK65X1080Accident · No injuriesClosedCessna 310 · Young, AZDec 21, 1964 · N5282A · Substantial damage NTSB UNK65X1032Accident · No injuriesClosedConvair PBY6A · Phoenix, AZDec 16, 1964 · N7057C · Substantial damage NTSB UNK65X1000Accident · No injuriesClosedLake LA4 · Winslow, AZDec 13, 1964 · N1134L · Substantial damage NTSB UNK65X0988Accident · No injuriesClosedCessna 182 · Flagstaff, AZDec 12, 1964 · N3150Y · Substantial damage NTSB UNK65X0974Accident · No injuriesClosedCessna 172 · Kingman, AZDec 11, 1964 · N1326Y · Substantial damage NTSB UNK65X0888Accident · No injuriesClosedCessna 310B · Tucson, AZNov 29, 1964 · N5232A · Substantial damage NTSB UNK65X0884Accident · No injuriesClosedBeechcraft T34 · Buckeye, AZNov 29, 1964 · N109L · Substantial damage NTSB UNK65X0853Accident · No injuriesClosedCessna 310 · Tucson, AZNov 27, 1964 · N9899Z · Substantial damage NTSB UNK65X0825Accident · Minor injuriesClosedTaylorcraft BC12D · Fishers Ldg, AZNov 25, 1964 · N43726 · Substantial damage NTSB UNK65X0766Accident · Minor injuriesClosedPiper PA18 · Cochise, AZNov 20, 1964 · N1758P · Destroyed NTSB UNK65X0686Accident · No injuriesClosedCessna 205 · Tucson, AZNov 13, 1964 · N1827Z · Substantial damage NTSB UNK65X0680Accident · Serious injuriesClosedCessna 150 · Red Rock, AZNov 12, 1964 · N5940T · Destroyed NTSB UNK65X0612Accident · No injuriesClosedCallair A5 · Wellton, AZNov 8, 1964 · N2961G · Substantial damage NTSB UNK65X0561Accident · No injuriesClosedHughes 269A · Mt Trumbull, AZNov 4, 1964 · N8812F · Substantial damage NTSB UNK65X0538Accident · No injuriesClosedCessna 182 · Phoenix, AZNov 3, 1964 · N9224X · Substantial damage NTSB UNK65X0536Accident · Minor injuriesClosedBell 47G2 · Yuma, AZNov 2, 1964 · N6712D · Substantial damage NTSB UNK65X0493Accident · Serious injuriesClosedAeronca 65CA · Cameron, AZOct 30, 1964 · N31392 · Substantial damage NTSB UNK65X0449Accident · No injuriesClosedCessna 182 · Prescott, AZOct 27, 1964 · N2816Y · Substantial damage NTSB UNK65X0404Accident · No injuriesClosedPiper PA20 · Marana, AZOct 24, 1964 · N1567A · Substantial damage NTSB UNK65X0403Accident · No injuriesClosedPiper PA22 · Payson, AZOct 24, 1964 · N5745Z · Substantial damage NTSB UNK65X0400Accident · Minor injuriesClosedPiper PA22 · Tempe, AZOct 24, 1964 · N3113Z · Destroyed NTSB UNK65X0397Accident · No injuriesClosedCessna 182B · Phoenix, AZOct 24, 1964 · N2701G · Substantial damage NTSB UNK65X0379Accident · Serious injuriesClosedBoeing A75 · Mesa, AZOct 22, 1964 · N1148M · Destroyed NTSB UNK65X0333Accident · No injuriesClosedCessna C34 · Site Six, AZOct 18, 1964 · N15821 · Substantial damage NTSB UNK65X0311Accident · 3 fatalClosedPiper PA24 · Bumble Bee, AZOct 17, 1964 · N5951P · Destroyed NTSB UNK65X0299Accident · 2 fatalClosedHughes 269B · Crown King, AZOct 16, 1964 · N9340F · Destroyed NTSB UNK65X0282Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 15, 1964 · N8118B · Substantial damage NTSB UNK65X0199Accident · Minor injuriesClosedHughes 269B · Phoenix, AZOct 8, 1964 · N9333F · Substantial damage NTSB UNK65X0155Accident · No injuriesClosedBeechcraft 35B33 · Phoenix, AZOct 5, 1964 · N8923M · Substantial damage NTSB UNK65X0133Accident · No injuriesClosedHughes 269A · Scottsdale, AZOct 3, 1964 · N8744F · Substantial damage NTSB UNK64X4153Accident · No injuriesClosedPiper PA28 · Kayenta, AZSep 26, 1964 · N8865W · Substantial damage NTSB UNK64X4147Accident · No injuriesClosedPiper J3 · Herford, AZSep 25, 1964 · N98180 · Substantial damage NTSB UNK64X4123Accident · No injuriesClosedLuscombe 8A · Kingman, AZSep 24, 1964 · N1911B · Substantial damage NTSB UNK64X4118Accident · Minor injuriesClosedMooney MK21 · Springervill, AZSep 23, 1964 · N6940U · Substantial damage NTSB UNK64X4076Accident · No injuriesClosedLuscombe 8A · Mesa, AZSep 20, 1964 · N77885 · Substantial damage NTSB UNK64X4068Accident · No injuriesClosedCessna 150B · Tucson, AZSep 20, 1964 · N7364X · Substantial damage NTSB UNK64X4028Accident · 2 fatalClosedBeechcraft K35 · Cibola, AZSep 17, 1964 · N348B · Substantial damage NTSB UNK64X3994Accident · No injuriesClosedBeechcraft D18S · Sierra Vista, AZSep 15, 1964 · N80047 · Substantial damage NTSB UNK64X3919Accident · No injuriesClosedCessna 172 · Wilcox, AZSep 11, 1964 · N2598U · Substantial damage NTSB UNK64X3902Accident · Minor injuriesClosedMooney M20C · Sells, AZSep 10, 1964 · N6276U · Substantial damage NTSB UNK64X3861Accident · Minor injuriesClosedCessna 170 · Tucson, AZSep 7, 1964 · N3866V · Destroyed NTSB UNK64X3778Accident · 1 fatalClosedCessna 182C · Parker, AZSep 4, 1964 · N8745T · Destroyed NTSB UNK64X3763Accident · No injuriesClosedPiper PA23 · Douglas, AZSep 4, 1964 · N4858P · Substantial damage NTSB UNK64X3755Accident · Minor injuriesClosedPiper PA25 · Eloy, AZSep 3, 1964 · N6821Z · Substantial damage NTSB UNK64X3746Accident · No injuriesClosedNavy N3N3 · Gilbert, AZSep 2, 1964 · N45273 · Substantial damage NTSB UNK64X3704Accident · No injuriesClosedHughes 269A · Phoenix, AZAug 31, 1964 · N8784F · Destroyed NTSB UNK64X3683Accident · No injuriesClosedCessna 182 · Flagstaff, AZAug 30, 1964 · N3988D · Substantial damage NTSB UNK64X3681Accident · Minor injuriesClosedLuscombe 8A · Laveen, AZAug 30, 1964 · N25211 · Substantial damage NTSB UNK64X3540Accident · No injuriesClosedFairchild WM62C · Salome, AZAug 22, 1964 · N57064 · Substantial damage