NTSB investigations, 1987, SC

4 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases per year

19822026
NTSB investigations, 1987, SC per year, 1982–2026: 99 cases
19828
19833
19843
19855
19865
19874
19883
19894
19904
19913
19925
19938
19942
19954
19963
19978
19982
19997
20004
20011
20021
20033
20043
20053
20061
20072

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\" = 353)
  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 ATL88LA028Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Beaufort, SCThe airplane engine lost pwr at cruise and the plt made a forced lng in a salt-water marsh. Investigation revealed that the plt was ferrying the acft to another arpt to have maintenance performed on the fuel selector valve, which was stuck in the aux tank…Nov 5, 1987 · N78169 · Substantial damageNTSB ATL88LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Cordesville, SCThe airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after…Oct 6, 1987 · N11838 · Substantial damageNTSB ATL87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCEngine quit during descent for landing. PIC lnded in field, left wing struck tree and was separated from acft. PIC rpted no mechanical malfunctions. On post crash exam eng ran properly and right wing fuel quantity sys was operable. No fuel stains were seen on…Jun 6, 1987 · N2846N · Substantial damageNTSB ATL87LA098Accident · No injuriesLimited investigationFinal reportMooney M20F · Winnsboro, SCThe acft hit a ditch during a forced landing after a power loss on takeoff. The acft had received annual inspection during which no contamination of the fuel system was found. The acft was parked outside, in the rain, to await the owner's pickup. The fuel…Mar 26, 1987 · N6990V · Substantial damage