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 ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB ATL89LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Edgefield, SCPoor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.NTSB ATL89LA201Accident · No injuriesLimited investigationFinal reportBeech A-36 · Charleston, SCThe pilot's failure to maintain clearance from other parked aircraft while taxiing.NTSB ATL89LA199Accident · No injuriesLimited investigationFinal reportHughes 269A · Saluda, SCStudent pilot's improper use of the flight controls during lift-off and inadequate supervision by the flight instructor.NTSB CHI89FA157Accident · 1 fatalField investigationFinal reportCessna 152 · York, SCFailure of the pilot to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: excessive workload (task overload) and diverted attention.NTSB ATL89LA186Accident · No injuriesLimited investigationFinal reportCessna 172L · N Myrtle Beach, SCWater contamination of the airplane fuel supply, and the pilot's failure to adequately preflight the aircraft. A factor related to the accident was: swampy terrain at the emergency landing site.NTSB ATL89FA182Accident · 3 fatalField investigationFinal reportCessna 172G · Ridgeland, SCImproper planning/decision by the pilot-in-command (PIC), which resulted in an inadvertent stall during takeoff. Factors related to the accident were: the excessive gross weight and improper lift-off by the PIC, the pilot/passenger's improper crew…NTSB ATL89LA179Accident · No injuriesLimited investigationFinal reportCessna P210N · Jackson, SCThe pilot's mismanagement of the available fuel supply which resulted in a total loss of engine power. The fuel selector was not positioned to the tank which contained fuel. Contributing factor(s) was: the rough terrain encountered during the forced landing.NTSB ATL89LA176Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Holly Hill, SCPilot misjudged his landing approach path and crossed the runway threshold too high to safely complete the landing. He also flared the airplane at too high an altitude resulting in a stall to a hard touchdown on the nose wheel exceeding the structural…NTSB BFO89FA048Accident · 4 fatalField investigationFinal reportCessna 172P · Caesars Head, SCFailure of the pilot to maintain sufficient airspeed while flying over rising terrain, which resulted in an inadvertent stall and collision with wooded terrain. Factors related to the accident were: the terrain conditions and failure of the pilot to maintain…NTSB ATL89FA165Accident · 4 fatalField investigationFinal reportBeech B-60 · Gaston, SCThe pilot exercised questionable judgement in initiating a flight into an area of known thunderstorms. Further, either deliberately or inadvertantly entered a thunderstorm and overstressed the airframe structure resulting in an inflight separation of the…NTSB ATL89FA157Accident · 1 fatalField investigationFinal reportCessna 150K · N. Myrtle Beach, SCThe pilot's confusion and diverted attention regarding the multiple banner release system in the cockpit resulting in an inadvertent stall/spin into the terrain from a low altitude. Also causal was the pilot attempting the abrupt maneuver at the low airspeed…NTSB ATL89LA156Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Myrtle Beach, SCThe improper installation/modification of the banner tow system, which jammed the rudder during a landing. The wind and terrain conditions were related factors.NTSB ATL89LA143Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Lugoff, SCInadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…NTSB ATL89FA130Accident · Serious injuriesField investigationFinal reportBell UH-1E · Aiken, SCImproper installation of a tail rotor pitch change crosshead retention bolt by the company mechanic, which resulted in loosening of the bolt and eventual failure of the tail rotor assembly/blade and subsequent loss of control. Trees at the crash site…NTSB ATL89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Barnwell, SCThe pilot's poor in-flight planning/decision in continuing flight to the destination airport without refueling which resulted in fuel exhaustion. Unfavorable winds and inadequate fuel consumption calculations were contributing factors.NTSB ATL89LA117Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Timmonsville, SCThe pilot's failure to remain aware of the local wind conditions. Additionally, he executed the approach and landing with excessive speed, combined with a tailwind, which resulted in the runway overrun.NTSB ATL89DLG01Accident · No injuriesFinal reportUpchurch Rotorway Executive · Lugoff, SCImproper evaluation of existing conditions during preflight inspection resulting in a dynamic rollover due to drag from an imbedded left skid.NTSB ATL89LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Kershaw, SCFatigue failure of the crankshaft dowel pin. Factors related to the accident were: failure of maintenance personnel to follow the applicable service bulletin and darkness.NTSB ATL89LA109Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pickens, SCImproper flare by the pilot and inadequate supervision of the flight by the other crew member.NTSB ATL89LA097Accident · No injuriesLimited investigationFinal reportCessna 180J · W. Columbia, SCImproper torquing of the attachment bolt during installation by unknown person(s), which resulted in the separation of the bolt and nut and subsequent separation of the main landing gear from the airplane.NTSB ATL89LA074Accident · No injuriesLimited investigationFinal reportCessna T210N · Florence, SCThe failure of maintenance personnel to properly torque the thru bolts during number 2 cylinder installation. Contributing factors to the accident were terrain features which led to the collapse of the nose gear during landing.NTSB ATL89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Mill, SCTwo days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…NTSB ATL89IA026Incident · No injuriesIncident investigationFinal reportBeech 58 · Georgetown, SCThe plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched…NTSB ATL89LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Hilton Head Is., SCThe plt reported that the airplane lost power shortly after takeoff. A forced ldg was subsequently made in a swamp near the arpt. The airplane nosed over during rollout. Post-crash exam of the airplane revealed that the throttle cable outer casing had become…NTSB ATL89LA001Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Ridgeland, SCThe plt reported that the left brake failed to function during taxi when he attempted to reduce speed and turn 180 deg into t/o position. The airplane began to track to the right. He released brake pressure on both pedals thinking that he might have been…NTSB ATL88LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot was conducting his first SOL0 flight, when he lost directional control and collided with three parked airplanes. The student said that his right foot slipped off the rudder pedal; attempts to recover failed. The pilot did not report any…NTSB ATL88LA249Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Saluda, SCThe instructor pilot reported that they were conducting autorotation training. During an autorotation the crew delayed initiating the power recovery. The helicopters struck the ground causing substantial damage. The pilots did not report experiencing a system…NTSB ATL88FA239Accident · Serious injuriesField investigationFinal reportBoeing 767 · Charleston, SCNTSB ATL88IA238Incident · No injuriesIncident investigationFinal reportBell 47G · N Myrtle Beach, SCNTSB ATL88LA236Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bamberg, SCWhile at cruise, the pilot reported hearing a ticking sound coming from the engine. Shortly afterward the eng quit. During the emergency landing, the airplane nosed over. Engine examination disclosed that teeth from the crankshaft and camshaft gears were…NTSB ATL88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rock Hill, SCThe plt reported that the engine began to run rough & lose pwr while he was circling some property he owned. He subsequently attempted to land at a nearby ultralight airstrip. He stated that he didn't remember anything after that. The airstrip owner reported…NTSB ATL88LA234Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Ridgeland, SCThe pilot experienced a complete power loss about four hours after departing pompano beach. The pilot had varied his altitude throughout the flight. The flight manual indicates that the acft could fly about 3.8 hours, at 2500 feet altitude, on 48 gallons of…NTSB ATL88FA230Accident · 3 fatalField investigationFinal reportBeech 60 · Pageland, SCThe airplane was observed to approach the airport from the northwest. As it crossed the northeast end of the runway, it initiated a right turn to cross the runway about the midpoint to a position for a left downwind for landing on runway 5. Its altitude was…NTSB ATL88LA225Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · N. Myrtle Beach, SCThe plt reported that he made a low pass over the banner staging area to drop a banner; the release mechanism in the cockpit failed to operate and the banner remained in tow. Xwind conditions blew the banner into another banner on the ground which was…NTSB ATL88LA223Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Laurens, SCThe plt rprtd that when he landed, everything seemed normal until he was lowering the nose to the rwy drg the landing roll. At that time, the left wing began to settle. At first, he thought the left tire was going flat, but the settling continued.…NTSB ATL88FA213Accident · Serious injuriesField investigationFinal reportBell TH-1L · Walterboro, SCThe military surplus helicopter experienced a 42 degree gear box failure while lifting a load of logs. The helicopter subsequently landed hard as the plt was attempting to autorotate to a ldg. Metallurgical examination of the gearbox revealed that a gear…NTSB ATL88FA211Accident · Serious injuriesField investigationFinal reportCessna 175 · Ninety Six, SCThe pilot was cruising the airplane at 2,000 feet AGL when he noted a loss of oil pressure and increase in oil temperature. He also noted a loss in engine power. He elected to make a landing off airport and set up a pattern for the selected field. The…NTSB ATL88LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, SCThe student & instructor (CFI) were on a practice short field apch, simulating a 50' obstacle. The CFI rprtd that as the acft came over the threshold at about 40' AGL, the airspeed was 60 mph & the flaps were extended 40 deg. The studentreduced the power to…NTSB ATL88LA197Accident · Serious injuriesLimited investigationFinal reportAeronca 0-58B · Newberry, SCThe pilot related that he had been flying around the local area making landings at various airports for about 1 1/2 hours. He returned to the departure airport and made a full stop landing. His 12 year old son requested that he make another takeoff and…NTSB ATL88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccormick, SCThe student pilot was on her second solo cross country flight. She had deptd donaldson center near greenville, SC and had flown to athens, ga where she had completed a touch and go landing. She then proceeded to Mccormick, SC and flew over the airport to…NTSB ATL88FA186Accident · 1 fatalField investigationFinal reportCessna 402B · West Columbia, SCThe airplane used about 1/2 of the 8,602 ft rwy for the t/o roll. After t/o it pitched nose-down briefly over the rwy during init climb. The plt radioed that he was having a problem with the elevator which required 'full back pressure' to keep the nose up,…NTSB ATL88LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe pilot was conducting a maintenance test flight when he experienced a drop in engine RPM. After a series of bangs the engine quit. The pilot made a forced landing into a rough field. The engine examination disclosed that no. 1 piston had failed. The engine…NTSB ATL88LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Myrtle Beach, SCThe plt was practicing touch and go ldgs on rwy 23 when he lost control of the airplane just after takeoff when it encountered a gust of wind. The rt wing contacted the terrain adjacent to the runway and the airplane flipped over.NTSB ATL88LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Florence, SCThe accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of…NTSB ATL88LA161Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Greenwood, SCThe plt reported that the engine RPM began to drop. Shortly after he took off from an open field. He opened the throttle further in an attempt to regain RPM but the engine did not respond. The helicopter subsequently crashed onto a bldg roof as the plt…NTSB ATL88LA160Accident · No injuriesLimited investigationFinal reportCessna 172N · Gilbert, SCThe airplane overran rwy 23 during ldg and nosed over. The plt reported that he attempted to abort the ldg after initially landing long on the rwy. As the airplane began to climb however, he realized that it would not clear obstacles located past the end of…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 ATL88LA149Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Chester, SCWhile thermaling during the sailplane competition, N45BD was slightly higher and to the left of N295SZ. N45BD made a right turn and struck the right inboard wing section of N294SZ with the outboard wing tip of N45BD. The outboard wing tip of N45BD separated…NTSB ATL88FA150Accident · Minor injuriesField investigationFinal reportCessna 152 · Moncks Corner, SC