Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 DEN66D0193Accident · No injuriesClosedCessna 170B · Carefree, AZDec 31, 1965 · N4500C · Substantial damage NTSB DEN66A0051Accident · No injuriesClosedBell 47G3B1 · Mesa, AZDec 30, 1965 · N73947 · Substantial damage NTSB DEN66F0199Accident · No injuriesClosedMooney M20C · Phoenix, AZDec 29, 1965 · N7815V · Substantial damage NTSB DEN66D0204Accident · Minor injuriesClosedPiper PA-22 · Payson, AZDec 28, 1965 · N8519C · Destroyed NTSB DEN66D0192Accident · No injuriesClosedFairchild F24 · Tucson, AZDec 25, 1965 · N77607 · Substantial damage NTSB DEN66A0050Accident · 2 fatalClosedCessna 182 · Laveen, AZDec 22, 1965 · N9944B · Destroyed NTSB DEN66A0044Accident · 2 fatalClosedCessna 120 · Kingman, AZDec 12, 1965 · N89805 · Destroyed NTSB DEN66A0043Accident · No injuriesClosedFairchild F-27 · Yuma, AZDec 8, 1965 · N749L · Substantial damage NTSB DEN66D0181Accident · Minor injuriesClosedLuscombe 8A · Chandler, AZDec 5, 1965 · N45738 · Substantial damage NTSB DEN66D0186Accident · No injuriesClosedBeechcraft S35 · Phoenix, AZDec 4, 1965 · N8944M · Substantial damage NTSB FTW66A0054Accident · 2 fatalClosedBeech T34A · Gila Bend, AZNov 30, 1965 · N12273 · Destroyed NTSB DEN66D0187Accident · No injuriesClosedNavion B · Havasu City, AZNov 27, 1965 · N8647H · Substantial damage NTSB DEN66D0180Accident · No injuriesClosedPiper PA-28 · Yuma, AZNov 27, 1965 · N5434W · Substantial damage NTSB DEN66D0177Accident · No injuriesClosedCessna 150 · Tucson, AZNov 26, 1965 · N4138U · Substantial damage NTSB DEN66F0178Accident · No injuriesClosedBeechcraft S35 · Tucson, AZNov 25, 1965 · N8699Q · Substantial damage NTSB DEN66A0037Accident · 5 fatalClosedBeech 35 · Roosevelt, AZNov 25, 1965 · N4572V · Destroyed NTSB DEN66A0042Accident · 2 fatalClosedPiper PA-22 · Quartzsite, AZNov 24, 1965 · N2924P · Destroyed NTSB DEN66A0039Accident · 2 fatalClosedCessna 210 · Payson, AZNov 24, 1965 · N9633X · Destroyed NTSB DEN66D0179Accident · No injuriesClosedBeechcraft B-95 · Phoenix, AZNov 14, 1965 · N659T · Substantial damage NTSB DEN66D0175Accident · No injuriesClosedPiper PA-28 · Phoenix, AZNov 8, 1965 · N5279W · Substantial damage NTSB DEN66F0174Accident · Minor injuriesClosedNaval Arcft N3N-3 · Sun City, AZNov 4, 1965 · N44757 · Substantial damage NTSB DEN66D0167Accident · No injuriesClosedCessna 182F · Casa Grande, AZOct 29, 1965 · N3536Y · Substantial damage NTSB DEN66F0140Accident · No injuriesClosedNaval Arcft N3N-3 · Litchfield Pk, AZOct 25, 1965 · N45024 · Substantial damage NTSB DEN66D0158Accident · No injuriesClosedCessna 140 · Yuma, AZOct 23, 1965 · N2321V · Substantial damage NTSB DEN66D0161Accident · No injuriesClosedMooney M20C · Mormon Lake, AZOct 20, 1965 · N6758U · Substantial damage NTSB DEN66A0026Accident · No injuriesClosedBell 47G-2 · Queen Creek, AZOct 14, 1965 · N5158B · Substantial damage NTSB DEN66D0137Accident · Minor injuriesClosedBellanca 14-19 · Payson, AZOct 2, 1965 · N9812B · Destroyed NTSB DEN66D0135Accident · No injuriesClosedCessna 180 · Pearce, AZSep 28, 1965 · N3633C · Substantial damage NTSB DEN66D0134Accident · No injuriesClosedCessna 170B · Phoenix, AZSep 21, 1965 · N2917D · Substantial damage NTSB DEN66D0128Accident · No injuriesClosedNaval Arcft N3N · Mesa, AZSep 11, 1965 · N44863 · Destroyed NTSB DEN66D0127Accident · No injuriesClosedBoeing A-75N1 · Goodyear, AZAug 26, 1965 · N63496 · Substantial damage NTSB DEN66F0078Accident · Serious injuriesClosedNavion D-16 · Grand Canyon, AZAug 21, 1965 · N88W · Destroyed NTSB DEN66D0112Accident · No injuriesClosedTaylorcraft L-2 · New River, AZAug 17, 1965 · N49195 · Substantial damage NTSB DEN66F0092Accident · Minor injuriesClosedNaval Arcft N3N-3 · Casa Grande, AZAug 6, 1965 · N45094 · Destroyed NTSB DEN66A0005Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZAug 5, 1965 · N1182W · Substantial damage NTSB DEN66F0071Accident · Minor injuriesClosedLuscombe 8E · Wendon, AZAug 1, 1965 · N2539K · Substantial damage NTSB DEN66D0096Accident · No injuriesClosedPiper PA-22 · Sanders, AZJul 30, 1965 · N1646P · Substantial damage NTSB DEN66A0013Accident · No injuriesClosedHughes 269A-1 · Mesa, AZJul 29, 1965 · N8949F · Substantial damage NTSB DEN66D0070Accident · No injuriesClosedCessna 310B · Phoenix, AZJul 23, 1965 · N6644B · Substantial damage NTSB DEN66A0012Accident · No injuriesClosedBell 47G3B · Show Low, AZJul 23, 1965 · N73236 · Substantial damage NTSB DEN66A0011Accident · 2 fatalClosedAeronca 7AC · Chandler, AZJul 23, 1965 · N81719 · Destroyed NTSB DEN66D0065Accident · No injuriesClosedCessna 182 · Holbrook, AZJul 16, 1965 · N34565 · Substantial damage NTSB DEN66A0008Accident · No injuriesClosedBell 47G3B · Phoenix, AZJul 12, 1965 · N6788D · Substantial damage NTSB DEN66D0056Accident · No injuriesClosedPiper PA-28 · L.Havasu Cty, AZJul 11, 1965 · N5077P · Substantial damage NTSB UNK65X1516Accident · No injuriesClosedPiper PA-22 · Casa Grande, AZJul 7, 1965 · N1583P · Destroyed NTSB DEN66D0036Accident · Serious injuriesClosedPiper PA-25 · Goodyear, AZJul 3, 1965 · N6492Z · Destroyed NTSB DEN66A0003Accident · No injuriesClosedBrantly B2B · Phoenix, AZJul 3, 1965 · N2170U · Substantial damage NTSB DEN66D0055Accident · No injuriesClosedBeechcraft 35 · Flagstaff, AZJun 29, 1965 · N2875V · Substantial damage NTSB DEN65A0087Accident · No injuriesClosedBell Barnes · Phoenix, AZJun 29, 1965 · N74090 · Substantial damage NTSB DEN66D0043Accident · No injuriesClosedCessna 140 · Hereford, AZJun 27, 1965 · N1634V · Substantial damage