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 ATL94LA027Accident · Minor injuriesLimited investigationFinal reportWonder VAN'S Acft RV-6 · Ridgeland, SCImproper installation of the magnetos by maintenance personnel, which allowed the right magneto to come loose, oil to escape from the engine, and subsequent oil starvation.NTSB ATL94LA025Accident · Minor injuriesLimited investigationFinal reportSikorsky H34-G · Walterboro, SCThe seizure of the aircraft throttle to engine linkage for unknown reasons.NTSB ATL94LA017Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Lake City, SCThe pilot's failure to maintain a proper glidepath which resulted in collision with trees near the approach end of the runway.NTSB ATL94LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Charleston, SCThe failure of the right main landing gear to extend for undetermined reasons.NTSB ATL94LA013Accident · Serious injuriesLimited investigationFinal reportBowermaster B-8M · Cowpens, SCFuel starvation which resulted from unported fuel in the fuel tank due to inadequate design of the tanks.NTSB ATL93LA152Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe failure of the engine exhaust valve which resulted in the loss of engine power. The soft terrain in the landing area was a factor.NTSB ATL93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Hilton Head Is, SCA loss of engine power for undetermined reasons.NTSB ATL93LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moncks Corner, SCFailure of the number one cylinder at the cylinder flange radius.NTSB ATL93IA135Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Charleston, SCWas the pilot's failure to maintain adequate airspeed during the landing attempt which resulted in a stall and the subsequent collision with the runway.NTSB ATL93LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Pelion, SCThe pilot's improper weather evaluation prior to commencing the flight. Factors were the fog and low ceiling weather conditions, and the rough, uneven terrain at the landing siteNTSB ATL93LA128Accident · Minor injuriesLimited investigationFinal reportBrown Glassair SH-2 · Timmonsville, SCThe pilot's inadequate fuel planning which resulted in the exhaustion of the fuel supply and the loss of engine power. A factor was the pilot's failure to comply with a manufacturer's service bulletin.NTSB ATL93LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, SCThe pilot's improper preflight planning which resulted in fuel exhaustion.NTSB ATL93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Ridgeland, SCThe pilot's improper use of carburetor heat, which resulted in a partial loss of engine power. Factors were the carburetor icing conditions, and the soft terrain at the forced landing site.NTSB ATL93LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ravenel, SCThe continuation of the landing attempt into the short sod field without the use of flaps and the use of excessive airspeed by the pilot. Factors in the accident were the failure of the aircraft flaps to extendNTSB ATL93LA092Accident · Minor injuriesLimited investigationFinal reportJones Lightning BUG 2 · Walterboro, SCThe disconnection of an elevator rod end fitting in flight, which disabled the elevatorNTSB ATL93LA090Accident · No injuriesLimited investigationFinal reportRapp VAN'S RV-4 · Greenwood, SCThe loss of engine power which resulted from the formation of carburetor ice. The lack of a carburetor heat source and the carburetor icing conditions were factorsNTSB ATL93LA088Accident · Serious injuriesLimited investigationFinal reportExtra 300 · Ridge Springs, SCThe pilot's failure to determine the landing distance required for a landing on a wet sod runway, which resulted in the overrun of the landing area and the collision with a treeNTSB ATL93LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Myrtle Beach, SCThe pilot's improper compensation for wind conditions during the approach and landing. Factors were the gusts, turbulence, and tailwind conditions at the landing site.NTSB ATL93LA077Accident · No injuriesLimited investigationFinal reportMyers Avid Aircraft Flyer · Winnsboro, SCThe pilot's failure to maintain the airspeed above the stall speed, during the forced landing. A factor was the undetermined engine malfunction.NTSB ATL93LA065Accident · No injuriesLimited investigationFinal reportHiller UH12E · Greeleyville, SCThe pilot's misjudgment of the helicopter's altitude during the landing flare.NTSB ATL93LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe poor preflight planning by the pilot.NTSB ATL93LA044Accident · No injuriesLimited investigationFinal reportCessna 182A · New Ellenton, SCInadequate preflight planning and preparation by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Factors were trees in the emergency landing area.NTSB ATL93LA033Accident · Minor injuriesLimited investigationFinal reportKaman HH43F · Columbia, SCThe deterioration of the engine fuel shutoff solenoid valve which failed in the closed position.NTSB ATL93LA032Accident · No injuriesLimited investigationFinal reportVan Arsdell/Brent,M. Rutan Long EZ · Charleston, SCThe pilot's inadequate pre-flight planning and his failure to note the raised arresting device near the runway threshold.NTSB ATL93FA028Accident · 1 fatalField investigationFinal reportBeech 58 · West Columbia, SCThe pilot's continued operation with known deficient equipment, his improper descent, and his failure to perform a missed approach. A factor was the operator's inadequate surveillance of the pilot's procedures and the maintenance of the airplane.NTSB ATL93LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, SCThe loss of engine power which resulted from fuel starvation when the carburetor float valve stuck in the closed position. A factor was the soft field .NTSB ATL93LA020Accident · No injuriesLimited investigationFinal reportMaule M4-210C · Pickens, SCThe pilot's failure to follow normal before takeoff procedures which included placing the propeller lever in the high RPM low pitch position. The pilot also delayed in aborting the takeoff attempt and applied hard braking which resulted in a nose over.NTSB ATL92LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Darlington, SCThe improper servicing of the airplane with contaminated fuel by the owner pilot.NTSB ATL92LA168Accident · No injuriesLimited investigationFinal reportBeech C23 · Pageland, SCThe pilot's improper touchdown, resulting in an overload failure of the nose gear attachment support tubes. Factors were the lack of total experience of the pilot and the ditch adjacent to the runway.NTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.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 ATL92FA152Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Dovesville, SCThe loss of engine power which resulted from an undetermined malfunction of the ignition system. A factor was fog.NTSB ATL92LA149Accident · No injuriesLimited investigationFinal reportCessna 182A · Aiken, SCThe pilot's diverted attention which resulted in the improper use of the elevator and inadvertent porpoise.NTSB MIA92LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26E · Ridgeland, SCThe pilot's inadequate inflight planning resulting in an encounter with a windshift on final approach.NTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.NTSB ATL92GA121Accident · 2 fatalFinal reportEnstrom 280FX · Summerville, SCThe pilot's inadvertent flight into IMC, which resulted in an in flight collision with trees. Factors were the obscured sky and foggy weather conditions, and the night lighting conditions at the time of the accident.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 ATL92LA114Accident · No injuriesLimited investigationFinal reportHopkins, R. And M. Protech PT-2 · Landrum, SCThe failure of the pilot to maintain aircraft control during the landing attempt. Factors were the inadequate climb capability of the aircraft and the pilot's lack of familiarity with the aircraft.NTSB ATL92FA109Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Winnsboro, SCThe inadvertent flight into instrument meteorological conditions by the pilot. The dark night and fog were factors in the accident.NTSB ATL92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150E · N.Myrtle Beach, SCThe ostentatious display of the Piper cub's pilot caused the accident airplane's pilot to loose control and crash.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB ATL92LA089Accident · No injuriesLimited investigationFinal reportBeech 23A-19 · Orangeburg, SCThe deterioration of the exhaust muffler which resulted in an inflight fire.NTSB ATL92LA081Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Elgin, SCThe improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.NTSB ATL92LA084Accident · No injuriesLimited investigationFinal reportPZL-Okecie PZL-104 Wilga 80 · Mt. Pleasant, SCThe improper flare during the touchdown phase of the approach by the pilot which exceeded the design limits of the airframe and the right landing gear assembly.NTSB ATL92LA073Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, SCThe improper installation of the engine counterweight retention rings which resulted in the separation of the retention pin, allowing the leading edge of the counterweight to strike the crankcase. Factors in the accident were the subseqent loss of power and…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 ATL92LA062Accident · Minor injuriesLimited investigationFinal reportWilliam D. Weeks Glasair I · Timmonsville, SCThe improper selection of the fuel sector valve to the off position by the pilot.NTSB ATL92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Aiken, SCThe unexpected, gusting crosswind.NTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.NTSB ATL92LA052Accident · No injuriesLimited investigationFinal reportMooney M20C · Charleston, SCThe blocked fuel vent.