NTSB investigations, 1987, SC

4 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19822026
NTSB investigations, 1987, SC per year, 1982–2026: 31 cases
19824
19831
19845
19852
19874
19882
19901
19911
19921
19931
19951
19972
19981
19992
20011
20041
20051

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\" = 230)
  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 ATL88DMG01Accident · 1 fatalFinal reportRogers-Gibson 1 · Bennettsville, SCThe homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near…Oct 11, 1987 · N111MJ · DestroyedNTSB ATL87LA129Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe aircraft landed with the landing gear in the up position when the pilot inadvertently failed to extend the gear. He had disarmed the landing gear warning system by pulling the system circuit breaker because it was activating at normal power settings. He…Apr 29, 1987 · N3240Y · Substantial damageNTSB ATL87LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt…Apr 27, 1987 · N5824S · Substantial damageNTSB ATL87LA070Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Florence, SCDuring the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember…Feb 6, 1987 · N1013G · Substantial damage