NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 OAK72AP021Accident · 2 fatalClosedCessna 177A · Las Vegas, NVNTSB OAK72AP018Accident · 1 fatalClosedCessna 182M · Reno, NVNTSB OAK72FVW20Accident · Minor injuriesClosedHughes 269C · Las Vegas, NVNTSB OAK72FVW19Accident · No injuriesClosedAero Comdr 100 · Mercury, NVNTSB OAK72FVW18Accident · Serious injuriesClosedCessna 172B · Las Vegas, NVNTSB OAK72FVW17Accident · Minor injuriesClosedRepublic RC-3 · Las Vegas, NVNTSB OAK72AP014Accident · 2 fatalClosedCessna 150J · Tonopah, NVNTSB OAK72FXQ16Accident · No injuriesClosedMaule M-4 · Lund, NVNTSB LAX72AL028Accident · 1 fatalClosedCessna 150 · Reno, NVNTSB OAK72DVW16Accident · No injuriesClosedCessna 175A · Mercury, NVNTSB OAK72FXQ15Accident · No injuriesClosedLuscombe 8A · Reno, NVNTSB OAK72FVW15Accident · No injuriesClosedMooney M20E · Alamo, NVNTSB OAK72DXQ14Accident · Minor injuriesClosedCessna 206 · Elko, NVNTSB OAK72FVW14Accident · No injuriesClosedPiper PA-28 · Boulder City, NVNTSB OAK72FVW13Accident · No injuriesClosedCessna P206 · Las Vegas, NVNTSB OAK72FXQ13Accident · No injuriesClosedN.American P-51 · Reno, NVNTSB OAK72DVW12Accident · No injuriesClosedCurtis Sull J T · Pioche, NVNTSB OAK72FVW11Accident · No injuriesClosedPiper PA-24 · Las Vegas, NVNTSB OAK72FVW10Accident · No injuriesClosedCessna 206A · Alamo, NVNTSB OAK72AP008Accident · 1 fatalClosedCessna 172K · Sparks, NVNTSB OAK72FVW09Accident · Minor injuriesClosedCessna 206 · Las Vegas, NVNTSB OAK72FXQ12Accident · Serious injuriesClosedCessna 150G · Imlay, NVNTSB OAK72DVW08Accident · Minor injuriesClosedNavion A · Corldale, NVNTSB OAK72FXQ07Accident · No injuriesClosedCessna 182 · Carson City, NVNTSB OAK72FXQ08Accident · Serious injuriesClosedAer-Pegaso M-100S · Minden, NVNTSB OAK72FXQ06Accident · No injuriesClosedCessna 310I · Beowawe, NVNTSB OAK72FVW05Accident · No injuriesClosedPiper PA-28 · Las Vegas, NVNTSB OAK72FVW06Accident · No injuriesClosedCessna 182 · Las Vegas, NVNTSB OAK72AP001Accident · No injuriesClosedPiper PA-24 · Reno, NVNTSB OAK72FVW02Accident · Minor injuriesClosedCessna 140 · Boulder City, NVNTSB OAK72FVW01Accident · No injuriesClosedPiper PA-24 · Beatty, NVNTSB OAK72DXQ02Accident · No injuriesClosedKaman K-600 · Orovada, NVNTSB OAK71FXQ46Accident · Minor injuriesClosedChampion 7ECA · Ely, NVNTSB OAK71DXQ47Accident · No injuriesClosedCessna 182 · Winnemucca, NVNTSB OAK71FVW38Accident · No injuriesClosedCessna 421 · Las Vegas, NVNTSB OAK71FVW37Accident · No injuriesClosedCessna 150J · Las Vegas, NVNTSB OAK71FXQ44Accident · Minor injuriesClosedCessna 177 · Minden, NVNTSB OAK71FXQ45Accident · Minor injuriesClosedCessna 182 · Reno, NVNTSB OAK71DXQ43Accident · No injuriesClosedChampion 7KCAB · West Wendover, NVNTSB OAK71FVW36Accident · Minor injuriesClosedCessna 210H · Laughlin, NVNTSB OAK71FVW35Accident · No injuriesClosedCessna 411 · Las Vegas, NVNTSB OAK71FXQ41Accident · No injuriesClosedBeech E18S · Reno, NVNTSB OAK71DXQ40Accident · No injuriesClosedHiller 12E · Ely, NVNTSB OAK71FVW34Accident · No injuriesClosedPiper PA-28 · Las Vegas, NVNTSB OAK71FVW33Accident · No injuriesClosedCessna 172 · Las Vegas, NVNTSB OAK71AP046Accident · 2 fatalClosedCessna 150 · Minden, NVNTSB OAK71DVW32Accident · No injuriesClosedAeronca 7AC · N.Las Vegas, NVNTSB OAK71FXQ38Accident · No injuriesClosedPiper PA-28 · Gardenville, NVNTSB OAK71FXQ37Accident · No injuriesClosedHughes 269A · Verdi, NVNTSB OAK71FVW31Accident · No injuriesClosedPiper PA-24 · Lathrop Wells, NV