# NTSB investigations: Garrett TFE731 series: Loss of control - on ground/water

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 NYC02IA118](https://openairdocs.org/ntsb/NYC02IA118.md): Learjet 35A · Oxford, CT · Incident · No injuries · Incident investigation · Final report · Jun 17, 2002 · N989AL · Minor damage
  > The flight instructor's inadequate supervision of the commercial pilot during a touch and go landing, including his failure to properly brief the commercial to not use reverse thrust during a touch and go landing.
- [NTSB MKC89LA161](https://openairdocs.org/ntsb/MKC89LA161.md): Gates Learjet Learjet 35 · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1989 · N701AS · Substantial damage
  > Failure of the pilot to maintain directional control and runway alignment during the landing. Factors related to the accident were: adverse weather/runway/terrain conditions, failure of the local controller to warn the pilot of possible hydroplaning…
- [NTSB NYC86LA042](https://openairdocs.org/ntsb/NYC86LA042.md): Israel Aircraft Industries WW-24 · Worcester, MA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1985 · N4WG · Substantial damage
  > According to the pilot, the flight was normal, upon touchdown the reversers were deployed, pilot had information that braking action was poor and rwy was icy but had been sanded, pilot landed on the left side of the rwy centerline aircraft began to drift…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('29001')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=29001&occurrence=260

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