NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1148Accident · No injuriesClosedCessna 172 · Grants, NMNTSB UNK65X1041Accident · No injuriesClosedBeechraft S35 · Chama, NMNTSB UNK65X0946Accident · No injuriesClosedPiper PA18 · Parkview, NMNTSB UNK65X0591Accident · No injuriesClosedPiper PA24 · Corona, NMNTSB UNK65X0448Accident · No injuriesClosedBeechcraft 35 · Sunland Par, NMNTSB UNK65X0439Accident · Serious injuriesClosedPiper PA-24 · Albuquerque, NMNTSB UNK65X0406Accident · No injuriesClosedNavion A · Las Cruces, NMNTSB UNK65X0389Accident · No injuriesClosedMorrow II · Hobbs, NMNTSB UNK65X0342Accident · No injuriesClosedMooney M20C · Cebolla, NMNTSB UNK65X0263Accident · No injuriesClosedMooney M20D · Socorro, NMNTSB UNK65X0210Accident · No injuriesClosedCessna 182 · Albuquerque, NMNTSB UNK65X0198Accident · No injuriesClosedPiper PA18A · Socorro, NMNTSB UNK65X0158Incident · No injuriesClosedConvair 240 · Roswell, NMNTSB UNK65X0129Accident · No injuriesClosedPiper PA24 · Columbus, NMNTSB UNK64X4194Accident · No injuriesClosedBeechcraft A35 · Albuquerque, NMNTSB UNK64X4174Accident · No injuriesClosedPiper PA22 · Alameda, NMNTSB UNK64X4098Accident · No injuriesClosedNavion · Silver City, NMNTSB UNK64X3991Accident · No injuriesClosedCessna 310D · Farmington, NMNTSB UNK64X3989Accident · No injuriesClosedMooney MK21 · Farmington, NMNTSB UNK64X3979Accident · No injuriesClosedConvair CV-440 · Farmington, NMNTSB UNK64X3814Accident · No injuriesClosedBeechcraft A23 · Springer, NMNTSB UNK64X3799Accident · Minor injuriesClosedPiper PA28 · Coyote, NMNTSB UNK64X3658Accident · No injuriesClosedLuscombe 8F · Albuquerque, NMNTSB UNK64X3657Accident · No injuriesClosedCessna 195 · White Sands, NMNTSB UNK64X3544Accident · No injuriesClosedSchweizer 123H · Jal, NMNTSB UNK64X3506Accident · No injuriesClosedPiper PA24 · Socorro, NMNTSB UNK64X3505Accident · No injuriesClosedErcoupe 415C · Alamogordo, NMNTSB UNK64X3459Accident · Minor injuriesClosedPiper PA12 · Grants, NMNTSB UNK64X3425Accident · No injuriesClosedCessna 140 · Farmington, NMNTSB UNK64X3340Accident · No injuriesClosedMooney MK20A · Santa Rosa, NMNTSB UNK64X3254Accident · No injuriesClosedPiper PA22 · Alameda, NMNTSB UNK64X3115Accident · No injuriesClosedCessna 182 · Gallup, NMNTSB UNK64X3043Accident · Minor injuriesClosedPiper PA23 · Albuquerque, NMNTSB UNK64X3017Accident · No injuriesClosedCessna 180 · Albuquerque, NMNTSB UNK64X2993Accident · No injuriesClosedCessna 182 · Gallup, NMNTSB UNK64X2984IncidentClosedDouglas DC3 · Gallup, NMNTSB UNK64X2944Accident · No injuriesClosedPiper PA25 · Gallup, NMNTSB UNK64X2885Accident · No injuriesClosedBell 47G3B · Reserve, NMNTSB UNK64X2869Accident · 4 fatalClosedBeechcraft G18S · Toadlena, NMNTSB UNK64X2805Accident · Minor injuriesClosedBeechcraft 23 · Springer, NMNTSB UNK64X2784Accident · 4 fatalClosedPiper PA24 · Tijeras, NMNTSB UNK64X2734Accident · No injuriesClosedBeechcraft B55 · Albuquerque, NMNTSB UNK64X2723Accident · No injuriesClosedBellanca 14192 · Farmington, NMNTSB UNK64X2718Accident · No injuriesClosedMooney MK20B · Las Cruces, NMNTSB UNK64X2674Accident · Serious injuriesClosedCessna 195 · Clines Corners, NMNTSB UNK64X2658Accident · No injuriesClosedPiper PA28 · Rosweell, NMNTSB UNK64X2578Accident · No injuriesClosedCessna 170B · Albuquerque, NMNTSB UNK64X2563Accident · Serious injuriesClosedCessna 150 · Cloudcroft, NMNTSB UNK64X2528Accident · Serious injuriesClosedPiper PA22 · Cowles, NMNTSB UNK64X2496Accident · No injuriesClosedBeechcraft D35 · Las Cruces, NM