Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 DEN70D0155Accident · No injuriesClosedCessna 150 · Canjilon, NMDec 30, 1969 · N5703E · Substantial damage NTSB DEN70D0156Accident · No injuriesClosedPiper PA-20 · Roswell, NMDec 26, 1969 · N7671K · Substantial damage NTSB DEN70D0161Accident · Minor injuriesClosedBeech V35 · Trra Amala, NMDec 19, 1969 · N233GT · Substantial damage NTSB DEN70A0040Accident · Serious injuriesClosedCessna 310 · Fort Stantn, NMDec 14, 1969 · N1122B · Destroyed NTSB DEN70D0153Accident · No injuriesClosedCessna 172 · Gallup, NMDec 13, 1969 · N3826L · No damage NTSB DEN70D0152Accident · No injuriesClosedCessna 172 · Moriarty, NMDec 12, 1969 · N8292X · Substantial damage NTSB DEN70F0137Accident · No injuriesClosedPiper PA-12 · Lordsburg, NMDec 7, 1969 · N7831H · Substantial damage NTSB DEN70A0039Accident · 1 fatalClosedBeech B35 · Tucumcari, NMDec 6, 1969 · N5092C · Destroyed NTSB DEN70A0038Accident · 11 fatalClosedLockheed 18 · Albuquerque, NMDec 5, 1969 · N410M · Destroyed NTSB DEN70D0134Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNov 28, 1969 · N3697J · Substantial damage NTSB DEN70D0142Accident · No injuriesClosedCessna 120 · Las Vegas, NMNov 26, 1969 · N87F · Substantial damage NTSB DEN70D0132Accident · No injuriesClosedBell 47G-3B · Alamogordo, NMNov 20, 1969 · N73995 · Substantial damage NTSB DEN70F0141Accident · No injuriesClosedPiper PA-28 · Alameda, NMNov 16, 1969 · N4604R · Substantial damage NTSB DEN70F0140Accident · No injuriesClosedHiller Acft FH1100 · Albuquerque, NMNov 16, 1969 · N514FH · Substantial damage NTSB DEN70D0133Accident · No injuriesClosedPiper PA-24 · Mayhill, NMNov 16, 1969 · N9180P · Substantial damage NTSB DEN70D0119Accident · No injuriesClosedCessna 182A · Corona, NMNov 16, 1969 · N5962B · Substantial damage NTSB DEN70F0148Accident · Serious injuriesClosedHiller UH-12B · Roswell, NMNov 15, 1969 · N10321 · Substantial damage NTSB DEN70F0131Accident · Minor injuriesClosedCessna 150J · Las Cruces, NMNov 10, 1969 · N51000 · Substantial damage NTSB DEN70F0120Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNov 8, 1969 · N5656P · Substantial damage NTSB DEN70F0123Accident · No injuriesClosedCessna 175 · Hobbs, NMNov 3, 1969 · N7664M · Substantial damage NTSB DEN70F0113Accident · Minor injuriesClosedCessna 210 · Santa Fe, NMNov 2, 1969 · N9690T · Destroyed NTSB DEN70D0151Accident · Minor injuriesClosedAero Comdr 520 · Albuquerque, NMNov 1, 1969 · N4192B · Substantial damage NTSB DEN70D0118Accident · No injuriesClosedHughes 269A · Roy, NMOct 31, 1969 · N8855F · Substantial damage NTSB DEN70F0117Accident · No injuriesClosedBellanca 17-30 · Grants, NMOct 30, 1969 · N4799V · Substantial damage NTSB DEN70A0030Accident · 2 fatalClosedBeech V35 · Vaughn, NMOct 26, 1969 · N315LH · Destroyed NTSB DEN70D0101Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMOct 21, 1969 · N6983P · Substantial damage NTSB DEN70F0103Accident · No injuriesClosedCessna A188 · Roswell, NMOct 10, 1969 · N8167V · Substantial damage NTSB DEN70F0099Accident · Minor injuriesClosedLuscombe 8F · Las Cruces, NMSep 29, 1969 · N2219B · Substantial damage NTSB DEN70A0020Accident · 2 fatalClosedTed Smith 601 · Santa Fe, NMSep 15, 1969 · N7442S · Destroyed NTSB DEN70F0102Accident · No injuriesClosedBeech 35 · Albuquerque, NMSep 6, 1969 · N313V · Substantial damage NTSB DEN70F0100Accident · No injuriesClosedBell 47J2B · Santa Fe, NMSep 3, 1969 · N6224N · Substantial damage NTSB DEN70D0080Accident · No injuriesClosedCessna 150G · Capitan, NMSep 1, 1969 · N8691J · Destroyed NTSB DEN70F0079Accident · Serious injuriesClosedPiper PA-28 · Carlsbad, NMAug 30, 1969 · N8019N · Destroyed NTSB DEN70A0014Accident · 2 fatalClosedForney F-1 · Rancho Taos, NMAug 28, 1969 · N3010G · Destroyed NTSB DEN70D0062Accident · No injuriesClosedBell 47G3B1 · Bingham, NMAug 18, 1969 · N1383X · Substantial damage NTSB DEN70A0012Accident · 3 fatalClosedBeech 95-B55 · Clines Crnr, NMAug 16, 1969 · N308AA · Destroyed NTSB DEN70F0065Accident · No injuriesClosedBoeing 75M · Las Cruces, NMAug 15, 1969 · N59293 · Substantial damage NTSB DEN70F0066Accident · No injuriesClosedStinson 108-3 · Silver City, NMAug 9, 1969 · N6539M · Substantial damage NTSB DEN70F0063Accident · No injuriesClosedCessna 320 · Albuquerque, NMAug 8, 1969 · N5759X · Substantial damage NTSB DEN70F0053Accident · Minor injuriesClosedStinson 108-1 · Albuquerque, NMAug 6, 1969 · N9164K · Destroyed NTSB DEN70A0008Accident · 1 fatalClosedCessna 172H · Albuquerque, NMAug 3, 1969 · N1662F · Destroyed NTSB DEN70F0051Accident · No injuriesClosedPiper PA-25 · Estancia, NMAug 2, 1969 · N8675L · Destroyed NTSB DEN70A0006Accident · 5 fatalClosedBeech C35 · Las Vegas, NMJul 27, 1969 · N64F · Destroyed NTSB DEN70F0035Accident · Serious injuriesClosedCessna 140 · Gallup, NMJul 11, 1969 · N2393V · Destroyed NTSB DEN70F0012Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJul 1, 1969 · N4178J · Substantial damage NTSB DEN70F0025Accident · No injuriesClosedCessna 195 · Santa Fe, NMJun 26, 1969 · N3095B · Substantial damage NTSB DEN70F0011Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJun 19, 1969 · N6311P · Substantial damage NTSB DEN70D0004Accident · No injuriesClosedPiper PA-18 · Carrizozo, NMJun 19, 1969 · N1701A · Substantial damage NTSB DEN70F0007Accident · No injuriesClosedBeech A23-24 · Carlsbad, NMJun 14, 1969 · N7924L · Substantial damage NTSB DEN70D0001Accident · No injuriesClosedCessna 150J · Albuquerque, NMJun 11, 1969 · N60704 · Substantial damage