NTSB investigations, SC
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.NTSB GAA18CA451Accident · No injuriesData collectionFinal reportVans RV 6 · Pickens, SCThe pilot's improper landing flare, which resulted in a bounced landing.NTSB ERA18LA213Accident · No injuriesLimited investigationFinal reportPiper PA46 · West Columbia, SCThe pilot’s inadvertent navigation onto a service road instead of a taxiway, which resulted in a collision with a stop sign.NTSB GAA18CA434Accident · No injuriesData collectionFinal reportClassic Waco · North Myrtle Beach, SCThe pilot's failure to maintain directional control during landing in a left quartering headwind.NTSB GAA18CA368Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Columbia, SCThe pilot's failure to maintain directional control during landing.NTSB GAA18CA356Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 · Winnsboro, SCThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s improper decision to provide instruction in an airplane with only one control stick.NTSB GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.NTSB GAA18CA225Accident · No injuriesData collectionFinal reportRepublic RC 3 · Pelion, SCThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB ERA18LA095Accident · 1 fatalLimited investigationFinal reportRobert Snyder Autogyro Calidus · Beaufort, SCThe gyroplane pilot's failure to maintain rotor speed and aircraft control as he was attempting to return to the runway during a low-altitude simulated engine-out maneuver.NTSB GAA18LA131Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Charleston, SCThe flight instructor’s abrupt evasive maneuver to avoid a reported unmanned aerial system, which resulted in a loss of forward airspeed and settling with power and a subsequent collision with trees and terrain.NTSB ERA18LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ridgeland, SCThe student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA18FA004Accident · 2 fatalField investigationFinal reportCessna 401 · Salters, SCThe pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…NTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.NTSB ERA17LA334Accident · Serious injuriesLimited investigationFinal reportMcmillan Joel L Avid SW 65 · Darlington, SCA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.NTSB ERA17LA257Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Myrtle Beach, SCA loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…NTSB ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.NTSB ERA17LA262Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11BC · Gilbert, SCThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion.NTSB ERA17LA256Accident · Minor injuriesLimited investigationFinal reportD & K Baby Belle · Spartanburg, SCThe pilot's failure to maintain helicopter control during the approach to landing.NTSB ERA17LA235Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Greenwood, SCThe pilots' inadequate preflight inspection, during which they failed to adequately verify the quantity of fuel, which resulted in fuel exhaustion, a subsequent total loss of power to both engines, and a forced landing into trees. Contributing to the accident…NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB ERA17LA175Accident · No injuriesLimited investigationFinal reportMooney M20R · Myrtle Beach, SCA total loss of engine power during initial climb for reasons that could not be determined because the airplane sank in the ocean and was not recovered.NTSB ERA17FA164Accident · 1 fatalField investigationFinal reportBell-Carson 47G Super C 4 · Timmonsville, SCThe pilot's decision to maneuver the helicopter at a low altitude near trees, which resulted in collision with the trees.NTSB ERA17LA053Accident · Minor injuriesLimited investigationFinal reportBroussard Broussard MH 1521 · Simpsonville, SCThe pilot’s inability to maintain directional control during the landing roll due to a flat left main landing gear tire.NTSB ERA16LA331Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Camden, SCA total loss of engine power due to the improper torqueing of the magneto, which led it to its malfunctioning in flight.NTSB GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA16CA426Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Cordova, SCThe pilot's failure to maintain the runway heading, which resulted in the airplane not being aligned with the runway and a subsequent runway excursion.NTSB ERA16LA236Accident · No injuriesLimited investigationFinal reportPiper PA34 · Winnsboro, SCThe pilot's failure to maintain sufficient airspeed during a go-around, and the flight instructor's delayed remedial action, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the…NTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).NTSB GAA16CA302Accident · No injuriesData collectionFinal reportPiper PA 28 · Rowesville, SCThe fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.NTSB GAA16CA291Accident · Minor injuriesData collectionFinal reportBilly Amerson Stol CH 750 · Manning, SCThe pilot's failure to maintain directional control during landing, which resulted in an impact with a fence and trees.NTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB ERA16LA148Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Hilton Head Island, SCThe pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.NTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.NTSB GAA16CA170Accident · No injuriesData collectionFinal reportWaco CTO · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA16LA139Accident · 1 fatalLimited investigationFinal reportHall, Wendall W Harmon Rocket II · Cheraw, SCThe pilot's decision to fly at low altitude, which resulted in a collision with power lines.NTSB ERA16LA135Accident · No injuriesLimited investigationFinal reportCessna 210L · Myrtle Beach, SCA complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…NTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.NTSB ERA16LA030Accident · No injuriesLimited investigationFinal reportHughes 369D · Marion, SCA momentary jam in the tail rotor control system from an undetermined source, resulting in a torsional fracture of the tail rotor control torque tube and a loss of helicopter control.NTSB ERA16LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Campobello, SCThe pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.NTSB ERA16FA001Accident · 4 fatalField investigationFinal reportPiper PA32R · Westminster, SCThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB GAA15CA297Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Spartanburg, SCThe pilot's failure to maintain pitch control during the landing which resulted in a bounced landing, and an aerodynamic stall during the attempted recovery.NTSB ERA15CA295Accident · No injuriesData collectionFinal reportStol JA30 Superstol · West Union, SCA loss of engine power while maneuvering due to water contamination in the fuel.NTSB ERA15CA307Accident · Minor injuriesData collectionFinal reportJohnny F Anderson Buckeye Dream Machin · Trenton, SCThe non-certificated pilot's inadequate preflight inspection, which resulted in a loss of directional control during takeoff, and collision with trees during the subsequent rejected takeoff.NTSB ERA15MA259Accident · 2 fatalClass 2 · MajorFinal reportCessna 150M · Moncks Corner, SCThe approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…NTSB ERA15FA221Accident · 1 fatalField investigationFinal reportBR Legend Turbine Legend · West Columbia, SCAn engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…NTSB GAA15CA081Accident · Serious injuriesData collectionFinal reportCitabria 7GCBC · Winnsboro, SCThe pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.NTSB GAA15CA043Accident · No injuriesData collectionFinal reportShort Bros SD 360-300 · Greer, SCThe fuel truck driver's inattention, which resulted in backing over a warning cone and into the horizontal stabilizer of the airplane.NTSB ERA15LA174Accident · Serious injuriesLimited investigationFinal reportG-Dawg Just Acft Highlander · Walhalla, SCThe pilot's failure to maintain airplane control during a go-around in gusting tailwind conditions, which resulted in a collision with trees.NTSB ERA15LA219Accident · 1 fatalLimited investigationFinal reportRainbow Aerotrike · Chesnee, SCThe pilot’s failure to maintain lateral or bank control during takeoff, which resulted in collision with, and subsequent suspension from, a tree. Contributing to the pilot’s fatal injuries was his attempt to jump out of the trike to a nearby tree limb.NTSB ERA15LA062Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Hampton, SCThe pilot’s improper decision to descend the airplane at an airspeed greater than the published best glide speed following an erroneous oil pressure indication, which resulted in an off-airport landing. Contributing to the erroneous oil pressure indication…