NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 NYC72FIA11Accident · Minor injuriesClosedPiper PA-28 · Front Royal, VANTSB NYC72FID17Accident · Minor injuriesClosedBeech H18 · Charlottsville, VANTSB NYC72DID18Accident · No injuriesClosedCessna 172K · Reedville, VANTSB NYC72AN066Accident · 3 fatalClosedBeech B23 · Chesapeake, VANTSB NYC72FID16Accident · No injuriesClosedPiper PA-32 · Lynchburg, VANTSB NYC72AN060Accident · 3 fatalClosedPiper PA-23 · Berlin, VANTSB NYC72FID15Accident · No injuriesClosedPiper PA-30 · Fredericksburg, VANTSB NYC72AN053Accident · 6 fatalClosedSwearingen SA26AT · Hot Springs, VANTSB NYC72DIA08Accident · No injuriesClosedPiper PA-28 · Culpeper, VANTSB NYC72FIA07Accident · Minor injuriesClosedPiper PA-22 · Elkton, VANTSB NYC72FIA06Accident · No injuriesClosedBeech V35TC · Browntown, VANTSB NYC72FID14Accident · Serious injuriesClosedAero Comdr A-9B · Melfa, VANTSB NYC72FID13Accident · 1 fatalClosedBell 47D-1 · Millers Tavern, VANTSB NYC72DIA05Accident · No injuriesClosedCessna 177 · Manassas, VANTSB NYC72FIJ29Accident · Serious injuriesClosedCessna 150 · Abingdon, VANTSB NYC72FID12Accident · No injuriesClosedN.American SNJ-4 · Fredericksburg, VANTSB NYC72AN033Accident · 1 fatalClosedTaylorcraft BC12-D · Arcola, VANTSB NYC72DID11Accident · No injuriesClosedPiper PA-28R · Wingina, VANTSB NYC72DID09Accident · No injuriesClosedCessna 182J · Ashland, VANTSB NYC72DID08Accident · No injuriesClosedCessna 337 · Lynchburg, VANTSB NYC72FID07Accident · No injuriesClosedCessna 150 · Ft Eustis, VANTSB NYC72FID06Accident · Serious injuriesClosedPiper PA-22 · Montvale, VANTSB NYC72DID04Accident · No injuriesClosedCessna 150 · Portsmouth, VANTSB NYC72FIA03Accident · No injuriesClosedStearman PT-17 · Bealeton, VANTSB NYC72DID03Accident · No injuriesClosedCessna 210H · Bedford, VANTSB NYC72AN020Accident · No injuriesClosedBeech 3TM · Dublin, VANTSB NYC72AN021Accident · 1 fatalClosedBeech V35 · Tazewell, VANTSB NYC72FIA02Accident · No injuriesClosedPiper PA-28 · Winchester, VANTSB NYC72FIA01Accident · No injuriesClosedPiper PA-12 · Arcola, VANTSB IAD72FID02Accident · Minor injuriesClosedCessna 182 · Headwaters, VANTSB IAD72DID01Accident · No injuriesClosedGrumman G-164A · Blacksburg, VANTSB IAD71FIA23Accident · Minor injuriesClosedBeechy Pusher · Bealton, VANTSB IAD71DID27Accident · No injuriesClosedChampion 7ECA · Clarksville, VANTSB IAD71DID26Accident · No injuriesClosedChampion 7KCAB · Virginia Beach, VANTSB IAD71AI055Accident · 6 fatalClosedAero Comdr 680E · Roanoke, VANTSB IAD71AI053Accident · 4 fatalClosedCessna 177 · New Castle, VANTSB IAD71FIA20Accident · Serious injuriesClosedCessna 175 · Hillsboro, VANTSB IAD71FIA19Accident · Minor injuriesClosedDehavilland 60GM · Bealeton, VANTSB IAD71FIJ18Accident · Minor injuriesClosedPiper PA-28 · Glen Lyn, VANTSB IAD71FID22Accident · No injuriesClosedCessna 182 · Lively, VANTSB IAD71FIA17Accident · Minor injuriesClosedLuscombe 8F · Woodbridge, VANTSB IAD71FIJ17Accident · Serious injuriesClosedMooney M20C · Rocky Gap, VANTSB IAD71DID22Accident · No injuriesClosedPiper PA-22 · Monterey, VANTSB IAD71FIJ16Accident · No injuriesClosedCessna 180 · Abingdon, VANTSB IAD71FIA16Accident · Serious injuriesClosedPiper PA-23 · Upperville, VANTSB IAD71AI043Accident · 1 fatalClosedPiper PA-28 · Basye, VANTSB IAD71FID21Accident · No injuriesClosedCessna 150J · Amelia, VANTSB IAD71DIA15Accident · No injuriesClosedPiper PA-28 · Quantico, VANTSB IAD71DID20Accident · Minor injuriesClosedTaylorcraft BC12-D · Ararat, VANTSB IAD71AI038Accident · 1 fatalClosedBellanca 14-193 · Jamesville, VA