NTSB investigations, 1981, VA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1981
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") = 1981 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 ATL82FIA04Accident · Minor injuriesClosedBellanca 7ECA · Warrenton, VANTSB MIA82FA015Accident · 2 fatalClosedMooney M20F · Richmond, VANTSB ATL82FID04Accident · 1 fatalClosedCessna 150 · Chesapeake, VANTSB ATL82FA026Accident · 2 fatalClosedBeech A24R · The Plains, VANTSB ATL82FIA03Accident · Serious injuriesClosedPiper PA-28 · Pender, VANTSB ATL82FA021Accident · 2 fatalClosedBell 206B · Honaker, VANTSB ATL82DID03Accident · No injuriesClosedChampion 7ECA · Virginia Beach, VANTSB ATL82AA019Accident · 3 fatalClosedPiper Advcd PAT-1 · Mathews, VANTSB ATL82FID02Accident · No injuriesClosedPiper PA600A · Oak Grove, VANTSB ATL81FIA02Accident · No injuriesClosedPiper J-3 · Leesburg, VANTSB ATL82DID01Accident · No injuriesClosedBeech 77 · Boones Mill, VANTSB ATL82FA004Accident · 2 fatalClosedPiper PA-32 · Winchester, VANTSB ATL81FIA11Accident · Serious injuriesClosedBede BD-5B · Brandy Station, VANTSB ATL81FIA10Accident · Minor injuriesClosedCessna 150 · Luray, VANTSB ATL81FID21Accident · No injuriesClosedBell 47G-2A · Charles City, VANTSB ATL81DID18Accident · No injuriesClosedPiper PA-25 · Carrolton, VANTSB ATL81FID20Accident · 1 fatalClosedPiper PA-25 · Sandston, VANTSB ATL81FID17Accident · No injuriesClosedBeech B60 · Danville, VANTSB ATL81FID16Accident · Serious injuriesClosedCessna 188B · Pungo, VANTSB ATL81FIA09Accident · No injuriesClosedPiper PA-28R · Woodbridge, VANTSB ATL82FA107Accident · 2 fatalClosedCessna 182 · Berryville, VANTSB ATL81FIA08Accident · Minor injuriesClosedAeronca 7AC · Woodbridge, VANTSB ATL81FA103Accident · 3 fatalClosedPiper PA-31T · Richlands, VANTSB ATL81FA081Accident · No injuriesClosedPiper PA-23 · Manassas, VANTSB ATL81FID15Accident · No injuriesClosedPiper PA-28 · Lawrenceville, VANTSB ATL81FIA07Accident · No injuriesClosedCessna 320 · Culpeper, VANTSB ATL81IID14Accident · No injuriesClosedPiper PA-28R · Williamsburg, VANTSB ATL81FIA05Accident · Minor injuriesClosedBellanca 7GCBC · Hartwood, VANTSB ATL81DID13Accident · No injuriesClosedCessna 305E · Forest, VANTSB ATL81DIA04Accident · No injuriesClosedGrum Amer AA1A · Culpeper, VANTSB ATL81FA063Accident · 1 fatalClosedGrumman AA-5 · No.Sandbridge, VANTSB ATL81FA057Accident · 1 fatalClosedAerostar 601P · Roanoke, VANTSB ATL81DID12Accident · Serious injuriesClosedCessna 172N · Northampton Co, VANTSB ATL81FIA03Accident · No injuriesClosedPiper PA-18 · Warrenton, VANTSB ATL81FID11Accident · Serious injuriesClosedCessna 172 · Chesapeake, VANTSB ATL81FIJ03Accident · Serious injuriesClosedPiper PA-28 · Abingdon, VANTSB ATL81FA046Accident · Serious injuriesClosedBoeing 737 · Newport News, VANTSB DCA81AA008Incident · No injuriesClosedDouglas DC-10 · Leesburg, VANTSB ATL81FA042Accident · No injuriesClosedCessna 182Q · Abbingdon, VANTSB ATL81IA038Incident · No injuriesClosedAvions Mrcl Falcon · Chantilly, VANTSB ATL81FID10Accident · No injuriesClosedBeech E90 · Chesterfield, VANTSB ATL81IA033Incident · No injuriesClosedMitsubishi MU-2B · Norfolk, VA