NTSB investigations, 1978, NV
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1978
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") = 1978 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 OAK79FVW06Accident · No injuriesClosedBell 47J2A · Boulder City, NVNTSB OAK79FVW04Accident · No injuriesClosedCessna 320B · Las Vegas, NVNTSB OAK79FVW02Accident · No injuriesClosedHiller Acft FH1100 · Boulder City, NVNTSB OAK79FVW03Accident · No injuriesClosedCessna 305A · Overton, NVNTSB OAK79FXQ03Accident · No injuriesClosedPiper PA-31 · Reno, NVNTSB OAK79FA010Accident · 1 fatalClosedCessna 182A · Reno, NVNTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNTSB OAK79FVW01Accident · No injuriesClosedCessna 152 · Henderson, NVNTSB OAK79FA005Accident · Minor injuriesClosedLear Jet 24D · Las Vegas, NVNTSB OAK79FXQ02Accident · No injuriesClosedCessna 177B · Reno, NVNTSB OAK78FVW21Accident · Minor injuriesClosedVarga 2150A · Las Vegas, NVNTSB OAK78DXQ50Accident · Minor injuriesClosedCessna 206 · Mina, NVNTSB OAK78FXQ48Accident · No injuriesClosedN American P-51H · Reno, NVNTSB OAK78FXQ46Accident · No injuriesClosedBoeing E75N1 · Reno, NVNTSB OAK78DXQ49Accident · No injuriesClosedCessna 172 · Hawthorne, NVNTSB OAK78DA055Accident · 2 fatalClosedN.American SNJ-4 · Reno, NVNTSB OAK78DXQ51Accident · No injuriesClosedSteen Sybt · Carson City, NVNTSB OAK78DXQ47Accident · No injuriesClosedPiper PA-22 · Elko, NVNTSB OAK78FVW20Accident · Minor injuriesClosedHughes 269B · Las Vegas, NVNTSB UNK78X0134Accident · 10 fatalClosedPiper PA-31 · Las Vegas, NVNTSB OAK78DXQ42Accident · Serious injuriesClosedLuscombe 8E · Jackpot, NVNTSB OAK78FVW19Accident · No injuriesClosedCessna TU206 · Las Vegas, NVNTSB OAK78FXQ31Accident · No injuriesClosedCessna 172 · Reno, NVNTSB OAK78FVW18Accident · No injuriesClosedBeech C45H · Las Vegas, NVNTSB OAK78DA041Incident · No injuriesClosedDouglas DC-8 · Las Vegas, NVNTSB OAK78FXQ39Accident · Minor injuriesClosedCessna 182 · Middlegate, NVNTSB OAK78FA040Accident · 1 fatalClosedScheitzer 2-33A · Boulder City, NVNTSB OAK78FXQ37Accident · No injuriesClosedCessna 175 · Winnemucca, NVNTSB OAK78FVW17Accident · No injuriesClosedCessna 152 · Las Vegas, NVNTSB OAK78DXQ33Accident · No injuriesClosedCessna 180 · Yerington, NVNTSB OAK78DXQ32Accident · Minor injuriesClosedCessna 182 · Minden, NVNTSB OAK78DXQ30Accident · Minor injuriesClosedErco 415-D · Rawhide, NVNTSB OAK78DXQ36Accident · No injuriesClosedBeech B-23 · Ft.Ruby, NVNTSB OAK78DXQ29Accident · No injuriesClosedPiper PA-28 · Austin, NVNTSB OAK78FVW16Accident · No injuriesClosedPiper PA-31 · Las Vegas, NVNTSB OAK78DXQ28Accident · Minor injuriesClosedPiper PA-28 · Carson City, NVNTSB OAK78FXQ27Accident · Serious injuriesClosedBeech 35 · Reno, NVNTSB OAK78FA033Accident · 1 fatalClosedPiper PA-24 · Dayton, NVNTSB OAK78DXQ25Accident · No injuriesClosedPiper PA-25 · Lovelock, NVNTSB OAK78DXQ24Accident · Minor injuriesClosedCherokee II · Minden, NVNTSB OAK78FVW15Accident · No injuriesClosedHiller Acft FH1100 · Boulder City, NVNTSB OAK78DXQ23Accident · No injuriesClosedGlasflugel 201B · Dayton, NVNTSB OAK78DXQ20Accident · No injuriesClosedCessna 180 · Owhyee, NVNTSB OAK78FVW14Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNTSB OAK78FA038Accident · 6 fatalClosedCessna T210H · Reno, NVNTSB OAK78DXQ19Accident · No injuriesClosedCessna 172 · Elko, NVNTSB OAK78DXQ18Accident · No injuriesClosedCessna 180 · Ely, NVNTSB OAK78FVW13Incident · No injuriesClosedCessna 402 · Las Vegas, NVNTSB OAK78DXQ14Accident · No injuriesClosedBellanca 14-19 · Carson City, NVNTSB OAK78FA024Accident · 2 fatalClosedCessna 150M · Carson City, NV