Skip to content

NTSB investigations, 1975, NM

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 DEN76FQA32Accident · No injuriesClosedPiper PA-34 · Albuquerque, NMDec 30, 1975 · N44311 · Substantial damage NTSB DEN76FQA31Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMDec 16, 1975 · N8880P · Substantial damage NTSB DEN76DQD10Accident · No injuriesClosedBellanca 17-30A · Chamberino, NMNov 23, 1975 · N917TB · Substantial damage NTSB DEN76FQA29Accident · No injuriesClosedTaylorcraft BC12-D · Farmington, NMNov 19, 1975 · N95313 · Substantial damage NTSB DEN76FQA28Accident · No injuriesClosedCessna 182L · Lincoln, NMNov 14, 1975 · N42015 · Destroyed NTSB DEN76FQA27Accident · No injuriesClosedPiper PA-24 · Quemado, NMNov 14, 1975 · N411VW · Destroyed NTSB DEN76FQA26Accident · Minor injuriesClosedCessna 182 · Gallup, NMNov 14, 1975 · N92523 · Substantial damage NTSB DEN76FQA25Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMNov 14, 1975 · N5366Y · Substantial damage NTSB DEN76FQA24Accident · No injuriesClosedCessna 206 · Abiquiu, NMNov 10, 1975 · N12007 · Substantial damage NTSB DEN76FQA23Accident · Serious injuriesClosedCessna 180 · Zuni, NMNov 7, 1975 · N2420C · Destroyed NTSB DEN76AD020Accident · 2 fatalClosedChampion 7GC · Lordsburg, NMOct 23, 1975 · N8547E · Destroyed NTSB DEN76AD021Accident · 4 fatalClosedPiper PA-23 · Penasco, NMOct 19, 1975 · N4770P · Destroyed NTSB DEN76FQA22Accident · Minor injuriesClosedBernardin MS-2 · Albuquerque, NMOct 18, 1975 · N4956E · Substantial damage NTSB DEN76FQA21Accident · Serious injuriesClosedCessna 150L · Los Alamos, NMOct 11, 1975 · N18084 · Destroyed NTSB DEN76FQA20Accident · Serious injuriesClosedAero Comdr 680E · Raton, NMOct 8, 1975 · N8490C · Substantial damage NTSB DEN76FQA19Accident · Minor injuriesClosedCessna 206 · Des Moines, NMOct 7, 1975 · N2629X · Substantial damage NTSB DEN76FQG03Accident · No injuriesClosedBeech C35 · Lovington, NMOct 4, 1975 · N5860C · Substantial damage NTSB DEN76FQA17Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMSep 29, 1975 · N102MS · Substantial damage NTSB DEN76FQA18Accident · No injuriesClosedCessna 177 · Las Vegas, NMSep 28, 1975 · N3154T · Substantial damage NTSB DEN7LFQA16Accident · Serious injuriesClosedBreigleib BG-12A · Moriarity, NMSep 27, 1975 · N5573V · Substantial damage NTSB DEN76FQA15Accident · Serious injuriesClosedLongmire SP-3 · Albuquerque, NMSep 16, 1975 · N33DL · Substantial damage NTSB DEN76FQA13Accident · No injuriesClosedAero Comdr 680 · Cuba, NMSep 15, 1975 · N919U · Substantial damage NTSB DEN76DQA14Accident · No injuriesClosedBeech 58 · Ruidoso, NMAug 31, 1975 · N9027Q · Substantial damage NTSB DEN76DQA12Accident · No injuriesClosedBellanca 8GCBC · Farmington, NMAug 23, 1975 · N8658V · Substantial damage NTSB DEN7LFQA10Accident · Serious injuriesClosedCessna 150 · Corona, NMAug 15, 1975 · N8421G · Substantial damage NTSB DEN7LFQA09Accident · No injuriesClosedCessna 175 · Santa Fe, NMAug 14, 1975 · N7975T · Substantial damage NTSB DEN76DQG02Accident · No injuriesClosedWeatherly 201B · Clovis, NMAug 6, 1975 · N1271W · Substantial damage NTSB DEN7LFQD04Accident · No injuriesClosedCessna 150 · Lordsburg, NMAug 3, 1975 · N50651 · Substantial damage NTSB DEN76DAQ08Accident · No injuriesClosedChampion 7GCBC · Luna, NMAug 1, 1975 · N9641S · Substantial damage NTSB DEN76FQA07Accident · No injuriesClosedBeech 65-80 · Santa Fe, NMJul 31, 1975 · N716AG · Substantial damage NTSB DEN76FAQ06Accident · No injuriesClosedBell 47G3B1 · Belen, NMJul 23, 1975 · N73998 · Substantial damage NTSB DEN76DQG01Accident · No injuriesClosedGlasflugel H301B · Hobbs, NMJul 20, 1975 · N3012 · Substantial damage NTSB DEN76FQA04Accident · Serious injuriesClosedMooney M20F · Albuquerque, NMJul 18, 1975 · N6321Q · Substantial damage NTSB DEN76DQD03Accident · Serious injuriesClosedFlug-Undfah HBV · Artesia, NMJul 18, 1975 · N292D · Substantial damage NTSB DEN76FQA03Accident · No injuriesClosedPiper PA-25 · Roswell, NMJul 17, 1975 · N6547Z · Substantial damage NTSB DEN76DQD01Accident · No injuriesClosedAero Comdr 600S2R · Las Cruces, NMJul 12, 1975 · N4986X · Substantial damage NTSB DEN76DQA02Accident · Minor injuriesClosedAmer Avco AA1-B · Pie Town, NMJul 11, 1975 · N9930L · Substantial damage NTSB DEN76FQA05Accident · No injuriesClosedGlobe GC-1B · Albuquerque, NMJul 9, 1975 · N3202K · Substantial damage NTSB DEN76FQA01Accident · No injuriesClosedCessna UC-78 · Gallup, NMJul 3, 1975 · N61654 · Substantial damage NTSB DEN75FQA53Accident · No injuriesClosedMooney M20F · Albuquerque, NMJun 30, 1975 · N6496Q · Substantial damage NTSB DEN75FQA52Accident · Minor injuriesClosedAmer Avco AA-1B · Gallup, NMJun 29, 1975 · N8868L · Substantial damage NTSB DEN76DQD32Accident · No injuriesClosedSchweizer SGS232 · Las Cruces, NMJun 28, 1975 · N17871 · Substantial damage NTSB DEN75AD064Accident · Serious injuriesClosedRaven RX-6 · Albuquerque, NMJun 28, 1975 · N1015R · No damage NTSB DEN75AAQ54Accident · No injuriesClosedAero Comdr 680F · Wagon Mound, NMJun 25, 1975 · N6185X · Substantial damage NTSB DEN75FQA50Accident · No injuriesClosedBeech V35B · Albuquerque, NMJun 13, 1975 · N1102W · Substantial damage NTSB DEN75DQD28Accident · No injuriesClosedBeech TC-45G · Steins, NMJun 12, 1975 · N9430Z · Substantial damage NTSB DEN75DQA49Accident · No injuriesClosedPiper PA-23 · Santa Fe, NMJun 12, 1975 · N4190P · Substantial damage NTSB DEN75DQD27Accident · No injuriesClosedCessna 150 · Silver City, NMJun 11, 1975 · N306BJ · Substantial damage NTSB DEN75DQA48Accident · No injuriesClosedCessna 150 · Villanueva, NMJun 8, 1975 · N88135 · Substantial damage NTSB DEN75FQD23Accident · No injuriesClosedCessna 182 · Las Cruces, NMMay 24, 1975 · N58947 · Substantial damage