NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 LAX70A0034Accident · 1 fatalClosedBeech K35 · Reno, NVNTSB OAK70F0183Accident · No injuriesClosedBeech B95 · Reno, NVNTSB OAK70F0171Accident · Minor injuriesClosedAeronca 15AC · Reno, NVNTSB OAK70D0169Accident · No injuriesClosedCessna 182K · N.Las Vegas, NVNTSB OAK70A0026Accident · 2 fatalClosedBeech E33 · Carson City, NVNTSB OAK70F0126Accident · Minor injuriesClosedCessna 210 · Reno, NVNTSB OAK70F0124Accident · No injuriesClosedPiper PA-25 · Minden, NVNTSB OAK70F0179Accident · No injuriesClosedStarduster SA-300 · Jean, NVNTSB OAK70D0178Accident · No injuriesClosedCessna 140 · Searchlight, NVNTSB OAK70A0020Accident · 4 fatalClosedCessna 172H · Lovelock, NVNTSB OAK70F0132Accident · Minor injuriesClosedCessna 182 · Las Vegas, NVNTSB OAK70F0112Accident · Serious injuriesClosedNavion A · Reno, NVNTSB OAK70A0016Accident · 3 fatalClosedMooney M20C · Las Vegas, NVNTSB OAK70A0013Accident · Minor injuriesClosedCessna 401A · Battle Mntn, NVNTSB OAK70A0012Accident · 2 fatalClosedNavion B · Ash Meadows, NVNTSB OAK70D0110Accident · No injuriesClosedCessna 182 · Reno, NVNTSB OAK70A0006Accident · 4 fatalClosedStinson 108 · Searchlight, NVNTSB OAK70D0109Accident · No injuriesClosedBeech 95-B55 · Hawthorne, NVNTSB OAK70D0091Accident · Minor injuriesClosedCessna 150 · Tonopah, NVNTSB OAK70A0005Accident · 2 fatalClosedCessna 150F · Las Vegas, NVNTSB LAX70D0059Accident · No injuriesClosedSiai-Marche S.205 · Searchlight, NVNTSB OAK70D0077Accident · No injuriesClosedCessna 150 · Gerlach, NVNTSB OAK70F0057Accident · No injuriesClosedGlobe GC-1A · Reno, NVNTSB OAK70D0028Accident · No injuriesClosedCessna 182 · Lovelock, NVNTSB OAK70D0054Accident · No injuriesClosedLuscombe 8A · Boulder City, NVNTSB OAK69A0075Accident · 1 fatalClosedCessna 182A · Mesquite, NVNTSB OAK69A0073Accident · 1 fatalClosedCessna 170B · Lathrop Wells, NVNTSB OAK70F0010Accident · No injuriesClosedCessna 150H · Sparks, NVNTSB OAK70F0015Accident · No injuriesClosedBell 206A · Tonopah, NVNTSB OAK70F0175Accident · No injuriesClosedCessna 182 · N.Las Vegas, NVNTSB OAK70D0009Accident · No injuriesClosedCessna 150 · Winnemucca, NVNTSB OAK70F0014Accident · No injuriesClosedMooney M20F · Tonopah, NVNTSB OAK70F0007Accident · No injuriesClosedCessna 150 · Dyer, NVNTSB LAX69F0355Accident · Serious injuriesClosedCessna 170B · State Line, NVNTSB OAK70F0002Accident · No injuriesClosedBeech A35 · Mina, NVNTSB OAK69F0318Accident · No injuriesClosedBell 47G3B1 · Las Vegas, NVNTSB OAK69F0303Accident · Minor injuriesClosedBeech 35-B33 · Sparks, NVNTSB OAK69A0062Accident · Serious injuriesClosedDouglas DC-9 · Las Vegas, NVNTSB OAK69D0299Accident · Minor injuriesClosedLuscombe 11A · Lathrop Wells, NVNTSB OAK69F0263Accident · No injuriesClosedBoeing A75N1 · Minden, NVNTSB OAK69D0298Accident · No injuriesClosedCessna 172 · Caliente, NVNTSB OAK69F0293Accident · No injuriesClosedCessna 150G · N Las Vegas, NVNTSB OAK69D0269Accident · No injuriesClosedBeech S35 · Austin, NVNTSB OAK69A0054Accident · No injuriesClosedPiper PA-30 · Reno, NVNTSB OAK69A0052Accident · 4 fatalClosedCessna 310F · Reno, NVNTSB OAK69A0055Accident · 1 fatalClosedPiper PA-12 · Goldfield, NVNTSB OAK69F0219Accident · Serious injuriesClosedMooney M20F · Lathrop Wells, NVNTSB OAK69A0049Accident · 4 fatalClosedPiper PA-24 · Searchlight, NVNTSB OAK69D0220Accident · Minor injuriesClosedCessna 175 · Goldfield, NVNTSB OAK69A0045Accident · 1 fatalClosedPiper PA-23 · Sparks, NV