NTSB investigations, 1974, 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\") = 1974
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") = 1974 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 OAK75FVW11Accident · No injuriesClosedMooney M20C · Las Vegas, NVNTSB OAK75DXQ33Accident · No injuriesClosedCessna 182 · Jackpot, NVNTSB OAK75AP024Accident · Serious injuriesClosedCessna 180C · Lovelock, NVNTSB OAK75AP023Accident · Serious injuriesClosedCessna 210T · Reno, NVNTSB OAK75FVW10Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNTSB OAK75AP033Accident · 1 fatalClosedPiper PA-28R · Las Vegas, NVNTSB OAK75FXQ30Accident · No injuriesClosedPiper PA-28 · Carson City, NVNTSB OAK75FVW08Accident · No injuriesClosedCessna 205 · Sloan, NVNTSB OAK75FVW07Accident · Minor injuriesClosedCessna 150K · Las Vegas, NVNTSB OAK75DXQ28Accident · No injuriesClosedAmer Avco AA1-B · Elko, NVNTSB OAK75FXQ27Accident · No injuriesClosedCessna 206 · Reno, NVNTSB OAK75DXQ25Accident · No injuriesClosedMaule M4220C · Reno, NVNTSB OAK75FVW06Accident · No injuriesClosedCessna 172L · Las Vegas, NVNTSB OAK75FX022Accident · 1 fatalClosedBensen B-8M · Reno, NVNTSB OAK75FVW05Accident · No injuriesClosedBeech F50 · Las Vegas, NVNTSB OAK75FP010Accident · 4 fatalClosedPiper PA-28 · Reno, NVNTSB OAK75DXQ26Accident · No injuriesClosedPiper PA-28 · Oasis, NVNTSB OAK75DXQ20Accident · No injuriesClosedBeech C35 · Elko, NVNTSB OAK75DXQ18Accident · No injuriesClosedAmer Avco AA-5 · Elko, NVNTSB OAK75FXQ15Accident · No injuriesClosedBeech E35 · Reno, NVNTSB OAK75DXQ21Incident · No injuriesClosedPiper PA-28 · Carson City, NVNTSB OAK75FVW02Accident · No injuriesClosedBeech B19 · N.Las Vegas, NVNTSB OAK75FXQ12Accident · No injuriesClosedCessna 185 · Reno, NVNTSB OAK75FXQ09Accident · No injuriesClosedPiper PA-36 · Winnemucca, NVNTSB OAK75DXQ07Accident · No injuriesClosedPiper PA-23 · Pyramid, NVNTSB OAK75DVW01Accident · No injuriesClosedCessna 172 · Round Mt, NVNTSB OAK75FXQ06Accident · No injuriesClosedPiper PA-28 · Carson City, NVNTSB OAK75DXQ11Accident · No injuriesClosedSnow 600S2D · Orovada, NVNTSB OAK75DXQ13Accident · No injuriesClosedCessna 175 · Winnemucca, NVNTSB OAK75AP003Accident · 1 fatalClosedCessna 206 · Lathrop Wells, NVNTSB OAK75FXQ10Accident · Minor injuriesClosedCessna 150 · Empire, NVNTSB OAK75FXQ05Accident · Minor injuriesClosedPiper PA-25 · Wellington, NVNTSB OAK75DXQ02Accident · No injuriesClosedPiper PA-25 · Fallon, NVNTSB OAK75FXQ01Accident · 1 fatalClosedBell 206B · Reno, NVNTSB OAK74FVW24Accident · Minor injuriesClosedCessna 150F · Henderson, NVNTSB OAK74DXQ44Accident · No injuriesClosedAeronca 7AC · Elko, NVNTSB OAK74FVW23Accident · No injuriesClosedCessna 180 · Las Vegas, NVNTSB OAK74DXQ43Accident · No injuriesClosedCessna 172 · Minden, NVNTSB OAK74FVW22Accident · Minor injuriesClosedCessna 175 · Las Vegas, NVNTSB OAK74FXQ42Accident · No injuriesClosedCessna 411 · Reno, NVNTSB OAK74DVW21Accident · No injuriesClosedHughes 269B · Las Vegas, NVNTSB OAK74FXQ38Accident · No injuriesClosedGrumman G-164 · Fallon, NVNTSB OAK74DXQ39Accident · No injuriesClosedCessna 150 · Reno, NVNTSB OAK74FVW20Accident · Minor injuriesClosedHughes 269C · Las Vegas, NVNTSB OAK74DXQ37Accident · No injuriesClosedSchweizer SGS232 · Yerrington, NVNTSB OAK74FXQ34Accident · Minor injuriesClosedAlouette III · East Dayton, NVNTSB OAK74FVW18Accident · No injuriesClosedPiper PA-16 · Sloan, NVNTSB OAK74DXQ32Accident · No injuriesClosedPiper PA-28 · Reno, NVNTSB OAK74FVW19Accident · No injuriesClosedMooney M20E · Las Vegas, NVNTSB OAK74DXQ31Accident · No injuriesClosedPiper PA-23 · Ely, NV