NTSB investigations, 1970, 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\") = 1970
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") = 1970 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 OAK71FXQ25Accident · Serious injuriesClosedAmer Avco AA-1 · Reno, NVNTSB OAK71FVW18Accident · No injuriesClosedCessna 310Q · Las Vegas, NVNTSB OAK71AP027Accident · 3 fatalClosedCessna TU206E · Boulder City, NVNTSB OAK71DVW19Accident · No injuriesClosedCessna 182 · Las Vegas, NVNTSB OAK71DXQ24Accident · Minor injuriesClosedPiper PA-28 · Winnemucca, NVNTSB OAK71FXQ23Accident · Serious injuriesClosedCessna 182 · Mt City, NVNTSB OAK71FVW17Accident · No injuriesClosedPiper PA-32 · Pahrump, NVNTSB OAK71DXQ22Accident · No injuriesClosedLuscombe 8A · Winnemucca, NVNTSB OAK71DXQ21Accident · No injuriesClosedCessna 182 · Reno, NVNTSB OAK71FVW13Accident · No injuriesClosedPiper PA-28 · Lida Junction, NVNTSB OAK71FVW12Accident · No injuriesClosedChampion 7ECA · Alamo, NVNTSB OAK71DVW14Accident · No injuriesClosedSpartan 7W · Pahrump, NVNTSB OAK71FXQ20Accident · 1 fatalClosedBell 47G3B1 · Tuscarora, NVNTSB OAK71DXQ18Accident · Minor injuriesClosedPiper PA-18 · Summit Lake, NVNTSB OAK71DXQ15Accident · Minor injuriesClosedPiper PA-28 · Reno, NVNTSB OAK71FXQ16Accident · Minor injuriesClosedN.American P-51D · Reno, NVNTSB OAK71FXQ17Accident · Serious injuriesClosedPitts S-1-S · Sparks, NVNTSB OAK71DXQ14Accident · No injuriesClosedSorceress 1 · Reno, NVNTSB OAK71AP014Accident · 4 fatalClosedCessna 182 · Virginia City, NVNTSB OAK71FVW10Accident · No injuriesClosedCessna 150 · Las Vegas, NVNTSB OAK71FVW11Accident · Serious injuriesClosedHughes 269B · Caliente, NVNTSB OAK71FVW09Accident · No injuriesClosedPiper PA-28 · Boulder City, NVNTSB OAK71FVW08Accident · No injuriesClosedCessna 182M · Boulder City, NVNTSB OAK71FXQ13Accident · No injuriesClosedMooney M20E · Reno, NVNTSB OAK71FVW06Accident · No injuriesClosedGlobe GC-1B · Boulder City, NVNTSB OAK71FXQ12Accident · Minor injuriesClosedMooney M20A · Reno, NVNTSB OAK71FVW05Accident · No injuriesClosedBell 47D1 · Las Vegas, NVNTSB OAK71FVW04Accident · No injuriesClosedPiper PA-28 · Jean, NVNTSB OAK71DXQ11Accident · Serious injuriesClosedHarlow A9B · Orovada, NVNTSB OAK71AP007Accident · 1 fatalClosedCessna T210F · Tonopah, NVNTSB OAK71FVW03Accident · No injuriesClosedAero Comdr 680S · Las Vegas, NVNTSB OAK71AP003Accident · 4 fatalClosedBeech 35-C33 · Minden, NVNTSB OAK71FXQ06Accident · No injuriesClosedCessna 150 · Reno, NVNTSB OAK71DXQ02Accident · Minor injuriesClosedPiper PA-18 · Austin, NVNTSB OAK71DXQ03Accident · No injuriesClosedCessna 182 · Mcdermitt, NVNTSB OAK70DXQ23Accident · No injuriesClosedCessna 150 · Valmy, NVNTSB OAK70FVW22Accident · No injuriesClosedStinson V-77 · No Las Vegas, NVNTSB OAK70DXQ19Accident · No injuriesClosedPiper PA-18 · Elko, NVNTSB OAK70FXQ17Accident · No injuriesClosedCessna 177 · Reno, NVNTSB OAK70DXQ16Accident · No injuriesClosedSchempp STD · Gerlach, NVNTSB OAK70FVW17Accident · Minor injuriesClosedBell 47G3B2 · Las Vegas, NVNTSB OAK70DXQ14Accident · Minor injuriesClosedBell 47G3B · Fallon, NVNTSB OAK70FXQ15Accident · No injuriesClosedTaylorcraft BC12-D · Reno, NVNTSB OAK70FXQ12Accident · No injuriesClosedBell 47G3B1 · Reno, NVNTSB OAK70FVW16Accident · No injuriesClosedCessna 310D · Las Vegas, NVNTSB OAK70FXQ13Accident · No injuriesClosedCessna 180 · Reno, NVNTSB OAK70FVW18Accident · No injuriesClosedCessna 172F · Boulder City, NVNTSB OAK70FVW15Accident · No injuriesClosedCessna 140 · Las Vegas, NVNTSB OAK70FVW13Accident · No injuriesClosedCessna 150 · Las Vegas, NVNTSB OAK70AP053Accident · 3 fatalClosedCessna 310 · Beatty, NV