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 ATL97LA103Accident · No injuriesLimited investigationFinal reportHughes 269C · Johnston, SCfailure of the pilot to maintain the proper rotor RPM during the approach and flare for landing.NTSB ATL97FA090Accident · 1 fatalField investigationFinal reportBeech 35-C33A · Lugoff, SCimproper fuel management by the pilot by not positioning the fuel selector to the fullest tank for landing, which resulted in fuel starvation, loss of engine power, and a forced landing. Trees in the emergency landing area were a factor.NTSB MIA97LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Orangeburg, SCFailure of the pilot to recover from the bounced landing. Contributing to the accident was the pilots complacency.NTSB MIA97LA184Accident · No injuriesLimited investigationFinal reportCessna 150G · Greer, SCthe student pilot's improper management of fuel, which resulted in fuel exhaustion, loss of engine power, and subsequent collision with trees and terrain.NTSB ATL97LA083Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Orangeburg, SCThe pilot experienced a partial loss of engine power for undetermined reason. The pilot failed to maintain flying airspeed which resulted in a stall and then subsequent collision with the ground. A factor was, conditions were favorable for the formation of…NTSB ATL97LA081Accident · No injuriesLimited investigationFinal reportCessna 172I · N. Myrtle Beach, SCThe pilot's inadequate pre-flight inspection which resulted in fuel exhaustion and total loss of engine power. A factor was the soft terrain at the emergency landing site.NTSB MIA97LA169Accident · No injuriesLimited investigationFinal reportCessna Wren 182G-460 · Spartanburg, SCthe pilot's inadequate preflight planning/preparation, by failure to survey the takeoff area, and his delay in aborting the takeoff. Upsloping terrain and high vegetation in the takeoff area were related factors.NTSB MIA97FA162Accident · 1 fatalField investigationFinal reportCessna R182 · N. Myrtle Beach, SCthe pilot's failure to maintain airspeed during a go-around resulting in an inadvertent stall.NTSB MIA97LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Pickens, SCfailure of the student pilot to maintain directional control during the takeoff roll from a touch-and-go landing, which resulted in the airplane going off the side of the runway, down an embankment, and into brush/trees.NTSB MIA97LA115Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Columbia, SCThe pilot's inadequate planning/decision and failure to assure an adequate supply of fuel was on board the airplane.NTSB MIA97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · St Matthews, SCthe pilot's improper decision to take off downwind with gusty wind conditions.NTSB ATL97LA052Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Lancaster, SCthe pilot's improper use of the spoilers, while approaching to land, which allowed the glider to get low on final approach and strike trees. The pilot's lack of recent flying experience and lack of experience in the make and model of glider were related…NTSB ATL97LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Aikens, SCexcessive wear of the fuel metering unit/shaft, which resulted in a fuel leak and premature exhaustion of the fuel supply.NTSB MIA97LA088Accident · Minor injuriesLimited investigationFinal reportLearjet LR35 · Greenville, SCThe pilot-in-command's failure to achieve the proper touchdown point on a known wet runway, resulting in a subsequent overrun and on ground collision with a ditch.NTSB ATL97LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Anderson, SCThe pilot's improper recovery from a bounced landing. A factor was the pilot's improper level off.NTSB MIA97LA055Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Florence, SCThe pilot-in-command's improper management of fuel resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL97FA092Accident · 2 fatalField investigationFinal reportCessna 182 · Charleston, SCThe noninstrument-rated pilot's failure to remain clear of instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. A factor was the pilot's failure to obtain a weather briefing.NTSB MIA97LA024Accident · No injuriesLimited investigationFinal reportCessna 182C · Anderson, SCthe pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.NTSB ATL97LA002Accident · Serious injuriesLimited investigationFinal reportBell UH-IB · Bennettsville, SCthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of usable fuel. A factor relating to the accident was: an inoperative left boost pump, which increased the amount of unusable fuel…NTSB MIA97LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartsville, SCThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an inadvertent stall, and subsequent in-flight collision with terrain and nose over.NTSB ATL96LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Georgetown, SCfailure of maintenance personnel to comply with an airworthiness directive, requiring periodic magneto inspections; inadequate annual inspection of the airplane by (other) maintenance personnel; and subsequent failure of the impulse coupling in the left…NTSB MIA96LA217Accident · No injuriesLimited investigationFinal reportPiper J3 · Aiken, SCthe pilot's improper flare, which resulted in a hard landing; and his loss of directional control, which was followed by impact with trees.NTSB ATL96FA114Accident · 1 fatalField investigationFinal reportCessna TU206A · Greer, SCThe disintegration of the number 3 piston, and the pilot's inadequate selection of terrain for the landing.NTSB MIA96LA190Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Georgetown, SCfailure of the pilot to see-and-avoid an obstruction on the ground (inadequate visual lookout) during a precautionary landing, which resulted in a collapsed nose gear and subsequent nose over. Factors relating to the accident were: the adverse weather…NTSB ATL96LA107Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Scotia, SCa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for a forced landing.NTSB MIA96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Jonesville, SCthe pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.NTSB MIA96FA148Accident · 1 fatalField investigationFinal reportAeronca O-58B · Greenville, SCthe pilot's failure to maintain adequate altitude/clearance from power lines while maneuvering at a low altitude.NTSB MIA96FA130Accident · 1 fatalField investigationFinal reportHelio H-295 · Gaffney, SCfailure of the pilot to remove the control lock during the preflight, and his failure to check the flight controls before taking off.NTSB MIA96IA114Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2G-30 · Columbia, SCfailure of the nose landing gear bearing due to improper assembly and staking (inadequate quality control) by the manufacturer; which prevented the nose gear from retracting and the main gear from extending, and resulted in a subsequent landing on the nose…NTSB ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.NTSB MIA96LA101Accident · No injuriesLimited investigationFinal reportSummerfeldt Thorp T-18 · Hampton, SCThe pilot's improper planning/decision and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: the pilot's failure to use a preflight briefing service, the adverse weather conditions, and soft terrain in the…NTSB ATL96FA049Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Johns Island, SCthe pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.NTSB ATL96LA041Accident · No injuriesLimited investigationFinal reportBeech 23 · Mc Coll, SCthe pilot's failure to maintain aircraft control.NTSB ATL96LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, SCthe failure of the student pilot to maintain airspeed while raising the flaps during the go-around.NTSB MIA96FA067Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-60 · West Columbia, SCa total loss of power on one engine for undetermined reasons, and the pilot-in-command's failure to maintain airspeed (VMC) resulting in an in-flight loss of control. Contributing to the accident was the wind gusts encountered while on final approach to land.NTSB MIA96LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Eastover, SCinadequate overhaul procedures by maintenance personnel resulting in an oil pump failure and subsequent loss of engine power.NTSB MIA96LA050Accident · 2 fatalLimited investigationFinal reportNanchang China CJ6A · Planterville, SCfailure of the pilot to maintain sufficient altitude or clearance from trees.NTSB ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationNTSB ATL96FA022Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Greenwood, SCthe loss of engine power for undetermined reason.NTSB ATL96LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA 315 · Manning, SCThe loss of engine power during takeoff for undetermined reason(s).NTSB ATL96LA031Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, SCAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of engine power. The tree stump was a factor.NTSB ATL96LA012Accident · No injuriesLimited investigationFinal reportWaco ASO · Ridgeland, SCFailure of the ignition system after takeoff, which resulted the loss of engine power.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 ATL95LA172Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lynchburg, SCThe failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.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 ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB ATL95LA144Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Allendale, SCThe pilot's failure to see and avoid the guy wire. Factors in the accident were the weather and the pilot's unfamiliarity with the terrain.NTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.NTSB ATL95LA134Accident · Minor injuriesLimited investigationFinal reportStafford Aerosport Scamp · Abbeville, SCThe improper engine overhaul which resulted in metal contamination of the engine assembly.