NTSB investigations: Rockwell International S-2R, LA
12 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
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 2 |
| 1993 | 1 |
| 1998 | 1 |
| 2004 | 1 |
Where
Open the mapLatest 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 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"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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW04LA176Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Jonesville, LAThe pilot's failure to maintain clearance with the power lines.NTSB FTW99LA030Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alexandria, LAThe pilot's failure to maintain clearance with the water during the turnaround maneuver. A factor was the haze over the river.NTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.NTSB FTW82FRJ16Accident · 2 fatalFinal reportRockwell S-2R · Jones, LAAir 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 FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs 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 FTW81DRJ25Accident · No injuriesClosedRockwell S2R · Boyce, LANTSB FTW80DRD05Accident · No injuriesClosedAero-Comdr S2R · Vinton, LANTSB FTW79FRJ20Accident · 1 fatalClosedRockwell S-2R · Waterproof, LANTSB FTW78DRJ27Accident · No injuriesClosedAero-Comdr S-2R · Simmesport, LANTSB FTW78FRJ24Accident · 1 fatalClosedAero-Comdr S-2R · Lake Providenc, LANTSB FTW76FRJ45Accident · 1 fatalClosedSnow 600S2R · Ferriday, LANTSB FTW75FRD31Accident · 1 fatalClosedAero Comdr 600S2R · Oberlin, LA