NTSB investigations, 1964, NV
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
| 1963 | 1 |
|---|---|
| 1964 | 71 |
| 1965 | 56 |
| 1966 | 79 |
| 1967 | 77 |
| 1968 | 45 |
| 1969 | 51 |
| 1970 | 68 |
| 1971 | 66 |
| 1972 | 55 |
| 1973 | 46 |
| 1974 | 72 |
| 1975 | 55 |
| 1976 | 64 |
| 1977 | 55 |
| 1978 | 59 |
| 1979 | 51 |
| 1980 | 49 |
| 1981 | 46 |
| 1982 | 39 |
| 1983 | 38 |
| 1984 | 36 |
| 1985 | 40 |
| 1986 | 35 |
| 1987 | 26 |
| 1988 | 28 |
| 1989 | 36 |
| 1990 | 27 |
| 1991 | 33 |
| 1992 | 32 |
| 1993 | 29 |
| 1994 | 42 |
| 1995 | 22 |
| 1996 | 23 |
| 1997 | 25 |
| 1998 | 30 |
| 1999 | 42 |
| 2000 | 45 |
| 2001 | 37 |
| 2002 | 34 |
| 2003 | 29 |
| 2004 | 29 |
| 2005 | 25 |
| 2006 | 27 |
| 2007 | 38 |
| 2008 | 25 |
| 2009 | 28 |
| 2010 | 24 |
| 2011 | 22 |
| 2012 | 24 |
| 2013 | 28 |
| 2014 | 22 |
| 2015 | 21 |
| 2016 | 31 |
| 2017 | 31 |
| 2018 | 27 |
| 2019 | 29 |
| 2020 | 22 |
| 2021 | 19 |
| 2022 | 22 |
| 2023 | 23 |
| 2024 | 16 |
| 2025 | 21 |
| 2026 | 13 |
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\" = 'NV' 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" = 'NV' 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 UNK65X1088Accident · No injuriesClosedChampion 7FC · Sparks, NVNTSB UNK65X1083Accident · No injuriesClosedCessna 120 · Yerington, NVNTSB UNK65X1057Accident · Serious injuriesClosedCessna 182 · Las Vegas, NVNTSB UNK65X1050Accident · No injuriesClosedCessna 172 · Mesquite, NVNTSB UNK65X0886Accident · No injuriesClosedCessna 172 · Las Vegas, NVNTSB UNK65X0816Accident · 1 fatalClosedPeper J-3C · Minden, NVNTSB UNK65X0729Accident · 29 fatalClosedFairchild F-27 · Las Vegas, NVNTSB UNK65X0681Accident · 1 fatalClosedPiper PA22 · Battle Mt., NVNTSB UNK65X0413Accident · 2 fatalClosedPiper PA-22 · Reno, NVNTSB UNK65X0201Accident · No injuriesClosedBeechcraft C35 · Ash Meadows, NVNTSB UNK65X0130Accident · No injuriesClosedCessna 170 · Las Vegas, NVNTSB UNK64X4208Accident · Minor injuriesClosedWaco YPF7 · Yerrington, NVNTSB UNK64X4201Accident · Serious injuriesClosedPiper PA25 · Clark County, NVNTSB UNK64X4103Accident · No injuriesClosedPiper PA22 · Reno, NVNTSB UNK64X4061Accident · No injuriesClosedPiper PA22 · Sparks, NVNTSB UNK64X4042Accident · No injuriesClosedFairchild 22C7G · Reno, NVNTSB UNK64X4040Accident · No injuriesClosedGrumman TBM · Beowawe, NVNTSB UNK64X3956Accident · 4 fatalClosedNavion NAV-A · Las Vegas, NVNTSB UNK64X3860Accident · No injuriesClosedCessna 150D · Boulder City, NVNTSB UNK64X3811Accident · No injuriesClosedDehavilland 5A · Las Vegas, NVNTSB UNK64X3777Accident · 1 fatalClosedTaylorcraft BC-12D · Fallon, NVNTSB UNK64X3695Accident · Serious injuriesClosedLaister LK10A · Ren0, NVNTSB UNK64X3618Accident · 2 fatalClosedBeechcraft C-45H · Austin, NVNTSB UNK64X3468Accident · No injuriesClosedDouglas DC-3 · Tonopah, NVNTSB UNK64X3434Accident · 1 fatalClosedCessna 182 · Elko, NVNTSB UNK64X3395Accident · No injuriesClosedCessna 210 · Las Vegas, NVNTSB UNK64X3326Accident · No injuriesClosedChampion 7EC · Mercury, NVNTSB UNK64X3324Accident · No injuriesClosedHughes 269B · Las Vegas, NVNTSB UNK64X3160Accident · No injuriesClosedHughes 269A · Las Vegas, NVNTSB UNK64X3136Accident · No injuriesClosedPiper PA24 · Las Vegas, NVNTSB UNK64X2945Accident · No injuriesClosedAeronca 7AC · Elko, NVNTSB UNK64X2936Accident · 2 fatalClosedPiper PA18 · Orovada, NVNTSB UNK64X2833Accident · 3 fatalClosedPiper PA-28 · Reno, NVNTSB UNK64X2772Accident · No injuriesClosedNavion B · Pahrump, NVNTSB UNK64X2645Accident · No injuriesClosedPiper PA25 · Minden, NVNTSB UNK64X2436Accident · No injuriesClosedBoeing A75 · Lovelock, NVNTSB UNK64X2352Accident · No injuriesClosedPiper PA24 · Caliente, NVNTSB UNK64X2230Accident · No injuriesClosedPiper PA28 · Las Vegas, NVNTSB UNK64X2171Accident · No injuriesClosedCessna 150 · Las Vegas, NVNTSB UNK64X2170Accident · No injuriesClosedCessna 172 · Lathrop Wells, NVNTSB UNK64X2074Accident · 2 fatalClosedCessna 182 · Wells, NVNTSB UNK64X2054Accident · Minor injuriesClosedCessna 206 · Wells, NVNTSB UNK64X2003Accident · Minor injuriesClosedCessna 170B · Mercury, NVNTSB UNK64X1664Accident · No injuriesClosedCessna 170 · Baker, NVNTSB UNK64X1606Accident · Serious injuriesClosedSchweizer TG3A · Jean, NVNTSB UNK64X1580Accident · Minor injuriesClosedCessna 172 · Elko, NVNTSB UNK64X1553Accident · Minor injuriesClosedCessna 210A · Reno, NVNTSB UNK64X1547Accident · No injuriesClosedStinson 108 · Flanigan, NVNTSB UNK64X1544Accident · No injuriesClosedCessna 182 · Las Vegas, NVNTSB UNK64X1503Accident · 2 fatalClosedCessna 140 · Elko, NV