NTSB investigations, 1970, VA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1970
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") = 1970 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 IAD71FIA14Accident · Serious injuriesClosedSud Aviatio SE3130 · Alexandria, VANTSB IAD71FID17Accident · No injuriesClosedCessna 175 · Sandston, VANTSB IAD71II028Incident · No injuriesClosedBoeing 737 · Lynchburg, VANTSB IAD71DID16Accident · Minor injuriesClosedCessna 172K · Waynesboro, VANTSB IAD71DIA13Accident · No injuriesClosedPiper PA-11 · Culpepper, VANTSB IAD71AI026Accident · 1 fatalClosedPiper PA-28 · Missing Aircraft, VANTSB IAD71FIJ11Accident · No injuriesClosedPiper PA-24 · Independence, VANTSB IAD71FID14Accident · 1 fatalClosedCessna 182 · Crewe, VANTSB IAD71AI021Accident · 3 fatalClosedCessna 172G · Providence Frg, VANTSB IAD71II019Incident · No injuriesClosedNihon YS-11A · Hot Springs, VANTSB IAD71AI018Accident · 4 fatalClosedBeech 95-C55 · Boones Mill, VANTSB IAD71AI015Accident · 1 fatalClosedChampion 7ECA · Coles Point, VANTSB IAD71AI027Accident · No injuriesClosedMooney M20C · Lynchburg, VANTSB IAD71FID10Accident · Serious injuriesClosedBeech A23-19 · Norfolk, VANTSB IAD71FIA12Accident · No injuriesClosedCessna 150F · Manassas, VANTSB IAD71DID09Accident · Serious injuriesClosedChampion 7GCBC · Lynchburg, VANTSB IAD71DIA11Accident · Minor injuriesClosedSchweizer SGS233 · Warrenton, VANTSB IAD71FIA10Accident · No injuriesClosedPiper J3P · Woodbridge, VANTSB IAD71FID06Accident · Minor injuriesClosedPiper PA-28 · Cohasset, VANTSB IAD71DID11Accident · No injuriesClosedChampion 7KCAB · Lexington, VANTSB IAD71FID07Accident · 1 fatalClosedPiper PA-18 · Virginia Beach, VANTSB IAD71FIA09Accident · No injuriesClosedCessna 172 · Herndon, VANTSB IAD71DIA07Accident · No injuriesClosedBeech 35-B33 · Warrenton, VANTSB IAD70DIJ05Accident · No injuriesClosedCessna 120 · Dublin, VANTSB IAD71FID05Accident · No injuriesClosedPiper PA-24 · Norfolk, VANTSB IAD71FIA04Accident · No injuriesClosedGlobe GC-1B · Manassas, VANTSB IAD71DIA06Accident · No injuriesClosedPiper PA-22 · Woodbridge, VANTSB IAD71DIJ06Accident · Serious injuriesClosedHughes 269B · Big Rock, VANTSB IAD71FID04Accident · No injuriesClosedPiper PA-25 · Zuni, VANTSB IAD71DID08Accident · No injuriesClosedHiller Acft FH1100 · Bedford, VANTSB IAD71AI008Accident · 5 fatalClosedPiper PA-28 · Hinton, VANTSB IAD71FID03Accident · No injuriesClosedAlon A-2 · Disputanta, VANTSB IAD71FID01Accident · Serious injuriesClosedPiper PA-28 · Boones Mill, VANTSB IAD71AI004Accident · 3 fatalClosedPiper PA-22 · Chesapeake, VANTSB IAD71FIA05Accident · Minor injuriesClosedBensen B-8M · Woodbridge, VANTSB IAD70FIJ08Accident · Serious injuriesClosedBeech 65S · Dublin, VANTSB IAD70DID23Accident · No injuriesClosedLuscombe 8A · Gordonsville, VANTSB IAD70DID22Accident · Minor injuriesClosedAlon A-2 · Hopewell, VANTSB IAD70FID24Accident · No injuriesClosedPiper J-3 · Wallops Island, VANTSB IAD70DID21Accident · No injuriesClosedPiper J3C · Sealston, VANTSB IAD70FI018Accident · Minor injuriesClosedCessna 182K · Richmond, VANTSB IAD70AI060Accident · 1 fatalClosedGlobe GC-1B · Blue Ridge, VANTSB IAD70FIA14Accident · Serious injuriesClosedPiper PA-28 · Baileys X-Road, VANTSB IAD70DID20Accident · No injuriesClosedCessna 150F · Blacksburg, VANTSB IAD70FID17Accident · No injuriesClosedPiper PA-28 · Quinton, VANTSB IAD70DID16Accident · Minor injuriesClosedCessna 172 · Hopewell, VANTSB IAD70DIA11Accident · No injuriesClosedSchweizer 2-33 · Warrenton, VANTSB IAD70FIA08Accident · No injuriesClosedPiper PA-28 · Baileys X Road, VANTSB IAD70II056Incident · No injuriesClosedNihon YS-11A · Roanoke, VANTSB IAD70DIA07Accident · No injuriesClosedCessna 182D · Radiant, VA