Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 LAX67F0240Accident · No injuriesClosedBellanca 14-19 · Tucson, AZDec 13, 1966 · N7678B · Substantial damage NTSB LAX67A0058Accident · Serious injuriesClosedBell 47G-3B · Grand Canyon, AZDec 12, 1966 · N73208 · Substantial damage NTSB LAX67F0233Accident · No injuriesClosedPiper PA-20 · Yuma, AZDec 11, 1966 · N5596H · Substantial damage NTSB LAX67F0222Accident · No injuriesClosedBeech 23 · Holbrook, AZDec 11, 1966 · N1963F · Substantial damage NTSB LAX67D0235Accident · No injuriesClosedPiper PA-22 · Williams, AZDec 10, 1966 · N3507P · Substantial damage NTSB LAX67F0216Accident · No injuriesClosedSIAI March. S-205 · Phoenix, AZDec 1, 1966 · N4780G · Substantial damage NTSB LAX67A0055Accident · No injuriesClosedPiper PA-24 · Buckeye, AZNov 29, 1966 · N7824P · Substantial damage NTSB LAX67F0226Accident · No injuriesClosedLuscombe 8A · Phoenix, AZNov 28, 1966 · N45694 · Substantial damage NTSB LAX67A0053Accident · No injuriesClosedBeech C50 · Tucson, AZNov 25, 1966 · N3700B · Substantial damage NTSB LAX67F0207Accident · No injuriesClosedBeech 35 · Wellton, AZNov 24, 1966 · N2710V · Substantial damage NTSB LAX67F0215Accident · No injuriesClosedBeech H35 · Tucson, AZNov 22, 1966 · N5478D · Substantial damage NTSB LAX67F0213Accident · Minor injuriesClosedBoeing A75 · Yuma, AZNov 21, 1966 · N56841 · Substantial damage NTSB LAX67D0203Accident · Serious injuriesClosedPiper PA-28 · Maricopa, AZNov 16, 1966 · N6507W · Destroyed NTSB LAX67D0187Accident · No injuriesClosedStinson 108 · Mormon Lake, AZNov 13, 1966 · N97417 · Substantial damage NTSB LAX67F0192Accident · No injuriesClosedMooney M20C · Mesa, AZNov 12, 1966 · N6914U · Substantial damage NTSB LAX67D0198Accident · No injuriesClosedCessna 210 · Parker, AZNov 11, 1966 · N3787Y · Substantial damage NTSB LAX67D0202Accident · Minor injuriesClosedPiper PA-11 · Buckeye, AZNov 6, 1966 · N5086H · Substantial damage NTSB LAX67D0199Accident · Serious injuriesClosedCessna 182 · Phoeni, AZNov 1, 1966 · N2517G · Destroyed NTSB LAX67F0175Accident · No injuriesClosedCessna 195 · Nogales, AZOct 20, 1966 · N1527D · Substantial damage NTSB LAX67F0176Accident · Minor injuriesClosedCessna 150 · Phoenix, AZOct 15, 1966 · N7802Z · Substantial damage NTSB LAX67F0169Accident · No injuriesClosedMooney M20E · Tucson, AZOct 14, 1966 · N2669W · Substantial damage NTSB LAX67D0218Accident · No injuriesClosedPiper PA-22 · Seligman, AZOct 13, 1966 · N2437P · Substantial damage NTSB LAX67D0168Accident · No injuriesClosedCessna 172G · Winslow, AZOct 13, 1966 · N5917R · Substantial damage NTSB LAX67D0164Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 8, 1966 · N1752F · Substantial damage NTSB LAX67D0162Accident · No injuriesClosedPiper PA-24 · Tucson, AZOct 2, 1966 · N8242P · Substantial damage NTSB LAX67D0155Accident · Minor injuriesClosedCessna 172 · Sonoita, AZOct 2, 1966 · N5932R · Destroyed NTSB LAX67D0152Accident · No injuriesClosedBeech J35 · Parker, AZSep 25, 1966 · N8368D · Substantial damage NTSB LAX67D0174Accident · No injuriesClosedLuscombe 8E · Phoenix, AZSep 24, 1966 · N1676K · Substantial damage NTSB LAX67D0143Accident · No injuriesClosedPiper PA-28 · Mt.Trumble, AZSep 23, 1966 · N8608W · Substantial damage NTSB LAX67D0116Accident · No injuriesClosedCessna 180 · Parker, AZSep 14, 1966 · N2821A · Substantial damage NTSB LAX67D0103Accident · Minor injuriesClosedDowner 14-19 · Poston, AZSep 10, 1966 · N1001R · Substantial damage NTSB LAX67D0129Accident · No injuriesClosedCessna 150 · Mesa, AZSep 8, 1966 · N4312U · Substantial damage NTSB LAX67F0105Accident · Serious injuriesClosedCessna 150 · Adamana, AZSep 7, 1966 · N3680J · Destroyed NTSB LAX67D0127Accident · No injuriesClosedChampion 7ECA · Sierra Vista, AZSep 4, 1966 · N2583F · Substantial damage NTSB LAX67F0102Accident · No injuriesClosedCessna 180 · Tucson, AZSep 3, 1966 · N4913A · Substantial damage NTSB LAX67A0028Accident · No injuriesClosedBell 47G-3B · Chandler, AZSep 3, 1966 · N8498E · Substantial damage NTSB LAX67D0108Accident · No injuriesClosedLuscombe 8A · Happy Jack, AZSep 2, 1966 · N45538 · Substantial damage NTSB LAX67F0117Accident · Minor injuriesClosedCallair A-9 · Somerton, AZAug 24, 1966 · N3591G · Substantial damage NTSB LAX67A0022Accident · 1 fatalClosedAeronca 7BCM · Pierce Ferry, AZAug 24, 1966 · N85052 · Substantial damage NTSB LAX67F0095Accident · No injuriesClosedBoeing A-75 · Maricopa, AZAug 17, 1966 · N68162 · Substantial damage NTSB LAX67D0075Accident · No injuriesClosedMooney M20C · Flagstaff, AZAug 12, 1966 · N6511U · Substantial damage NTSB LAX67D0060Accident · No injuriesClosedBeech C-18S · Yuma, AZAug 10, 1966 · N8073H · Substantial damage NTSB LAX67D0050Accident · No injuriesClosedCessna 182 · Williams, AZAug 9, 1966 · N8999T · Substantial damage NTSB LAX67D0056Accident · No injuriesClosedBeech 35 · Window Rock, AZAug 4, 1966 · N5090C · Substantial damage NTSB LAX67A0013Accident · No injuriesClosedPiper PA-23 · Grand Canyon, AZJul 30, 1966 · N4680P · Substantial damage NTSB LAX67A0012Accident · No injuriesClosedBeech D18S · Phoenix, AZJul 30, 1966 · N191U · Substantial damage NTSB LAX67D0063Accident · No injuriesClosedBeech E35 · Prescott, AZJul 27, 1966 · N133Y · Substantial damage NTSB LAX67D0057Accident · Minor injuriesClosedStearman A75 · Dateland, AZJul 27, 1966 · N56551 · Substantial damage NTSB LAX67F0061Accident · Minor injuriesClosedCessna 120 · Esa, AZJul 22, 1966 · N2010V · Destroyed NTSB LAX67F0053Accident · Serious injuriesClosedPiper PA-22 · Tucson, AZJul 21, 1966 · N3317B · Destroyed