NTSB investigations, 1968, VA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 | 75 |
| 1965 | 76 |
| 1966 | 91 |
| 1967 | 75 |
| 1968 | 90 |
| 1969 | 87 |
| 1970 | 74 |
| 1971 | 53 |
| 1972 | 60 |
| 1973 | 56 |
| 1974 | 61 |
| 1975 | 53 |
| 1976 | 59 |
| 1977 | 60 |
| 1978 | 64 |
| 1979 | 65 |
| 1980 | 63 |
| 1981 | 42 |
| 1982 | 38 |
| 1983 | 52 |
| 1984 | 53 |
| 1985 | 44 |
| 1986 | 42 |
| 1987 | 35 |
| 1988 | 43 |
| 1989 | 36 |
| 1990 | 34 |
| 1991 | 33 |
| 1992 | 31 |
| 1993 | 32 |
| 1994 | 27 |
| 1995 | 30 |
| 1996 | 26 |
| 1997 | 26 |
| 1998 | 30 |
| 1999 | 31 |
| 2000 | 39 |
| 2001 | 42 |
| 2002 | 38 |
| 2003 | 31 |
| 2004 | 22 |
| 2005 | 15 |
| 2006 | 32 |
| 2007 | 36 |
| 2008 | 30 |
| 2009 | 34 |
| 2010 | 27 |
| 2011 | 30 |
| 2012 | 24 |
| 2013 | 17 |
| 2014 | 25 |
| 2015 | 21 |
| 2016 | 30 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 24 |
| 2020 | 15 |
| 2021 | 18 |
| 2022 | 21 |
| 2023 | 25 |
| 2024 | 27 |
| 2025 | 24 |
| 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\" = 'VA' 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" = 'VA' 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 DIA69D0124Accident · No injuriesClosedPiper PA-28 · Lexington, VANTSB DIA69F0132Accident · Serious injuriesClosedCessna 177 · Waynesboro, VANTSB DIA69F0129Accident · No injuriesClosedPiper PA-24 · Sandston, VANTSB DIA69F0122Accident · No injuriesClosedCessna T337B · Sandston, VANTSB DIA69F0110Accident · Minor injuriesClosedBell 47G-5 · Roanoke, VANTSB DIA69A0027Accident · 2 fatalClosedPiper PA-30 · Damascus, VANTSB DIA69A0025Accident · 1 fatalClosedPiper PA-23 · Charlottesvlle, VANTSB DIA69F0097Accident · No injuriesClosedN American SNJ-5 · Bailey Crosrds, VANTSB DIA69F0105Accident · No injuriesClosedBellanca 17-30 · Mine Run, VANTSB DIA69F0109Accident · No injuriesClosedPiper PA-28 · Fredericksburg, VANTSB DIA69D0101Accident · No injuriesClosedCessna 172 · Chantilly, VANTSB DIA69F0096Accident · No injuriesClosedBoeing A75N1 · Chesapeake, VANTSB DIA69F0094Accident · Serious injuriesClosedCessna 401 · Hopewell, VANTSB DIA69F0098Accident · No injuriesClosedCessna 150 · Topping, VANTSB DIA69A0022Accident · 4 fatalClosedCessna 182J · Front Royal, VANTSB DIA69F0088Accident · No injuriesClosedNavion A · Culpeper, VANTSB DIA69F0082Accident · No injuriesClosedCarson-Bell 47-G · Sandston, VANTSB DIA69A0017Accident · No injuriesClosedLear Jet 23 · Dulles Itl Apt, VANTSB DIA69F0080Accident · No injuriesClosedPiper PA-31 · Fredericksburg, VANTSB DIA69D0079Accident · No injuriesClosedBeech S35 · Hot Springs, VANTSB DIA69D0072Accident · No injuriesClosedMooney M20C · Baileys Xroads, VANTSB DIA69F0076Accident · No injuriesClosedHughes 269B · Alexandria, VANTSB DIA69I0015Incident · Minor injuriesClosedDouglas DC-6B · Norfolk, VANTSB DIA69F0084Accident · No injuriesClosedPiper PA-28 · Chatham, VANTSB DIA69F0069Accident · No injuriesClosedPiper PA-24 · Richmond, VANTSB DIA69A0012Accident · 2 fatalClosedPiper PA-24 · Rocky Gap, VANTSB DIA69D0083Accident · Minor injuriesClosedPiper PA-15 · Grayson County, VANTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VANTSB DIA69D0060Accident · No injuriesClosedSchweizer SGS126 · Leesburg, VANTSB DIA69D0058Accident · No injuriesClosedPiper PA-28 · Weirwood, VANTSB DIA69D0064Accident · No injuriesClosedSchwiezer SGS233 · Leesburg, VANTSB DIA69F0048Accident · No injuriesClosedCessna 195B · Fredericksburg, VANTSB DIA69F0055Accident · No injuriesClosedPiper PA-24 · Alexandria, VANTSB DIA69D0047Accident · No injuriesClosedPiper PA-25 · Surry, VANTSB DIA69F0044Accident · Minor injuriesClosedPiper PA-28 · Fredericksburg, VANTSB DIA69D0043Accident · No injuriesClosedAeronca 7AC · Leesburg, VANTSB DIA69A0008Accident · Serious injuriesClosedBoeing 737 · Herndon, VANTSB DIA69D0041Accident · No injuriesClosedMooney M20C · Culpeper, VANTSB DIA69A0006Accident · 2 fatalClosedPiper PA-22 · Chesapeake, VANTSB DIA69F0037Accident · No injuriesClosedPiper PA-22 · Earlysville, VANTSB DIA69A0007Accident · 5 fatalClosedBeech A23-24 · Cana, VANTSB DIA69F0036Accident · No injuriesClosedCessna 172 · Richmond, VANTSB DIA69F0035Accident · 1 fatalClosedBensen Bowles · Leesburg, VANTSB DIA69A0003Accident · 3 fatalClosedCessna 195 · Stuart, VANTSB DIA69F0034Accident · No injuriesClosedAeronca 7AC · South Hill, VANTSB DIA69D0033Accident · No injuriesClosedCessna 172 · Warsaw, VANTSB DIA69A0002Accident · 2 fatalClosedPiper PA-18S · Swords Creek, VANTSB DIA69F0014Accident · No injuriesClosedErcoupe 415-C · B.Crossroads, VANTSB DIA69F0046Accident · No injuriesClosedAeronca 7CCM · Abingdon, VANTSB DIA69F0019Accident · No injuriesClosedCessna 170 · Richmond, VA