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 MIA95FA183Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Hilton Head Isl, SCloss of engine power for undetermined reasons, and the unsuitable terrain encountered during the emergency landing. A factor in the accident was the pilot's extension of the downwind leg which prevented landing on the intended runway following loss of engine…NTSB ATL95LA132Accident · No injuriesLimited investigationFinal reportCessna 310 · Ridgeland, SCThe pilot's failure to assure that the airplane's alternators were on which led to a complete loss of electrical power, and his failure to attempt to lower the landing gear by emergency procedures.NTSB ATL95LA131Accident · Serious injuriesLimited investigationFinal reportPZL Koliber -150A · Pickens, SCthe inadequate design and operation of the induction airbox. A factor in the accident was the carburetor icing weather conditions.NTSB ATL95LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe pilot's failure to maintain aircraft control which resulted in the uncontrolled descent and collision with terrain.NTSB ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.NTSB ATL95LA118Accident · No injuriesLimited investigationFinal reportPiper J3 · York, SCThe loss of engine power for undetermined reasons.NTSB ATL95LA116Accident · 1 fatalLimited investigationFinal reportSmith Monnett Moni · Cheraw, SCThe loss of engine power for unknown reasons, and the pilot's failure to maintain flying speed, which resulted in impact with the ground while the airplane was in a stalled condition.NTSB ATL95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Columbia, SCThe misalignment of the nose gear centering track and roller assemblies which precluded landing gear extension.NTSB ATL95LA103Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Moncks Corner, SCThe pilot's failure to properly calculate the fuel required and his fuel consumption for the flight.NTSB ATL95LA104Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Rock Hill, SCAn inoperative left main wheel brake that resulted in a loss of directional control. A factor was the wet, grass runway.NTSB ATL95FA101Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenville, SCThe pilot's failure to maintain flying speed. A factor was his failure to reposition the elevator trim.NTSB ATL95LA093Accident · Minor injuriesLimited investigationFinal reportLet L-23 Super Blanik · Spartanburg, SCThe pilot's inadvertent use speed brakes during takeoff.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 ATL95LA067Accident · No injuriesLimited investigationFinal reportWente Kitfox III · Moncks Corner, SCThe pilot's selection of the wrong runway relative to the wind conditions and his failure to maintain alignment with the runway during the balked landing.NTSB ATL95LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Charleston, SCThe failure of the position washer in the fuel selector valve, which resulted in the fuel starvation of the engine.NTSB ATL95FA049Accident · 1 fatalField investigationFinal reportCessna 150J · Piedmont, SCThe pilot's inappropriate 'buzzing' that resulted in exceeding the airplane's design stress limits, the failure of the windshield, and the pilot's subsequent loss of control and impact with the ground.NTSB MIA95FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · York, SCThe noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…NTSB ATL95LA026Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe pilot's failure to maintain directional control during a crosswind takeoff.NTSB ATL95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Greenwood, SCUnapproved maintenance work done by uncertificated persons which resulted in a broken starter drive which was not properly removed from the engine. The particles sheared the magneto shafts causing the loss of engine power.NTSB ATL95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Myrtle Beach, SCThe pilot's failure to properly pre-flight the airplane to ensure the left fuel tank cover was properly secured.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 ATL95LA019Accident · 2 fatalLimited investigationFinal reportWeeks Glasair SH2F · Timmonsville, SCThe pilot's continued operation into known adverse weather conditions with a known aircraft deficiency, and his ensuing spatial disorientation, which resulted in ground impact during an uncontrolled descent.NTSB ATL95LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Johns Island, SCA loss of engine power due to a partially blocked fuel line to the gascolator.NTSB ATL95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Luray, SCThe pilot's improper landing flare which resulted in a hard landing.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 ATL94LA175Accident · No injuriesLimited investigationFinal reportCessna 182 · Lancaster, SCThe pilot's delay in taking remedial action when the engine failed to develop takeoff RPM. A factor was conditions favorable for the formation of carburetor ice.NTSB ATL94LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · W. Columbia, SCThe student pilot's failure to properly flare the aircraft, resulting in a hard landing.NTSB ATL94LA155Accident · No injuriesLimited investigationFinal reportCessna 210A · Varnville, SCWater contamination in the fuel that resulted from inadequate maintenance inspection of the airplane. A factor was the rough terrain at the landing site.NTSB ATL94LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Beaufort, SCThe pilot's improper use of the rudder during landing.NTSB ATL94LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greenville, SCThe pilot's improper positioning of the fuel selector valve which resulted in fuel starvation.NTSB ATL94LA146Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Greenville, SCThe pilot's failure to properly flare the aircraft during landing, resulting in a hard landing.NTSB ATL94LA120Accident · No injuriesLimited investigationFinal reportBeech P35 · Bluffton, SCA loss of engine power due to oil starvation. This resulted from an undertorqued condition of the oil filter adapter, and the subsequent fretting of the adapter threads.NTSB ATL94FA116Accident · 1 fatalField investigationFinal reportMooney M20C · West Columbia, SCThe pilot's failure to maintain control of the airplane during climbout because of spatial disorientation. Factors were low ceilings and the dark night.NTSB ATL94LA113Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Laurens, SCThe loss of engine power on one engine followed by failure of the propeller to feather or be feathered.NTSB ATL94LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Andrews, SCThe failure of the pilot to maintain directional control of the aircraft.NTSB ATL94FA093Accident · 1 fatalField investigationFinal reportNord 1101 · Spartanburg, SCThe pilot's failure to maintain adequate airspeed while maneuvering for an emergency landing. A factor in the accident was an inflight fire from an undetermined source.NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.NTSB ATL94LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Barnwell, SCThe pilot's failure to flare properly which resulted in a hard landing.NTSB ATL94LA080Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Latta, SCThe pilot's failure to obtain flying speed and the premature lift off which resulted in a stall.NTSB ATL94LA069Accident · Minor injuriesLimited investigationFinal reportCessna 150L · N. Myrtle Beach, SCThe improper procedures used by ground personnel during banner tow operations.NTSB ATL94FA062Accident · 1 fatalField investigationFinal reportCessna 152 · Allendale, SCThe pilot's failure to maintain a proper altitude while in the VFR traffic pattern, resulting in a collision with trees. Factors were; his failure to comply with school directives by not obtaining a weather briefing prior to the accident flight, and the rain,…NTSB ATL94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Columbia, SCThe poor inspection of the aircraft during the annual inspection by maintenance personnel. A factor in the accident was the foreign object found in the carburetor bowl.NTSB ATL94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · St. Matthews, SCA loss of engine power for undetermined reasons. A factor was the electric transmission wire located at the forced landing site.NTSB ATL94LA054Accident · No injuriesLimited investigationFinal reportHelio HE391B · Saluda, SCThe pilot's and mechanic's failure to adequately inspect the aircraft fuel system which resulted in fuel starvation.NTSB ATL94FA043Accident · 2 fatalField investigationFinal reportCulver LCA · Lake City, SCWas the pilot's failure to maintain flying speed while maneuvering the airplane which resulted in the loss of control and the collision with the ground.NTSB ATL94LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Pelion, SCInadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.NTSB ATL94LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCThe pilot's inadequate in-flight planning in determining fuel requirements for the flight.NTSB ATL94LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · N. Myrtle Beach, SCThe pilot's improper inflight decision in that he failed to refuel the aircraft prior to exhausting the fuel supply. A factor was the soft terrain at the forced landing site.NTSB ATL94LA032Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edisto Island, SCFailure of the pilot to use carburetor heat, while maneuvering and changing altitudes, which resulted in carburetor ice. A factor related to the accident was that weather conditions were favorable for the formation of carburetor ice.