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 ATL92FA042Accident · No injuriesField investigationFinal reportCessna T210L · Georgetown, SCThe failure of overhaul personnel to properly torque the engine case rear thru bolts.NTSB ATL92FA040Accident · 2 fatalField investigationFinal reportCessna 140 · Columbia, SCThe pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…NTSB ATL92FA031Accident · 5 fatalField investigationFinal reportBeech 58TC · Bluffton, SCThe pilot's failure to maintain minimum controllable airspeed after a reported engine power loss, resulting in a loss of aircraft control. A factor was the loss of power on the left engine. The reason for the left engine power loss could not be determined.NTSB MIA92LA048Accident · Serious injuriesLimited investigationFinal reportPiper J-4E · Timmonsville, SCTotal loss of engine power (nonmechanical) due to inadequate fuel consumption calculation by the pilot-in-command, resulting in an engine failure due to fuel exhaustion, a forced landing, and in-flight collision with terrain.NTSB ATL92LA011Accident · No injuriesLimited investigationFinal reportWinchester Thorp T-18 · Walterboro, SCThe student pilot's improper use of the wheel brakes, and the subsequent loss of directional control. Factors in this accident were the student pilot's lack of total flying experience and the pilot-in-command's inadequate supervision of the flight.NTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB ATL91LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, SCThe dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.NTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.NTSB ATL91LA171Accident · No injuriesLimited investigationFinal reportCessna 150L · Pickens, SCThe panicked, intentional interference of the flight controls by the student.NTSB ATL91LA152Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Manning, SCThe pilot's failure to maintain directional control during the takeoff roll, and his failure to abort the takeoff in a timely manner once the airplane had departed the runway surface. A factor in the accident was the pilot's failure to utilize the entire…NTSB ATL91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Spartanburg, SCThe pilot's failure to follow the checklist and extend the landing gear prior to touchdown.NTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).NTSB ATL91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Conway, SCFailure of the number two exhaust valve, which resulted in loss of engine power.NTSB ATL91LA105Accident · No injuriesLimited investigationFinal reportCessna 188 · Sycamore, SCThe pilot's failure to secure the gust lock during prelflight; the string jammed the flight controls and created an uncontrollable condition.NTSB ATL91LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Little River, SCThat the pilot dragged the right wing tip on final approach when he failed to control the aircraft. Factors to this accident were: a wind shift below the treetops.NTSB ATL91FA099Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Surf Side Beach, SCThe improper preflight inspection of the aircraft by the pilot, in that he failed to turn the aircraft fuel selector 'on' prior to starting the engine. A factor in the accident was the aircraft fuel selector valve leaking enough fuel to the engine in the…NTSB ATL91LA096Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Rock Hill, SCThe pilot diverted his attention to a poisonous snake in the cockpit and failed to maintain control of the aircraft.NTSB ATL91LA080Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Saluda, SCThe flight instructor did not maintain the proper altitude during the simulated forced landing.NTSB ATL91LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Greer, SCThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL91FA020Accident · 2 fatalField investigationFinal reportMooney M20F · Pageland, SCFailure of the pilot to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the weather conditions and the malfunction of a gyro instrument (probably the attitude indicator).NTSB ATL91LA033Accident · No injuriesLimited investigationFinal reportCessna 310Q · Windsor, SCFailure of the owner of the private sod airport to properly maintain the runway, which precipitated the loss of control of the airplane during the landing roll.NTSB ATL91LA030Accident · No injuriesLimited investigationFinal reportBeech S35 · N. Myrtle Beach, SCThe pilot's failure to ensure that the engine oil filter was properly installed prior to flight, resulting in engine oil loss and eventual failure of the engine.NTSB ATL91FA026Accident · Serious injuriesField investigationFinal reportBeech D-55 · Greer, SCFuel starvation. A contributing factor was the pilot's failure to follow normal fuel system operational procedures which resulted in the total loss of engine power.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB ATL91LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Summerville, SCAn eroded exhaust stack which allowed hot gases to impinge upon the firewall, and ignite cabin insulation.NTSB ATL91FA008Accident · 2 fatalField investigationFinal reportBeech A36 · Georgetown, SCThe pilot-in-command's loss of consciousness during flight. The reason for the loss of consciousness could not be determined.NTSB ATL90LA181Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Minturn, SCA previously fractured main wheel which had resulted from a hard landing. A factor in the accident was inadequate inspection by the operator.NTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.NTSB ATL90LA159Accident · No injuriesLimited investigationFinal reportCessna 172 · Ridge Spring, SCThe failure of the maintenance facility/owner to follow standard preventive maintenance procedures. A factor was the pilot's failure to extend the flaps during the forced landing.NTSB ATL90FA157Accident · 1 fatalField investigationFinal reportBeech E18S · Greenwood, SCThe pilot's improper emergency procedure by shutting down the wrong engine, which resulted in a forced landing. Factors related to the accident were: failure of the number three intake valve in the right engine due to fatigue, and trees in the emergency…NTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…NTSB ATL90LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Saluda, SCPilot's failure to properly plan for high density altitude operations, which resulted in settling with power to the ground.NTSB ATL90FA135Accident · Serious injuriesField investigationFinal reportBoeing 727-281 · Charleston, SCImproper utilization of the emergency equipment.NTSB ATL90LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greenwood, SCThe pilot's failure to maintain flying speed during the flare phase of the approach/landing. Contributing to the accident was a sudden increase in winds.NTSB ATL90IA123Incident · No injuriesIncident investigationFinal reportBeech BE-18 · Anderson, SCThe pilot's failure to ensure adequate clearance while taxiing to the ramp. A factor in the incident was a dark, unlighted ramp area.NTSB ATL90FA110Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Hilton Head, SCThe pilot's mismanagement of the fuel system through inadvertant selection of the 'off' position of the fuel selector valve handle.NTSB ATL90LA101Accident · No injuriesLimited investigationFinal reportCessna 177B · Spartanburg, SCThe pilot's improper flare and improper recovery from a bounced landing.NTSB ATL90FA100Accident · 1 fatalField investigationFinal reportBell 205A-1 · Moncks Corner, SCThe in-flight separation of the main rotor because of the failure of a pillow block bolt, and the failure of the operator/repair station to follow the overhaul procedures.NTSB ATL90LA098Accident · 1 fatalLimited investigationFinal reportCessna 150H · N. Myrtle Beach, SCThe pilot's improper course reversal procedure which resulted in a stall at a low altitude precluding a recovery before water impact.NTSB ATL90LA080Accident · Serious injuriesLimited investigationFinal reportLearjet 24 · Anderson, SCElectrical arcing which resulted from a short in the pilot's map light circuit; a chafted wire contacted the oxygen supply line at the oxygen control panel in the cockpit. A factor in the accident was the inadequate design of the oxygen panel plumbing and…NTSB ATL90FA075Accident · 1 fatalField investigationFinal reportSikorsky HSS-1N · Cross, SCImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to fly the helicopter in such a manner that would have assured sufficient rotor RPM for an autorotation.NTSB ATL90LA058Accident · No injuriesLimited investigationFinal reportBeech C24R · Greer, SCThe pilot in command's improper flare which resulted in a hard landing.NTSB ATL90LA057Accident · No injuriesLimited investigationFinal reportMooney M20A · Parris Island, SCThe failure of the pilot to insure that sufficient fuel was aboard for the flight, resulting in fuel exhaustion.NTSB ATL90LA028Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Georgetown, SCThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.NTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.NTSB ATL90LA015Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Florence, SCThe worn steering system.NTSB ATL90LA006Accident · No injuriesLimited investigationFinal reportCessna 172 · Ridgeland, SCThe pilot misjudged the airspeed and failed to attain the proper touchdown point.NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.