Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 DEN80FA013Accident · 1 fatalClosedRockwell 500B · Santa Fe, NMDec 22, 1979 · N6194X · Destroyed NTSB DEN80DQD04Accident · No injuriesClosedCessna 210 · Animas, NMDec 22, 1979 · N761JE · Substantial damage NTSB DEN80FQA12Accident · Serious injuriesClosedCessna 177B · Vaughn, NMDec 21, 1979 · N16239 · Destroyed NTSB DEN80FQA11Incident · No injuriesClosedCessna 402A · Albuquerque, NMDec 10, 1979 · N4514Q · Minor damage NTSB DEN80DQG03Accident · No injuriesClosedCessna 206 · Hobbs, NMDec 9, 1979 · N735VE · Substantial damage NTSB DEN80IA010Incident · No injuriesClosedBeech 95-B55 · Albuquerque, NMNov 27, 1979 · N677K · Minor damage NTSB DEN80DQD03Accident · No injuriesClosedBeech A36 · Deming, NMNov 18, 1979 · N130T · Substantial damage NTSB DEN80FQG02Accident · No injuriesClosedCessna 421 · Elida, NMNov 14, 1979 · N421BH · Substantial damage NTSB DEN80DQA09Accident · No injuriesClosedStearman B-75 · Gallup, NMNov 13, 1979 · N55692 · Minor damage NTSB DEN80DQA10Accident · No injuriesClosedPiper PA-23 · Ruidoso, NMNov 10, 1979 · N5998Y · Minor damage NTSB DEN80DQD02Accident · Minor injuriesClosedCessna 182N · Hacienda Sr Ln, NMNov 9, 1979 · N9128G · Substantial damage NTSB DEN80FQA08Accident · Minor injuriesClosedCessna T210L · Farmington, NMNov 5, 1979 · N59156 · Destroyed NTSB DEN80FQA07Accident · No injuriesClosedCessna 182 · Dexter, NMNov 4, 1979 · N2462X · Substantial damage NTSB DEN80FQG01Accident · No injuriesClosedCessna 150L · Hobbs, NMOct 31, 1979 · N6908G · Substantial damage NTSB DEN80FA008Accident · 2 fatalClosedCessna 310 · Tucumcari, NMOct 30, 1979 · N1758H · Destroyed NTSB DEN80FA007Accident · 1 fatalClosedCessna 182P · Farmington, NMOct 29, 1979 · N1987M · Destroyed NTSB DEN80FA005Accident · 1 fatalClosedSoloy 47G · Ruidoso, NMOct 23, 1979 · N7828S · Destroyed NTSB DEN80DQD01Accident · Minor injuriesClosedPiper PA-28 · Alamogordo, NMOct 21, 1979 · N6229W · Substantial damage NTSB DEN80FQA06Accident · No injuriesClosedCessna 210B · Albuquerque, NMOct 14, 1979 · N9591X · Substantial damage NTSB DEN80FQA05Accident · Minor injuriesClosedGrum Amer AA-1C · Albuquerque, NMOct 13, 1979 · N9529U · Substantial damage NTSB DEN79FQA04Accident · No injuriesClosedPiper PA-12 · Farmington, NMOct 12, 1979 · N7897H · Substantial damage NTSB DEN80FQA03Accident · No injuriesClosedHughes 500C · Albuquerque, NMOct 10, 1979 · N9186F · Substantial damage NTSB DEN80FA002Accident · 2 fatalClosedRaven S55AX7 · Albuquerque, NMOct 10, 1979 · N403AA · Destroyed NTSB DEN80FQA02Accident · Minor injuriesClosedPiper PA-28R · Torreon, NMOct 9, 1979 · N56175 · Substantial damage NTSB DEN80FQA01Accident · No injuriesClosedPiper PA-38 · Gallup, NMOct 5, 1979 · N2461K · Substantial damage NTSB DEN79FA065Accident · 1 fatalClosedBell 47G · Deming, NMSep 20, 1979 · N2220W · Destroyed NTSB DEN79FQA47Accident · No injuriesClosedBeech 35-33 · Gallop, NMSep 19, 1979 · N9046S · Substantial damage NTSB CHI79DA080Incident · Serious injuriesClosedBoeing 727 · Cimarron, NMSep 15, 1979 · N7444U · No damage NTSB DEN79FQA52Accident · No injuriesClosedCessna 175 · Albuquerque, NMSep 14, 1979 · N7173M · Substantial damage NTSB DEN79DQG07Accident · Minor injuriesClosedPiper PA-25 · Portales, NMSep 7, 1979 · N4605Y · Destroyed NTSB DEN79DQA51Accident · No injuriesClosedGrum Amer AA-5A · Dulce, NMSep 7, 1979 · N26349 · Substantial damage NTSB DEN79FQA50Accident · Minor injuriesClosedPiper PA-28 · Gallup, NMSep 6, 1979 · N8007N · Substantial damage NTSB DEN80FQG06Accident · No injuriesClosedCessna 310G · Lovington, NMSep 1, 1979 · N8906Z · Substantial damage NTSB DEN79DQD16Accident · No injuriesClosedHelicom COMM11 · Carsbad, NMAug 27, 1979 · N44JA · Substantial damage NTSB DEN79FQA48Accident · No injuriesClosedPiper PA-24 · Truth Or Cons, NMAug 23, 1979 · N8451P · Substantial damage NTSB DEN79DQG05Accident · Minor injuriesClosedPiper PA-36 · Arch, NMAug 22, 1979 · N82671 · Substantial damage NTSB DEN79FQA33Accident · No injuriesClosedCessna TC210 · Albuquerque, NMAug 15, 1979 · N761ST · Substantial damage NTSB DEN79FA054Accident · 2 fatalClosedPiper PA-18 · Artesia, NMAug 15, 1979 · N83286 · Destroyed NTSB DEN79FQD15Accident · Minor injuriesClosedCessna 172 · Cloudcroft, NMAug 13, 1979 · N739WT · Destroyed NTSB DEN79FQA46Accident · No injuriesClosedCessna T210M · Ruidoso, NMAug 11, 1979 · N732UZ · Substantial damage NTSB DEN79DQA45Accident · Serious injuriesClosedCessna 152 · Crown Point, NMAug 8, 1979 · N68705 · Substantial damage NTSB DEN79FQA44Accident · Minor injuriesClosedCessna 337 · Prewitt, NMJul 31, 1979 · N5322S · Substantial damage NTSB DEN79FQA43Accident · No injuriesClosedStinson 108-2 · Mid Valley, NMJul 29, 1979 · N45CG · Substantial damage NTSB DEN79FA052Accident · Serious injuriesClosedCessna P210 · Farmington, NMJul 26, 1979 · N4798K · Substantial damage NTSB DEN79DQA42Accident · No injuriesClosedBellanca 7GCBC · Clayton, NMJul 26, 1979 · N5033E · Substantial damage NTSB DEN79FQA39Accident · No injuriesClosedPiper PA-24 · Angel Fire, NMJul 23, 1979 · N6499P · Substantial damage NTSB DEN79FQA41Accident · No injuriesClosedPiper PA-28 · Cuba, NMJul 21, 1979 · N8726N · Substantial damage NTSB DEN79FA049Accident · 1 fatalClosedCessna 172 · Albuquerque, NMJul 14, 1979 · N1695E · 2 aircraft · Substantial damage NTSB DEN79FQD14Accident · Serious injuriesClosedPiper PA-25 · Deming, NMJul 13, 1979 · N7402Z · Destroyed NTSB DEN79FQA38Accident · Serious injuriesClosedCessna 172 · Albuquerque, NMJul 7, 1979 · N5117F · Substantial damage