# NTSB investigations: Aero Commander 112, 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 ATL87FA243](https://openairdocs.org/ntsb/ATL87FA243.md): Aero Commander 112 · Middlefield, OH · Accident · 1 fatal · Field investigation · Final report · Aug 28, 1987 · N1050J · Destroyed
  > On the previous flt, the plt made two unsuccessful IFR approaches before landing on the third attempt. The pax- configured acft was loaded with cargo. The plt filed an IFR flight plan and departed the arpt. Radio contact was established with ATC and the plt…
- [NTSB NYC87LA270](https://openairdocs.org/ntsb/NYC87LA270.md): Rockwell 112A · No Kingstown, RI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1987 · N1223J · Substantial damage
  > The aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.
- [NTSB FTW87FA134](https://openairdocs.org/ntsb/FTW87FA134.md): Rockwell Commander 112 · Ft.Worth, TX · Accident · No injuries · Field investigation · Final report · Jun 6, 1987 · N1153J · Substantial damage
  > On 6/6/87 a Rockwell commander 112, N1153J, impacted the terrain near meacham field, forth worth, Texas while on a photography flight. The pilot had been cleared to land on runway 16L when the tower changed the runway assignment to 16R. The pilot added power…
- [NTSB BFO87FA027](https://openairdocs.org/ntsb/BFO87FA027.md): Rockwell 112 · Edgewood, MD · Accident · 2 fatal · Field investigation · Final report · Mar 7, 1987 · N112BB · Destroyed
  > On the day of the accident and before the accident flight, the inlet fuel hose to the fuel flow divider was replaced. The hose assembly was fabricated by maint personnel. An inspection flight afterwards revealed engine roughness during fuel mixture leaning.…

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

This list as a web page: https://openairdocs.org/ntsb?model=0144701&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.