NTSB investigations, 1964, SC
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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
| 1964 | 46 |
|---|---|
| 1965 | 41 |
| 1966 | 58 |
| 1967 | 49 |
| 1968 | 62 |
| 1969 | 39 |
| 1970 | 51 |
| 1971 | 42 |
| 1972 | 58 |
| 1973 | 43 |
| 1974 | 49 |
| 1975 | 51 |
| 1976 | 39 |
| 1977 | 44 |
| 1978 | 56 |
| 1979 | 28 |
| 1980 | 29 |
| 1981 | 32 |
| 1982 | 52 |
| 1983 | 40 |
| 1984 | 35 |
| 1985 | 36 |
| 1986 | 25 |
| 1987 | 35 |
| 1988 | 41 |
| 1989 | 27 |
| 1990 | 23 |
| 1991 | 20 |
| 1992 | 31 |
| 1993 | 24 |
| 1994 | 30 |
| 1995 | 32 |
| 1996 | 19 |
| 1997 | 28 |
| 1998 | 28 |
| 1999 | 26 |
| 2000 | 19 |
| 2001 | 13 |
| 2002 | 21 |
| 2003 | 22 |
| 2004 | 20 |
| 2005 | 22 |
| 2006 | 17 |
| 2007 | 15 |
| 2008 | 20 |
| 2009 | 29 |
| 2010 | 19 |
| 2011 | 21 |
| 2012 | 21 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 12 |
| 2016 | 15 |
| 2017 | 12 |
| 2018 | 21 |
| 2019 | 18 |
| 2020 | 13 |
| 2021 | 22 |
| 2022 | 21 |
| 2023 | 21 |
| 2024 | 10 |
| 2025 | 19 |
| 2026 | 15 |
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\") = 1964
AND c.\"eventStateOrRegion\" = 'SC' 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") = 1964 AND c."eventStateOrRegion" = 'SC' 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 UNK65X0982Accident · No injuriesClosedCessna 182 · Columbia, SCNTSB UNK65X0617Accident · Minor injuriesClosedPiper PA22 · James Island, SCNTSB UNK65X0514Accident · No injuriesClosedPiper PA24 · Columbia, SCNTSB UNK65X0409Accident · Minor injuriesClosedTaylorcraft BC · Spantanburg, SCNTSB UNK65X0226Accident · No injuriesClosedCurtiss C-46 · Charleston, SCNTSB UNK64X4180Accident · No injuriesClosedWaco UPF7 · Steel Creek Tp, SCNTSB UNK64X4154Accident · Minor injuriesClosedAeronca 7AC · Newberry, SCNTSB UNK64X4055Accident · No injuriesClosedCessna 175B · Charleston, SCNTSB UNK64X4024Accident · No injuriesClosedPiper PA22 · Kershaw, SCNTSB UNK64X3922Accident · No injuriesClosedCessna 170 · Allendale, SCNTSB UNK64X3675Accident · No injuriesClosedPiper PA28 · Anderson, SCNTSB UNK64X3621Accident · Minor injuriesClosedCallair A9 · Hampton, SCNTSB UNK64X3441Accident · No injuriesClosedAeronca 7AC · Newberry, SCNTSB UNK64X3366Accident · Minor injuriesClosedPiper PA24 · Isle Of Palms, SCNTSB UNK64X3251Accident · No injuriesClosedPiper PA11 · Lydia, SCNTSB UNK64X3209Accident · No injuriesClosedCessna 170B · Stuckey, SCNTSB UNK64X3175Accident · No injuriesClosedBellanca 14192 · Laurens, SCNTSB UNK64X3122Accident · No injuriesClosedPiper PA25 · Martin, SCNTSB UNK64X3027Accident · No injuriesClosedHughes 269A · Bowman, SCNTSB UNK64X3023Accident · No injuriesClosedHughes 269A · Clio S C, SCNTSB UNK64X2990Accident · 1 fatalClosedPiper PA22 · Bethune, SCNTSB UNK64X2786Accident · No injuriesClosedPiper PA28 · Johns Island, SCNTSB UNK64X2435Accident · No injuriesClosedPiper PA28 · Columbia, SCNTSB UNK64X2421Accident · Minor injuriesClosedAeronca 11AC · Cherry Grv Bch, SCNTSB UNK64X2278Accident · No injuriesClosedPiper PA22 · Ridgeland, SCNTSB UNK64X1831Accident · No injuriesClosedErcoupe 415C · Harleyville, SCNTSB UNK64X1809Accident · No injuriesClosedErcoupe 415C · Isle Of Palms, SCNTSB UNK64X1669Accident · No injuriesClosedPiper PA24 · Cheraw, SCNTSB UNK64X1636Accident · No injuriesClosedErcoupe 415C · Cheraw, SCNTSB UNK64X1527Accident · No injuriesClosedPiper PA28 · Charleston, SCNTSB UNK64X1451Accident · No injuriesClosedBeechcraft 35B33 · Mrytle Beach, SCNTSB UNK64X1386Accident · Serious injuriesClosedFairchild 24 · Pickens, SCNTSB UNK64X1232Accident · No injuriesClosedPiper PA30 · Johns Island, SCNTSB UNK64X1213Accident · Serious injuriesClosedCessna 195 · York, SCNTSB UNK64X1171Accident · No injuriesClosedPiper PA22 · Charleston, SCNTSB UNK64X1113Accident · Minor injuriesClosedPiper PA24 · Lake City, SCNTSB UNK64X1105Accident · Serious injuriesClosedPiper PA22 · Union, SCNTSB UNK64X0818Accident · No injuriesClosedChampion 7FC · West Columbia, SCNTSB UNK64X0622Accident · No injuriesClosedBoeing A75N1 · Campobello, SCNTSB UNK64X0591Accident · No injuriesClosedCessna 182 · Walterboro, SCNTSB UNK64X0529Accident · No injuriesClosedChampion 7GCB · Timmonsville, SCNTSB UNK64X0443Accident · No injuriesClosedLuscombe 8E · Pontiac, SCNTSB UNK64X0441Accident · No injuriesClosedPiper PA23 · Spartanburg, SCNTSB UNK64X0321Accident · No injuriesClosedBeechcraft 95 · Charleston, SCNTSB UNK64X0219Accident · No injuriesClosedBeechcraft N35 · Columbia, SCNTSB UNK64X0159Accident · Serious injuriesClosedPiper PA-24 · Hartsville, SC