# NTSB investigations: Aero Commander 500-B, MT

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 SEA98LA073](https://openairdocs.org/ntsb/SEA98LA073.md): Aero Commander 500-A · Billings, MT · Accident · No injuries · Limited investigation · Final report · May 9, 1998 · N9382R · Substantial damage
  > Failure of the main landing gear strut outer-body to inner-body needle bearing from the lack of lubrication and the development of corrosion. An inadequate manufacturer's inspection program was a factor.
- [NTSB SEA93LA047](https://openairdocs.org/ntsb/SEA93LA047.md): Aero Commander AC-500B · Billings, MT · Accident · No injuries · Limited investigation · Final report · Dec 29, 1992 · N2783Q · Substantial damage
  > Loss of engine power on both engines for undetermined reasons and left main landing gear not down and locked on touchdown.
- [NTSB DEN84FA121](https://openairdocs.org/ntsb/DEN84FA121.md): Aero Commander 500-B · Miles City, MT · Accident · Serious injuries · Field investigation · Final report · Mar 31, 1984 · N743W · Destroyed
  > The plt said that when he called on the radio prior to the approach for an altimeter setting the reply was '30.11 or 30.12, something like that.' The acft altimeter was found after the accident set at 30.22 inches of mercury. The visibility was described as 1…
- [NTSB SEA78FA062](https://openairdocs.org/ntsb/SEA78FA062.md): Aero Comdr 500B · Great Falls, MT · Accident · 1 fatal · Closed · Sep 6, 1978 · N6112X · Destroyed
- [NTSB SEA78FA017](https://openairdocs.org/ntsb/SEA78FA017.md): Aero Comdr 500B · Miles City, MT · Accident · 1 fatal · Closed · Jan 5, 1978 · N6308U · Destroyed
- [NTSB SEA69D0174](https://openairdocs.org/ntsb/SEA69D0174.md): Aero Comdr 500-B · Belgrade, MT · Accident · No injuries · Closed · Jan 8, 1969 · N4918 · Substantial damage
- [NTSB SEA69A0035](https://openairdocs.org/ntsb/SEA69A0035.md): Aero Comdr 500 · Glendive, MT · Accident · 1 fatal · Closed · Dec 18, 1968 · N6281X · Destroyed

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

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

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