NTSB investigations, SC
187 cases where NTSB found Task performance.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 17 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 14 |
| 2013 | 9 |
| 2014 | 10 |
| 2015 | 9 |
| 2016 | 12 |
| 2017 | 6 |
| 2018 | 17 |
| 2019 | 13 |
| 2020 | 6 |
| 2021 | 11 |
| 2022 | 8 |
| 2023 | 15 |
| 2024 | 3 |
| 2025 | 10 |
| 2026 | 2 |
Where
Open the mapLatest cases
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206')) 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 ERA26LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mount Pleasant, SCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB ERA26LA154Accident · Minor injuriesClass 4 · LimitedFinal reportBeech V35 · Saluda, SCThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, collision with a fence, and a hard landing .NTSB ERA26LA022Accident · No injuriesClass 4 · LimitedFinal reportRans Employee Flying Club Rans S-6ES Coyote II · Williston, SCThe pilot’s failure to maintain directional control of the airplane during the initial climb in gusting crosswind conditions.NTSB ERA26LA017Accident · Serious injuriesClass 4 · LimitedFinal reportTricks Trike Storm · Gaffney, SCThe pilot’s failure to maintain aircraft control during the initial climb, which resulted in an impact with terrain.NTSB ERA25LA336Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Ridgeland, SCThe pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot.NTSB ERA25LA252Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Pelzer, SCThe pilot’s failure to maintain proper airspeed while landing on a short, down-sloping turf runway, which resulted in a noseover.NTSB ERA25LA374Accident · No injuriesClass 4 · LimitedFinal reportFlying Cloud AL18 · Ridgeland, SCThe pilot’s failure to maintain directional control of the airplane during landing.NTSB ERA25LA162Accident · Serious injuriesClass 4 · LimitedFinal reportRuys Nicholas G RV-8 · Bennettsville, SCThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing.NTSB ERA25LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Anderson, SCThe pilots’ overcorrection during the landing roll which resulted in a loss of directional control and runway excursion. Contributing was the flight instructor’s inability to correct the pilot’s actions because due to brakes only being installed on the…NTSB ERA25LA136Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · North Myrtle Beach, SCThe pilot’s failure to maintain directional control while attempting to land in a gusty crosswind, which resulted in a runway excursion.NTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.NTSB ERA25LA097Accident · No injuriesClass 4 · LimitedFinal reportJonathan C Eggers Challenger II · Conway, SCThe pilot's inadequate fuel planning, which resulted in a total total loss of engine power due to fuel exhaustion.NTSB ERA25LA094Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Florence, SCThe pilot’s failure to follow the emergency procedures and extend the landing gear manually after the landing gear did not initially extend normally.NTSB ERA24LA393Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ravenel, SCThe pilot’s failure to maintain clearance from terrain, which resulted in the right skid contacting the ground and a subsequent rollover.NTSB ERA24LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCorella Neil RV9A · Saluda, SCThe pilot’s failure to maintain an appropriate glide path during the landing approach in variable wind conditions, which resulted in collision with trees.NTSB ERA24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 112 · Saluda, SCThe pilot’s failure to maintain directional control of the airplane during an aborted landing in crosswind conditions. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA23LA387Accident · No injuriesClass 4 · LimitedFinal reportJohn W Moll Vans RV-7 · Liberty, SCThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and substantial damage to the left wing and left horizontal stabilizer.NTSB ERA23LA342Accident · 2 fatalClass 3 · LimitedFinal reportBeech C23 · Greer, SCA partial loss of engine power during the initial climb due to the formation of carburetor ice, resulting in reduced climb capability. Contributing to the accident was the pilot’s failure to maintain proper airspeed during the emergency descent, which…NTSB ERA23LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · North Myrtle Beach, SCThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA329Accident · Serious injuriesClass 4 · LimitedFinal reportEipper Formance Mxii · Holy Hill, SCThe pilot’s exceedance of the critical angle of attack during the initial climb, which resulted in an aerodynamic stall at low altitude and a collision with a hangar. Contributing to the accident was the pilot’s lack of experience in the accident make and…NTSB ERA23LA319Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · North Charleston, SCA failure of the tail rotor pitch change lever assembly due to incorrectly installed bolts and maintenance personnel’s inadequate inspection of the tail rotor control system.NTSB ERA23LA356Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA287Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCThe pilot’s failure to maintain control of the helicopter during a hover taxi, which resulted in a rollover.NTSB ERA23FA280Accident · 5 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · North Myrtle Beach, SCThe pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…NTSB ERA23LA289Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Anderson, SCThe mechanics’ improper torquing of the main rotor blade dampers, which resulted in a ground resonance event during landing.NTSB ERA23FA235Accident · No injuriesClass 3 · FieldFinal reportHonda HA-420 · Summerville, SCThe pilot’s improper calculation of the airplane’s landing approach speed and required landing distance, which resulted in the airplane touching down fast with inadequate runway available, and a subsequent runway excursion.NTSB ERA23FA164Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Johns Island, SCThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s degraded judgement and…NTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.NTSB ERA23LA160Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Abbeville, SCA loss of directional control during landing, which resulted in a ground loop and substantial damage to the airplane. The pilot flying could not be determined since both pilots claimed that the other was at the controls during the landing. The flight…NTSB ERA23LA168Accident · No injuriesClass 4 · LimitedFinal reportWeiss Theodore T RV-8 · Ridgeland, SCThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA23LA049Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Greenville, SCThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing was the pilot’s failure to use the checklist aboard the airplane during her attempts to restore engine power.NTSB ERA23LA052Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Columbia, SCThe pilot’s failure to maintain directional control during the crosswind landing.NTSB CEN22FA419Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28R-201 · Conway, SCThe mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…NTSB ERA22LA337Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Pelion, SCThe pilot’s improper landing flare during a practice autorotation.NTSB ERA22LA319Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Charleston, SCThe failure of the torsion spring inside the drive clutch assembly of the landing gear actuator which prevented normal and manual extension of the landing gear.NTSB ERA22FA243Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · North Myrtle Beach, SCThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.NTSB ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB ERA22LA201Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Union, SCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.NTSB ERA22LA032Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Pickens, SCThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and collision with rocky terrain.NTSB ERA22FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Walterboro, SCThe pilot’s inadequate fuel planning and fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA22LA025Accident · Serious injuriesClass 4 · LimitedFinal reportPipistrel Apis-Bee · Columbia, SCThe pilot’s failure to maintain control of the glider during the landing approach, which resulted in an aerodynamic stall and subsequent impact with the runway.NTSB ERA22LA019Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Mount Pleasant, SCThe pilot’s failure to maintain clearance with the parked fuel truck while taxiing for takeoff. Contributing to the outcome was the pilot’s decision to park the airplane in the congested ramp area and his excessive taxi speed.NTSB ERA21LA316Accident · No injuriesClass 3 · LimitedFinal reportSocata TBM-700 C2 · Mount Pleasant, SCThe pilot’s decision to continue an unstable approach, which resulted in a runway excursion.NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB ERA21LA208Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aerospace Industries Gulfstream G150 · Ridgeland, SCThe flight crew’s continuation of an unstable approach and the failure of the ground air brakes to deploy upon touchdown, both of which resulted in the runway overrun. Contributing was the crew’s motivation and response to external pressures to complete the…NTSB ERA21LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Orangeburg, SCThe student pilot’s improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA21LA101Accident · 1 fatalClass 3 · LimitedFinal reportBeech F33 · Columbia, SCThe pilot's in-flight loss of airplane control due to spatial disorientation during a missed approach in instrument meteorological conditions.NTSB ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.