NTSB investigations, 1987, SC

4 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 1987, SC per year, 1982–2026: 40 cases
19822
19833
19842
19851
19861
19874
19882
19893
19901
19911
19944
19951
19971
19982
19993
20011
20022
20031
20053
20061
20071

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\" = 260)
  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 ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…Oct 21, 1987 · N94126 · Substantial damageNTSB ATL87LA128Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Greenville, SCThe pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full…Apr 28, 1987 · N5670C · Substantial damageNTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…Apr 25, 1987 · N13PH · Substantial damageNTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…Jan 4, 1987 · N70493 · Destroyed