Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 LAX68D0282Incident · Minor injuriesClosedPiper PA-28 · Winslow, AZDec 25, 1967 · CF-SPT · Substantial damage NTSB LAX68D0275Accident · No injuriesClosedBeech V35 · Eloy, AZDec 21, 1967 · N5605S · Substantial damage NTSB LAX68D0245Accident · No injuriesClosedBell 47J-2 · Sunflower, AZDec 20, 1967 · N922NA · Substantial damage NTSB LAX68F0259Accident · No injuriesClosedBeech D18S · Phoenix, AZDec 15, 1967 · N7526 · Substantial damage NTSB LAX68F0265Accident · No injuriesClosedCessna 411 · Phoenix, AZDec 13, 1967 · N617EJ · Substantial damage NTSB LAX68F0249Accident · No injuriesClosedPiper PA-24 · Tucson, AZDec 11, 1967 · N7740P · Substantial damage NTSB LAX68D0370Accident · No injuriesClosedLovings Love B · Chandler, AZDec 10, 1967 · N15R · Substantial damage NTSB LAX68D0233Accident · No injuriesClosedPiper PA-25 · Litchfield, AZNov 22, 1967 · N4483Y · Substantial damage NTSB LAX68A0049Accident · 1 fatalClosedSnow S2A · Dateland, AZNov 15, 1967 · N9406R · Destroyed NTSB LAX68D0244Accident · No injuriesClosedCessna 185 · Tucson, AZNov 12, 1967 · N4548F · Substantial damage NTSB LAX68D0230Accident · Minor injuriesClosedBeech F35 · Peach Spring, AZNov 9, 1967 · N3371C · Substantial damage NTSB LAX68F0208Accident · No injuriesClosedBeech C35 · Phoenix, AZNov 7, 1967 · N8973A · Substantial damage NTSB LAX68D0232Accident · No injuriesClosedCessna 172 · Cibola, AZNov 7, 1967 · N1432Y · Substantial damage NTSB LAX68D0209Accident · No injuriesClosedAeronca 7AC · Cave Creek, AZNov 6, 1967 · N81474 · Substantial damage NTSB LAX68D0201Accident · No injuriesClosedCessna 210 · Phoenix, AZNov 5, 1967 · N9678T · Substantial damage NTSB LAX68A0045Accident · 5 fatalClosedCessna 182 · Grand Canyon, AZNov 1, 1967 · N3555Y · Destroyed NTSB LAX68A0044Accident · 1 fatalClosedPiper PA-24 · Show Low, AZOct 31, 1967 · N6418P · Destroyed NTSB LAX68D0197Accident · No injuriesClosedBellanca 14-19 · Springervile, AZOct 26, 1967 · N8838R · Substantial damage NTSB LAX68F0195Accident · Minor injuriesClosedPiper PA-15 · Tucson, AZOct 21, 1967 · N4466H · Substantial damage NTSB LAX68D0210Accident · No injuriesClosedCessna 177 · Phoenix, AZOct 16, 1967 · N2244Y · Substantial damage NTSB LAX68D0211Accident · No injuriesClosedCessna 172 · Lk Havsu Cty, AZOct 15, 1967 · N7456X · Substantial damage NTSB LAX68D0176Accident · No injuriesClosedMooney M21 · Grand Canyon, AZOct 15, 1967 · N6691U · Substantial damage NTSB LAX68D0171Accident · No injuriesClosedLuscombe 8A · Dateland, AZOct 8, 1967 · N1186B · Substantial damage NTSB LAX68D0188Accident · No injuriesClosedCessna 172 · Joseph City, AZOct 1, 1967 · N3003U · Substantial damage NTSB LAX68D0194Accident · No injuriesClosedBeech B35 · Phoenix, AZSep 30, 1967 · N7953K · Substantial damage NTSB LAX68D0162Accident · Minor injuriesClosedCessna 182 · Clifton, AZSep 30, 1967 · N2346R · Destroyed NTSB LAX68D0192Accident · No injuriesClosedPiper PA-22 · Coolidge, AZSep 28, 1967 · N2914P · Substantial damage NTSB LAX68D0157Accident · No injuriesClosedBeech 60 · Sedona, AZSep 26, 1967 · N1060D · Substantial damage NTSB LAX68F0150Accident · No injuriesClosedCessna 172 · Phoenix, AZSep 24, 1967 · N5781R · Substantial damage NTSB LAX68D0175Accident · No injuriesClosedCessna 120 · Prescott, AZSep 16, 1967 · N4211N · Substantial damage NTSB LAX68I0031Incident · No injuriesClosedBoeing 707 · Phoenix, AZSep 14, 1967 · N7598A · Minor damage NTSB LAX68D0236Accident · No injuriesClosedPiper PA-22 · Wenden, AZSep 10, 1967 · N8446D · Substantial damage NTSB LAX68F0129Accident · 1 fatalClosedNaval Fcty N3N · Casa Grande, AZSep 9, 1967 · N45293 · Destroyed NTSB LAX68D0163Accident · No injuriesClosedCessna 150 · Florence Jct, AZSep 4, 1967 · N8674G · Substantial damage NTSB LAX68D0128Accident · No injuriesClosedTravel Air 4000 · Phoenix, AZSep 4, 1967 · N4910 · Substantial damage NTSB LAX68D0123Accident · No injuriesClosedGlobe Swift GC-1B · Peoria, AZSep 4, 1967 · N78293 · Substantial damage NTSB LAX68F0127Accident · No injuriesClosedMooney M21 · Showlow, AZAug 30, 1967 · N2637W · Substantial damage NTSB LAX68D0117Accident · No injuriesClosedCessna 185 · Glendale, AZAug 20, 1967 · N9837X · Destroyed NTSB LAX68F0112Accident · No injuriesClosedPiper PA-28 · Tucson, AZAug 19, 1967 · N6350W · Substantial damage NTSB LAX68D0122Accident · No injuriesClosedCessna 150 · Snowflake, AZAug 19, 1967 · N6682F · Substantial damage NTSB LAX68A0020Accident · No injuriesClosedBell 47G3B1 · Gilbert, AZAug 17, 1967 · N73240 · Substantial damage NTSB LAX68D0103Accident · No injuriesClosedNavion G · Avondale, AZAug 10, 1967 · N1011M · Substantial damage NTSB LAX68D0101Accident · Minor injuriesClosedCallair A-5 · Maricopa, AZAug 9, 1967 · N6151C · Destroyed NTSB LAX68D0109Accident · No injuriesClosedStearman PT-17 · Queen Creek, AZAug 7, 1967 · N1320N · Destroyed NTSB LAX68F0086Accident · No injuriesClosedBell 47G3B1 · Marana, AZAug 2, 1967 · N1181W · Substantial damage NTSB LAX68D0100Accident · No injuriesClosedBeech E18S · Phoenix, AZAug 1, 1967 · N301V · 2 aircraft · Substantial damage NTSB LAX68D0070Accident · No injuriesClosedGlobe GC-1B · Marana, AZJul 29, 1967 · N78296 · Substantial damage NTSB LAX68D0111Accident · No injuriesClosedCessna 310 · Window Rock, AZJul 28, 1967 · N530 · Substantial damage NTSB LAX68D0094Accident · No injuriesClosedPiper PA-28 · Showlow, AZJul 28, 1967 · N5144W · Substantial damage NTSB LAX68D0065Accident · No injuriesClosedNaval Fcty N3N · Chandler, AZJul 27, 1967 · N45151 · Substantial damage