# NTSB investigations: Enstrom F-28C, 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 CEN13LA099](https://openairdocs.org/ntsb/CEN13LA099.md): Enstrom F-28C · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 2012 · N574H · Substantial damage
  > The flight instructor's failure to conduct an autorotation following the loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the flight instructor and the student pilot to visually check fuel levels to ensure adequate…
- [NTSB FTW97LA094](https://openairdocs.org/ntsb/FTW97LA094.md): Enstrom F-28C · Lake Jackson, TX · Accident · No injuries · Limited investigation · Final report · Jan 30, 1997 · N51774 · Destroyed
  > The failure of the #2 cylinder for an undetermined reason which resulted in an exhaust leak that melted an oil line.
- [NTSB FTW91FA002](https://openairdocs.org/ntsb/FTW91FA002.md): Enstrom F28-C · Mesquite, TX · Accident · 1 fatal · Field investigation · Final report · Oct 7, 1990 · N88RA · Destroyed
  > Installation error of company maintenance personnel. Factors were the unsuitable terrain, the tailwind, the inability of the pilot to maintain main rotor RPM, and the inadequate annual inspection by company maintenance personnel.
- [NTSB FTW89LA079](https://openairdocs.org/ntsb/FTW89LA079.md): Enstrom F28C · Padre Island, TX · Accident · No injuries · Limited investigation · Final report · Apr 8, 1989 · N51774 · Substantial damage
  > The pilot's decision to fly in adverse weather condition. The adverse weather was a related factor.
- [NTSB FTW80DRG11](https://openairdocs.org/ntsb/FTW80DRG11.md): Enstrom F-28C · Port Mansfield, TX · Accident · No injuries · Closed · Dec 7, 1979 · N51759 · Substantial damage
- [NTSB FTW79DRG45](https://openairdocs.org/ntsb/FTW79DRG45.md): Enstrom F-28C · Victoria, TX · Accident · No injuries · Closed · Jul 13, 1979 · N51774 · 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 ('3300407'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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