NTSB investigations, 1976, NV
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
| 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 | 12 |
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\") = 1976
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") = 1976 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 OAK77DXQ04Accident · No injuriesClosedPiper PA28 · Winnemucca, NVNTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NVNTSB OAK77FVW05Accident · No injuriesClosedEmair 1200MA · Las Vegas, NVNTSB OAK77DXQ03Accident · No injuriesClosedPiper PA-28 · Minden, NVNTSB OAK77DXQ02Accident · No injuriesClosedMaule M5 · Battle Mountn, NVNTSB OAK77FA005Accident · 2 fatalClosedCessna 310L · Hawthorne, NVNTSB OAK77FVW03Accident · Minor injuriesClosedPiper PA-32R · Searchlight, NVNTSB OAK77FVW02Accident · Minor injuriesClosedMooney M20C · Pioche, NVNTSB OAK77FA004Accident · 2 fatalClosedBellanca 8GCBC · Las Vegas, NVNTSB OAK77DVW01Accident · No injuriesClosedCessna 205 · Searchlight, NVNTSB OAK77DXQ01Accident · No injuriesClosedCessna 210 · Elko, NVNTSB OAK76AP071Accident · 2 fatalClosedBellanca Bkcab · Las Vegas, NVNTSB OAK76FXQ70Accident · Serious injuriesClosedBellanca 17-30 · Yerington, NVNTSB OAK76DXQ69Accident · No injuriesClosedCessna 185 · Reno, NVNTSB OAK76FVW34Accident · No injuriesClosedGrum Amer AA1-B · Boulder City, NVNTSB OAK76FXQ67Accident · No injuriesClosedKinner Kinair · Reno, NVNTSB OAK76FXQ66Accident · No injuriesClosedTwin Engine D-16 · Carson City, NVNTSB OAK76DXQ68Accident · No injuriesClosedSchweizer SGS134 · Minden, NVNTSB OAK76FXQ65Accident · Serious injuriesClosedPiper PA-28 · Incline Villge, NVNTSB OAK76DXQ64Accident · No injuriesClosedPiper PA-24 · Reno, NVNTSB OAK76DVW33Accident · No injuriesClosedPiper PA-30 · Pioche, NVNTSB OAK76DXQ63Accident · No injuriesClosedGlobe GC-1B · Wild Horse Res, NVNTSB OAK76FVW32Accident · No injuriesClosedMooney M20F · Las Vegas, NVNTSB OAK76DXQ59Accident · Minor injuriesClosedBeech A35 · Mountain Pass, NVNTSB OAK76DXQ60Accident · No injuriesClosedGrum Amer AA-5A · Currie, NVNTSB OAK76DXQ58Accident · Minor injuriesClosedNavion B · Oasis, NVNTSB OAK76DXQ56Accident · No injuriesClosedPiper PA-18 · Orovada, NVNTSB OAK76DXQ57Accident · No injuriesClosedCessna 180 · Minden, NVNTSB OAK76DXQ55Accident · No injuriesClosedSnow 600S2C · Yerington, NVNTSB OAK76AP060Accident · 3 fatalClosedBell 206B · Carson City, NVNTSB OAK76FXQ53Accident · No injuriesClosedCessna 150 · Reno, NVNTSB OAK76FXQ52Accident · No injuriesClosedGrum Amer AA-5 · Reno, NVNTSB OAK76FVW30Accident · No injuriesClosedPiper PA-28 · Las Vegas, NVNTSB OAK76DXQ51Accident · No injuriesClosedCessna 150 · Reno, NVNTSB OAK76FXQ50Accident · No injuriesClosedPiper PA-28R · Sparks, NVNTSB OAK76FVW29Accident · Serious injuriesClosedPiper PA-24 · Tempiute, NVNTSB OAK76FXQ49Accident · No injuriesClosedCessna 140 · Silver Springs, NVNTSB OAK76DVW28Accident · Serious injuriesClosedBellanca 8GCBC · Beatty, NVNTSB OAK76DXQ47Accident · No injuriesClosedCessna 172K · Wild Horse Res, NVNTSB OAK76FVW25Accident · No injuriesClosedSchweizer SGS233 · Henderson, NVNTSB OAK76DXQ44Accident · Serious injuriesClosedChampion 7GCAA · Warm Springs, NVNTSB OAK76FVW24Accident · No injuriesClosedLuscombe 8A · Boulder City, NVNTSB OAK76DXQ42Accident · No injuriesClosedPiper PA-12 · Winnemucca, NVNTSB OAK76FXQ40Accident · No injuriesClosedBellanca 7GCBC · Reno, NVNTSB OAK76FXQ39Accident · No injuriesClosedBede BD-5 · Reno, NVNTSB OAK76DVW22Accident · No injuriesClosedGrum Amer AA-5B · Las Vegas, NVNTSB OAK76FVW21Accident · No injuriesClosedCessna 175 · Las Vegas, NVNTSB OAK76DXQ41Accident · No injuriesClosedMustang Midget · Lovelock, NVNTSB OAK76FVW19Accident · No injuriesClosedBellanca 17-30 · Laughlin, NVNTSB OAK76DVW18Accident · No injuriesClosedCessna 172M · Las Vegas, NV