# NTSB investigations: Lycoming IGSO-540-B1A, 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 DFW08CA194](https://openairdocs.org/ntsb/DFW08CA194.md): Beech 65-A80 · Midland, TX · Accident · No injuries · Data collection · Final report · Jul 17, 2008 · N6AQ · Substantial damage
  > The failure of the landing gear retraction/extension mechanism due to it being jammed by displaced sound proofing material.
- [NTSB FTW89LA077](https://openairdocs.org/ntsb/FTW89LA077.md): Gulfstream 680FLP · Lohn, TX · Accident · No injuries · Limited investigation · Final report · Apr 1, 1989 · N721F · Destroyed
  > Arson undertaken to conceal illegal activity.
- [NTSB FTW87LA176](https://openairdocs.org/ntsb/FTW87LA176.md): Piper PA28R-201 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 26, 1987 · N6083H · Substantial damage
  > According to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an…
- [NTSB FTW87FA045](https://openairdocs.org/ntsb/FTW87FA045.md): Beech 65-80 · Brownsville, TX · Accident · No injuries · Field investigation · Final report · Jan 15, 1987 · N1590S · Substantial damage
  > Commercial pilot departed Brownsville, TX (bro) on special VFR flight plan. During initial climb, at approximately 300 ft AGL both engines quit due to fuel starvation. Forced landing was made to unimproved field. Aircraft sustained substantial damage. Pilot…
- [NTSB FTW80FA096](https://openairdocs.org/ntsb/FTW80FA096.md): Aero Comdr 680FLP · Iola, TX · Accident · 2 fatal · Closed · Jul 25, 1980 · N6515V · 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" = '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 ('41535'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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