# NTSB investigations: Rockwell International S-2R, 1987

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB MKC87LA164](https://openairdocs.org/ntsb/MKC87LA164.md): Rockwell S-2R · Mediapolis, IA · Accident · No injuries · Limited investigation · Final report · Aug 15, 1987 · N4949X · Substantial damage
  > The 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…
- [NTSB LAX87DVA11](https://openairdocs.org/ntsb/LAX87DVA11.md): Rockwell S-2R · Mendota, CA · Accident · 1 fatal · Final report · Aug 13, 1987 · N4219X · Substantial damage
  > The 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…
- [NTSB SEA87LA151](https://openairdocs.org/ntsb/SEA87LA151.md): Rockwell S-2R · Plymouth, WA · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N4229X · Substantial damage
  > Drg 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.
- [NTSB SEA87LA131](https://openairdocs.org/ntsb/SEA87LA131.md): Rockwell S-2R · Glenns Ferry, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1987 · N5580X · Destroyed
  > During 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…
- [NTSB MKC87LA115](https://openairdocs.org/ntsb/MKC87LA115.md): Ayres S2R600 · Lepanto, AR · Accident · No injuries · Limited investigation · Final report · Jun 2, 1987 · N4943X · Substantial damage
  > The 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…
- [NTSB LAX87DVG06](https://openairdocs.org/ntsb/LAX87DVG06.md): Ayres S-2R · Williams, CA · Accident · Minor injuries · Final report · May 6, 1987 · N4216X · Substantial damage
  > The 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…
- [NTSB LAX87DUM02](https://openairdocs.org/ntsb/LAX87DUM02.md): Rockwell S2R · Imperial, CA · Accident · No injuries · Final report · Apr 24, 1987 · N4194X · Substantial damage
  > During 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb?model=7630202&year=1987

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.