NTSB investigations, 1973, VA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1973
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") = 1973 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 IAD74FID24Accident · Minor injuriesClosedCessna 150K · St Stephens C, VANTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VANTSB IAD74FID23Accident · No injuriesClosedCessna 172C · Moneta, VANTSB IAD74F1A06Accident · Minor injuriesClosedPiper PA-28 · Manassas, VANTSB IAD74FID22Accident · No injuriesClosedPiper PA-28 · Charlottesvill, VANTSB IAD74FIA07Accident · No injuriesClosedChampion 7GCBC · Bealton, VANTSB IAD74FID21Accident · No injuriesClosedPiper PA-24 · Hopewell, VANTSB IAD74FID19Accident · No injuriesClosedPiper PA-28 · Ashland, VANTSB IAD74FID20Accident · No injuriesClosedBeech M35B · Waynesboro, VANTSB IAD74DIJ07Accident · Minor injuriesClosedAeronca 15AC · Covington, VANTSB IAD74DIJ06Accident · Minor injuriesClosedCessna 150 · Dublin, VANTSB IAD74FID16Accident · No injuriesClosedAeronca 7AC · South Hill, VANTSB IAD74DID15Accident · No injuriesClosedBellanca 8KCAB · Charlottesvlle, VANTSB IADMJFID17Accident · Minor injuriesClosedPiper PA-25 · Crewe, VANTSB IAD74FIA05Accident · No injuriesClosedPiper PA-12 · Front Royal, VANTSB IAD74AI015Accident · 1 fatalClosedBeech B55 · Agusta Springs, VANTSB IAD74DIJ05Accident · No injuriesClosedCessna 172 · Austinville, VANTSB IAD74FID14Accident · No injuriesClosedCessna 170B · Eastville, VANTSB IAD74FID13Accident · No injuriesClosedBoeing A75N1 · Clifton Forge, VANTSB IAD74FIA04Accident · No injuriesClosedPiper PA-22 · Harrisonburg, VANTSB IAD74FID12Accident · No injuriesClosedCessna 172B · Ashland, VANTSB IAD74DIJ01Accident · Serious injuriesClosedBell 47-G4 · Nora, VANTSB IAD74DID10Accident · No injuriesClosedPiper PA-25 · Parksley, VANTSB IAD74FID09Accident · Minor injuriesClosedCessna 172G · Ashland, VANTSB IAD74DID08Accident · Minor injuriesClosedPiper PA-28 · Lexington, VANTSB IAD74FIA01Accident · No injuriesClosedCessna 172K · Leesburg, VANTSB IAD74FID07Accident · Serious injuriesClosedBeech V35B · Wakefield, VANTSB IAD74DIJ04Accident · No injuriesClosedBell 47-G2A · Pulaski, VANTSB IAD74DID11Accident · No injuriesClosedCessna 172E · Fort Eustis, VANTSB IAD74FID06Accident · No injuriesClosedErco 415-D · Ashland, VANTSB IAD74DID05Accident · No injuriesClosedCessna 182 · Fredricksburg, VANTSB IAD74FID04Accident · Minor injuriesClosedCessna 172K · Charles City, VANTSB IAD74FID02Accident · No injuriesClosedCessna A188B · Norfolk, VANTSB IAD74DID03Accident · No injuriesClosedAero Comdr A-9B · Parksley, VANTSB IAD73FIA17Accident · No injuriesClosedNavion G · West Haymarket, VANTSB IAD73DID25Accident · No injuriesClosedCessna 172 · Ashland, VANTSB IAD73FID24Accident · No injuriesClosedCessna 150 · Blacksburg, VANTSB IAD73FID20Accident · 1 fatalClosedBannick T-100 · Buckingham, VANTSB IAD73FID22Accident · No injuriesClosedHughes 269C · Richmond, VANTSB IAD73FIA14Accident · No injuriesClosedCessna 172K · Luray, VANTSB IAD73DID21Accident · No injuriesClosedPiper PA-22 · Chesapeake, VANTSB IAD733ID20Accident · No injuriesClosedPiper J3C-65 · Blairs, VANTSB IAD73FIA16Accident · No injuriesClosedPiper PA-28 · Manassas, VANTSB IAD73AI011Accident · 2 fatalClosedPiper PA-24 · Orange, VANTSB NYC73AN140Accident · 2 fatalClosedPiper PA-24 · Floyd, VANTSB IAD73DID19Accident · No injuriesClosedCessna 305A · Forest, VANTSB IAD73AI007Accident · 3 fatalClosedCessna 172E · Montvale, VANTSB IAD73DID18Accident · No injuriesClosedHelio Acft H-250 · Lynchburg, VANTSB NYC73FIA12Accident · No injuriesClosedCessna 172 · Richardsville, VANTSB NYC73FIA10Accident · No injuriesClosedCessna 150L · Manassas, VA