NTSB investigations, SC
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, newest first
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 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 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 ATL04CA151Accident · No injuriesData collectionFinal reportCessna 182A · Walterboro, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL04LA123Accident · 1 fatalLimited investigationFinal reportCessna 310 · N. Myrtle Beach, SCThe pilot's inadequate preflight/planning and his in-flight decision which resulted in the loss of power in one engine due to fuel starvation.NTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.NTSB ATL04FA093Accident · 3 fatalField investigationFinal reportCessna 182S · North Augusta, SCThe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and subsequent in-flight collision with trees and the ground.NTSB ATL04LA092Accident · No injuriesLimited investigationFinal reportCessna 140 · Greenville, SCFatigue failure of the leaf spring gear strut.NTSB ATL04FA090Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Johns Island, SCThe pilot's failure to maintain airspeed during emergency descent, which resulted in an inadvertent stall/spin and uncontrolled descent into trees and terrain. A factor was the loss of engine power in one engine due to pre-ignition/detonation.NTSB ATL04LA088Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, SCThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion. The pilot's preflight planning and uneven terrain were contributing factors.NTSB ATL04LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Summerville, SCThe pilot's inadequate start procedure, which resulted in a run-away airplane.NTSB ATL04LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Allendale, SCThe failure of the hydraulic brake system accumulator due to a ruptured diaphragm. A factor was the ditch.NTSB ATL04LA064Accident · 1 fatalLimited investigationFinal reportAtkinson SA 102.5 · Trenton, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent in-flight collision with terrain.NTSB ATL04FA061Accident · 1 fatalField investigationFinal reportMooney 20F · Campobello, SCThe pilot's failure to maintain airspeed while maneuvering for an emergency landing resulting in an inadvertent stall and a collision with trees and the ground during an uncontrolled descent. A factor in the accident was the pilot's inadequate preflight…NTSB ATL04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Columbia, SCThe pilot's mismanagement of the fuel supply, and his inadequate preflight planning which resulted in fuel exhaustion.NTSB ATL04LA037Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Greenville, SCThe pilot's improper landing flare, resulting in a hard landing and a main rotor/tailboom strike.NTSB ATL04FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Spartanburg, SCThe pilot's failure to follow IFR procedures and descent below the glide path, which resulted in an inflight collision with trees during an instrument approach. A factor was the pilot's impairment due to the sedating effects of medication.NTSB ATL04LA025Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Edgefield, SCThe pilot's failure to follow the checklist to ensure the fuel filler cap was secured resulting in fuel starvation and subsequent loss of engine power.NTSB ATL04FA016Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Cordesville, SCThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent uncontrolled descent into trees and the ground. A factor was physical impairment.NTSB ATL03LA144Accident · Minor injuriesLimited investigationFinal reportBeech A90 · Summerville, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ATL03LA143Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Summerville, SCA loss of engine power due to the failure of the engine # 6 connecting rod bearing. A factor was the collision with a gate.NTSB ATL03FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Hilton Head Is, SCThe pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…NTSB ATL03LA112Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW28 · Batesburg, SCThe loss of thermal lifting action that resulted in the in-flight collision with trees during an attempted forced landing.NTSB ATL03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Mill, SCThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power.NTSB ATL03LA100Accident · No injuriesLimited investigationFinal reportCessna 172N · Orangeburg, SCThe pilot's continued operation of the airplane with known deficiencies in the equipment. Also causal was the other maintenance personnel's improper installation of the mixture control linkage bolt that resulted in binding of the mixture control linkage and…NTSB ATL03LA094Accident · 4 fatalLimited investigationFinal reportKerner Lancair IV · Allendale, SCThe pilot's inadvertent flight into adverse weather ,thunderstorms, that resulted in the design limits of the airplane being exceeded.NTSB ATL03TA078Accident · Serious injuriesFinal reportAero Commander 500S · Mount Pleasant, SCThe improper refueling of the airplane by airport personnel with the incorrect fuel grade that resulted in a total loss in engine power on both engines during initial climb. A factor was the inadequate preflight inspection by the pilot in command.NTSB ATL03LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe pilot's improper flare and recovery from a bounced landing.NTSB ATL03LA066Accident · Serious injuriesLimited investigationFinal reportDaigneault EAA BI-PLANE · Easley, SCThe pilots failure to maintain clearance while maneuvering on initial climb out resulting in an in-flight collision with a residence.NTSB ATL03LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Camden, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion, subsequent loss of engine power and an in-flight collision with terrain.NTSB ATL03LA050Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood, SCThe pilot's continued visual flight into instrument meteorological conditions and loss of aircraft control, which resulted in an in-flight collision with the ground.NTSB ATL03FA041Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Florence, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. A factors was dark night and clouds.NTSB MIA03LA049Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Myrtle Beach, SCA loss of engine power for undetermined reasons.NTSB ATL03LA034Accident · No injuriesLimited investigationFinal reportCessna 172S · Mt. Pleasant, SCThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a loss of control and collision with terrain.NTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…NTSB ATL03LA018Accident · No injuriesLimited investigationFinal reportHickman Murphy Rebel · Hilton Head, SCThe pilot's failure to maintain directional control during an aborted landing that resulted in the in-flight collision with a ditch.NTSB MIA03LA019Accident · 3 fatalLimited investigationFinal reportJohn H. Heiring Express · Moncks Corner, SCThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.NTSB ATL03LA016Accident · 1 fatalLimited investigationFinal reportChance Vought F4U-4 · Columbia, SCAn in-flight engine fire for undetermined reasonsNTSB MIA02LA166Accident · No injuriesLimited investigationFinal reportBeech C24R · Olar, SCThe pilot's failure to execute the proper remedial action for hydraulic leak fumes in the cockpit, and his decision to perform an immediate precautionary landing to a vacant field, resulting in collision with a tree. A factor in the accident was the…NTSB ATL02LA163Accident · No injuriesLimited investigationFinal reportCessna 210L · Georgetown, SCThe failure of the landing gear to lock in the down position.NTSB MIA02LA155Accident · Serious injuriesLimited investigationFinal reportBarnes Vans RV-6 · Chesnee, SCthe pilot misjudged the landing flare, resulting in a hard landing, loss of directional control, and damage to the airplane.NTSB MIA02LA154Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Union, SCthe pilot's failure to maintain obstacle clearance.NTSB MIA02FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cheraw, SCThe misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…NTSB ATL02FA150Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Spartanburg, SCThe pilot's failure to maintain airspeed during the takeoff initial climb which resulted in an inadvertent stall and subsequent collision with an embankment.NTSB MIA02LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Pickens, SCThe pilot's improper preflight planning/preparation that resulted in the airplane's gust lock being left installed which resulted in a loss of control during the takeoff roll and damage to the airplane when it exited the departure end of the runway and…NTSB MIA02LA125Accident · No injuriesLimited investigationFinal reportMooney M20R · Mt. Pleasant, SCThe pilot's failure to maintain airspeed resulting in a stall, an uncontrolled descent, and an impact with the ground during the attempted go-around.NTSB ATL02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · N Myrtle Beach, SCThe pilot's failure to maintain airspeed during a banner tow pickup resulting in an inadvertent stall and uncontrolled descent and collision with terrain.NTSB MIA02FA102Accident · 1 fatalField investigationFinal reportBeech F33A · Conway, SCThe failure of the pilot to request in-flight weather avoidance assistance and his poor in-flight planning/decision for flying into a Level 5 thunderstorm resulting in an in-flight loss of control, uncontrolled descent, and subsequent in-flight collision with…NTSB ATL02LA103Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Charleston, SCTotal loss of engine power due to oil system starvation. A factor was the transmission wire encountered during emergency descent.NTSB ATL02FA101Accident · 2 fatalField investigationFinal reportLuscombe LL-8-E · Olar, SCThe in-flight separation of the elevator push-pull control tube that resulted in a loss of flight control and subsequent collision with the ground.NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.NTSB ATL02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe failure of the pilot to use proper wind correction technique, resulting in a loss of directional control of the aircraft.NTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.