# NTSB investigations: Aero Commander 112, MD

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 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 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.…
- [NTSB NYC73FIG18](https://openairdocs.org/ntsb/NYC73FIG18.md): Aero Comdr 112 · Stevensville, MD · Accident · Minor injuries · Closed · Nov 18, 1972 · N1014J · Substantial damage

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

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

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