NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 NYC66D0448Accident · No injuriesClosedChampion 7GC · Leesburg, VANTSB NYC66F0395Accident · No injuriesClosedPiper PA-24 · Lunenburg, VANTSB NYC66F0394Accident · No injuriesClosedPiper PA-24 · Richmond, VANTSB NYC66F0458Accident · No injuriesClosedCessna 210 · Chantilly, VANTSB NYC66A0069Accident · 2 fatalClosedBeech D35 · Louisa, VANTSB NYC66D0373Accident · No injuriesClosedStinson L-5E · Mechanicsville, VANTSB NYC66F0387Accident · No injuriesClosedCessna 182 · Fork Union, VANTSB NYC66F0536Accident · No injuriesClosedBeechcraft G35 · Roanoke, VANTSB NYC66F0402Accident · No injuriesClosedPiper PA-23 · Leesburg, VANTSB NYC66F0386Accident · Minor injuriesClosedErcoupe 415C · Rustburg, VANTSB NYC66F0378Accident · No injuriesClosedCessna 182 · Portsmouth, VANTSB NYC66A0056Accident · 1 fatalClosedPiper PA-23 · Covington, VANTSB NYC66F0356Accident · No injuriesClosedCessna 182E · Petersburg, VANTSB NYC66F0308Accident · No injuriesClosedErcoupe 415C · South Boston, VANTSB NYC66F0320Accident · No injuriesClosedPiper PA-18 · Brookneal, VANTSB NYC66D0321Accident · No injuriesClosedCessna 172 · Pennington Gap, VANTSB NYC66A0043Accident · 4 fatalClosedCessna 182 · Chantilly, VANTSB NYC66F0276Accident · No injuriesClosedPiper PA-24 · Martinsville, VANTSB NYC66A0039Accident · Minor injuriesClosedAir & Space 18A · Rocky Mt., VANTSB NYC66F0272Accident · No injuriesClosedPiper PA-28 · Farmville, VANTSB NYC66F0333Accident · No injuriesClosedCessna 150B · Chesapeake, VANTSB NYC66F0271Accident · No injuriesClosedPiper PA-28 · Gloucester, VANTSB NYC66F0268Accident · Minor injuriesClosedBeech 35 · Union Hall, VANTSB NYC66F0263Accident · No injuriesClosedStinson 108-2 · Alexandria, VANTSB NYC66A0033Accident · 2 fatalClosedPiper PA-28 · Elkwood, VANTSB UNK65X1532Accident · No injuriesClosedPiper PA-22 · Clarksville, VANTSB NYC66F0216Accident · No injuriesClosedPiper PA-22 · West Point, VANTSB NYC66D0179Accident · No injuriesClosedPiper PA-28 · Midlothian, VANTSB NYC66F0224Accident · No injuriesClosedChampion 7ECA · Foxwells, VANTSB NYC66F0242Accident · No injuriesClosedBeechcraft F-35 · Richmond, VANTSB NYC66F0249Accident · Minor injuriesClosedCessna 140 · Victoria, VANTSB NYC66A0031Accident · 3 fatalClosedPiper PA-24 · Clintwood, VANTSB NYC66F0162Accident · No injuriesClosedPiper PA-28 · Richmond, VANTSB NYC66D0121Accident · Minor injuriesClosedWren 460 · Pound, VANTSB NYC66F0085Accident · No injuriesClosedErcoupe 415C · Blacksburg, VANTSB NYC66D0090Accident · Serious injuriesClosedSchweizer SGU222 · Newcastle, VANTSB UNK65X1510Accident · No injuriesClosedPiper PA-18 · Martinsville, VANTSB NYC65A0154Accident · 1 fatalClosedPiper PA-24 · Winchester, VANTSB NYC66F0126Accident · Serious injuriesClosedBeechcraft C45H · E.Bigstone Gap, VANTSB NYC66F0043Accident · No injuriesClosedCessna 310B · Leesburg, VANTSB NYC65A0151Accident · No injuriesClosedBell 47G-2A · Denbigh, VANTSB NYC66F0079Accident · No injuriesClosedCessna 182 · Woodbridge, VANTSB NYC65A0148Accident · 1 fatalClosedPiper PA12 · Cape Charles, VANTSB NYC66D0248Accident · No injuriesClosedCessna 182E · Sandston, VANTSB NYC66F0009Accident · No injuriesClosedPiper PA-23 · Manassas, VANTSB NYC65D0242Accident · Minor injuriesClosedSchemp SH1 · Strasburg, VANTSB NYC65F0211Accident · No injuriesClosedCessna 182 · Dulles Arpt, VANTSB NYC66D0039Accident · No injuriesClosedErcoupe 415C · Castlewood, VANTSB NYC66F0006Accident · Minor injuriesClosedCurtiss J1D · Fredericksburg, VANTSB NYC65F0215Accident · No injuriesClosedPiper PA-24 · Leesburg, VA