NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 MIA67F0373Accident · No injuriesClosedPiper PA-30 · Greenville, SCNTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCNTSB MIA67F0342Accident · No injuriesClosedPiper PA-22 · West Columbia, SCNTSB MIA67F0350Accident · No injuriesClosedPiper PA-23 · Charleston, SCNTSB MIA67D0316Accident · No injuriesClosedBeech T-34A · Spartanburg, SCNTSB MIA67A0049Accident · 4 fatalClosedPiper PA-22 · Cross, SCNTSB MIA67D0264Accident · No injuriesClosedBoeing B75N1 · Trenton, SCNTSB MIA67F0262Accident · No injuriesClosedMooney M20E · Columbia, SCNTSB MIA67F0255Accident · No injuriesClosedErcoupe 415-C · Lancaster, SCNTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCNTSB MIA67A0034Accident · 2 fatalClosedPiper PA-22 · Newberry, SCNTSB MIA67F0261Accident · Minor injuriesClosedAeronca 65-LB · St-Stephens, SCNTSB MIA67F0252Accident · No injuriesClosedPiper PA-30 · Columbia, SCNTSB MIA67F0138Accident · No injuriesClosedCessna 172 · Spartanburg, SCNTSB MIA67F0304Accident · No injuriesClosedCallair A-9 · Estill, SCNTSB MIA67F0251Accident · No injuriesClosedWaco ASO · Timmonsville, SCNTSB MIA67D0254Accident · No injuriesClosedCessna 210 · Spartanburg, SCNTSB MIA67F0259Accident · No injuriesClosedPiper PA-22 · Pageland, SCNTSB MIA67A0028Accident · 1 fatalClosedBoeing D75N1 · Reidville, SCNTSB MIA67F0253Accident · No injuriesClosedCallair A-9 · Allendale, SCNTSB MIA67D0237Accident · No injuriesClosedChampion 7GCB · Darlington, SCNTSB MIA67A0025Accident · No injuriesClosedBell 47D1 · Crescent Beach, SCNTSB MIA67F0216Accident · Minor injuriesClosedCessna 150D · No. Charleston, SCNTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCNTSB MIA67F0184Accident · No injuriesClosedPiper PA-25 · Darlington, SCNTSB MIA67A0021Accident · 1 fatalClosedBrantly B-2 · Charleston Hts, SCNTSB MIA67D0180Accident · No injuriesClosedCessna 185E · Moncks Corner, SCNTSB MIA67A0016Accident · No injuriesClosedBeech D18S · Landrum, SCNTSB MIA67A0004Accident · No injuriesClosedHughes 269B · Cope, SCNTSB MIA67D0130Accident · No injuriesClosedCessna 150 · Johns Island, SCNTSB MIA67D0131Accident · No injuriesClosedPiper PA-22 · Johns Island, SCNTSB MIA67D0089Accident · Minor injuriesClosedAeronca 7AC · Denmark, SCNTSB MIA67F0079Accident · Minor injuriesClosedPiper PA-22 · Starr, SCNTSB MIA67F0053Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCNTSB MIA66A0139Accident · 1 fatalClosedStits Ray SA3 · Columbia, SCNTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCNTSB MIA66A0135Accident · 1 fatalClosedPiper PA-28 · Summerton, SCNTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SCNTSB MIA67F0004Accident · No injuriesClosedPiper PA-28 · Ridgeland, SCNTSB MIA66D0626Accident · No injuriesClosedPiper PA-22 · Cayce, SCNTSB MIA66D0600Accident · Serious injuriesClosedCessna 170 · Darlington, SCNTSB MIA66D0589Accident · No injuriesClosedBeech A23 · Greenville, SCNTSB MIA66D0544Accident · No injuriesClosedCessna 182 · Little River, SCNTSB MIA66A0127Accident · No injuriesClosedHughes 269B · Landrum, SCNTSB MIA66D0581Accident · Minor injuriesClosedPiper PA14 · Lane, SCNTSB MIA66A0123Accident · No injuriesClosedHughes 269A · Orangeburg, SCNTSB MIA66A0122Accident · No injuriesClosedBell 47G-5 · Mcbee, SCNTSB MIA66D0521Accident · No injuriesClosedCessna 172 · Bishopville, SCNTSB MIA66D0510Accident · No injuriesClosedCessna 172 · Moncks Corner, SCNTSB MIA66F0506Accident · Minor injuriesClosedErco 415-C · St Stephen, SC