NTSB investigations, 2000, SC
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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
Open the mapLatest 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\") = 2000
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") = 2000 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 MIA01LA044Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hilton Head Isl, SCthe pilot's improper inflight planning/decision and failure to follow the prelanding checklist, resulting in the landing gear not being lowered in sufficient time to be verified down and locked, which resulted in a wheels up landing and substantial damage to…NTSB ATL01LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Florence, SCLoss of engine power due to carburetor icing, which resulted in a emergency landing into rough uneven terrain.NTSB MIA01LA022Accident · No injuriesLimited investigationFinal reportHorne Bowers Flybaby · Greer, SCA runway overrun as a result of the pilot's failure to maintain proper approach speed and landing touch down point.NTSB MIA01LA014Accident · Minor injuriesLimited investigationFinal reportCraig R. Merrill Luton Beta · Ridgeland, SCThe pilot's failure to maintain airspeed on final approach resulting in the aircraft settling fast, touching down hard, and colliding with an embankment on the side of the runway, where it came to rest inverted.NTSB ATL01LA004Accident · No injuriesLimited investigationFinal reportJoseph A. Grimaud Seawind 3000 · Chapin, SCA total loss of engine power for undetermined reasons. A factor was the trees.NTSB ATL00LA087Accident · No injuriesLimited investigationFinal reportGrumman G164A · Dillon, SCA total loss of engine power due to a cracked cylinder head. A factor was the emergency landing into unsuitable terrain, and the subsequent nose over.NTSB MIA00LA256Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Furman, SCThe pilot's failure to ensure the aircraft contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB ATL00LA071Accident · Minor injuriesLimited investigationFinal reportRyskamp Sonex · Greenville, SCThe pilot's misjudgment of airspeed and altitude resulting in an undershoot.NTSB ATL00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Charleston, SCThe pilot's inadequate evaluation of weather information, and his delay in taking remedial action that resulted in the in-flight encounter with severe weather.NTSB MIA00LA227Accident · Minor injuriesLimited investigationFinal reportBell 206A-1 · Bennettsville, SCThe pilot's failure to use proper remedial action to counteract a loss of tail rotor effectiveness resulting in collision with terrain during the subsequent uncontrolled descent.NTSB MIA00LA159Accident · Minor injuriesLimited investigationFinal reportRichard Shaffer Aircamper GN-1 · Florence, SCThe failure of the pilot to maintain directional control after takeoff resulting in the uncontrolled descent and impact on a closed runway.NTSB ATL00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-200 · Mt. Pleasant, SCThe airplane collision with a deer during a night landing.NTSB ATL00LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Stonesboro, SCThe pilot's improper inflight decision not to refuel which resulted in fuel exhaustion and a total loss of engine power.NTSB ATL00LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Rock Hill, SCThe maintenance personnel's failure to re-torque the engine driven fuel pump in accordance with an Airworthiness Directive that resulted in a fuel leak and a subsequent engine fire.NTSB MIA00FA117Accident · 1 fatalField investigationFinal reportCessna 177RG · Columbia, SCThe PIC's inadequate planning and preparation resulting in refueling not being performed and the subsequent fuel exhaustion and forced landing into trees. A factor in the accident was the erratic operation of the right fuel tank quantity indicating system.NTSB MIA00LA079Accident · No injuriesLimited investigationFinal reportBeech D50E · Myrtle Beach, SCThe on-ground fire caused by fuel flowing out the fuel vent and near the exhaust of the left engine resulting in the on-ground fire and substantial damage to the airplane. A finding in the investigation was that all four fuel tanks had been filled before the…NTSB MIA00LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · W. Columbia, SCThe inadequate wording of the NOTAM for failure to identify that the usable width of the runway was reduced and the inadequate snow removal by airport personnel for failure to remove the snow from the runway resulting in the on-ground collision with a snow…NTSB MIA00FA066Accident · 1 fatalField investigationFinal reportMooney M20M · Mount Pleasant, SCThe pilot's failure to maintain airspeed (VSO) while maneuv ering on a night instrument approach in instrument conditions. This resulted in an inadvertent in-flight loss of control (stall/spin), and subsequent in-flight collision with a swamp. Contributing to…NTSB ATL00FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Cordesville, SCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.