NTSB investigations, 1972, 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\") = 1972
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") = 1972 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 OAK73DVW13Accident · Minor injuriesClosedPiper PA-15 · Henderson, NVNTSB OAK73FXG20Accident · No injuriesClosedPiper PA-28 · Carson City, NVNTSB OAK73FXQ19Accident · No injuriesClosedPiper PA-28 · Carson City, NVNTSB OAK73AP014Accident · 3 fatalClosedBeech C18S · Searchlight, NVNTSB OAK17FVW11Accident · Minor injuriesClosedPiper PA-28 · Glendale, NVNTSB OAK73FVW10Accident · No injuriesClosedPiper PA-28 · Henderson, NVNTSB OAK73FVW08Accident · Serious injuriesClosedCessna 182 · Alamo, NVNTSB OAK73FXQ15Accident · 1 fatalClosedThomas BTS · Reno, NVNTSB OAK73FVW07Accident · No injuriesClosedPiper PA-32 · Las Vegas, NVNTSB OAK73DXQ16Accident · No injuriesClosedStinson 108 · Reno, NVNTSB OAK73FXQ14Accident · No injuriesClosedPiper PA-24 · Battle Mtn, NVNTSB OAK73DXQ12Accident · No injuriesClosedPiper PA-28 · Elko, NVNTSB OAK73FXQ10Accident · Minor injuriesClosedGrumman G-164A · Fallon, NVNTSB OAK73FVW06Accident · No injuriesClosedPiper PA-34 · Boulder City, NVNTSB OAK73FXQ11Accident · Minor injuriesClosedCessna T210 · Reno, NVNTSB OAK73DXQ09Accident · No injuriesClosedChampion 7GCAA · Reno, NVNTSB OAK73DXQ07Accident · No injuriesClosedCessna 182 · Elko, NVNTSB CHI73IC007Incident · Serious injuriesClosedDouglas DC-8 · Las Vegas, NVNTSB OAK73FXQ05Accident · Serious injuriesClosedBoeing B75N1 · Yerington, NVNTSB OAK73FXQ04Accident · Minor injuriesClosedConcept 70 · Minden, NVNTSB OAK73FVW05Accident · Minor injuriesClosedCessna 206 · Las Vegas, NVNTSB OAK73DVW03Accident · No injuriesClosedPiper PA-28 · Lathrop Wells, NVNTSB OAK73FVW01Accident · No injuriesClosedCessna 150F · Las Vegas, NVNTSB OAK72AP045Accident · 2 fatalClosedCessna U206C · Steamboat, NVNTSB OAK72FVW33Accident · No injuriesClosedCessna 150J · Goldfield, NVNTSB OAK72DVW34Accident · No injuriesClosedErco 415-C · Boulder City, NVNTSB OAK72DXQ34Accident · No injuriesClosedKaman K-600 · Orovada, NVNTSB OAK72FVW32Accident · No injuriesClosedCessna T337D · Las Vegas, NVNTSB OAK72FXQ33Accident · No injuriesClosedCessna 310 · Reno, NVNTSB OAK72DVW31Accident · No injuriesClosedPiper J3C-65 · Las Vegas, NVNTSB OAK72FVW30Accident · No injuriesClosedCessna 150H · Tonopah, NVNTSB OAK72FXQ32Accident · No injuriesClosedCessna 210 · Winnemucca, NVNTSB OAK72DXQ31Accident · No injuriesClosedPiper PA-18A · Elko, NVNTSB OAK72DXQ30Accident · No injuriesClosedCessna 150 · Ely, NVNTSB OAK72DXQ28Accident · No injuriesClosedGrumman G-164A · Fallon, NVNTSB OAK72FVW29Accident · No injuriesClosedCessna 172G · Las Vegas, NVNTSB OAK72FVW27Accident · No injuriesClosedCessna 172K · Las Vegas, NVNTSB OAK72DXQ29Incident · No injuriesClosedAeronca 7AC · Carson City, NVNTSB OAK72FXQ27Accident · No injuriesClosedSpartan 7W · Reno, NVNTSB OAK72DXQ26Accident · No injuriesClosedTaylorcraft BC12-D · Reno, NVNTSB OAK72FVW26Accident · Minor injuriesClosedMooney M20F · Boulder City, NVNTSB OAK72DXQ25Accident · Minor injuriesClosedCessna 172 · Wells, NVNTSB OAK72FVW25Accident · No injuriesClosedHughes 269B · Las Vegas, NVNTSB OAK72FXQ24Accident · 1 fatalClosedPitts SC-1 · Carson City, NVNTSB OAK72FVW24Accident · No injuriesClosedCessna 180 · Las Vegas, NVNTSB OAK72FVW23Accident · No injuriesClosedPiper PA-24 · Las Vegas, NVNTSB OAK72FXQ21Accident · Serious injuriesClosedPiper PA-28 · Reno, NVNTSB OAK72DXQ22Accident · No injuriesClosedCessna 180 · Ione, NVNTSB OAK72FXQ23Accident · Serious injuriesClosedBeech K35 · Reno, NVNTSB OAK72AP027Accident · 2 fatalClosedBeech S35 · Battle Mntn, NV