NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 DIA67D0006Accident · No injuriesClosedBeech D35 · Waynesboro, VANTSB DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VANTSB NYC67A0095Accident · No injuriesClosedGrumman G-159 · Richmond, VANTSB NYC67D0470Accident · No injuriesClosedCessna 182A · Turbeville, VANTSB DIA67F0011Accident · No injuriesClosedBeech D18S · Ampthill, VANTSB DIA67D0013Accident · No injuriesClosedPiper PA-12 · Lynchburg, VANTSB DIA67D0005Accident · No injuriesClosedPiper PA-28 · Newport News, VANTSB DIA67F0018Accident · Minor injuriesClosedCessna 182E · Stony Point, VANTSB NYC67F0413Accident · No injuriesClosedBeech A23 · Woodbridge, VANTSB DIA67F0001Accident · No injuriesClosedPiper PA-15 · Wakefield, VANTSB NYC67D0412Accident · No injuriesClosedCessna 182J · Warrenton, VANTSB NYC67F0380Accident · No injuriesClosedAeronca 7DC · Williamsburg, VANTSB DIA67A0002Accident · No injuriesClosedCessna 310F · Chantilly, VANTSB DIA67A0001Accident · Minor injuriesClosedBrantly 305 · Manassas, VANTSB DIA67F0072Accident · No injuriesClosedCessna 185 · Baileys Xroad, VANTSB NYC67A0081Accident · 3 fatalClosedPiper PA-28 · Crewe, VANTSB NYC67D0363Accident · No injuriesClosedAlon A2 · Elk Creek, VANTSB NYC67D0346Accident · No injuriesClosedCessna 120 · Waynesboro, VANTSB DIA67D0008Accident · No injuriesClosedMorrisey 2150A · New Castle, VANTSB NYC67F0357Accident · Minor injuriesClosedCessna 150E · Leesburg, VANTSB NYC67F0344Accident · Serious injuriesClosedPiper PA-12 · Waynesboro, VANTSB NYC67D0345Accident · No injuriesClosedCessna 150 · South Norfolk, VANTSB NYC67F0414Accident · No injuriesClosedPiper PA-24 · Baileys Xroads, VANTSB NYC67F0306Accident · Minor injuriesClosedChampion 7ECA · Quinton, VANTSB NYC67F0398Incident · 1 fatalClosedPiaggio P136L1 · Sandston, VANTSB NYC67F0348Accident · Serious injuriesClosedLuscombe 8A · Richmond, VANTSB NYC67A0058Accident · Minor injuriesClosedBensen B8M · Suffolk, VANTSB NYC67F0332Accident · No injuriesClosedPiper PA-23 · Hot Springs, VANTSB NYC67D0294Accident · Minor injuriesClosedPiper J3L-65 · Grottoes, VANTSB MIA67A0042Accident · No injuriesClosedConvair 440 · Richmond, VANTSB NYC67A0053Accident · Minor injuriesClosedBell Carson · Richmond, VANTSB NYC67F0303Accident · Minor injuriesClosedCessna 175C · Alton, VANTSB NYC67F0262Accident · No injuriesClosedCessna 172D · Leesburg, VANTSB NYC67F0240Accident · No injuriesClosedPiper PA-28 · Langley Afb, VANTSB NYC67F0187Accident · No injuriesClosedPiper PA-28 · Sandston, VANTSB NYC67F0203Accident · No injuriesClosedCessna 310C · Alexandria, VANTSB NYC67D0226Accident · No injuriesClosedAeronca 11AC · Marion, VANTSB NYC67F0340Accident · No injuriesClosedPiper PA-30 · Franklin, VANTSB NYC67D0235Accident · Minor injuriesClosedMooney M21 · Monterey, VANTSB NYC67F0227Accident · No injuriesClosedBeech 23 · Newport News, VANTSB NYC67F0342Accident · No injuriesClosedFairchild M-62 · Gum Spring, VANTSB NYC67A0031Accident · 2 fatalClosedPiper PA-24 · Buena Vista, VANTSB NYC67F0304Accident · Minor injuriesClosedPiper PA-30 · Chesapeake, VANTSB NYC67F0178Accident · Minor injuriesClosedCessna 150F · Dillwyn, VANTSB NYC67F0134Accident · No injuriesClosedCessna 310F · Chantilly, VANTSB NYC67F0165Accident · No injuriesClosedBeech S35 · Waynesboro, VANTSB NYC67F0091Accident · No injuriesClosedBeech M23 · Baileys Crosrd, VANTSB NYC67A0014Accident · Serious injuriesClosedBell 47G-2A · Kimballton, VANTSB NYC67D0056Accident · No injuriesClosedAlon A-2 · Hopewell, VANTSB NYC67A0007Accident · Serious injuriesClosedMartin M-404 · Roanoke, VA