# NTSB investigations: Lycoming GO-435C&D series, 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 FTW78FQD26](https://openairdocs.org/ntsb/FTW78FQD26.md): Navion B · El Paso, TX · Accident · Minor injuries · Closed · Jul 15, 1978 · N6928C · Substantial damage
- [NTSB FTW73FQD12](https://openairdocs.org/ntsb/FTW73FQD12.md): Helio Acft H-391B · El Paso, TX · Accident · No injuries · Closed · Dec 30, 1972 · N316HW · Substantial damage
- [NTSB FTW71FRA06](https://openairdocs.org/ntsb/FTW71FRA06.md): Beech B50 · Friendswood, TX · Accident · Minor injuries · Closed · Jul 18, 1970 · N41U · Substantial damage
- [NTSB FTW69D0309](https://openairdocs.org/ntsb/FTW69D0309.md): Navion B · Denver City, TX · Accident · No injuries · Closed · Dec 7, 1968 · N5132K · Substantial damage
- [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 FTW66F0354](https://openairdocs.org/ntsb/FTW66F0354.md): Aero Cmdr 520 · Midland, TX · Accident · No injuries · Closed · Oct 16, 1965 · N4183B · Substantial damage
- [NTSB UNK64X3980](https://openairdocs.org/ntsb/UNK64X3980.md): Bellanca 1413W · Uvalde, TX · Accident · No injuries · Closed · Sep 14, 1964 · N74480 · 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.engine_model_code IN ('41521'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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