NTSB investigations, 1987, SC

6 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases per year

19822026
NTSB investigations, 1987, SC per year, 1982–2026: 50 cases
19823
19835
19843
19851
19863
19876
19885
19891
19904
19911
19932
19953
19962
19972
19981
20001
20011
20023
20041
20051
20061

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 year(c.\"eventDate\") = 1987
    AND 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\" = 130)
  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 ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…Nov 30, 1987 · N4463W · DestroyedNTSB ATL88IA074Incident · No injuriesIncident investigationFinal reportMooney M-20E · Columbia, SCDuring takeoff the propeller studs failed and the propeller departed the acft. FAA incident rpt stated that propeller had been overhauled and replaced 32 hours prior to the separation. Metallurgical exam of the propeller studs revealed fatigue failure of the…Oct 6, 1987 · N1936Y · Minor damageNTSB ATL87LA157Accident · No injuriesLimited investigationFinal reportBeech A36 · Greenville, SCThe plt made a precautionary ldg after experiencing acft electrical problems and observing the ammeter indicate discharging. The nose and rt main ldg gear collapsed during rollout braking. The plt reported that the gear had extended prior to ldg using the…Jun 3, 1987 · N1859A · Substantial damageNTSB ATL87FA147Accident · 1 fatalField investigationFinal reportHiller UH-12D (H23) · Spartanburg, SCDuring a local pleasure flight above the treetops, the passenger reported that they heard a loud 'pop' over the sound of the engine. The plt told her that they were going down and she noticed the main rotor blades began to turn slower than usual before the…May 24, 1987 · N6408 · DestroyedNTSB ATL87IA114Incident · No injuriesIncident investigationFinal reportCessna 340 · Myrtle Beach, SCPlt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached…Apr 17, 1987 · N25RF · Minor damageNTSB ATL87LA113Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ridgeland, SCThe plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was…Apr 12, 1987 · N9563V · Destroyed