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 ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.NTSB ATL07LA026Accident · No injuriesLimited investigationFinal reportRidgway Bensen B8M · Johns Island, SCThe pilots improper preflight planning and decision resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL07CA009Accident · No injuriesData collectionFinal reportLawing Thomas R Exec 162-F · Aiken, SCThe pilot’s failure to adequately compensate for wind conditions during takeoff which resulted in a loss of tail rotor effectiveness and a roll over during an attempted forced landing.NTSB DEN06CA125Accident · Minor injuriesData collectionFinal reportThomas Velocity · Conway, SCthe loss of engine power due to fuel starvation. The cause of the fuel starvation was not determined. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ATL06CA123Accident · No injuriesData collectionFinal reportCessna 172P · Chester, SCThe CFI's failure to initiate a go-around when he noticed the flight was high and fast during the approach resulting in the flight landing long, overrunning the runway, and colliding with trees. Factors in the accident were a tail wind and a wet runway.NTSB ATL06FA122Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Hartsville, SCThe pilot's loss of control of the airplane due to spatial disorientation.NTSB ATL06IA108Incident · No injuriesIncident investigationFinal reportDassault Mystere Falcon 900 · Greenville, SCThe malfunction of the anti-skid system SPAD controller during the landing roll, which resulted in failure of the anti-skid braking system, and a runway overrun.NTSB ATL06LA086Accident · No injuriesLimited investigationFinal reportCessna 150M · Bishopville, SCThe loss of engine power for undetermined reasons during the approach to land, which resulted in an off-airport emergency landing.NTSB ATL06LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Blacksburg, SCThe pilot's failure to abort the takeoff after the airplane failed to achieve adequate airspeed on the takeoff roll for undetermined reasons. This resulted in an abrupt pull up, inadvertent stall, and in flight collision with wires, trees and the ground.NTSB ATL06LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hemmingway, SCA loss of engine power due to a total failure of the No.3 engine cylinder exhaust valve as a result of fatigue from over temperature resulting in a forced landing and collision with trees and the ground.NTSB ATL06LA070Accident · 1 fatalLimited investigationFinal reportLancair Lancair 360 · Charleston, SCThe pilot's failure to maintain sufficient airspeed during a climb to preclude a stall, which resulted in a loss of control and an in-flight collision with terrain. A factor associated with the accident was an inadvertent stall.NTSB ATL06LA060Accident · Serious injuriesLimited investigationFinal reportJust Highlander · Walhalla, SCThe pilot and owner/builders failure to determine the reason for partial loss of engine power resulting in loss of engine power due to fuel system contamination on a subsequent flight.NTSB ATL06CA056Accident · No injuriesData collectionFinal reportCessna 140 · Pageland, SCThe pilot's failure to maintain directional control during a crosswind landing resulting in the airplane veering to the right, colliding with a runway light, and subsequent nose over.NTSB ATL06CA055Accident · No injuriesData collectionFinal reportUrban Air UFM-10 · Lancaster, SCThe pilot's excessive climb angle during a go-around from a bounced landing which resulted in an inadvertent stall and subsequent in-flight collision with trees.NTSB ATL06LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180F · Easley, SCLoss of engine power for undetermined reasons which resulted in a forced landing and subsequent in-flight collision with non-suitable terrain.NTSB ATL06FA044Accident · 6 fatalField investigationFinal reportBeech 200 · N Myrtle Beach, SCThe pilot's failure to maintain control during landing approach for undetermined reasons.NTSB ATL06CA034Accident · No injuriesData collectionFinal reportLabarre Hatz CB1 · Walhalla, SCThe pilot's selection of unsuitable terrain to land. Contributing factors were the wet, soft, grassy runway.NTSB ATL06LA022Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-110P1 · Orangeburg, SCThe pilot's inadequate preflight inspection and her failure to refuel the airplane which resulted in total loss of engine power due to fuel exhaustion, and subsequent in-flight collision with trees.NTSB ATL06LA021Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbia, SCMaintenance personnel's improper installation of the stabilator trim arm which resulted in separation of a bolt, loss of control during takeoff, and a subsequent hard landing.NTSB ATL06LA014Accident · 1 fatalLimited investigationFinal reportMooney M20M · Summerville, SCThe pilot's failure to follow the pre-landing checklist which resulted in a gear up landing and subsequent propeller strike. The pilots improper decision to attempt a go-around after the propeller strike, resulted in a loss of engine power and subsequent…NTSB ATL06CA013Accident · Minor injuriesData collectionFinal reportBeech BE-76 · Greer, SCThe pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.NTSB ATL06CA011Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Bennettsville, SCThe malfunction of the wheel brake assembly due to low fluid level that resulted in a loss of control during the landing roll.NTSB ATL06CA009Accident · Minor injuriesData collectionFinal reportSwing Brian S Quickie Q2 · Beaufort, SCThe pilot's failure to maintain directional control during the landing roll which resulted in a collision with an object.NTSB ATL06CA002Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Pageland, SCThe pilots failure to maintain flying speed during the go-around, which resulted in a stall and the subsequent collision with trees.NTSB ATL05CA151Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 · N. Myrtle Beach, SCThe loss of engine power due to the pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice.NTSB ATL05CA147Accident · Minor injuriesData collectionFinal reportCessna 172G · Ridgeland, SCThe loss of engine power for undertermined reasons which resulted in a collision with objects.NTSB ATL05FA135Accident · 2 fatalField investigationFinal reportBeech V35B · Rock Hill, SCThe pilot's mismanagement of the fuel supply , which resulted in fuel starvation and subsequent loss of engine power.NTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.NTSB ATL05CA127Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Landrum, SCThe pilot's improper use of the flight controls (collective pitch and cylic controls) during a take off to a hover resulting in the helicopter encountering dynamic roll over and rolling over on its right side.NTSB ATL05CA122Accident · Serious injuriesData collectionFinal reportAeronca C3 · Summerville, SCThe maintenance personnel failure to secure the intake valve adjustment jam nut which resulted in excessive valve clearance, and the subsequent loss of engine power.NTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.NTSB ATL05CA129Accident · No injuriesData collectionFinal reportLuscombe 8E · Orangeburg, SCThe pilot's failure to maintain directional control during landing roll.NTSB ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…NTSB ATL05LA073Accident · 1 fatalLimited investigationFinal reportAnderson Mini Mustang · Mullins, SCThe pilot's inadequate visual lookout and the pilot's failure to maintain clearance from trees while maneuvering.NTSB ATL05CA068Accident · No injuriesData collectionFinal reportCessna 310J · Union City, SCThe pilot's delay in aborting the landing. A contributing factor was the pilot's failure to maintain directional control.NTSB ATL05FA066Accident · 2 fatalField investigationFinal reportCessna T206H · Johns Island, SCThe pilot's failure to follow instrument flight procedures and descent below the published minimum descent altitude, which resulted in an in-flight collision with terrain during an instrument approach.NTSB ATL05LA052Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Macedonia, SCThe fatigue cracking of the planetary gear housing, which resulted in the loss of engine power.NTSB ATL05FA043Accident · 1 fatalField investigationFinal reportPiper PA-30 · Charleston, SCThe pilot's inadequate preflight and mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB ATL05FA041Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Bradley, SCThe pilot's loss of control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with trees and the ground. A factor was the dark night conditions.NTSB ATL05FA034Accident · 3 fatalField investigationFinal reportDiamond DA40-180 · Pelzer, SCThe pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.NTSB ATL05CA019Accident · Serious injuriesData collectionFinal reportCessna 172N · Columbia, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.NTSB ATL05FA011Accident · 1 fatalField investigationFinal reportBeech BE-P35 · Aiken, SCThe pilot’s failure to follow IFR procedures, and continued flight below the minimum descent altitude and collided with trees.NTSB ATL05LA009Accident · 2 fatalLimited investigationFinal reportNorth American Harvard II T-6 · Leesville, SCLoss of engine power due to fuel system contamination which blocked the flow of fuel which resulted in fuel starvation.NTSB ATL05CA015Accident · No injuriesData collectionFinal reportCessna 172SP · West Columbia, SCThe student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.NTSB ATL04CA193Accident · No injuriesData collectionFinal reportCessna 177 · Anderson, SCThe pilot's inadequate preflight planning of fuel required for the flight and his improper in-flight decision, which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB ATL04CA184Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mount Pleasant, SCGround collision with an animal (deer) during an attempted takeoff.NTSB ATL04CA163Accident · Minor injuriesData collectionFinal reportCessna 172 · Inman, SCThe pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.NTSB CHI04MA182Accident · 4 fatalMajor investigationFinal reportBell 407 · Newberry, SCThe pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.