Skip to content

NTSB investigations, 1977, NM

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 DEN78FQA09Accident · Minor injuriesClosedCessna T210L · Moriarty, NMDec 23, 1977 · N5114Q · Substantial damage NTSB DEN78FQA08Accident · Minor injuriesClosedPiper PA-22 · Albuquerque, NMDec 17, 1977 · N1745P · Substantial damage NTSB DEN78FA016Accident · 2 fatalClosedLake LA-4 · Albuquerque, NMDec 16, 1977 · N6011V · Destroyed NTSB DEN78DQA06Accident · No injuriesClosedCessna T210 · Bernalillo, NMDec 13, 1977 · N6724M · Substantial damage NTSB DEN78FA013Accident · 3 fatalClosedCessna 182 · Socorro, NMDec 8, 1977 · N6488A · Destroyed NTSB DEN78DQA07Accident · No injuriesClosedGrum Amer AA1C · Albuquerque, NMDec 3, 1977 · N9605U · Substantial damage NTSB DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NMNov 25, 1977 · N2665T · Substantial damage NTSB DEN78FA007Accident · 2 fatalClosedStinson 108-2 · Hope, NMNov 13, 1977 · N178C · Destroyed NTSB DEN78F0A03Accident · No injuriesClosedMooney M20E · Clines Corners, NMNov 6, 1977 · N5741Q · Substantial damage NTSB DEN78DQA05Accident · Serious injuriesClosedSemco T · Mosquero, NMNov 6, 1977 · N24420 · No damage NTSB DEN78FQA02Accident · Serious injuriesClosedPietenpol Aircam · Albuquerque, NMOct 31, 1977 · N83893 · Destroyed NTSB DEN78FQA01Accident · No injuriesClosedCessna 172M · Albuquerque, NMOct 25, 1977 · N4412R · Substantial damage NTSB DEN78DQD03Accident · No injuriesClosedCessna 337F · Hachita, NMOct 24, 1977 · N1744M · Substantial damage NTSB DEN78FA004Accident · 1 fatalClosedPiper PA-23 · Corona, NMOct 22, 1977 · N1906T · Destroyed NTSB DEN78FQD02Accident · 1 fatalClosedPiper PA-28R · Columbus, NMOct 20, 1977 · N32061 · Substantial damage NTSB DEN78DQD01Accident · No injuriesClosedPiper PA-24 · Las Cruces, NMOct 13, 1977 · N510GQ · Substantial damage NTSB DEN77DQA56Accident · Minor injuriesClosedCessna 210K · Aqua Fria, NMSep 25, 1977 · N5773J · Substantial damage NTSB DEN77FQA55Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMSep 12, 1977 · N1175F · Substantial damage NTSB DEN77DQA54Accident · No injuriesClosedCessna 210E · Carrizozo, NMSep 12, 1977 · N194CF · Substantial damage NTSB DEN77FQA53Accident · No injuriesClosedCessna A188B · Raton, NMSep 9, 1977 · N72062 · Substantial damage NTSB DEN77DQG11Accident · No injuriesClosedPiper PA-28 · Hobbs, NMSep 7, 1977 · N32574 · Substantial damage NTSB UNK77X0110Accident · No injuriesClosedPiper PA-24 · Clovis, NMSep 6, 1977 · N9042P · Substantial damage NTSB DEN77FQA52Accident · Minor injuriesClosedPiper PA-28 · Aztec, NMSep 4, 1977 · N1344H · Substantial damage NTSB DEN77DQG09Accident · No injuriesClosedAero Comdr 600S2R · Clovis, NMSep 2, 1977 · N4956X · Substantial damage NTSB DEN77FA055Accident · 2 fatalClosedBeech C-23 · Miami, NMAug 28, 1977 · N9756L · Destroyed NTSB DEN77FQA51Accident · Serious injuriesClosedPiper PA-28 · Albuquerque, NMAug 26, 1977 · N6624W · Substantial damage NTSB DEN77FQG08Accident · No injuriesClosedCessna 402 · Clovis, NMAug 25, 1977 · N9900F · Substantial damage NTSB DEN77DQA50Accident · No injuriesClosedCessna 170 · Gallup, NMAug 20, 1977 · N9130A · Substantial damage NTSB DEN77FQA49Accident · No injuriesClosedBoeing B75N1 · Albuquerque, NMAug 19, 1977 · N4408N · Substantial damage NTSB DEN77DQA48Accident · No injuriesClosedBeech C35 · Albuquerque, NMAug 18, 1977 · N5959C · Destroyed NTSB DEN77FA052Accident · 4 fatalClosedCessna U206 · Engle, NMAug 11, 1977 · N8062Z · Destroyed NTSB DEN77FA051Accident · 2 fatalClosedMooney M20E · Albuquerque, NMAug 11, 1977 · N3488X · Destroyed NTSB DEN77DQD23Accident · Minor injuriesClosedPiper PA-22 · Silver City, NMAug 4, 1977 · N4779Z · Substantial damage NTSB DEN77DQA47Accident · No injuriesClosedCessna 150 · Santa Fe, NMAug 2, 1977 · N5911T · Substantial damage NTSB DEN77FQA46Accident · Serious injuriesClosedPiper PA-30 · Albuquerque, NMJul 30, 1977 · N222GM · Substantial damage NTSB DEN77DQG07Accident · Minor injuriesClosedCessna 188 · Clovis, NMJul 29, 1977 · N4947Q · Substantial damage NTSB DEN77DQG06Accident · Minor injuriesClosedPiper PA-28 · Jal, NMJul 27, 1977 · N32805 · Substantial damage NTSB DEN77FQG05Accident · Serious injuriesClosedMolino PIK-20 · Hobbs, NMJul 19, 1977 · N37N · Substantial damage NTSB DEN77FA048Accident · 2 fatalClosedBellanca 8GCBC · San Mateo, NMJul 18, 1977 · N18854 · Destroyed NTSB DEN77FQA45Accident · No injuriesClosedCessna T210 · Abiquiu, NMJul 15, 1977 · N59181 · Substantial damage NTSB DEN77FA047Accident · 1 fatalClosedCessna TU206C · Vaughn, NMJul 13, 1977 · N29101 · Destroyed NTSB DEN77FQA44Accident · No injuriesClosedPiper PA-30 · Estancia, NMJul 12, 1977 · N8502Y · Substantial damage NTSB DEN77DQA43Accident · No injuriesClosedCessna 188 · Grady, NMJul 11, 1977 · N8010G · Substantial damage NTSB DEN77FQA42Accident · Serious injuriesClosedCessna 150L · Gallup, NMJul 10, 1977 · N152EZ · Substantial damage NTSB DEN77DQD25Accident · No injuriesClosedGrum Amer AA-5B · Silver City, NMJul 3, 1977 · N76SL · Substantial damage NTSB DEN77DQA41Accident · Minor injuriesClosedCessna 182 · Las Vegas, NMJul 2, 1977 · N9VG · Substantial damage NTSB DEN77DQA40Accident · No injuriesClosedPiper PA-34 · Albuquerque, NMJun 18, 1977 · N3671Q · Substantial damage NTSB DEN77FQA39Accident · No injuriesClosedPiper PA-28R · Albuquerque, NMJun 15, 1977 · N15644 · Substantial damage NTSB DEN77FQA38Accident · No injuriesClosedCessna 150K · Alburquerque, NMJun 15, 1977 · N6087G · Substantial damage NTSB DEN77FQA37Accident · No injuriesClosedCessna 210 · Farmington, NMJun 14, 1977 · N1623X · Substantial damage