Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 DEN74FQG02Accident · No injuriesClosedCessna TU206F · Jal, NMDec 18, 1973 · N51404 · Substantial damage NTSB DEN74FQA27Accident · No injuriesClosedCessna 182 · Albuquerque, NMDec 17, 1973 · N9363G · Substantial damage NTSB DEN74DQD12Accident · No injuriesClosedCessna 170B · Las Cruces, NMDec 1, 1973 · N43F · Substantial damage NTSB DEN74AD024Accident · 1 fatalClosedBellanca 8KCAB · Santa Fe, NMNov 18, 1973 · N36033 · Destroyed NTSB DEN74FQA26Accident · No injuriesClosedCessna 310P · Albuquerque, NMNov 12, 1973 · N5842M · Substantial damage NTSB DEN74AD022Accident · 1 fatalClosedPiper PA-24 · Roswell, NMNov 9, 1973 · N9001P · Destroyed NTSB DEN74AD021Accident · No injuriesClosedCessna 210 · Albuquerque, NMNov 7, 1973 · N5876F · Substantial damage NTSB DEN74FQA24Accident · No injuriesClosedAmer Avco AA5 · Albuquerque, NMNov 6, 1973 · N6015L · Substantial damage NTSB DEN74DQA73Accident · No injuriesClosedCessna TU206B · Roswell, NMNov 3, 1973 · N3478L · Destroyed NTSB DCA74AZ031Accident · 1 fatalClosedDouglas DC-10 · Albuquerque, NMNov 3, 1973 · N60NA · Substantial damage NTSB DEN74DQA22Accident · No injuriesClosedCessna 182G · Mid Valley, NMOct 31, 1973 · N2496R · Substantial damage NTSB DEN74FQD11Accident · Minor injuriesClosedCessna T337 · Sacramento, NMOct 24, 1973 · N2509S · Substantial damage NTSB DEN74DQD10Accident · No injuriesClosedCessna 150 · Las Cruces, NMOct 14, 1973 · N22280 · Substantial damage NTSB DEN74DQA21Accident · No injuriesClosedCessna 182 · Ramah, NMOct 14, 1973 · N42878 · Substantial damage NTSB DEN74DQA20Accident · Minor injuriesClosedPiper J-3 · Stead, NMOct 14, 1973 · N88240 · Substantial damage NTSB DEN74AD014Accident · 4 fatalClosedCessna 182 · Artesia, NMOct 6, 1973 · N71227 · Destroyed NTSB DEN74DQD07Accident · No injuriesClosedBeech B55 · Silver City, NMOct 3, 1973 · N6844Q · Substantial damage NTSB DEN74DQD06Accident · No injuriesClosedPiper PA-28 · Silver City, NMOct 1, 1973 · N98222 · Substantial damage NTSB DEN74AD012Accident · No injuriesClosedPiper PA-31 · Roswell, NMSep 25, 1973 · N6472L · Substantial damage NTSB DEN74DQA18Accident · No injuriesClosedAero Comdr 100 · Albuquerque, NMSep 21, 1973 · N4088X · Substantial damage NTSB DEN74DQA17Accident · No injuriesClosedSchweizer SGS126 · Moriarty, NMSep 15, 1973 · N8671R · Substantial damage NTSB DEN74DQA16Accident · No injuriesClosedCessna 182 · Gallop, NMSep 4, 1973 · N91288 · Substantial damage NTSB LAX74AL014Accident · 4 fatalClosedPiper PA-28 · Ruidoso, NMAug 13, 1973 · N16454 · Destroyed NTSB DEN74DQD03Accident · No injuriesClosedCessna 150 · Alamogordo, NMAug 9, 1973 · XB-BIV · Substantial damage NTSB DEN74DQA13Accident · No injuriesClosedMcdonald S-20 · Moriarty, NMAug 9, 1973 · N106AB · Substantial damage NTSB DEN74DQA11Accident · No injuriesClosedCessna 150L · Moriarity, NMAug 9, 1973 · N1796Q · Substantial damage NTSB DEN74AD006Accident · 1 fatalClosedPiper PA-24 · Weed, NMAug 5, 1973 · N5879P · Destroyed NTSB DEN74DQD02Accident · Minor injuriesClosedPiper PA-28 · Loving, NMAug 4, 1973 · N1249T · Substantial damage NTSB DEN74FQA10Accident · Minor injuriesClosedPiper PA-28 · Mountainair, NMJul 24, 1973 · N5831U · Substantial damage NTSB DEN74AD003Accident · 1 fatalClosedBell 205A-1 · Luna, NMJul 24, 1973 · N83044 · Substantial damage NTSB DEN74DQA08Accident · No injuriesClosedChampion 7GC · Albuquerque, NMJul 21, 1973 · N8547E · Substantial damage NTSB DEN74FQA07Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJul 13, 1973 · N9602J · Substantial damage NTSB DEN74DQA06Accident · No injuriesClosedBell 47G3B2 · Luna, NMJul 11, 1973 · N58131 · Substantial damage NTSB DEN74FQA03Accident · No injuriesClosedBell 47G5 · Albuquerque, NMJul 8, 1973 · N6278N · Substantial damage NTSB DEN74DQA05Accident · No injuriesClosedPiper PA-24 · Lybrook, NMJul 8, 1973 · N8967P · Substantial damage NTSB DEN74DQA04Accident · No injuriesClosedCessna 177 · Cimarron, NMJul 4, 1973 · N3357T · Substantial damage NTSB DEN74FQA01Accident · No injuriesClosedCessna 150L · Albuquerque, NMJul 1, 1973 · N1580Q · Substantial damage NTSB DEN74FQA02Accident · No injuriesClosedCessna 210E · Albuquerque, NMJun 29, 1973 · N4957U · Substantial damage NTSB DEN73DQA48Accident · No injuriesClosedPiper PA-18 · Corona, NMJun 19, 1973 · N1585P · Substantial damage NTSB DEN73AD055Accident · 1 fatalClosedBell 4G3B2A · Luna, NMJun 19, 1973 · N83111 · Substantial damage NTSB DEN73DQA47Accident · Minor injuriesClosedCessna U206 · Corona, NMJun 18, 1973 · N4997F · Substantial damage NTSB DEN73FQD20Accident · No injuriesClosedBeech D18S · Cloudcroft, NMJun 16, 1973 · N26Q · Destroyed NTSB DEN73FQA46Accident · No injuriesClosedBell 47G-3B · Cuba, NMJun 13, 1973 · N4727R · Substantial damage NTSB DEN73FQA44Accident · No injuriesClosedAmer Avco AA1 · Bernalillo, NMJun 3, 1973 · N5982L · Substantial damage NTSB DEN73DQA45Accident · No injuriesClosedRaven S-55A · Albuquerque, NMJun 3, 1973 · N1969R · Substantial damage NTSB DEN73FQA43Accident · No injuriesClosedAero Cmdr 500-B · Crownpoint, NMJun 1, 1973 · N160X · Substantial damage NTSB DEN73DQA42Accident · No injuriesClosedCessna 150F · Albuquerque, NMMay 24, 1973 · N8182F · Substantial damage NTSB DEN73FQA40Accident · No injuriesClosedCessna 340 · Albuquerque, NMMay 18, 1973 · N4098L · Substantial damage NTSB DEN73DQA41Accident · No injuriesClosedCessna 170 · Los Alamos, NMMay 16, 1973 · N3947V · Substantial damage NTSB DEN73DQA38Accident · No injuriesClosedMooney M20F · Ramah, NMMay 5, 1973 · N9568M · Substantial damage