Skip to content

NTSB investigations, 1968, NM

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 DEN69F0155Accident · No injuriesClosedPiper PA-30 · Albuquerque, NMDec 27, 1968 · N7999Y · Substantial damage NTSB DEN69A0031Accident · 1 fatalClosedCessna 172 · Sandia Park, NMDec 26, 1968 · N9200V · Destroyed NTSB DEN69D0144Accident · No injuriesClosedBeech 35-C33 · Eagle Nest, NMNov 30, 1968 · N2083W · Substantial damage NTSB DEN69D0149Accident · Minor injuriesClosedPiper PA-28 · Alamogordo, NMNov 27, 1968 · N6122W · Substantial damage NTSB DEN69D0145Accident · No injuriesClosedCessna 140 · Albuquerque, NMNov 23, 1968 · N1957N · Substantial damage NTSB DEN69D0138Accident · No injuriesClosedBeech 35C33A · Albuquerque, NMNov 13, 1968 · N8310N · Substantial damage NTSB DEN69D0137Accident · No injuriesClosedCessna 210 · Hobbs, NMNov 9, 1968 · N3772Y · Substantial damage NTSB DEN69D0128Accident · No injuriesClosedPiper PA-24 · Artesia, NMOct 30, 1968 · N9180P · Substantial damage NTSB DEN69F0124Accident · No injuriesClosedLuscombe 8A · Anapra, NMOct 19, 1968 · N71363 · Substantial damage NTSB DEN69A0020Accident · 2 fatalClosedBeech S35 · Las Cruces, NMOct 16, 1968 · N5785K · Destroyed NTSB DEN69D0127Accident · No injuriesClosedCessna 170B · Whites City, NMOct 14, 1968 · N2953D · Substantial damage NTSB DEN69D0110Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMOct 13, 1968 · N8419W · Substantial damage NTSB DEN69A0017Accident · No injuriesClosedCessna 320 · Raton, NMOct 8, 1968 · N5748X · Substantial damage NTSB DEN69D0109Accident · No injuriesClosedCessna 150 · Espanola, NMOct 6, 1968 · N7709E · Substantial damage NTSB DEN69F0125Accident · Serious injuriesClosedCessna 150F · Las Cruces, NMOct 5, 1968 · N7716F · Substantial damage NTSB DEN69A0015Accident · 3 fatalClosedCessna T-210G · Estancia, NMOct 4, 1968 · N6846R · Destroyed NTSB DEN69A0018Accident · 4 fatalClosedPiper PA-28 · Santa Fe, NMOct 2, 1968 · N8905J · Destroyed NTSB DEN69D0123Accident · No injuriesClosedPiper PA-24 · Columbus, NMSep 28, 1968 · N7551P · Substantial damage NTSB DEN69F0092Accident · No injuriesClosedBellanca 14-193 · Tucumcari, NMSep 25, 1968 · N6853D · Substantial damage NTSB DEN69D0112Accident · Minor injuriesClosedPiper PA-18 · Columbus, NMSep 23, 1968 · N4259Z · Substantial damage NTSB DEN69F0111Accident · Serious injuriesClosedBeech A45 · White Sands, NMSep 22, 1968 · N6843C · Substantial damage NTSB DEN69D0091Accident · Serious injuriesClosedAero Comdr 560-A · Albuquerque, NMSep 15, 1968 · N2668B · No damage NTSB DEN69D0103Accident · No injuriesClosedCessna 140A · Las Cruces, NMSep 11, 1968 · N5646C · Substantial damage NTSB DEN69D0101Accident · No injuriesClosedCessna 170 · Albuquerque, NMSep 9, 1968 · N3186B · Substantial damage NTSB DEN69F0093Accident · No injuriesClosedPiper PA-28R · Cubero, NMSep 4, 1968 · N3865T · Substantial damage NTSB DEN69F0090Accident · No injuriesClosedCessna 172 · Lordsburg, NMAug 30, 1968 · N6724A · Substantial damage NTSB DEN69D0082Accident · No injuriesClosedCessna 182K · Albuquerque, NMAug 30, 1968 · N2625Q · Substantial damage NTSB DEN69D0084Accident · No injuriesClosedBeech 23 · Los Alamos, NMAug 26, 1968 · N2394Z · Substantial damage NTSB DEN69F0066Accident · Minor injuriesClosedCessna 182K · Mountainair, NMAug 12, 1968 · N2494Q · Substantial damage NTSB DEN69F0083Accident · Serious injuriesClosedCessna 177 · Albuquerque, NMAug 10, 1968 · N2240Y · Substantial damage NTSB DEN69F0069Accident · Serious injuriesClosedCessna 150 · Lbuquerque, NMJul 28, 1968 · N7931F · Destroyed NTSB DEN69F0055Accident · Serious injuriesClosedChaney EFG-1 · Espanola, NMJul 28, 1968 · N3041 · Substantial damage NTSB DEN69D0054Accident · Minor injuriesClosedCessna 172 · Crownpoint, NMJul 28, 1968 · N7914X · Substantial damage NTSB DEN69F0067Accident · No injuriesClosedWaco YKS-7 · Albuquerque, NMJul 23, 1968 · N1937 · Substantial damage NTSB DEN69D0053Accident · No injuriesClosedTemco 11A · Farmington, NMJul 21, 1968 · N1650B · Substantial damage NTSB DEN69F0048Accident · No injuriesClosedCessna 188 · Tucumcari, NMJul 12, 1968 · N8167V · Substantial damage NTSB DEN69F0038Accident · No injuriesClosedBeech 36 · Socorro, NMJul 11, 1968 · N7452N · Substantial damage NTSB DEN69D0049Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJul 6, 1968 · N6235P · Substantial damage NTSB DEN69F0065Accident · No injuriesClosedCessna 180 · Las Cruces, NMJul 5, 1968 · N180Y · Substantial damage NTSB DEN69D0039Accident · Minor injuriesClosedPiper PA-22 · Mountainair, NMJun 30, 1968 · N5810D · Substantial damage NTSB DEN69F0014Accident · Minor injuriesClosedPiper PA-25 · Roswell, NMJun 26, 1968 · N6424Z · Substantial damage NTSB DEN69D0011Accident · No injuriesClosedCessna 170B · Farmington, NMJun 19, 1968 · N8290A · Substantial damage NTSB DEN69D0068Accident · No injuriesClosedBeech 95-A55 · Albuquerque, NMJun 16, 1968 · N942Q · Substantial damage NTSB DEN69D0009Accident · No injuriesClosedMooney M21 · Albuquerque, NMJun 16, 1968 · N2734W · Substantial damage NTSB DEN69F0013Accident · Minor injuriesClosedCessna TU206 · Santa Fe, NMJun 13, 1968 · N4931F · Substantial damage NTSB DEN69F0015Accident · No injuriesClosedPiper PA-22 · Roswell, NMJun 10, 1968 · N1687P · Substantial damage NTSB DEN69D0037Accident · No injuriesClosedCessna 320 · Lovington, NMJun 10, 1968 · N5724X · Substantial damage NTSB DEN68F0280Accident · No injuriesClosedBeech 95-A55 · Carlsbad, NMJun 9, 1968 · N8501M · Substantial damage NTSB DEN68D0271Accident · No injuriesClosedBeech V35 · Solano, NMJun 3, 1968 · N7145N · Substantial damage NTSB DEN68F0270Accident · Minor injuriesClosedBeech A23 · Albuquerque, NMJun 2, 1968 · N3631Q · Substantial damage