NTSB investigations, 1975, 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\") = 1975
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") = 1975 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 OAK76AP038Accident · 3 fatalClosedBeech 35 · Incline Vlg, NVNTSB OAK76AP029Accident · 2 fatalClosedCessna 402 · Elko, NVNTSB OAK76FVW09Accident · No injuriesClosedCessna 411A · Las Vegas, NVNTSB OAK76FXQ26Accident · Minor injuriesClosedCessna 172M · Carson City, NVNTSB OAK76FVW08Accident · No injuriesClosedCessna 310F · Las Vegas, NVNTSB OAK76FVW07Accident · No injuriesClosedCessna 180 · Searchlight, NVNTSB OAK76FVW06Accident · No injuriesClosedCessna 172M · Pioche, NVNTSB OAK76DXQ24Accident · No injuriesClosedCessna 195 · Elko, NVNTSB OAK76DXQ23Accident · No injuriesClosedCessna 177RG · Eureka, NVNTSB OAK76AP023Accident · 2 fatalClosedPiper PA-34 · Zephyr Cove, NVNTSB OAK76DXQ22Accident · No injuriesClosedBellanca 1419-3 · Ely, NVNTSB OAK76DXQ21Accident · No injuriesClosedCessna 195B · Reno, NVNTSB OAK76FVW04Accident · No injuriesClosedChampion 7ECA · Las Vegas, NVNTSB OAK76FXQ19Accident · Minor injuriesClosedCessna 150 · Reno, NVNTSB OAK76DVW03Accident · No injuriesClosedPiper PA-32 · Gold Butte, NVNTSB OAK76AP011Accident · 3 fatalClosedCessna 170B · Goldfield, NVNTSB OAK76DXQ20Accident · No injuriesClosedAeronca 11AC · Fallon, NVNTSB OAK76FVW02Accident · No injuriesClosedCessna T210L · Las Vegas, NVNTSB OAK76FXQ16Accident · 1 fatalClosedN.American AT-6 · Reno, NVNTSB OAK76FXQ15Accident · 1 fatalClosedStearman PT-17 · Reno, NVNTSB OAK7LAP009Accident · 4 fatalClosedPiper PA-22 · Hawthorne, NVNTSB OAK76DXQ13Accident · No injuriesClosedStinson 108-3 · Winnemucca, NVNTSB OAK76DX012Accident · No injuriesClosedBriegleb BG-12 · Reno, NVNTSB OAK75FVW03Accident · No injuriesClosedCessna 150F · Jean, NVNTSB OAK76FXQ08Accident · 1 fatalClosedPiper PA-28 · Carson City, NVNTSB OAK76FXQ04Accident · No injuriesClosedBeech 95-B55 · Reno, NVNTSB OAK76FVW01Accident · No injuriesClosedBellanca 7ECA · Henderson, NVNTSB OAK76FXQ07Accident · No injuriesClosedPiper PA-25 · Orovada, NVNTSB OAK76AP002Accident · Serious injuriesClosedBoeing 707 · Boulder, NVNTSB OAK76DXQ02Accident · Minor injuriesClosedGlasflugel H301B · Washoe City, NVNTSB OAK75DXQ50Accident · No injuriesClosedCessna 150 · Yerington, NVNTSB OAK75FVW23Accident · No injuriesClosedPiper PA-28 · Pahrump, NVNTSB OAK75DXQ51Accident · Serious injuriesClosedPiccard AX-6 · Incline Vlg, NVNTSB OAK75FXQ47Accident · Serious injuriesClosedPiper PA-18 · Sparks, NVNTSB OAK75DXQ46Accident · Minor injuriesClosedBeech 35 · Elko, NVNTSB OAK75FVW22Accident · No injuriesClosedCessna 320F · Las Vegas, NVNTSB OAK75FVW21Accident · No injuriesClosedBellanca 7KCAB · Las Vegas, NVNTSB OAK75DXQ43Accident · Minor injuriesClosedPilatus B-4 · Schurz, NVNTSB OAK75DVW20Accident · Minor injuriesClosedLaister LP-15 · Hidden Hills, NVNTSB OAK75FVW19Accident · Minor injuriesClosedCessna 182A · Las Vegas, NVNTSB OAK75DXQ45Accident · No injuriesClosedMaule M4220C · Reno, NVNTSB OAK75FXQ44Accident · Minor injuriesClosedCessna 150 · Carson City, NVNTSB OAK75AP051Accident · No injuriesClosedCessna T210K · Battle Mt, NVNTSB OAK75FVW18Accident · No injuriesClosedGlobe GC-1B · Boulder City, NVNTSB OAK75AP048Accident · 3 fatalClosedCessna 182A · Incline Vlg, NVNTSB OAK75FVW17Accident · No injuriesClosedBell 47G-5 · Las Vegas, NVNTSB OAK75FVW16Accident · No injuriesClosedPitts S-1S · Henderson, NVNTSB OAK75AP045Accident · Serious injuriesClosedDouglas DC-8 · Las Vegas, NVNTSB OAK75FVW15Accident · Minor injuriesClosedMaule M-4 · Mesquite, NVNTSB OAK75DVW14Accident · No injuriesClosedCessna 175 · Goldfield, NV