Skip to content

NTSB investigations, 1967, NM

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

19642026

NTSB investigations, 1967, NM per year, 1964–2026: 2,946 cases
1964	82
1965	88
1966	99
1967	113
1968	99
1969	85
1970	86
1971	79
1972	69
1973	73
1974	74
1975	85
1976	64
1977	89
1978	98
1979	94
1980	68
1981	78
1982	72
1983	46
1984	56
1985	63
1986	41
1987	44
1988	48
1989	36
1990	33
1991	34
1992	26
1993	28
1994	27
1995	41
1996	41
1997	42
1998	43
1999	39
2000	42
2001	36
2002	33
2003	36
2004	29
2005	21
2006	26
2007	36
2008	31
2009	27
2010	27
2011	23
2012	19
2013	23
2014	28
2015	25
2016	18
2017	24
2018	27
2019	20
2020	8
2021	17
2022	16
2023	15
2024	24
2025	16
2026	16

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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 DEN68F0189Accident · No injuriesClosedBeech D18S · Albuquerque, NMDec 29, 1967 · N260R · Substantial damage NTSB DEN68D0186Accident · No injuriesClosedCessna 320C · Farmington, NMDec 29, 1967 · N3024T · Substantial damage NTSB DEN68D0170Accident · Minor injuriesClosedPiper PA-24 · Willard, NMDec 21, 1967 · N8004P · Substantial damage NTSB DEN68D0188Accident · No injuriesClosedPiper PA-28 · Clines Cnrs, NMDec 18, 1967 · N9671J · Substantial damage NTSB DEN68D0160Accident · No injuriesClosedBeech V35A · Clines Crns, NMDec 18, 1967 · N7087N · Substantial damage NTSB DEN68F0180Accident · No injuriesClosedPiper PA-23 · Tucumcari, NMDec 17, 1967 · N2225P · Substantial damage NTSB DEN68A0026Accident · 2 fatalClosedPiper PA-32 · Corona, NMDec 15, 1967 · N3408W · Destroyed NTSB DEN68F0159Accident · No injuriesClosedCessna 182 · Albuquerque, NMDec 8, 1967 · N2030G · Substantial damage NTSB DEN68D0162Accident · No injuriesClosedCessna 182 · Hobbs, NMNov 30, 1967 · N5626B · Substantial damage NTSB DEN68F0171Accident · No injuriesClosedBeech M35 · Roswell, NMNov 28, 1967 · N329Z · Substantial damage NTSB DEN68F0147Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNov 24, 1967 · N6626W · Substantial damage NTSB DEN68D0185Accident · No injuriesClosedPiper PA-12 · Vaughn, NMNov 23, 1967 · N3035M · Substantial damage NTSB DEN68D0161Accident · No injuriesClosedCessna 182 · Chama, NMNov 23, 1967 · N2263G · Substantial damage NTSB DEN68D0157Accident · No injuriesClosedCessna 182 · Roswell, NMNov 23, 1967 · N2938Y · Substantial damage NTSB DEN68D0155Accident · No injuriesClosedCessna 150 · Albuquerque, NMNov 18, 1967 · N8694G · Substantial damage NTSB DEN68F0152Accident · No injuriesClosedPiper PA-31 · Anapra, NMNov 14, 1967 · N844FS · Substantial damage NTSB DEN68F0144Accident · No injuriesClosedCessna 140 · Crown Pt, NMNov 11, 1967 · N89436 · Substantial damage NTSB DEN68D0156Accident · Minor injuriesClosedAlon A-2 · Torreon, NMNov 11, 1967 · N6370V · Substantial damage NTSB DEN68D0153Accident · No injuriesClosedCessna 150 · Columbus, NMNov 10, 1967 · N6297R · Substantial damage NTSB DEN68D0134Accident · Minor injuriesClosedCessna 150 · Shiprock, NMOct 27, 1967 · N6524T · Substantial damage NTSB DEN68D0128Accident · No injuriesClosedCessna 182H · Socorro, NMOct 25, 1967 · N8492S · Substantial damage NTSB DEN68D0116Accident · No injuriesClosedCessna 172 · Gallup, NMOct 17, 1967 · N8014L · Substantial damage NTSB DEN68D0130Accident · No injuriesClosedCessna 210D · Ruidoso, NMOct 15, 1967 · N3902Y · Substantial damage NTSB DEN68F0129Accident · Minor injuriesClosedTaylorcraft BC-65 · Aztec, NMOct 12, 1967 · N29810 · Substantial damage NTSB DEN68D0197Accident · No injuriesClosedCessna 182 · Deming, NMOct 8, 1967 · N3121U · Substantial damage NTSB DEN68A0019Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMOct 5, 1967 · N1337X · Substantial damage NTSB DEN68D0104Accident · No injuriesClosedCessna 150 · Las Cruces, NMOct 4, 1967 · N6442F · Substantial damage NTSB DEN68D0107Accident · No injuriesClosedCessna 150F · Albuquerque, NMSep 28, 1967 · N8713S · Substantial damage NTSB DEN68D0115Accident · No injuriesClosedPiper PA-24 · Grady, NMSep 14, 1967 · N8029P · Substantial damage NTSB DEN68D0096Accident · No injuriesClosedCessna 310D · Clovis, NMSep 11, 1967 · N6891T · Substantial damage NTSB DEN68A0018Accident · 3 fatalClosedBeech C-45H · Farmington, NMSep 8, 1967 · N9507Z · Destroyed NTSB DEN68D0093Accident · Serious injuriesClosedStinson 108-3 · Gallup, NMSep 4, 1967 · N6237M · Substantial damage NTSB DEN68F0095Accident · No injuriesClosedBeech C35 · Albuquerque, NMSep 3, 1967 · N811Y · Substantial damage NTSB DEN68D0094Accident · No injuriesClosedCessna 210 · Albuquerque, NMSep 1, 1967 · N3758Y · Substantial damage NTSB DEN68A0015Accident · 1 fatalClosedNightengale FW-2 · Las Vegas, NMAug 30, 1967 · N141W · Destroyed NTSB DEN68D0088Accident · No injuriesClosedCessna 210 · Cimarron, NMAug 25, 1967 · N2375F · Substantial damage NTSB DEN68D0085Accident · No injuriesClosedCessna 310 · Zuni, NMAug 23, 1967 · N3619D · Substantial damage NTSB DEN68D0086Accident · No injuriesClosedPiper PA-12 · Albuquerque, NMAug 19, 1967 · N7654H · Substantial damage NTSB DEN68F0051Accident · Minor injuriesClosedMooney M20C · Ruidoso, NMAug 15, 1967 · N5981Q · Substantial damage NTSB DEN68F0068Accident · No injuriesClosedBeech T-34A · Albuquerque, NMAug 12, 1967 · N421NM · Substantial damage NTSB DEN68D0061Accident · No injuriesClosedCessna 150 · Cimarron, NMAug 12, 1967 · N7808F · Substantial damage NTSB DEN68A0013Accident · 3 fatalClosedMooney M20C · Hillsboro, NMAug 12, 1967 · N79856 · Destroyed NTSB DEN68D0058Accident · No injuriesClosedCessna 150 · Springer, NMAug 8, 1967 · N8228F · Substantial damage NTSB DEN68A0012Accident · No injuriesClosedBell 47G3B1 · Holoman Afb, NMAug 8, 1967 · N1361X · Substantial damage NTSB DEN68F0062Accident · No injuriesClosedCessna 32OD · White Sands, NMAug 4, 1967 · N3329Q · Substantial damage NTSB DEN68F0040Accident · Serious injuriesClosedChampion 7GC · Albuquerque, NMAug 1, 1967 · N8547E · Substantial damage NTSB DEN68F0063Accident · No injuriesClosedPiper J3C-65 · Deming, NMJul 29, 1967 · N3490K · Substantial damage NTSB DEN68D0059Accident · No injuriesClosedFairchild WM62C · Clovis, NMJul 28, 1967 · N48706 · Substantial damage NTSB DEN68A0007Accident · No injuriesClosedBeech D18S · Tucumcari, NMJul 22, 1967 · N103G · Substantial damage NTSB DEN68F0052Accident · No injuriesClosedCessna 310 · Truth Or Co, NMJul 21, 1967 · N3619D · Substantial damage