Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 DEN72FQA30Accident · Minor injuriesClosedCessna 411 · Alameda, NMDec 29, 1971 · N4977T · Substantial damage NTSB DEN72FQD20Accident · Minor injuriesClosedAero-Comdr 100 · Deming, NMDec 24, 1971 · N4127X · Substantial damage NTSB DEN72FQD18Accident · No injuriesClosedBell 47G3B1 · Hollomn Afb, NMDec 15, 1971 · N1382X · Substantial damage NTSB DEN72DQD19Accident · No injuriesClosedChampion 7EC · Montoya, NMDec 12, 1971 · N4307C · Substantial damage NTSB DEN72FQA25Accident · No injuriesClosedLuscombe 8A · Albuquerque, NMNov 24, 1971 · N23060 · Substantial damage NTSB DEN72FQA26Accident · No injuriesClosedCessna 150F · Cedar Crest, NMNov 21, 1971 · N8182F · Substantial damage NTSB DEN72FQA24Accident · No injuriesClosedHarvard IV · Albuquerque, NMNov 3, 1971 · CF-UJI · Substantial damage NTSB DEN72AD023Accident · 4 fatalClosedCessna 310K · Ramah, NMOct 30, 1971 · N3829X · Destroyed NTSB DEN72DQA23Accident · No injuriesClosedBeech D18S · Conchas Dam, NMOct 28, 1971 · N104J · Substantial damage NTSB LAX72AL031Accident · 1 fatalClosedLuscombe 8 · Belen, NMOct 21, 1971 · N1114K · Destroyed NTSB DEN72FQA21Accident · No injuriesClosedPiper PA-16 · Albuquerque, NMOct 9, 1971 · N6818K · Substantial damage NTSB DEN72AD018Accident · 1 fatalClosedCessna 150J · Albuquerque, NMOct 7, 1971 · N50995 · Destroyed NTSB DEN72FQA22Accident · No injuriesClosedCessna 172 · Bernalillo, NMOct 4, 1971 · N35485 · Substantial damage NTSB DEN72FQD10Accident · Minor injuriesClosedCessna 150F · Cloudcroft, NMSep 29, 1971 · N8996S · Substantial damage NTSB DEN72FQA20Accident · No injuriesClosedBeech B55 · Albuquerque, NMSep 29, 1971 · N126Q · Substantial damage NTSB DEN72AD017Accident · 1 fatalClosedBeech P35 · Luna, NMSep 25, 1971 · N9790Y · Destroyed NTSB DEN72AD015Accident · 2 fatalClosedMartin RB-57C · Albuquerque, NMSep 24, 1971 · AF533842 · 2 aircraft · Minor damage NTSB DEN72AD014Accident · 2 fatalClosedCessna 172F · Capitan, NMSep 18, 1971 · N5552R · Destroyed NTSB DEN72AD009Accident · 1 fatalClosedPiper PA-22 · Alamogordo, NMSep 6, 1971 · N8736C · Destroyed NTSB DEN72FQA16Accident · Minor injuriesClosedCessna 172K · Santa Fe, NMSep 4, 1971 · N7065G · Destroyed NTSB DEN72FQA18Accident · Minor injuriesClosedCessna 210 · Ruidoso, NMSep 2, 1971 · N9649T · Destroyed NTSB DEN72FQD08Accident · No injuriesClosedBell 47G3B1 · Ruidoso, NMAug 31, 1971 · N1333X · Substantial damage NTSB DEN72FQA15Accident · No injuriesClosedCessna 411 · Albuquerque, NMAug 30, 1971 · N3236R · Substantial damage NTSB DEN72FQA14Accident · No injuriesClosedPiper PA-12 · Taos, NMAug 28, 1971 · N98971 · Substantial damage NTSB DEN72AD008Accident · 4 fatalClosedBellanca 17-30 · Hachita, NMAug 28, 1971 · N7307V · Destroyed NTSB DEN72FQA17Accident · No injuriesClosedCessna 150 · Albuquerque, NMAug 27, 1971 · N8682S · Substantial damage NTSB DEN72FQA13Accident · No injuriesClosedBeech M35 · Albuquerque, NMAug 20, 1971 · N9771R · Substantial damage NTSB DEN72DQG14Accident · No injuriesClosedPiper PA-25 · Clovis, NMAug 15, 1971 · N6980Z · Substantial damage NTSB DEN72DQD06Accident · No injuriesClosedCessna T310Q · Quemado, NMAug 12, 1971 · N7704Q · Substantial damage NTSB DEN72FQA10Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMAug 9, 1971 · N5374L · Substantial damage NTSB DEN72FQA09Accident · No injuriesClosedHelio Acft H-395 · Albuquerque, NMAug 8, 1971 · N4150D · Substantial damage NTSB DEN72DQG13Accident · No injuriesClosedAero Comdr 500 · Hobbs, NMAug 7, 1971 · N999AJ · Substantial damage NTSB DEN72FQA08Accident · No injuriesClosedMiniplane Faler · Gallup, NMJul 29, 1971 · N2117 · Substantial damage NTSB DEN72FQA06Accident · No injuriesClosedPiper PA-32 · Albuquerque, NMJul 24, 1971 · N3507W · Substantial damage NTSB DEN72DQA07Accident · No injuriesClosedPiper PA-28R · Carrizozo, NMJul 21, 1971 · N4996J · Substantial damage NTSB DEN72FQA11Accident · Serious injuriesClosedBeech J35 · Sante Fe, NMJul 19, 1971 · N620Q · Destroyed NTSB DEN72FQD03Accident · No injuriesClosedNavion G · Carlsbad, NMJul 17, 1971 · N2410T · Substantial damage NTSB DEN72FQD02Accident · No injuriesClosedBeech 35 · Carlsbad, NMJul 14, 1971 · N5065C · Substantial damage NTSB DEN72FQD01Accident · Minor injuriesClosedPiper PA-28 · Las Cruces, NMJul 14, 1971 · N6304W · Substantial damage NTSB DEN72FQA05Accident · Minor injuriesClosedCessna 150F · Gallup, NMJul 14, 1971 · N6521F · Substantial damage NTSB DEN72DQA04Accident · No injuriesClosedCessna 337B · Torreon, NMJul 11, 1971 · N5468S · Substantial damage NTSB DEN72FQA02Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMJul 5, 1971 · N5387Y · Substantial damage NTSB DEN72DQA12Accident · Minor injuriesClosedSikorsky S-55B · Pecos, NMJul 5, 1971 · N455V · Substantial damage NTSB DEN71FQA01Accident · No injuriesClosedCessna 310J · Albuquerque, NMJul 1, 1971 · N3097L · Substantial damage NTSB DEN71FQD27Accident · No injuriesClosedCessna T337E · Deming, NMJun 23, 1971 · N1258M · Substantial damage NTSB DEN71DQA59Accident · No injuriesClosedBeech 35 · Eagle West, NMJun 20, 1971 · N1166 · Substantial damage NTSB DEN71FQD26Accident · 1 fatalClosedBell 47J · Deming, NMJun 17, 1971 · N6743D · Destroyed NTSB DEN71FQD25Accident · Serious injuriesClosedPiper PA-32 · Chamberino, NMJun 15, 1971 · N5264S · Substantial damage NTSB DEN71FQA58Accident · Serious injuriesClosedMooney M20E · Albuquerque, NMJun 13, 1971 · N6965U · Substantial damage NTSB DEN71AD045Accident · 3 fatalClosedCessna 210 · Yeso, NMJun 7, 1971 · N3913Y · Destroyed