OpenAirDocs.org

NTSB investigations: Rockwell International S-2R, 1987

7 cases on aircraft the registry lists as Rockwell International S-2R. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19742026

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 year(c.\"eventDate\") = 1987
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630202', '7630205'))
  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 MKC87LA164Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mediapolis, IAThe pilot stated that the field to be sprayed appeared safe enough when he flew a recon flight over the area the day prior to the accident. He stated that he didn't expect the power transmission lines to be so low, and that he did not see a rise in the…Aug 15, 1987 · N4949X · Substantial damageNTSB LAX87DVA11Accident · 1 fatalFinal reportRockwell S-2R · Mendota, CAThe ground flagman reported the pilot had just completed spraying the bean field. The pilot was in the process of doing a touch-up application when he flew under the power lines. The airplane right wing contacted the lowest of the 4 powerlines, rolled…Aug 13, 1987 · N4219X · Substantial damageNTSB SEA87LA151Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Plymouth, WADrg a swath run, a total loss of power occurred when the eng's #9 cylinder failed. The plt made a forced lndg in a soft potato field, but the acft nosed over after it slowed to about 20 KTS.Jul 31, 1987 · N4229X · Substantial damageNTSB SEA87LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Glenns Ferry, IDDuring takeoff with a quartering tailwind about 3/4 way down the runway the aircraft settled back onto the runway. There was not enough room to stop the aircraft. The aircrafts main gear caught on a fence and tall wheat with the aircraft coming to rest…Jul 4, 1987 · N5580X · DestroyedNTSB MKC87LA115Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Lepanto, ARThe PIC had taken off for a LCL aerial operation. Enroute PIC had an engine failure and made a forced ldg in a muddy field. PIC applied brakes and acft nosed over. The exhaust rocker arm box on no. 3 cylinder was found to be cracked keeping exhaust valve in…Jun 2, 1987 · N4943X · Substantial damageNTSB LAX87DVG06Accident · Minor injuriesFinal reportAyres S-2R · Williams, CAThe plt reported he heard something break. The sound was followed by a vibration. The plt then turned to land on a road. He was unable to maintain alt and airspeed. The rockwell S2R landed in a cultivated field and nosed over after a collision with a dirt…May 6, 1987 · N4216X · Substantial damageNTSB LAX87DUM02Accident · No injuriesFinal reportRockwell S2R · Imperial, CADuring an aerial application applying sulphur, the sulphur ignited inflight. The pilot turned the aircraft back toward the airport; however, the cockpit filled with smoke and the pilot decided to land on a road. Due to the extent of fire damage it could not…Apr 24, 1987 · N4194X · Substantial damage