NTSB investigations, 1968, NV
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1968
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") = 1968 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 OAK96A0070Accident · 3 fatalClosedPiper PA-32 · Wellington, NVNTSB OAK69D0206Accident · No injuriesClosedMooney M20E · Reno, NVNTSB OAK70A0036Accident · Minor injuriesClosedLockheed 1649A · Las Vegas, NVNTSB OAK69F0175Accident · Minor injuriesClosedChampion 7GCB · Reno, NVNTSB OAK69A0031Accident · 1 fatalClosedPiper PA-28 · Ruth, NVNTSB OAK69F0174Accident · No injuriesClosedCessna 172 · Reno, NVNTSB OAK69A0027Accident · 3 fatalClosedCessna 210 · Wells, NVNTSB OAK69A0026Accident · 2 fatalClosedCessna 150H · Las Vegas, NVNTSB OAK69D0244Accident · No injuriesClosedTaylorcraft BC12-D · Baker, NVNTSB OAK69F0160Accident · No injuriesClosedCessna 177 · Las Vegas, NVNTSB OAK69A0021Accident · 4 fatalClosedDehavilland DH-104 · Las Vegas, NVNTSB OAK69D0144Accident · No injuriesClosedBeech 35-A33 · Reno, NVNTSB OAK69D0116Accident · No injuriesClosedPiper PA-28 · Battle Mtn., NVNTSB OAK69A0017Accident · 1 fatalClosedCessna 150 · East Ely, NVNTSB OAK69F0102Accident · No injuriesClosedCessna 180 · Reno, NVNTSB OAK69A0013Accident · No injuriesClosedPiper PA-32 · Reno, NVNTSB OAK69D0103Accident · No injuriesClosedCessna 210 · Fallon, NVNTSB OAK69F0083Accident · No injuriesClosedKaman K-600 · Orovada, NVNTSB OAK69A0008Accident · 1 fatalClosedCessna 180 · Las Vegas, NVNTSB OAK69F0134Accident · Minor injuriesClosedCessna 170A · Las Vegas, NVNTSB OAK69F0049Accident · Serious injuriesClosedBriegleb BG-12B · Reno, NVNTSB OAK69A0005Accident · 2 fatalClosedCessna 182H · Lathrop Wells, NVNTSB OAK69A0004Accident · 1 fatalClosedCessna 150H · N Las Vegas, NVNTSB OAK69D0048Accident · No injuriesClosedCessna 172 · Reno, NVNTSB OAK69F0109Accident · Minor injuriesClosedCessna 150 · Reno, NVNTSB OAK69A0002Accident · 1 fatalClosedChampion 7GCAA · Orovada, NVNTSB OAK69D0042Accident · No injuriesClosedPiper PA-24 · Reno, NVNTSB OAK69F0034Accident · Minor injuriesClosedCessna 206 · Steamboat, NVNTSB OAK69A0001Accident · 2 fatalClosedCessna 182 · Jarbidge, NVNTSB OAK68A0076Accident · 4 fatalClosedBeech H35 · Nellis Afb, NVNTSB OAK68A0075Accident · Minor injuriesClosedBell 47G-5 · Reno, NVNTSB OAK68A0074Accident · 5 fatalClosedMdoney M20A · Indian Sprngs, NVNTSB OAK68A0073Accident · 2 fatalClosedCessna 182D · Wells, NVNTSB OAK69F0036Accident · No injuriesClosedPiper PA-28 · Las Vegas, NVNTSB OAK69F0121Accident · No injuriesClosedCessna 182A · Las Vegas, NVNTSB OAK68A0071Accident · 3 fatalClosedCessna 320D · Carlin, NVNTSB OAK69F0031Accident · No injuriesClosedBeech A23-19 · Sparks, NVNTSB UNK68X0145Accident · No injuriesClosedAeronca 7AC · Sutcliffe, NVNTSB UNK68X0143Accident · Minor injuriesClosedPiper PA-25 · Topaz Lake, NVNTSB OAK68D0384Accident · No injuriesClosedBeech K35 · Fallon, NVNTSB OAK68D0374Accident · No injuriesClosedGrumman G-164 · Eureka, NVNTSB OAK68D0358Accident · No injuriesClosedCessna 150D · Las Vegas, NVNTSB OAK68D0284Accident · Minor injuriesClosedPiper J3C-65 · Boulder City, NVNTSB OAK68A0053Accident · Serious injuriesClosedBell 47G-5 · Minden, NVNTSB OAK68D0356Accident · No injuriesClosedCessna 310C · Reno, NV