NTSB investigations, 1981, NV
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1981
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") = 1981 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 LAX82FA032Accident · 3 fatalClosedBeech 58 · Elko, NVNTSB LAX82FA028Accident · 2 fatalClosedLing-T-Vogt A7E · Fallon, NVNTSB LAX82FA016Accident · 2 fatalClosedPiper PA-28 · Laughlin, NVNTSB LAX82FVW02Accident · No injuriesClosedPiper PA-28 · Las Vegas, NVNTSB LAX82DXQ02Accident · No injuriesClosedBell 206B · Ely, NVNTSB LAX82DXQ01Accident · No injuriesClosedCessna 150 · Minden, NVNTSB LAX82FVW01Accident · No injuriesClosedPiper PA-28 · Boulder City, NVNTSB LAX81FA134Accident · 2 fatalClosedCessna 414 · Tonopah, NVNTSB LAX81DXQ37Accident · No injuriesClosedCessna 180 · Reno, NVNTSB LAX81FXQ36Accident · 1 fatalClosedLa Lee W-18 · Reno, NVNTSB LAX81FVW19Accident · No injuriesClosedCessna 411 · Henderson, NVNTSB LAX81DXQ35Accident · Serious injuriesClosedPiper PA-22 · Jackpot, NVNTSB LAX81DVW18Accident · No injuriesClosedPiper PA-28 · Duckwater, NVNTSB LAX81FXQ33Accident · No injuriesClosedCessna 172N · Reno, NVNTSB LAX81FVW17Accident · No injuriesClosedHiller Acft UH-12B · Las Vegas, NVNTSB LAX81FVW16Accident · Minor injuriesClosedErco 415-D · Indian Springs, NVNTSB LAX81DXQ31Accident · Serious injuriesClosedMooney M20J · Reno, NVNTSB LAX81FVW15Accident · No injuriesClosedPiper PA-32 · Henderson, NVNTSB LAX81FXQ28Accident · Serious injuriesClosedCessna R172K · Sparks, NVNTSB LAX81DXQ21Accident · No injuriesClosedBeech 65-80 · Gerlach, NVNTSB LAX81DXQ24Accident · No injuriesClosedLemke-Schdr LS-3 · Reno, NVNTSB LAX81FA103Accident · 1 fatalClosedBeech F35 · Carson City, NVNTSB LAX81FVW14Accident · Minor injuriesClosedCessna P210N · Tonopah, NVNTSB LAX81FA101Accident · 3 fatalClosedCessna T210 · Elko, NVNTSB LAX81DXQ23Accident · No injuriesClosedCessna 152 · Carson City, NVNTSB LAX81DXQ22Accident · No injuriesClosedCessna T210 · Ely, NVNTSB LAX81DXQ18Accident · No injuriesClosedEiriavion PIK-20 · Minden, NVNTSB LAX81FA082Accident · 2 fatalClosedCessna 172A · Silver Peak, NVNTSB LAX81FA080Accident · 1 fatalClosedCessna 170B · Steamboat, NVNTSB LAX81FA076Accident · No injuriesClosedHughes 369D · Las Vegas, NVNTSB LAX81DA074Accident · Serious injuriesClosedPiper PA-18 · Quinn River, NVNTSB LAX81DXQ15Accident · No injuriesClosedBoeing E75 · Silver Springs, NVNTSB LAX81DVW10Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNTSB LAX81FVW09Accident · Minor injuriesClosedCessna 172N · Boulder City, NVNTSB LAX81FA066Accident · 1 fatalClosedCessna 150L · Reno, NVNTSB LAX81FA062Accident · 2 fatalClosedBeech TC-45J · Beatty, NVNTSB LAX81FA060Accident · 2 fatalClosedCessna 150 · Reno, NVNTSB LAX81DXQ14Accident · No injuriesClosedCessna 180J · Elko, NVNTSB LAX81FA051Accident · 2 fatalClosedCessna T210N · Fallon, NVNTSB LAX81DVW08Accident · No injuriesClosedCessna 150B · Overton, NVNTSB LAX81DXQ11Accident · No injuriesClosedCessna 182 · Reno, NVNTSB LAX81DXQ09Accident · Minor injuriesClosedPiper PA-28 · Yerington, NVNTSB LAX81FA041Accident · 2 fatalClosedAero Comdr 681 · Winnemucca, NVNTSB LAX81FVW07Accident · Serious injuriesClosedCessna 152 · Las Vegas, NVNTSB LAX81FA032Accident · Minor injuriesClosedHughes 369HS · Henderson, NVNTSB LAX81FA030Accident · 5 fatalClosedPiper PA-32R · Las Vegas, NV