Fatal NTSB investigations, 1982, SC
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 1 |
|---|---|
| 1965 | 6 |
| 1966 | 7 |
| 1967 | 6 |
| 1968 | 8 |
| 1969 | 5 |
| 1970 | 4 |
| 1971 | 5 |
| 1972 | 7 |
| 1973 | 6 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 7 |
| 1979 | 7 |
| 1980 | 7 |
| 1981 | 7 |
| 1982 | 10 |
| 1983 | 5 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 5 |
| 1994 | 6 |
| 1995 | 12 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 7 |
| 2004 | 9 |
| 2005 | 8 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 8 |
| 2010 | 6 |
| 2011 | 6 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 4 |
| 2026 | 3 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1982 AND c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ATL83LA078Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Daufuskie Islan, SCThe pilot's wife stated her husband had departed tampa, FL and could not recall if he had indicated a destination. She further stated her husband had a "charter". Investigation by law enforcement and drug enforcement personnel located cocaine in the aircraft…NTSB ATL83FA040Accident · 2 fatalField investigationFinal reportCessna 411 · Aiken, SCThe plt requested an instrument approach to the arpt & advised approach control (a/c) that he did not have an approach plate for the arpt. A/c cleared the acft for a NDB approach to rwy 24 & read the approach information to the plt. When the plt reported…NTSB ATL83FA013Accident · 1 fatalField investigationFinal reportBeech B-23 · Lexington, SCThe aircraft crashed in a corn field shortly after takeoff. The aircraft was owned by the pilot who was fatally injured in the accident. The weather was VMC and no system malfunction could be found. The aircraft was seen flying at low altitude prior to the…NTSB ATL83FA001Accident · 3 fatalField investigationFinal reportEagle C-7 · Piedmont, SCBalloon was inflated with difficulty because of gusty winds. Balloon did not have a skirt. During the flight which ended in the accident the balloon seemed to have trouble and during the final moments it was in a descent which ended with the envelope as a…NTSB ATL82FLG13Accident · 1 fatalFinal reportSmith Miniplane · Swansea, SCThe pilot was on a pleasure flight to practice aerobatic maneuvers. He held a current certificate of waiver which authorized him to practice low level aerobatics below 1500 ft above the surface. Four known witnesses observed the aircraft pull up from a low…NTSB ATL82FA184Accident · 1 fatalField investigationFinal reportCessna 152 · Charleston, SCPlt made steep turn after takeoff & stalled. Acft came to rest on the arpt about 1500 ft from the point where the takeoff run was initiated & about 200 ft north of rwy 9. It was necessary for the plt to be airborne by 0700 in order for him to make his first…NTSB ATL82FA140Accident · 2 fatalField investigationFinal reportCessna T210M · Holly Springs, SCPrior to departing new bern at 1837 the plt called his office & stated he had received a wx report for scattered thunderstorms along his route of flt. At 2020 & 2052 he contacted atl flt watch for wx advisories. He was advised that the wx radar was out of…NTSB ATL82FA066Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Bradley, SCBefore takeoff, the pilot telephoned his brother in north carolina and asked about the weather. He was told that there was an overcast. The pilot replied that he would "come on and skirt the mountains." No flight plan was filed and there was no FAA record of…NTSB ATL82FA059Accident · 4 fatalField investigationFinal reportCessna 210L · Hilton Head, SCThe aircraft departed dulles international airport at 1630 EST, no flight plan was filed. The next radio contact with the aircraft was by beaufort marine corps air station approach control when the controller transmitted the altimeter setting and the pilot…NTSB ATL82FLG10Accident · 1 fatalFinal reportCessna 150 · Darlington, SCWitnesses observed the aircraft performing aerobatic type of manuevers before entering a spin and crashing into a field. Although the pilot was known never to drink alcoholic beverages before flying, the pilot's blood alcohol level was 266MG/DL.