OpenAirDocs.org

NTSB investigations, SC

8 cases where the first occurrence was “Miscellaneous/other”.

Cases per year

19862026

Where

Open the map

Latest 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\" = 430)
  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.

NTSB ATL06LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Blacksburg, SCThe pilot's failure to abort the takeoff after the airplane failed to achieve adequate airspeed on the takeoff roll for undetermined reasons. This resulted in an abrupt pull up, inadvertent stall, and in flight collision with wires, trees and the ground.May 23, 2006 · N3217F · DestroyedNTSB ATL04LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Summerville, SCThe pilot's inadequate start procedure, which resulted in a run-away airplane.Feb 7, 2004 · N21266 · Substantial damageNTSB ATL03FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Hilton Head Is, SCThe pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…Aug 31, 2003 · N70DL · DestroyedNTSB ATL91FA008Accident · 2 fatalField investigationFinal reportBeech A36 · Georgetown, SCThe pilot-in-command's loss of consciousness during flight. The reason for the loss of consciousness could not be determined.Oct 25, 1990 · N97PA · DestroyedNTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…Jul 28, 1990 · N2789P · DestroyedNTSB ATL87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Edmund, SCThe CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI…Jul 22, 1987 · N45648 · Substantial damageNTSB ATL86LA226Accident · No injuriesLimited investigationFinal reportCessna 150L · Campobello, SCWhile on her 2nd solo x-country flt, the student plt became lost/disoriented after the comm/nav radios developed a problem. Subsequently, she made a precautionary landing in an open field. During the landing roll, the acft hit a ditch & nosed over.Aug 26, 1986 · N11154 · Substantial damageNTSB ATL86IA162Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCDuring a scheduled air carrier flight at normal cruising altitude, the captain passed out upon re-entering the cockpit after excusing himself to go to the lavatory. The flight crew diverted to an alternate destination due to the medical emergency. A review of…Jun 8, 1986 · N8865E · No damage