Fatal NTSB investigations, SC
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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'
AND c.\"highestInjuryLevel\" = 'Fatal'
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' AND c."highestInjuryLevel" = 'Fatal' 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 ERA09FA515Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Rock Hill, SCThe pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.NTSB ERA09LA501Accident · 2 fatalLimited investigationFinal reportKeithley Thomas E Starduster Too · St. Matthews, SCA loss of airplane control during approach for undetermined reasons.NTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.NTSB ERA09LA176Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ridgeland, SCThe pilot's failure to maintain control of the airplane during a precautionary landing. Contributing to the accident was a partial loss of engine power for undetermined reasons.NTSB ERA09FA148Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Moncks Corner, SCA loss of aircraft control during the landing approach for undetermined reasons.NTSB ERA09LA019Accident · 1 fatalLimited investigationFinal reportHargett Sky Ranger II · Rock Hill, SCThe non-certificated pilot's failure to maintain airspeed, which resulted in an inadvertent stall and a subsequent impact with the ground. Contributing to the accident were the pilot's lack of training and his impairment due to recent use of marijuana.NTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…NTSB NYC07LA124Accident · 2 fatalLimited investigationFinal reportBoeing Stearman A75N1 · Charleston, SCAn in-flight collision with water for undetermined reasons.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.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 ATL06FA122Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Hartsville, SCThe pilot's loss of control of the airplane due to spatial disorientation.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 ATL06FA044Accident · 6 fatalField investigationFinal reportBeech 200 · N Myrtle Beach, SCThe pilot's failure to maintain control during landing approach for undetermined reasons.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 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 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 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 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 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 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 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.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 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 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 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 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 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 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 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 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 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 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 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 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.NTSB MIA02LA027Accident · 2 fatalLimited investigationFinal reportMooney M-20-20 · Hilton Head, SCThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control, an uncontrolled descent, and an impact with the water.NTSB MIA01FA206Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-35 · Hilton Head, SCImproper maintenance/installation and and inadequate inspection of the airplane's flap torque tube joints during routine maintenance by company maintenance personnel, which resulted in the right flap torque tube assembly coupler becoming detached and the…NTSB MIA01FA192Accident · 1 fatalField investigationFinal reportBeech BE-35-F35 · Bamberg, SCthe failure of the pilot to maintain airspeed, while attempting a forced landing following a loss of engine power for undetermined reasons, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain. A factor in this accident was…NTSB MIA01LA164Accident · 1 fatalLimited investigationFinal reportBroyles P51 · Conestee, SCPartial loss of engine power due to an engine cylinder experiencing detonation resulting in a forced landing to none suitable terrain.NTSB MIA01FA071Accident · 2 fatalField investigationFinal reportMooney M20R · Bluffton, SCThe pilot's failure to maintain control due to spatial disorientation.NTSB MIA00FA117Accident · 1 fatalField investigationFinal reportCessna 177RG · Columbia, SCThe PIC's inadequate planning and preparation resulting in refueling not being performed and the subsequent fuel exhaustion and forced landing into trees. A factor in the accident was the erratic operation of the right fuel tank quantity indicating system.