Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 DEN73FQD13Accident · No injuriesClosedErco 415-CD · Alamogordo, NMDec 31, 1972 · N2431H · Substantial damage NTSB DEN73DQA22Accident · Minor injuriesClosedLuscombe 11A · Santa Fe, NMDec 16, 1972 · N1650B · Destroyed NTSB DEN73AD026Accident · 5 fatalClosedLockheed PV-1 · Tucumcari, NMDec 3, 1972 · N5033F · Destroyed NTSB DEN73DQD11Accident · No injuriesClosedBeech A36 · Pinon, NMNov 26, 1972 · N4467A · Substantial damage NTSB DEN73DQA21Accident · No injuriesClosedCessna 150 · Aztec, NMNov 18, 1972 · N5703E · Substantial damage NTSB DEN73FQA20Accident · No injuriesClosedCessna P206 · Tres Piedrs, NMNov 8, 1972 · N2586X · Substantial damage NTSB DEN73FQD10Accident · No injuriesClosedCessna 210D · Sunland, NMNov 4, 1972 · N3901Y · Substantial damage NTSB DEN73AD019Accident · 1 fatalClosedBeech 35 · Bloomfield, NMOct 29, 1972 · N3100V · Destroyed NTSB DEN73FQA19Accident · Serious injuriesClosedSmith DSA-1 · Albuquerque, NMOct 23, 1972 · N354S · Substantial damage NTSB DEN73FQA18Accident · No injuriesClosedCessna 206B · Moriarty, NMOct 21, 1972 · N3403L · Substantial damage NTSB DEN73DQG19Accident · No injuriesClosedPiper PA-23 · Humble City, NMSep 28, 1972 · N4358P · Substantial damage NTSB DEN73DQA17Accident · Minor injuriesClosedPiper PA-12 · Glencoe, NMSep 17, 1972 · N7964C · Substantial damage NTSB DEN73FQA16Accident · Minor injuriesClosedBeech S35 · Albuquerque, NMAug 31, 1972 · N4321S · Substantial damage NTSB DEN73AD008Accident · 2 fatalClosedEmigh Acft Trojan · Edgewood, NMAug 23, 1972 · N8341H · Destroyed NTSB DEN73FQA15Accident · Serious injuriesClosedPiper PA-17 · Gallup, NMAug 22, 1972 · N4657H · Destroyed NTSB DEN73FQA13Accident · No injuriesClosedCessna 421 · Albuquerque, NMAug 18, 1972 · N3140K · Substantial damage NTSB DEN73FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMAug 17, 1972 · N2790D · Substantial damage NTSB DEN73FQA11Accident · No injuriesClosedPiper PA-24 · Reserve, NMAug 17, 1972 · N6755P · Substantial damage NTSB DEN73FQA14Accident · Minor injuriesClosedPiper PA-28 · Counselors, NMAug 15, 1972 · N5459W · Destroyed NTSB DEN73FQA10Accident · No injuriesClosedCessna 150 · Albuquerque, NMAug 12, 1972 · N3137X · Substantial damage NTSB DEN73FQA09Accident · No injuriesClosedPiper PA-28R · Santa Fe, NMAug 4, 1972 · N3941T · Substantial damage NTSB DEN73FQD05Accident · No injuriesClosedBeech A36 · Columbus, NMAug 2, 1972 · N9261Q · Substantial damage NTSB DEN73FQA08Accident · Serious injuriesClosedPiper PA-24 · Las Vegas, NMAug 2, 1972 · N5183P · Destroyed NTSB DEN73FQA06Accident · No injuriesClosedBeech A60 · Roy, NMJul 26, 1972 · N147E · Destroyed NTSB DEN73FQA05Accident · 2 fatalClosedBoeing B-17 · Socorro, NMJul 12, 1972 · N73648 · Destroyed NTSB DEN73DQD03Accident · Minor injuriesClosedPitts S-1 · Deming, NMJul 11, 1972 · N77CK · Substantial damage NTSB DEN73FQA07Accident · No injuriesClosedCessna 172 · Grants, NMJul 9, 1972 · N5500R · Destroyed NTSB DEN73FQA04Accident · No injuriesClosedCessna 195A · Farmington, NMJul 8, 1972 · N1527D · Substantial damage NTSB DEN72DQA01Accident · No injuriesClosedCessna 120 · Raton, NMJul 5, 1972 · N77476 · Substantial damage NTSB DEN73FQA02Accident · Serious injuriesClosedPiper PA-28 · Albuquerque, NMJul 4, 1972 · N3265R · Substantial damage NTSB DEN73FQD01Accident · No injuriesClosedCessna 177B · Anapra, NMJul 2, 1972 · N34021 · Substantial damage NTSB DEN73AD001Accident · 1 fatalClosedTaylorcraft BC12-D · Lovington, NMJul 2, 1972 · N5016M · Destroyed NTSB DEN72FQD34Accident · No injuriesClosedLuscombe 8F · Deming, NMJun 30, 1972 · N1918B · Substantial damage NTSB DEN73FQA03Accident · No injuriesClosedCessna 150 · Dulche, NMJun 29, 1972 · N8293S · Substantial damage NTSB DEN72FQA45Accident · No injuriesClosedPiper PA-28 · Gallup, NMJun 27, 1972 · N6362J · Substantial damage NTSB DEN72AD060Accident · 6 fatalClosedPiper PA-32 · Glenwood, NMJun 22, 1972 · N4278R · Destroyed NTSB DEN72FQA44Accident · Minor injuriesClosedPiper PA-30 · Dulce, NMJun 20, 1972 · N8644Y · Substantial damage NTSB DEN72FQA44Accident · Serious injuriesClosedBeech 95 · Albuquerque, NMJun 19, 1972 · N2035C · Substantial damage NTSB DEN72FQA43Accident · Minor injuriesClosedCessna 172 · Farmington, NMJun 18, 1972 · N5801A · Substantial damage NTSB DEN72FQD29Accident · No injuriesClosedConvair BT-13A · Sunland Prk, NMJun 16, 1972 · N76W · Substantial damage NTSB DEN72DQD31Accident · No injuriesClosedPitts S-1 · Deming, NMJun 15, 1972 · N9SC · Substantial damage NTSB DEN72FQD28Accident · No injuriesClosedCessna 172L · Deming, NMJun 14, 1972 · N4345Q · Substantial damage NTSB DEN72AD058Accident · 3 fatalClosedPiper PA-28R · Corona, NMJun 7, 1972 · N4670J · Destroyed NTSB DEN72FQD27Accident · No injuriesClosedPiper PA-28 · Anthony, NMJun 2, 1972 · N6378R · Substantial damage NTSB DEN72AD057Accident · 1 fatalClosedCessna 182D · Ruidoso, NMMay 30, 1972 · N9136X · Destroyed NTSB DEN72FQA41Accident · No injuriesClosedHoward DGA-15 · Albuquerque, NMMay 27, 1972 · N450Y · Substantial damage NTSB DEN72AD055Accident · 9 fatalClosedBeech 65-B80 · Albuquerque, NMMay 19, 1972 · N841NS · Destroyed NTSB DEN72FQA40Accident · No injuriesClosedCessna 150E · Waterflow, NMMay 18, 1972 · N2567J · Substantial damage NTSB DEN72AD051Accident · 1 fatalClosedCessna 172K · Portales, NMMay 11, 1972 · N78235 · Destroyed NTSB DEN72AD049Accident · 1 fatalClosedCessna 182M · Counselor, NMMay 6, 1972 · N71503 · Destroyed