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

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 FTW04LA176](https://openairdocs.org/ntsb/FTW04LA176.md): Rockwell S-2R · Jonesville, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 2004 · N8486V · Substantial damage
  > The pilot's failure to maintain clearance with the power lines.
- [NTSB FTW99LA030](https://openairdocs.org/ntsb/FTW99LA030.md): Rockwell S-2R · Alexandria, LA · Accident · No injuries · Limited investigation · Final report · Nov 18, 1998 · N4938X · Destroyed
  > The pilot's failure to maintain clearance with the water during the turnaround maneuver. A factor was the haze over the river.
- [NTSB FTW93FA211](https://openairdocs.org/ntsb/FTW93FA211.md): Rockwell S-2R · Bastrop, LA · Accident · 1 fatal · Field investigation · Final report · Jul 10, 1993 · N8512V · Destroyed
  > The pilot's failure to maintain terrain clearance.
- [NTSB FTW82FRJ16](https://openairdocs.org/ntsb/FTW82FRJ16.md): Rockwell S-2R · Jones, LA · Accident · 2 fatal · Final report · Aug 23, 1982 · N8474V · 2 aircraft · Destroyed
  > Air tractor AT-400, N2342Z, and another aircraft, a Rockwell international S-2R, N8474V, collided while both aircraft were involved in spraying operatons. The AT-400 pilot was spraying a field that was surrounded by trees. He had just completed a swath run to…
- [NTSB FTW82DA089](https://openairdocs.org/ntsb/FTW82DA089.md): Rockwell S-2R · Oberlin, LA · Accident · No injuries · Final report · Mar 10, 1982 · N8466V · Destroyed
  > As the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…
- [NTSB FTW81DRJ25](https://openairdocs.org/ntsb/FTW81DRJ25.md): Rockwell S2R · Boyce, LA · Accident · No injuries · Closed · Jul 24, 1981 · N4866X · Destroyed
- [NTSB FTW80DRD05](https://openairdocs.org/ntsb/FTW80DRD05.md): Aero-Comdr S2R · Vinton, LA · Accident · No injuries · Closed · Nov 27, 1979 · N4857X · Substantial damage
- [NTSB FTW79FRJ20](https://openairdocs.org/ntsb/FTW79FRJ20.md): Rockwell S-2R · Waterproof, LA · Accident · 1 fatal · Closed · Aug 15, 1979 · N4251X · Destroyed
- [NTSB FTW78DRJ27](https://openairdocs.org/ntsb/FTW78DRJ27.md): Aero-Comdr S-2R · Simmesport, LA · Accident · No injuries · Closed · Aug 7, 1978 · N8460V · Substantial damage
- [NTSB FTW78FRJ24](https://openairdocs.org/ntsb/FTW78FRJ24.md): Aero-Comdr S-2R · Lake Providenc, LA · Accident · 1 fatal · Closed · Jul 19, 1978 · N8859Q · Destroyed
- [NTSB FTW76FRJ45](https://openairdocs.org/ntsb/FTW76FRJ45.md): Snow 600S2R · Ferriday, LA · Accident · 1 fatal · Closed · Sep 6, 1976 · N5655X · Destroyed
- [NTSB FTW75FRD31](https://openairdocs.org/ntsb/FTW75FRD31.md): Aero Comdr 600S2R · Oberlin, LA · Accident · 1 fatal · Closed · Feb 21, 1975 · N4887X · Destroyed

## 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 c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
  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&state=LA

---
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.