NTSB investigations, SC
40 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 3 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 5 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 1 |
| 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\", '030220'))
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", '030220')) 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 ERA26LA234Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mayesville, SCThe pilot’s failure to remain clear of a power line during an aerial application flight.NTSB ERA26LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Greenville, SCAn in-flight collision with a bird during cruise flight.NTSB ERA24LA273Accident · No injuriesClass 4 · LimitedFinal reportConstruzioni Aeronautiche Tecn P2004 Bravo · Laurens, SCAn in-flight collision with a bird while in cruise flight.NTSB ERA24LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orangeburg, SCThe student pilot’s failure to maintain adequate clearance from a fuel truck while taxiing. Also contributing was the flight instructor’s inadequate monitoring of the student pilot.NTSB ERA23LA391Accident · Minor injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7 · Anderson, SCThe pilot’s failure to avoid trees during the descent for landing, resulting in substantial damage to the balloon.NTSB ERA23LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Spartanburg, SCA partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.NTSB ERA23LA039Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Kingstree, SCThe airplane’s impact with two deer during the landing roll.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 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 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 ERA21LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Charleston, SCThe airplane's impact with a deer during takeoff.NTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.NTSB GAA20CA066Accident · No injuriesData collectionFinal reportAmerican AA 5 · Gilbert, SCThe pilot's improper approach path, which resulted in impact with a tree.NTSB GAA20CA001Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Longs, SCThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing, and impact with trees.NTSB GAA19CA477Accident · No injuriesData collectionFinal reportCessna 172 · Greer, SCThe pilot's improper decision to continue a steep and fast approach to landing, which resulted in a runway overrun and collision with a drainage culvert.NTSB GAA19CA429Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · Coward, SCThe noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.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 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 GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.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 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 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 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 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 ERA14LA425Accident · Minor injuriesLimited investigationFinal reportNavion Navion · Rock Hill, SCThe pilot’s improper fuel management, which resulted in the exhaustion of the fuel supply in the selected fuel tank and a subsequent total loss of engine power.NTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.NTSB ERA14CA172Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Saluda, SCAn inadvertent encounter with a deer during the takeoff roll.NTSB ERA13LA264Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Williamson, SCThe pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.NTSB ERA13CA208Accident · No injuriesData collectionFinal reportCessna 140 · Lancaster, SCThe pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA11LA208Accident · 1 fatalLimited investigationFinal reportJennings John C Mini Max · Clinton, SCThe pilot's inadequate performance planning, which resulted in a collision with a tree during takeoff.NTSB ERA10LA247Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Clemson, SCThe airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.NTSB ERA09LA378Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Loris, SCThe crew's failure to see and avoid a steel pole during a nighttime approach to the helipad.NTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.NTSB LAX08CA219Accident · No injuriesData collectionFinal reportTallent, Chris M. Putts Special · Sumter, SCthe pilot's failure to maintain the proper glideslope and clearance from obstacles. Contributing to the accident was the pilot's limited experience in the airplane type.NTSB MIA08CA124Accident · No injuriesData collectionFinal reportCessna 172S · Orangeburg, SCThe pilot's failure to obtain the proper touchdown point on landing.