Fatal NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 MIA96LA050Accident · 2 fatalLimited investigationFinal reportNanchang China CJ6A · Planterville, SCfailure of the pilot to maintain sufficient altitude or clearance from trees.NTSB ATL96FA022Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Greenwood, SCthe loss of engine power for undetermined reason.NTSB MIA95FA239Accident · 1 fatalField investigationFinal reportBeech 58 · Greer, SCoperation of the aircraft by the pilot with a known deficiency (failed mixture control linkage in the right engine), which resulted in loss of power in the right engine; and his failure to maintain control of the airplane during the initial climb after…NTSB ATL95FA174Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Columbia, SCthe pilot's improper IFR procedure by allowing the airplane to descend below the ILS glideslope and by continued descent below the decision height. Factors relating to the accident were: darkness, low ceiling, and fog.NTSB MIA95FA208Accident · 2 fatalField investigationFinal reportPiper 601P · Rock Hill, SCThe pilot's in-flight loss of aircraft control, due to incapacitation by a heart attack.NTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.NTSB MIA95FA183Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Hilton Head Isl, SCloss of engine power for undetermined reasons, and the unsuitable terrain encountered during the emergency landing. A factor in the accident was the pilot's extension of the downwind leg which prevented landing on the intended runway following loss of engine…NTSB ATL95LA116Accident · 1 fatalLimited investigationFinal reportSmith Monnett Moni · Cheraw, SCThe loss of engine power for unknown reasons, and the pilot's failure to maintain flying speed, which resulted in impact with the ground while the airplane was in a stalled condition.NTSB ATL95FA101Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenville, SCThe pilot's failure to maintain flying speed. A factor was his failure to reposition the elevator trim.NTSB ATL95FA079Accident · 1 fatalField investigationFinal reportCessna 172F · Seneca, SCThe pilot's inadequate visual lookout while maneuvering near utility lines, which resulted in a collision with the wires.NTSB ATL95FA049Accident · 1 fatalField investigationFinal reportCessna 150J · Piedmont, SCThe pilot's inappropriate 'buzzing' that resulted in exceeding the airplane's design stress limits, the failure of the windshield, and the pilot's subsequent loss of control and impact with the ground.NTSB MIA95FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · York, SCThe noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…