NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1031Accident · No injuriesClosedCessna 172 · Middleburg, VANTSB UNK65X0837Incident · No injuriesClosedViscount V745D · Hampton Roads, VANTSB UNK65X0808Accident · 1 fatalClosedPiper PA-18 · Chase City, VANTSB UNK65X0784Accident · No injuriesClosedGlobe GC-1B · White Sulpr Sp, VANTSB UNK65X0756Accident · No injuriesClosedDouglas DC-4 · Norfolk, VANTSB UNK65X0754Accident · No injuriesClosedCessna 172 · Louisa County, VANTSB UNK65X0753Accident · No injuriesClosedPiper PA-22 · Moneta, VANTSB UNK65X0722Accident · Minor injuriesClosedErcoupe 415D · Danville, VANTSB UNK65X0631Accident · No injuriesClosedCessna 150 · Fredericksburg, VANTSB UNK65X0596Accident · No injuriesClosedLuscombe 8E · Bridgewater, VANTSB UNK65X0595Accident · No injuriesClosedLuscombe 8A · Quinton, VANTSB UNK65X0554Accident · No injuriesClosedPiper PA24 · Farmville, VANTSB UNK65X0394Accident · No injuriesClosedPiper PA22 · Roanoke, VANTSB UNK65X0256Accident · No injuriesClosedVolaire 10 · Diggs, VANTSB UNK65X0165Accident · No injuriesClosedBeechcraft F35 · Richmond, VANTSB UNK64X4186Accident · No injuriesClosedCessna 172 · Quinton, VANTSB UNK64X4105Accident · Serious injuriesClosedViscount V-700 · Springfield, VANTSB UNK64X4056Accident · 3 fatalClosedCulver LCA · Northfield, VANTSB UNK64X4048Accident · Minor injuriesClosedMooney M20E · Norfolk, VANTSB UNK64X3985Accident · 3 fatalClosedBeechcraft 35A · Evington, VANTSB UNK64X3946Accident · No injuriesClosedGlobe GC1B · Richmond, VANTSB UNK64X3785Accident · No injuriesClosedPiper PA20 · Harrisonburg, VANTSB UNK64X3537Accident · No injuriesClosedCessna 140 · Bridgewater, VANTSB UNK64X3496Accident · No injuriesClosedCessna 150 · Waynesboro, VANTSB UNK64X3450Accident · 1 fatalClosedPiper PA-28 · Danville, VANTSB UNK64X3378Accident · No injuriesClosedCessna 172C · Williamsburg, VANTSB UNK64X3375Accident · No injuriesClosedPiper PA28 · Fredericksburg, VANTSB UNK64X3339Accident · No injuriesClosedChampion 7GC · Leesburg, VANTSB UNK64X3329Accident · No injuriesClosedPiper PA18 · Glebe Point, VANTSB UNK64X3288Accident · No injuriesClosedBeechcraft 23 · Richmond, VANTSB UNK64X3243Accident · 1 fatalClosedPiper AE-1 · Hurt, VANTSB UNK64X3157Accident · Minor injuriesClosedAeronca L16 · Buffalo, VANTSB UNK64X3128Accident · No injuriesClosedDouglas DC-7 · Chantilly, VANTSB UNK64X3058Accident · 2 fatalClosedForney 415C · Stanardsville, VANTSB UNK64X2979Accident · No injuriesClosedPiper PA28 · Chantilly, VANTSB UNK64X2903Accident · No injuriesClosedLuscombe 8A · Broadway, VANTSB UNK64X2891Accident · Minor injuriesClosedDouglas DC-7 · Richmond, VANTSB UNK64X2880Accident · Minor injuriesClosedGlobe Swift · Shenandoah, VANTSB UNK64X2850Accident · Minor injuriesClosedGyrocopter B8M · Amelia, VANTSB UNK64X2816Accident · No injuriesClosedPiper PA22 · Fredericksburg, VANTSB UNK64X2707Accident · 5 fatalClosedLockheed 12A · Martinsville, VANTSB UNK64X2700Accident · No injuriesClosedMooney MK20 · Newport News, VANTSB UNK64X2683Accident · Minor injuriesClosedPiper PA18 · Fredericksburg, VANTSB UNK64X2656Accident · No injuriesClosedCessna 210 · Richmond, VANTSB UNK64X2544Accident · No injuriesClosedLuscombe 8A · Amelia, VANTSB UNK64X2520Accident · No injuriesClosedStinson V77 · Haymarket, VANTSB UNK64X2499Accident · No injuriesClosedGlobe Swift GC1B · Leesburg, VANTSB UNK64X2429Accident · Serious injuriesClosedStinson L-5 · Newcastle, VANTSB UNK64X2259Accident · No injuriesClosedCmnwealth 185 · Kellam Field, VANTSB UNK64X2254Accident · 1 fatalClosedCessna 180 · Fancy Gap, VA