NTSB investigations, 1974, NM
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\") = 1974
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") = 1974 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 DEN75DQA25Accident · No injuriesClosedPiper PA-22 · Ruidoso, NMNTSB DEN75AD033Accident · 3 fatalClosedMooney M20F · Watrous, NMNTSB DEN75FQA24Accident · Serious injuriesClosedBell 47G3B2 · Albuquerque, NMNTSB DEN75FQA22Accident · No injuriesClosedAmer Avco AA-1A · Albuquerque, NMNTSB DEN75FQA23Accident · No injuriesClosedBellanca 8GCBC · San Mateo, NMNTSB DEN75FQA21Accident · Serious injuriesClosedCessna 180 · San Mateo, NMNTSB DEN75FQA20Accident · Serious injuriesClosedTaylorcraft DCO-65 · Raton, NMNTSB DEN75FQA19Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN75DQA18Accident · No injuriesClosedPiper PA-24 · Arrey, NMNTSB FTW75DQG27Accident · No injuriesClosedCessna 150 · Texico, NMNTSB DEN75DQG05Accident · No injuriesClosedChampion 7GC · Field, NMNTSB DEN75DQA16Accident · No injuriesClosedCessna 182 · Albuquerque, NMNTSB DEN75AQA15Accident · 1 fatalClosedPiper PA-28 · Farmington, NMNTSB DEN75AD014Accident · 1 fatalClosedPiper PA-18 · Corona, NMNTSB DEN75DQA14Accident · Serious injuriesClosedBoeing E75N1 · Gallup, NMNTSB DEN75FQA17Accident · No injuriesClosedMooney M20C · Zuni, NMNTSB DEN75DQA13Accident · No injuriesClosedSchweizer SGS232 · Albuquerque, NMNTSB DEN75AD005Accident · 2 fatalClosedCessna 170A · Bernardo, NMNTSB DEN75FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMNTSB DEN75DQA11Accident · No injuriesClosedBell 212 · Red Hill, NMNTSB DEN75FQD09Accident · No injuriesClosedBoeing A75N1 · Las Cruces, NMNTSB DEN75FQD08Accident · Serious injuriesClosedCessna 150 · Condran Aaf, NMNTSB DEN75DQA07Accident · No injuriesClosedLuscombe 8E · San Felipe, NMNTSB DEN75DQA10Accident · Minor injuriesClosedCessna 206 · La Vida Msn, NMNTSB DEN75FQD06Accident · No injuriesClosedBell 47G3B2 · Mesquite, NMNTSB DEN75DQD05Accident · No injuriesClosedPiper PA-24 · Silver City, NMNTSB DEN75FQA09Accident · Minor injuriesClosedNavion A · Aztec, NMNTSB DEN75FQA06Accident · Serious injuriesClosedPiper PA-28 · Lybrook, NMNTSB DEN75AQA05Accident · No injuriesClosedCessna 210A · Santa Fe, NMNTSB DEN75FQA04Accident · No injuriesClosedBeech D55 · Bernalillo, NMNTSB DEN75AQA02Accident · Minor injuriesClosedCessna 172G · Wagon Mound, NMNTSB DEN75DQA03Accident · No injuriesClosedSchweizer SGS123 · Moriarty, NMNTSB DEN75FQA08Accident · No injuriesClosedPiper PA-11 · Los Lunas, NMNTSB DEN75FQA01Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN75DQD01Accident · Minor injuriesClosedPiper PA-28 · Columbus, NMNTSB DEN75FQA52Accident · No injuriesClosedCessna 172 · Albuquerque, NMNTSB DEN74DQD28Accident · No injuriesClosedErco 415-C · Animas, NMNTSB DEN74DQA49Accident · No injuriesClosedBeech D18S · Raton, NMNTSB DEN74FQA51Accident · No injuriesClosedPiper PA-28 · Jmez Pueblo, NMNTSB LAX74AL081Accident · Minor injuriesClosedHughes 369HS · Luna, NMNTSB DEN74DQD26Accident · No injuriesClosedCessna 170B · Las Cruces, NMNTSB DEN74FQA48Accident · No injuriesClosedNavion A · Cerrillos, NMNTSB DEN74FQA47Accident · No injuriesClosedCessna 182B · Farmington, NMNTSB DEN74DQD25Accident · Minor injuriesClosedCessna 150L · Alamogordo, NMNTSB DEN74FQA46Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN74FQA45Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMNTSB DEN74FQA43Accident · 1 fatalClosedBensen B-8M · Cerrillos, NMNTSB DEN74FQD21Accident · No injuriesClosedCessna 182K · Ruidoso, NMNTSB DEN74FQA44Accident · No injuriesClosedBeech A24R · Socorro, NMNTSB DEN74FQD19Accident · No injuriesClosedPiper PA-28 · Alamogordo, NM