NTSB investigations, 1967, VA
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 | 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\") = 1967
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") = 1967 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 DIA68D0143Accident · No injuriesClosedCessna 150G · Crewe, VANTSB DIA68D0196Accident · No injuriesClosedCessna 310 · Grundy, VANTSB DIA68D0141Accident · No injuriesClosedLuscombe 8A · Melfa, VANTSB DIA68A0027Accident · No injuriesClosedSikorsky H-19G · Lebanon, VANTSB DIA68A0025Accident · 2 fatalClosedCessna 310F · Norfolk, VANTSB DIA68F0122Accident · No injuriesClosedCessna 310 · Sandston, VANTSB DIA68A0023Incident · 1 fatalClosedBensen B8MWBH · Stafford, VANTSB DIA68D0123Accident · No injuriesClosedSierradyne S-1 · Langley Afb, VANTSB DIA68A0022Accident · Serious injuriesClosedPiper PA-23 · Sandston, VANTSB DIA68F0129Accident · Minor injuriesClosedBeech 35 · Ringgold, VANTSB DIA68D0117Accident · Minor injuriesClosedCessna 150 · Basye, VANTSB DIA68A0017Accident · 3 fatalClosedNavion A · Lynchburg, VANTSB DIA68D0115Accident · No injuriesClosedCessna 150G · Basye, VANTSB DIA68D0100Accident · No injuriesClosedBeech 23 · Winchester, VANTSB DIA68F0097Accident · No injuriesClosedLuscombe 8A · Richmond, VANTSB DIA68D0153Accident · No injuriesClosedAeronca 11AC · Marion, VANTSB DIA68D0125Accident · No injuriesClosedPiper PA-22 · Boston, VANTSB DIA68D0086Accident · No injuriesClosedErco 415-C · Cartersville, VANTSB DIA68D0091Accident · No injuriesClosedPiper PA-20 · Oyster, VANTSB DIA68D0080Accident · No injuriesClosedCessna 150 · New Kent, VANTSB DIA68A0014Accident · 2 fatalClosedCessna 150G · Fincastle, VANTSB DIA68F0092Accident · No injuriesClosedBeech 35-B33 · Weyers Cave, VANTSB DIA68D0073Accident · No injuriesClosedCessna 337 · Roanoke, VANTSB DIA68F0081Accident · No injuriesClosedPiper J-3C · Va.Beach, VANTSB DIA68D0114Accident · No injuriesClosedPiper J4A · Jeffersonton, VANTSB DIA68D0065Accident · No injuriesClosedCessna 195 · Richmond, VANTSB DIA68A0010Accident · 2 fatalClosedCessna 182 · Tangier, VANTSB UNK67X0150Accident · No injuriesClosedPiper PA-25 · Cross Junction, VANTSB DIA68D0058Accident · No injuriesClosedPiper PA-28 · Chesapeake, VANTSB DIA68F0049Accident · No injuriesClosedNavion C · Roanoke, VANTSB DIA68A0004Accident · Serious injuriesClosedCessna 140 · Baileys Crsrds, VANTSB DIA68D0043Accident · Minor injuriesClosedGoodyear FG-1D · Norfolk, VANTSB DIA68F0035Accident · Minor injuriesClosedCessna 172G · Virginia Beach, VANTSB DIA68D0031Accident · No injuriesClosedPiper PA-28 · Bowling Green, VANTSB DIA68D0042Accident · No injuriesClosedStits SA-3 · Staunton, VANTSB DIA67A0023Accident · 1 fatalClosedCessna 185 · Etlan, VANTSB DIA68D0025Accident · No injuriesClosedPiper PA-18 · Brookneal, VANTSB DIA68F0005Accident · No injuriesClosedCessna 182 · Quinton, VANTSB DIA68D0014Accident · No injuriesClosedCessna 172 · Breaks, VANTSB DIA67F0112Accident · No injuriesClosedPitcairn PA-5 · Fredericksburg, VANTSB DIA67F0015Accident · No injuriesClosedPiper PA-28 · Sandston, VANTSB DIA67D0113Accident · No injuriesClosedPiper PA-32 · Lynchburg, VANTSB DIA67F0110Accident · No injuriesClosedCessna 150G · Sandston, VANTSB DIA67D0108Accident · No injuriesClosedCessna 172 · Fork Union, VANTSB DIA68F0036Accident · Serious injuriesClosedPiper PA-28 · Haymarket, VANTSB DIA67A0017Accident · 4 fatalClosedCessna 205 · New Castle, VANTSB DIA67F0082Accident · Minor injuriesClosedPiper PA-24 · Alexandria, VANTSB DIA68F0066Accident · No injuriesClosedCessna 150 · Woodbridge, VANTSB DIA67D0087Accident · No injuriesClosedAeronca 7AC · Pennington Gap, VANTSB DIA67F0086Accident · No injuriesClosedBeech 95 · Richmond, VA