# NTSB investigations: Aero Commander 112: Collision with terr/obj (non-CFIT)

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 CEN22LA322](https://openairdocs.org/ntsb/CEN22LA322.md): Aero Commander 112 · Granbury, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2022 · N1181J · Substantial damage
  > The loss of engine power due to metal contamination within the cylinder following poor maintenance.
- [NTSB ERA18LA034](https://openairdocs.org/ntsb/ERA18LA034.md): Aero Commander 112 · Westminister, MD · Accident · No injuries · Limited investigation · Final report · Nov 29, 2017 · N690RU · Substantial damage
  > The student pilot's failure to maintain a proper glidepath during the approach due to his distraction by the failure of an avionics panel, which resulted in a runway undershoot.
- [NTSB CEN14LA081](https://openairdocs.org/ntsb/CEN14LA081.md): Rockwell International 112 · Hammond, LA · Accident · No injuries · Limited investigation · Final report · Dec 10, 2013 · N1203J · Substantial damage
  > The total loss of engine power due to oil starvation because of a fractured governor oil line, which resulted from the improper installation of the governor oil line assembly during the last oil line replacement.
- [NTSB CEN11FA358](https://openairdocs.org/ntsb/CEN11FA358.md): Rockwell 112 · Bryan, TX · Accident · 2 fatal · Field investigation · Final report · May 29, 2011 · N1041J · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…
- [NTSB ERA09LA143](https://openairdocs.org/ntsb/ERA09LA143.md): Aero Commander 112A · Everglades City, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2009 · N1006J · Substantial damage
  > The partial loss of engine power for an undetermined reason. Contributing to the accident was the pilot's attempt to continue takeoff with partial engine power.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0144701')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?model=0144701

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