NTSB investigations, 1977, 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\") = 1977
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") = 1977 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 OAK78FVW07Accident · Serious injuriesClosedCessna 172 · Boulder City, NVNTSB OAK78FVW05Accident · No injuriesClosedPiper PA32R · Pahrump, NVNTSB OAK78FVW06Accident · Serious injuriesClosedPiper PA-23 · Tonopah, NVNTSB OAK78DXQ04Accident · No injuriesClosedCessna 182 · Winnemucca, NVNTSB OAK78DXQ05Accident · No injuriesClosedPiper PA-28 · Lund, NVNTSB OAK78FVW04Accident · Minor injuriesClosedPiper PA-32 · Currant, NVNTSB OAK78FXQ03Accident · No injuriesClosedCessna 182 · Austin, NVNTSB OAK78FVW03Accident · 1 fatalClosedJeanie Teenie · Boulder City, NVNTSB OAK78FA003Accident · 2 fatalClosedPiper PA-28R · Las Vegas, NVNTSB OAK78FVW01Accident · 2 fatalClosedHoward DGA-6 · Tonopah, NVNTSB OAK78FXQ02Accident · No injuriesClosedPiper PA-24 · Carson City, NVNTSB OAK77FA058Accident · 2 fatalClosedRepublic RC-3 · No.Las Vegas, NVNTSB OAK77DXQ36Accident · Minor injuriesClosedCessna 182 · Basalt, NVNTSB OAK77FVW31Accident · Serious injuriesClosedCessna 210 · Las Vegas, NVNTSB OAK77FXQ34Accident · 1 fatalClosedPiper PA-32 · Carson City, NVNTSB OAK77FXQ32Accident · No injuriesClosedLake LA4 · Lovelock, NVNTSB OAK77DXQ31Accident · Minor injuriesClosedCessna 180 · Reno, NVNTSB OAK77FVW29Accident · No injuriesClosedBeech D18 · Las Vegas, NVNTSB OAK77FA045Accident · 1 fatalClosedCessna 182P · Reno, NVNTSB OAK77DVW28Accident · No injuriesClosedFournier RF4D · Tonopah, NVNTSB OAK77FA043Accident · 4 fatalClosedPiper PA-28 · Jackpot, NVNTSB OAK77FXQ28Accident · Minor injuriesClosedCessna 172 · Reno, NVNTSB OAK77FVW30Accident · No injuriesClosedEnstrom 280C · Las Vegas, NVNTSB OAK77DVW31Accident · No injuriesClosedBell 47SG · Ash Springs, NVNTSB OAK77FVW24Accident · No injuriesClosedBeech G35 · Las Vegas, NVNTSB OAK77FVW23Accident · No injuriesClosedCessna 180H · Las Vegas, NVNTSB OAK77FVW22Accident · No injuriesClosedCessna 150M · Las Vegas, NVNTSB OAK77FVW21Accident · No injuriesClosedHughes 269B · Las Vegas, NVNTSB OAK77FA037Accident · 1 fatalClosedSikorski S58FT · Golconda, NVNTSB OAK77FXQ23Accident · Minor injuriesClosedBellanca 14-13 · Minden, NVNTSB OAK77FXQ22Accident · Minor injuriesClosedBeech V35A · Hawthorne, NVNTSB OAK77DXQ25Accident · Minor injuriesClosedSchweizer 1-35 · Dayton, NVNTSB OAK77FVW17Accident · No injuriesClosedCessna 172 · Las Vegas, NVNTSB OAK77DXQ24Accident · No injuriesClosedGlasflugel 201B · Minden, NVNTSB OAK77FVW16Accident · Minor injuriesClosedBeech C-45G · Beatty, NVNTSB OAK77DVW19Accident · No injuriesClosedSchweizer SGS-1 · Boulder City, NVNTSB OAK77DXQ18Accident · No injuriesClosedCessna 185F · Winnemucca, NVNTSB OAK77FA030Accident · 1 fatalClosedCessna 320C · Wells, NVNTSB OAK77FXQ17Accident · 1 fatalClosedPiper PA-28 · Winnemucca, NVNTSB OAK77FVW15Accident · No injuriesClosedCessna 177RG · Las Vegas, NVNTSB OAK77FVW14Accident · Minor injuriesClosedAero Comdr 112A · Las Vegas, NVNTSB OAK77DXQ16Accident · No injuriesClosedSchneider ES-60 · Fernley, NVNTSB OAK77FVW13Accident · No injuriesClosedBeech B55 · Boulder City, NVNTSB OAK77FVW12Accident · Serious injuriesClosedCessna 150H · Las Vegas, NVNTSB OAK77FVW11Accident · Minor injuriesClosedBeech C35 · Las Vegas, NVNTSB OAK77DXQ10Accident · No injuriesClosedMaule 210C · Kings Riv Vly, NVNTSB OAK77DXQ08Accident · No injuriesClosedPiper PA-24 · Hawthorne, NVNTSB OAK77FA021Accident · 1 fatalClosedPiper PA-24 · Elko, NVNTSB OAK77FA019Accident · 1 fatalClosedBoeing B75N1 · Jean, NVNTSB OAK77FA018Accident · 1 fatalClosedTaylorcraft BC12D1 · Las Vegas, NV