# NTSB investigations: Lycoming LTS-101 600A 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 FTW89FA049](https://openairdocs.org/ntsb/FTW89FA049.md): MBB BK-117 A-1 · Tyler, TX · Accident · 3 fatal · Field investigation · Final report · Feb 14, 1989 · N7025L · Destroyed
  > The pilot's failure to execute the published inadvertent IMC procedures when he encountered adverse weather conditions.
- [NTSB FTW83FRA03](https://openairdocs.org/ntsb/FTW83FRA03.md): S.N.I.A.S. AS350D · Houston, TX · Accident · Serious injuries · Final report · Dec 16, 1982 · N801DB · Destroyed
  > The pilot stated that as he came to a hover to land, an engine surge occurred which sent the helicopter back into the air. Reportedly, the engine continued to surge off and on, and as helicopter came down, it would impact the ground and bounce back in the…
- [NTSB FTW81IA112](https://openairdocs.org/ntsb/FTW81IA112.md): Aerospatial AS350 · Port Arthur, TX · Incident · No injuries · Closed · Jun 27, 1981 · N138BH · Minor 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 ('41562'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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