NTSB investigations, SC
53 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 MIA07LA131Accident · No injuriesLimited investigationFinal reportMBB BK-117 A-4 · Ridgeville, SCThe EMS helicopter pilot's failure to ensure adequate obstacle clearance which resulted in the tail rotor impacting a tree during the takeoff.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 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 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 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 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 ATL03LA066Accident · Serious injuriesLimited investigationFinal reportDaigneault EAA BI-PLANE · Easley, SCThe pilots failure to maintain clearance while maneuvering on initial climb out resulting in an in-flight collision with a residence.NTSB MIA02LA154Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Union, SCthe pilot's failure to maintain obstacle clearance.NTSB ATL02TA021Accident · No injuriesFinal reportBell 206 · Awendaw, SCThe pilot's failure to maintain clearance from the bambi bucket suspension assembly during dip operation.NTSB MIA00LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pelzer, SCThe student pilot's failure to recognize and compensate for changing wind conditions while on final approach and landing and his failure to initiate a timely go-around, resulting in collision with trees and a utility pole.NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB ATL98LA092Accident · 1 fatalLimited investigationFinal reportCessna 182 · Green Sea, SCThe inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.NTSB MIA98LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe pilot's delay in initiating a go-around, which resulted in an inflight collision with power lines.NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).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 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 MIA96LA050Accident · 2 fatalLimited investigationFinal reportNanchang China CJ6A · Planterville, SCfailure of the pilot to maintain sufficient altitude or clearance from trees.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 ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.NTSB ATL95FA079Accident · 1 fatalField investigationFinal reportCessna 172F · Seneca, SCThe pilot's inadequate visual lookout while maneuvering near utility lines, which resulted in a collision with the wires.NTSB ATL95LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greer, SCThe pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.NTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.NTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.NTSB ATL92LA157Accident · No injuriesLimited investigationFinal reportBeech 23-B24R · Walterboro, SCThe inadequate preflight planning by the pilot in command. Factors were the soft runway, and the high density altitude which existed at the time of the attempted departure.NTSB ATL92LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Socastee, SCThe failure of the pilot to maintain proper clearance from terrain during the maneuver. Factors in the accident were the failure of the pilot to release the banner, and the excessive size of the banner.NTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.NTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.NTSB ATL91LA080Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Saluda, SCThe flight instructor did not maintain the proper altitude during the simulated forced landing.NTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.NTSB ATL88LA151Accident · Serious injuriesLimited investigationFinal reportCirrus Design Standard · Chester, SCThe glider pilot failed to maintain sufficient altitude while on final approach for landing and struck trees.NTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…NTSB ATL87LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Greenville, SCBalloon dtpted launch site about six miles sw of landing airport for a key grab during a Balloon ralley. Wind was about seven KTS according to PIC. Approaching field to land basket was dragged through tree tops to slow Balloon. Power line hidden by the trees…NTSB ATL86LA056Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Conway, SCDuring night flight instruction for takeoff and landing practice, the aircraft collided with trees off the approach end of the runway and impacted the ground 800 feet short of the runway. The runway had been recently extended and the trees off the end of the…NTSB ATL86LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Greer, SCWhile on an ILS rwy 03 aprch at Greer, SC, the pilot descended below dh and collided with trees approx 500 ft left of runway centerline. The plt related that he descended below dh because he observed what he thought were the aprch lights.NTSB ATL86FA007Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Charleston, SCThe aircraft was observed on radar as it approached the joint civil - military airport. It passed over near the center of the airport at about 200 feet AGL. There was no reported communication with the aircraft. Several sighting placed the aircraft under at…NTSB ATL85FA272Accident · Serious injuriesField investigationFinal reportMBB BK-117A-1 · Aiken, SCPlt was maneuvering helicopter at low alt and into rising terrain. On 3rd right turn racetrack pattern, witnesses observed acft descend slightly, roll into a 45 deg or greater bank and contact trees. The acft started a yawing rotation to the right and…NTSB ATL85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Columbia, SCThe plt stated that during takeoff the right main gear struck a large dog which ran onto the rwy. The takeoff was continued & the plt circled the arpt for 2 hrs to burn off excess fuel before performing a ldg with the nose gear & the left main ldg gear…NTSB ATL85MA049Accident · 1 fatalMajor investigationFinal reportBeech 58 · Charleston, SCPlt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…NTSB ATL84LA140Accident · No injuriesLimited investigationFinal reportCessna 172N · Winnsboro, SCThe acft was making a precautionary landing because the fuel guages were indicating 'empty'. Following touchdown the pltsaw a barbed wire fence and attempted a go-around & struck the fence. After making ground contact a second time the acftcontinued through…NTSB ATL84FA115Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Spartanburg, SCThe acft collided with trees during a landing at a company helipad. The weather was IMC with low ceilings and fog. The acft had been cleared for a VOR approach monitored by radar. The co-plt spotted the pad and called it out to the plt who started a steep…NTSB ATL84FA084Accident · 4 fatalField investigationFinal reportRockwell 690B · Greenville, SCAs the plt was making an ILS approach in IMC weather, the acft descended into trees & crashed about 1-1/2 mi from the rwy threshold. The descision height for this approach was 1316 ft MSL & was located less than a mile from the threshold.a controller said…NTSB ATL84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Clemson, SCThe pilot failed to lower the landing gear stating that he was distracted by an acft on the ground & diverted his attention from the landing checklist.NTSB ATL84LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe purpose of the flt was to take pictures over lake murray. The plt stated that after taking off, he proceeded over the lake, then descended & varied his altitude between 400 & 800 ft MSL, so the passenger could take pictures. Shortly after rounding a bend…NTSB ATL83LA245Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe student plt was practicing landings on rwy 7 & completed 1 successful landing. He reported that on the 2nd approach, a gust of wind blew the acft to the left, so he made a go-around. A 3rd approach was made with the acft lined up slightly to the left of…NTSB ATL83LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Pickens, SCThe acft collided with two birds while cruising at 6000 ft MSL. The weather was VFR but the acft was on IFR flt plan. The acfts left wing was damaged but there were no injuries. The plt stated that although he heard a thud on the left side of the acft he was…NTSB ATL83FLG02Accident · Serious injuriesFinal reportPiper 32RT-300T · Hilton Head, SCThe aircraft collided with trees after takeoff. The pilot stated he held 80 or 90 KTS indicated and started what he thought was a normal climb. During gear retraction, the aircraft hit the trees.