Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 LAX70D0240Accident · No injuriesClosedCessna 310B · Phoenix, AZDec 31, 1969 · N5463A · Substantial damage NTSB LAX70D0232Accident · No injuriesClosedCessna 182 · Flagstaff, AZDec 31, 1969 · N71006 · Substantial damage NTSB LAX70D0234Accident · No injuriesClosedErco 415-CD · Kearney, AZDec 26, 1969 · N99644 · Substantial damage NTSB LAX70D0228Accident · Serious injuriesClosedCessna 150 · Phoenix, AZDec 25, 1969 · N3783J · Substantial damage NTSB LAX70D0235Accident · No injuriesClosedMooney M-20C · Winslow, AZDec 23, 1969 · N6746U · Substantial damage NTSB LAX70D0239Accident · No injuriesClosedCessna 182 · Sedona, AZDec 15, 1969 · N8434S · Substantial damage NTSB LAX70D0224Accident · No injuriesClosedBell 47D1 · Scottdale, AZDec 15, 1969 · N7732 · Substantial damage NTSB LAX70A0036Accident · 1 fatalClosedBell 206A · Grnd Canyon, AZDec 15, 1969 · N1479W · Destroyed NTSB LAX70D0223Accident · No injuriesClosedCessna 172 · Scottsdale, AZDec 2, 1969 · N7513T · Substantial damage NTSB LAX70F0210Accident · Serious injuriesClosedBeech F35 · Tucson, AZNov 26, 1969 · N3230C · Substantial damage NTSB LAX70D0192Accident · Minor injuriesClosedCessna 172 · Tucson, AZNov 25, 1969 · N4163L · Substantial damage NTSB LAX70D0212Accident · Minor injuriesClosedBeech C35 · Glendale, AZNov 24, 1969 · N756D · Substantial damage NTSB LAX70D0213Accident · No injuriesClosedHughes 269B · Phoenix, AZNov 14, 1969 · N9440F · Substantial damage NTSB LAX70F0190Accident · No injuriesClosedDehaviland DH-114 · Phoenix, AZNov 12, 1969 · N1420Z · Substantial damage NTSB LAX70D0180Accident · No injuriesClosedCessna 172 · St Johns, AZNov 8, 1969 · N8110L · Substantial damage NTSB LAX70D0203Accident · No injuriesClosedPiper PA-32 · Flagstaff, AZNov 7, 1969 · N4071R · Substantial damage NTSB LAX70A0028Accident · 4 fatalClosedBeech M35 · Happy Jack, AZNov 7, 1969 · N9725R · Destroyed NTSB LAX70A0027Accident · 3 fatalClosedBeech S35 · Bouse, AZNov 6, 1969 · N5628K · Destroyed NTSB LAX70D0198Accident · No injuriesClosedBell 47G3B1 · Parker, AZNov 5, 1969 · N614 · Substantial damage NTSB LAX70D0197Accident · Minor injuriesClosedCessna 150 · Tucson, AZNov 5, 1969 · N6665S · Destroyed NTSB LAX70D0223Accident · No injuriesClosedNaval Fcty N3N-3 · Yuma, AZNov 4, 1969 · N45027 · Substantial damage NTSB LAX70D0191Accident · No injuriesClosedGlobe GC-1A · Casa Grande, AZNov 3, 1969 · N80720 · Substantial damage NTSB LAX70I0025Incident · No injuriesClosedBoeing 737 · Phoenix, AZOct 30, 1969 · N4528W · Minor damage NTSB LAX70D0186Accident · Minor injuriesClosedCessna 172D · Bagdad, AZOct 26, 1969 · N2534U · Destroyed NTSB LAX70F0185Accident · Serious injuriesClosedWaco UPF-7 · Douglas, AZOct 19, 1969 · N39700 · Destroyed NTSB LAX70D0178Accident · No injuriesClosedPiper PA-24 · Flagstaff, AZOct 19, 1969 · N7824P · Substantial damage NTSB LAX70D0177Accident · No injuriesClosedCessna A188 · Guadalupe, AZOct 19, 1969 · N3525Q · Substantial damage NTSB LAX70F0153Accident · Serious injuriesClosedHughes 269B · Grnd Canyon, AZOct 9, 1969 · N9442F · Substantial damage NTSB LAX70F0170Accident · Minor injuriesClosedNavion A · Williams, AZOct 7, 1969 · N4277K · Destroyed NTSB LAX70D0167Accident · No injuriesClosedHughes 269A · Phoenix, AZOct 4, 1969 · N8750F · Substantial damage NTSB LAX70F0172Accident · No injuriesClosedCessna 150 · Phoenix, AZOct 2, 1969 · N3289J · Substantial damage NTSB LAX70D0148Accident · No injuriesClosedCessna 150 · Tucson, AZSep 27, 1969 · N8315M · Destroyed NTSB LAX70D0149Accident · Minor injuriesClosedMooney M-20C · Fort Grant, AZSep 23, 1969 · N9153V · Substantial damage NTSB LAX70F0146Accident · Serious injuriesClosedCessna 337B · Holbrook, AZSep 19, 1969 · N5429S · Destroyed NTSB LAX70D0166Accident · No injuriesClosedGrumman 164A · Ltchfld Prk, AZSep 19, 1969 · N994X · Substantial damage NTSB LAX70F0133Accident · No injuriesClosedCessna 150 · Phoenix, AZSep 17, 1969 · N8622J · Substantial damage NTSB LAX70F0134Accident · No injuriesClosedMooney 20A · Goodyear, AZSep 10, 1969 · N1096B · Substantial damage NTSB LAX70D0106Accident · No injuriesClosedCessna 150G · Scottsdale, AZSep 6, 1969 · N51538 · Substantial damage NTSB LAX70D0121Accident · No injuriesClosedPiper PA-28 · Clifton, AZAug 31, 1969 · N139SF · Substantial damage NTSB LAX70D0159Accident · No injuriesClosedAero Comdr 680 · Gila Bend, AZAug 29, 1969 · N6823S · Substantial damage NTSB LAX70D0109Accident · No injuriesClosedMooney M20A · Wenden, AZAug 28, 1969 · N8365E · Substantial damage NTSB LAX70D0108Accident · No injuriesClosedCessna A188 · Casa Grande, AZAug 28, 1969 · N9858V · Substantial damage NTSB LAX70D0113Accident · No injuriesClosedPiper PA-24 · Marble Cnon, AZAug 26, 1969 · N6408P · Substantial damage NTSB LAX70D0111Accident · Minor injuriesClosedCessna A188 · Palo Verde, AZAug 24, 1969 · N9855V · Destroyed NTSB LAX70D0112Accident · No injuriesClosedCessna T337C · Wickenburg, AZAug 22, 1969 · N2623S · Substantial damage NTSB LAX70F0071Accident · No injuriesClosedNaval Fcty N3N-1 · Litchfld Pk, AZAug 21, 1969 · N45280 · Destroyed NTSB LAX70F0105Accident · Minor injuriesClosedNaval 6fty N3N-1 · Tempe, AZAug 19, 1969 · N45117 · Substantial damage NTSB LAX70D0131Accident · No injuriesClosedNaval Fcty N3N-3 · Somerton, AZAug 19, 1969 · N44936 · Substantial damage NTSB LAX70F0229Accident · 1 fatalClosedBensen B8M · San Manuel, AZAug 17, 1969 · N4454 · Destroyed NTSB LAX70D0076Accident · No injuriesClosedBoeing PT-17 · Somerton, AZAug 17, 1969 · N48573 · Destroyed