Skip to content

NTSB investigations, 1981, NM

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1981, 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") = 1981 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\") = 1981
    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") = 1981
  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 FTW82FQA17Accident · 4 fatalClosedGrum Amer AA-5B · Truchas, NMDec 31, 1981 · N81350 · Destroyed NTSB FTW82FQA12Accident · Minor injuriesClosedMooney M20B · Hillsboro, NMDec 28, 1981 · N792RW · Substantial damage NTSB FTW82DQG13Accident · No injuriesClosedPiper PA-28 · Lovington, NMDec 20, 1981 · N2897A · Substantial damage NTSB FTW82DQA11Accident · Minor injuriesClosedRaven RX-7 · Gallup, NMDec 13, 1981 · N5566M · Substantial damage NTSB FTW82FQA10Accident · No injuriesClosedCessna 182RG · Tucumcari, NMNov 30, 1981 · N3186C · Destroyed NTSB FTW82FA025Accident · 1 fatalClosedPiper PA-28 · Ruidoso, NMNov 27, 1981 · N43981 · Destroyed NTSB FTW82FQA08Accident · No injuriesClosedCessna 210L · Farmington, NMNov 25, 1981 · N94285 · Substantial damage NTSB FTW82DQD05Accident · No injuriesClosedPiper PA-28 · Silver City, NMNov 25, 1981 · N15735 · Substantial damage NTSB FTW82DQD04Accident · No injuriesClosedHughes 369D · Deming, NMNov 24, 1981 · N1089N · Substantial damage NTSB FTW82DQD03Accident · No injuriesClosedCessna 150 · Las Cruces, NMNov 22, 1981 · N6696T · Substantial damage NTSB FTW82DQD08Accident · No injuriesClosedCessna 206 · Silver City, NMNov 20, 1981 · N4694Z · Substantial damage NTSB FTW82FQA09Accident · Minor injuriesClosedBellanca 17-31A · Farmington, NMNov 10, 1981 · N93615 · Destroyed NTSB FTW82FQA07Accident · No injuriesClosedStinson L-5 · Albuquerque, NMOct 20, 1981 · N1718M · Substantial damage NTSB FTW82FQA06Accident · No injuriesClosedSwearingen SA26AT · Albuquerque, NMOct 19, 1981 · N3HV · Substantial damage NTSB FTW82DQD01Accident · Minor injuriesClosedBeech 19A · Sunland Park, NMOct 18, 1981 · N6058N · Substantial damage NTSB FTW82FQA04Accident · Serious injuriesClosedRaven RX-6 · Albuquerque, NMOct 11, 1981 · N8663L · Substantial damage NTSB FTW82FQA05Accident · No injuriesClosedRaven S-55A · Corrales, NMOct 9, 1981 · N3251R · Destroyed NTSB FTW82FQA03Accident · Minor injuriesClosedCessna 152 · Alamo, NMOct 9, 1981 · N46155 · Substantial damage NTSB FTW82FQA02Accident · Minor injuriesClosedBarnes AX-7 · Albuquerque, NMOct 8, 1981 · N40708 · 2 aircraft · Substantial damage NTSB FTW82FQA01Accident · Serious injuriesClosedSchweizer 2-33A · Los Lunas, NMOct 3, 1981 · N2534H · Substantial damage NTSB FTW81DQD35Accident · Minor injuriesClosedGrum Amer AA-1B · Weed, NMSep 26, 1981 · N9978L · Destroyed NTSB FTW81DQD34Accident · No injuriesClosedBensen B8M · Carlsbad, NMSep 11, 1981 · N4218Z · Substantial damage NTSB FTW81DQD33Accident · No injuriesClosedPiper PA-32 · Timberon, NMSep 4, 1981 · N8194E · Substantial damage NTSB FTW81FA137Accident · 2 fatalClosedBeech K35 · Albuquerque, NMAug 29, 1981 · N6079E · Destroyed NTSB FTW81DQA44Accident · No injuriesClosedPiper PA-28 · Clayton, NMAug 26, 1981 · N1057X · Substantial damage NTSB FTW81FQG57Accident · Serious injuriesClosedPitts S-1S · Clovis, NMAug 25, 1981 · N51RA · Destroyed NTSB FTW81FQA43Accident · No injuriesClosedCessna 320F · Ruidoso, NMAug 24, 1981 · N6157Q · Substantial damage NTSB FTW81FQA42Accident · Serious injuriesClosedCessna 172RG · Eagle Nest, NMAug 22, 1981 · N5414V · Destroyed NTSB FTW81DQG55Accident · No injuriesClosedPiper PA-36 · Clovis, NMAug 19, 1981 · N2426V · Destroyed NTSB FTW81FQA39Accident · No injuriesClosedPiper PA-28R · Santa Fe, NMAug 9, 1981 · N1489X · Substantial damage NTSB FTW81DQG46Accident · No injuriesClosedCessna 188B · Portales, NMAug 5, 1981 · N70184 · Substantial damage NTSB FTW81FQA41Accident · No injuriesClosedSchweizer 1-26 · Moriarty, NMAug 2, 1981 · N2505H · Substantial damage NTSB FTW81FQA40Accident · No injuriesClosedPiper PA-25 · Dexter, NMJul 28, 1981 · N6527Z · Substantial damage NTSB FTW81FQA38Accident · No injuriesClosedBeech B23 · Taos, NMJul 22, 1981 · N7658R · Substantial damage NTSB FTW81FQA37Accident · No injuriesClosedCessna 140 · Albuquerque, NMJul 22, 1981 · N76082 · Substantial damage NTSB FTW81FA124Accident · 2 fatalClosedCessna 401 · Albuquerque, NMJul 22, 1981 · N441RS · Destroyed NTSB FTW81DQD29Accident · Minor injuriesClosedCessna 172 · Silver City, NMJul 17, 1981 · N6368G · Substantial damage NTSB FTW81FQG42Accident · Serious injuriesClosedSchneider LS-4 · Hobbs, NMJul 13, 1981 · N52AB · Substantial damage NTSB FTW81FQA36Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJul 11, 1981 · N1791J · Substantial damage NTSB FTW81FA113Accident · 3 fatalClosedCessna 172D · Alamogordo, NMJul 1, 1981 · N2591Y · Destroyed NTSB FTW81FQA34Accident · No injuriesClosedBellanca 17-30 · Albuquerque, NMJun 30, 1981 · N7337V · Substantial damage NTSB FTW81DQG38Accident · No injuriesClosedCessna R172K · Milnesand, NMJun 19, 1981 · N736BF · Substantial damage NTSB FTW81FQA35Accident · Serious injuriesClosedPiper PA-28 · Pecos, NMJun 10, 1981 · N8399Z · Destroyed NTSB FTW81IA103Incident · No injuriesClosedAerospatial SE3160 · Ruidoso, NMJun 9, 1981 · N605RA · Minor damage NTSB FTW81DQD27Accident · No injuriesClosedThunder BLN AX7-65 · Las Cruces, NMJun 7, 1981 · N5589T · Substantial damage NTSB FTW81DQA33Accident · Minor injuriesClosedCessna 172 · Luna, NMJun 6, 1981 · N3574S · Destroyed NTSB FTW81FQA32Accident · 1 fatalClosedSchleicher ASW-20 · Las Vegas, NMJun 1, 1981 · N9031W · Substantial damage NTSB FTW81FQD25Accident · Minor injuriesClosedCessna 402 · Cliff, NMMay 27, 1981 · N2AQ · Destroyed NTSB FTW81DQD24Accident · No injuriesClosedPitts SC-1 · Carlsbad, NMMay 26, 1981 · N137NB · Substantial damage NTSB FTW81DQD23Accident · No injuriesClosedAeronca 7BCM · Las Cruces, NMMay 19, 1981 · N3987B · Substantial damage