NTSB investigations, 1976, 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.
Cases per year
| 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
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\") = 1976
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") = 1976 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 DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMNTSB DEN77FQA08Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMNTSB DEN77FQA07Accident · No injuriesClosedBellanca 17-30A · Albuquerque, NMNTSB DEN77FQA09Accident · No injuriesClosedGrum Amer AA5 · Ft.Sumner, NMNTSB DEN77DQA06Accident · No injuriesClosedThorp T18 · Santa Fe, NMNTSB DEN77FA012Accident · 2 fatalClosedPiper PA-28 · Farmington, NMNTSB DEN77DQA05Accident · No injuriesClosedCessna 182 · Farmington, NMNTSB DEN77FA010Accident · 2 fatalClosedBellanca 17-30A · Taos, NMNTSB DEN77FA009Accident · No injuriesClosedN. American 265-60 · Albuquerque, NMNTSB DEN77FQA04Accident · Minor injuriesClosedCessna TU206F · Albuquerque, NMNTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMNTSB DEN77DQA03Accident · No injuriesClosedBell 206B · Aztec, NMNTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMNTSB DEN76FQA64Accident · Minor injuriesClosedStinson 108-3 · Albuquerque, NMNTSB DEN76AD072Accident · 2 fatalClosedPiper PA-31 · Pinon, NMNTSB DEN76AD071Accident · 2 fatalClosedPiper PA-28 · Scholle, NMNTSB DEN76DQD34Accident · Minor injuriesClosedCessna 188A · Hatch, NMNTSB DEN76FQA63Accident · No injuriesClosedCessna T210G · Eagle Nest, NMNTSB DEN76DQD33Accident · No injuriesClosedBoeing E75N1 · Animas, NMNTSB DEN76FQA62Accident · No injuriesClosedCessna 310I · Farmington, NMNTSB DEN76FQA61Accident · No injuriesClosedBeech 23 · Albuquerque, NMNTSB DEN76AD065Accident · 2 fatalClosedPiper PA-28R · Melrose, NMNTSB DEN76DQA57Accident · No injuriesClosedHughes 269A-1 · Milagro, NMNTSB DEN76FQD32Accident · No injuriesClosedBell 47G3B1 · Mesquite, NMNTSB DEN76FQA59Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN76DQD31Accident · No injuriesClosedCessna 15OJ · Silver City, NMNTSB DEN76FQA56Accident · Minor injuriesClosedCessna 150 · Tucumcari, NMNTSB DEN76FQA55Accident · No injuriesClosedBeech 58P · Albuquerque, NMNTSB DEN76DQA40Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN76FQG06Accident · 1 fatalClosedEL Gringo 1 · Hobbs, NMNTSB DEN76FQA54Accident · No injuriesClosedPiper PA-23 · Ruidoso, NMNTSB DEN76FQA53Accident · No injuriesClosedMooney M20C · Albuquerque, NMNTSB DEN76DQG05Accident · Serious injuriesClosedPiper PA-25 · Lovington, NMNTSB DEN76FQA52Accident · No injuriesClosedCessna 177 · Albuquerque, NMNTSB DEN76DQA51Accident · Minor injuriesClosedMeyers 200 · Tucumcari, NMNTSB DEN76FQD26Accident · No injuriesClosedTwin Engine D-16 · Las Cruces, NMNTSB DEN76FQA50Accident · No injuriesClosedCessna 182K · Taos, NMNTSB DEN76FQA49Accident · No injuriesClosedCessna U206 · Farmington, NMNTSB DEN76FQA48Accident · No injuriesClosedCessna 180 · Farmington, NMNTSB DEN76FQA47Accident · No injuriesClosedPiper PA-24 · Los Lunas, NMNTSB DEN76FQA46Accident · No injuriesClosedCessna T210 · Los Alamos, NMNTSB DEN76FQG04Accident · Serious injuriesClosedPiper PA-28 · Hobbs, NMNTSB DEN76AD050Accident · 1 fatalClosedPiper PA-18 · Buckhorn, NMNTSB DEN76DQD24Accident · No injuriesClosedCamair 480 · Lordsburg, NMNTSB DEN76DQA44Accident · No injuriesClosedRaven S-55A · Albuquerque, NMNTSB DEN76FQA43Accident · Serious injuriesClosedPiper PA-32 · Albuquerque, NMNTSB DEN76DQD21Accident · No injuriesClosedCessna 150 · Silver City, NMNTSB DEN76FQA41Accident · Serious injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN76DQA42Accident · No injuriesClosedStarduster SA-300 · Socorro, NM