# NTSB investigations: Aero Commander 520, TX

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 FTW87FA177](https://openairdocs.org/ntsb/FTW87FA177.md): Aero Commander 520 · Carrollton, TX · Accident · Minor injuries · Field investigation · Final report · Jul 27, 1987 · N4164B · Destroyed
  > Acft was destroyed when it struck pwr lines and the grnd during a single eng go-around. Following a left eng shut down due to severe vibrations, the plt overflew one arpt to return to his home base. En route, he elected not to go to full pwr due to a 3 min…
- [NTSB FTW84LA356](https://openairdocs.org/ntsb/FTW84LA356.md): Gulfstream 520 · Goliad, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1984 · N4183B · Destroyed
  > Acft was found abandoned. Wreckage scene indicates collision with trees prior to collision with terrain. Acft suspected of being used for illegal cargo operations.
- [NTSB FTW69F0278](https://openairdocs.org/ntsb/FTW69F0278.md): Aero Comdr 520 · Dallas, TX · Accident · No injuries · Closed · Nov 16, 1968 · N4129B · Substantial damage
- [NTSB FTW67F0615](https://openairdocs.org/ntsb/FTW67F0615.md): Aero Comdr 520 · Lubbock, TX · Accident · No injuries · Closed · May 13, 1967 · N2605B · Substantial damage
- [NTSB FTW67F0122](https://openairdocs.org/ntsb/FTW67F0122.md): Aero Comdr 520 · Amarillo, TX · Accident · No injuries · Closed · Jul 27, 1966 · N158V · Substantial damage
- [NTSB FTW66F0565](https://openairdocs.org/ntsb/FTW66F0565.md): Aero CDR 520 · Abernathy, TX · Accident · Serious injuries · Closed · Dec 27, 1965 · N33L · Destroyed
- [NTSB FTW66F0354](https://openairdocs.org/ntsb/FTW66F0354.md): Aero Cmdr 520 · Midland, TX · Accident · No injuries · Closed · Oct 16, 1965 · N4183B · 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" = 'TX' 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 ('0141202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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