# NTSB investigations: Aero Commander S2R, IA

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 CEN20LA294](https://openairdocs.org/ntsb/CEN20LA294.md): Rockwell S2R · Harlan, IA · Accident · No injuries · Class 3 · Limited · Final report · Jul 20, 2020 · N1662S · Substantial damage
  > The fatigue fracture of the upper rudder hinge that resulted in a partial separation of the rudder from the airplane during a spray pass.
- [NTSB CEN18LA278](https://openairdocs.org/ntsb/CEN18LA278.md): Aero Commander S2R · Vinton, IA · Accident · No injuries · Class 3 · Limited · Final report · Jul 17, 2018 · N5553X · Substantial damage
  > Loss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.
- [NTSB CEN11LA543](https://openairdocs.org/ntsb/CEN11LA543.md): Aero Commander S2R · Washington, IA · Accident · No injuries · Limited investigation · Final report · Aug 3, 2011 · N1735S · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.

## 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" = 'IA' 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 ('0143022'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0143022&state=IA

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