NTSB investigations, 1972, 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\") = 1972
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") = 1972 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 NYC73AN093Accident · 2 fatalClosedBellanca 14-132 · Blairs, VANTSB NYC73FIA08Accident · No injuriesClosedEnstrom F-28A · Fairfax, VANTSB NYC73AN085Accident · 2 fatalClosedPiper PA-22 · Newsoms, VANTSB NYC73DID15Accident · No injuriesClosedErco 415-C · South Boston, VANTSB NYC73FID14Accident · Serious injuriesClosedFairchild FH1100 · Roanoke, VANTSB NYC73DID13Accident · No injuriesClosedCessa 170B · Portsmouth, VANTSB NYC73F1D12Accident · No injuriesClosedEnstrom F-28A · Charlottsville, VANTSB NYC73FIJ11Accident · No injuriesClosedCessna 206D · Dublin, VANTSB NYC73FID11Accident · No injuriesClosedPiper PA-24 · Hopewell, VANTSB NYC73DID10Accident · No injuriesClosedCessna 150 · Amelia, VANTSB NYC73FIJ09Accident · No injuriesClosedCessna 310J · Wise, VANTSB NYC73FID09Accident · No injuriesClosedPiper PA-22 · Richmond, VANTSB MIA73AM037Accident · Serious injuriesClosedBoeing 727 · Norfolk, VANTSB NYC73FID08Accident · Minor injuriesClosedCallair A-9 · Melfa, VANTSB NYC73FIA05Accident · No injuriesClosedFairchild PT-23 · Warrenton, VANTSB NYC73DID07Accident · No injuriesClosedPiper PA-28 · Chesapeake, VANTSB NYC73DIJ02Accident · Minor injuriesClosedBell 47G-2A · Richlands, VANTSB NYC73AN034Accident · 1 fatalClosedBellanca 17-30A · Abingdon, VANTSB NYC73FID06Accident · No injuriesClosedCessna 182 · Jetersville, VANTSB NYC73FID05Accident · 2 fatalClosedBell 47G-2A · Floyd, VANTSB NYC73AN020Accident · 1 fatalClosedChampion 7KCAB · Windsor, VANTSB NYC73FID03Accident · Minor injuriesClosedPiper PA-25 · Newsoms, VANTSB NYC73FIA04Accident · Serious injuriesClosedBellanca 14-19 · Fredericksburg, VANTSB NYC73DID04Accident · No injuriesClosedPiper PA-28 · Fredericksburg, VANTSB NYC73AN011Accident · 2 fatalClosedAeronca 7AC · Culpeper, VANTSB NYC73FID02Accident · Serious injuriesClosedBeech 95-B55 · Covington, VANTSB NYC73FIA03Accident · No injuriesClosedMaule M4220C · Winchester, VANTSB NYC73FID01Accident · No injuriesClosedCessna 150K · Chesapeake, VANTSB NYC73AN006Accident · 1 fatalClosedCessna 150G · Arcola, VANTSB IAD73DIA01Accident · Serious injuriesClosedAmer Avco AA-1A · Syria, VANTSB NYC73DIA02Accident · No injuriesClosedStearman A75N1 · Warrenton, VANTSB NYC72FIJ43Accident · Minor injuriesClosedBeech D35 · Lebanon, VANTSB NYC72DID35Accident · Minor injuriesClosedPiper PA-28 · Ashland, VANTSB NYC72AN151Accident · 1 fatalClosedPiper PA-22 · Winchester, VANTSB NYC72DID32Accident · No injuriesClosedAlon A2-A · King George, VANTSB NYC72AN147Accident · 1 fatalClosedLowers R-1 · Sterling, VANTSB NYC72FID33Accident · No injuriesClosedMooney M20E · Orange, VANTSB NYC72FID31Accident · Minor injuriesClosedAeronca 7AC · Ashland, VANTSB NYC72FIA23Accident · No injuriesClosedPiper J3C-85 · Chantilly, VANTSB NYC72DIA22Accident · No injuriesClosedPiper PA-12 · Warrenton, VANTSB NYC72FID34Accident · No injuriesClosedCessna 150H · Newport News, VANTSB NYC72DID29Accident · Minor injuriesClosedPitts S-1 · Crewe, VANTSB NYC72DID28Accident · Minor injuriesClosedBell 47G-2A · Covington, VANTSB NYC72DID27Accident · No injuriesClosedCessna 172D · Crittenden, VANTSB NYC72FID25Accident · Minor injuriesClosedCessna 150G · Chesterfield, VANTSB NYC72IN136Incident · Minor injuriesClosedBoeing 720B · Front Royal, VANTSB NYC72FIJ41Accident · 1 fatalClosedSikorsky H-19G · Coeburn, VANTSB NYC72FIA20Accident · No injuriesClosedPiper PA-24 · Manassas, VANTSB NYC72FID26Accident · Serious injuriesClosedPiper J3C-65 · Bedford, VANTSB NYC72FIA19Accident · Minor injuriesClosedPiper PA-28R · Mt Clinton, VA