NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 FTW67A0066Accident · 1 fatalClosedCessna 150F · Anthony, NMNTSB DEN67A0038Accident · No injuriesClosedBeech E18S · Albuquerque, NMNTSB DEN67D0185Accident · No injuriesClosedCessna 172 · Crown Point, NMNTSB DEN67F0209Accident · No injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN67A0037Accident · Minor injuriesClosedBell 47G3B1 · Holloman Ab, NMNTSB DEN67F0180Accident · No injuriesClosedCessna 310C · Albuquerque, NMNTSB DEN67F0177Accident · No injuriesClosedMooney M20A · Albuquerque, NMNTSB DEN67D0181Accident · No injuriesClosedCessna 320 · Farmington, NMNTSB DEN67A0034Accident · No injuriesClosedBell 47G3B1 · Holloman Ab, NMNTSB DEN67F0162Accident · Serious injuriesClosedCessna 337 · Albuquerque, NMNTSB DEN67F0153Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN37D0151Accident · No injuriesClosedCessna 182 · Farmington, NMNTSB DEN67F0168Accident · No injuriesClosedCessna 182A · Las Cruces, NMNTSB DEN67F0146Accident · No injuriesClosedCessna 182B · Raton, NMNTSB DEN67F0143Accident · No injuriesClosedBeech B35 · Albuquerque, NMNTSB DEN67D0161Accident · No injuriesClosedBellanca 14-133 · Portales, NMNTSB DEN67D0160Accident · No injuriesClosedPiper PA-19 · White Sands, NMNTSB DEN67D0144Accident · No injuriesClosedCessna 310 · Las Vegas, NMNTSB DEN67F0123Accident · No injuriesClosedBeech A23 · Albuquerque, NMNTSB DEN67D0124Accident · No injuriesClosedPiper PA-24 · Willard, NMNTSB DEN67D0152Accident · No injuriesClosedMooney M20E · Lordsburg, NMNTSB DEN67D0121Accident · No injuriesClosedPiper PA-24 · Santa Rose, NMNTSB DEN67F0147Accident · No injuriesClosedErcoupe 415-C · Carlsbad, NMNTSB DEN67F0120Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN67F0098Accident · No injuriesClosedLark 95 · Deming, NMNTSB DEN67A0024Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMNTSB DEN67A0022Accident · 4 fatalClosedMooney M20B · Hobbs, NMNTSB DEN67F0099Accident · Serious injuriesClosedPiper PA-18 · Albuquerque, NMNTSB DEN67F0081Accident · No injuriesClosedCessna 172 · Roswell, NMNTSB DEN67D0080Accident · Minor injuriesClosedStinson 108-3 · Whites City, NMNTSB DEN67D0115Accident · No injuriesClosedPiper PA-25 · Carlsbad, NMNTSB DEN67D0142Accident · No injuriesClosedCessna P206A · Santa Rosa, NMNTSB DEN67F0091Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN67D0088Accident · No injuriesClosedPiper PA-24 · Taos, NMNTSB DEN67F0125Accident · Serious injuriesClosedPiper PA-25 · Deming, NMNTSB DEN67F0066Accident · Minor injuriesClosedCessna T-210F · Albuquerque, NMNTSB DEN67D0039Accident · No injuriesClosedCessna 150 · Espanola, NMNTSB DEN67D0072Accident · No injuriesClosedCessna 150 · Jal, NMNTSB DEN67D0073Accident · No injuriesClosedPiper PA-28 · Raton, NMNTSB DEN67D0089Accident · No injuriesClosedCessna 150 · Las Cruces, NMNTSB DEN67D0045Accident · Minor injuriesClosedCessna 170B · Roswell, NMNTSB DEN67A0011Accident · Serious injuriesClosedDouglas DC-3 · Gallup, NMNTSB DEN66D0046Accident · No injuriesClosedCessna 175 · Santa Fe, NMNTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMNTSB DEN67D0065Accident · No injuriesClosedCessna 210B · Milnesand, NMNTSB DEN67D0113Accident · Serious injuriesClosedBeech 35 · Columbus, NMNTSB DEN67D0026Accident · No injuriesClosedPiper PA-22 · Santa Rosa, NMNTSB DEN67A0002Accident · 2 fatalClosedPiper PA-18 · Quemado, NMNTSB DEN67D0090Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMNTSB DEN67D0035Accident · No injuriesClosedPiper PA-24 · Albuquerque, NM