NTSB investigations, 1965, 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.
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\") = 1965
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") = 1965 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 DEN66D0184Accident · No injuriesClosedPiper PA-18 · Ruidoso, NMNTSB DEN66A0049Accident · Minor injuriesClosedHiller UH12L4 · Albuquerque, NMNTSB DEN66A0047Accident · 2 fatalClosedPiper PA-24 · Cuba, NMNTSB DEN66A0041Accident · No injuriesClosedHiller UH12L4 · Albuquerque, NMNTSB DEN66F0176Accident · No injuriesClosedPitts Spcl S1C · Sunland Pk, NMNTSB DEN66F0168Accident · No injuriesClosedBeechcraft 35 · Albuquerque, NMNTSB DEN66F0170Accident · No injuriesClosedBeechcraft K35 · Moriarity, NMNTSB DEN66A0035Accident · 1 fatalClosedPiper PA-24 · Santa Fe, NMNTSB DEN66A0034Accident · 3 fatalClosedCessna 182E · Santa Fe, NMNTSB DEN66F0160Accident · No injuriesClosedAero Cmdr 680-FL · Albuquerque, NMNTSB DEN66F0171Accident · No injuriesClosedPiper PA-24 · Las Cruces, NMNTSB DEN66D0151Accident · No injuriesClosedBeechcraft E-185 · Taos, NMNTSB DEN66F0159Accident · No injuriesClosedAlon A2 · Sunland Pk, NMNTSB DEN66A0032Accident · 1 fatalClosedCessna 310B · Glenwood, NMNTSB DEN66D0152Accident · No injuriesClosedCessna 150 · Carlsbad, NMNTSB FTW66D0390Accident · No injuriesClosedCessna 182 · Portales, NMNTSB DEN66D0139Accident · No injuriesClosedCessna 150 · Roswell, NMNTSB DEN66D0138Accident · No injuriesClosedCessna 337 · Albuquerque, NMNTSB DEN66D0144Accident · No injuriesClosedCessna 170 · Carlsbad, NMNTSB DEN66F0163Accident · Serious injuriesClosedCessna 150F · Zuni, NMNTSB DEN66F0129Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMNTSB DEN66D0136Accident · Minor injuriesClosedCessna 150 · El Rito, NMNTSB DEN66D0121Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN66F0130Accident · No injuriesClosedMooney M20A · Grants, NMNTSB DEN66F0111Accident · Serious injuriesClosedCessna 320D · Albuquerque, NMNTSB FTW66F0336Accident · No injuriesClosedNavion A · Clovis, NMNTSB DEN66D0153Accident · No injuriesClosedPiper PA-30 · Farmington, NMNTSB DEN66F0123Accident · No injuriesClosedCessna 175 · Albuquerque, NMNTSB DEN66F0115Accident · No injuriesClosedPiper PA-16 · Carlsbad, NMNTSB DEN66F0104Accident · Minor injuriesClosedTemco D16A · Las Vegas, NMNTSB DEN66D0093Accident · No injuriesClosedCessna 180 · Belen, NMNTSB DEN66F0103Accident · Serious injuriesClosedPiper PA-22 · Grants, NMNTSB DEN66D0097Accident · No injuriesClosedCessna 170B · Las Cruces, NMNTSB DEN66D0102Accident · No injuriesClosedBeechcraft 95 · Albuquerque, NMNTSB DEN66D0087Accident · No injuriesClosedAeronca L-16 · Grants, NMNTSB DEN66A0009Accident · 3 fatalClosedPiper PA-24 · Ruidoso, NMNTSB DEN66D0069Accident · Minor injuriesClosedLuscombe 8E · Grants, NMNTSB DEN66D0077Accident · No injuriesClosedPiper PA-28 · Portales, NMNTSB DEN66D0068Accident · No injuriesClosedPiper PA-22 · Shiprock, NMNTSB DEN66D0067Accident · No injuriesClosedBeechcraft 23 · Albuquerque, NMNTSB DEN66D0051Accident · No injuriesClosedCessna 182 · Roy, NMNTSB DEN66D0049Accident · No injuriesClosedPiper PA-24 · Lucy, NMNTSB DEN66F0029Accident · No injuriesClosedBellanca 14-19 · Albuquerque, NMNTSB DEN66F0041Accident · No injuriesClosedPiper PA-24 · Artesia, NMNTSB DEN66F0040Accident · No injuriesClosedCessna 182 · Albuquerque, NMNTSB DEN66F0027Accident · Minor injuriesClosedErcoupe 415C · Socorro, NMNTSB DEN66D0086Accident · No injuriesClosedPiper PA-22 · Albuquerque, NMNTSB DEN66D0050Accident · No injuriesClosedPiper PA-22 · Lavida Miss, NMNTSB DEN66D0066Accident · No injuriesClosedCessna 190 · Gallup, NMNTSB DEN65A0089Accident · No injuriesClosedGrumman TBM · Silver City, NM