# Major NTSB investigations: Loss of engine power(partial) - mech failure/malf

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 FTW90MA161](https://openairdocs.org/ntsb/FTW90MA161.md): Grumman G-159 · Houston, TX · Accident · 3 fatal · Major investigation · Final report · Aug 23, 1990 · N80RD · Destroyed
  > Partial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…
- [NTSB DCA88MA011](https://openairdocs.org/ntsb/DCA88MA011.md): Piper PA-31-350 · Kenai, AK · Accident · 6 fatal · Major investigation · Final report · Dec 23, 1987 · N496SC · Destroyed
  > The pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…
- [NTSB DCA87MA024](https://openairdocs.org/ntsb/DCA87MA024.md): Lockheed L-382G · Travis Afb, CA · Accident · 5 fatal · Major investigation · Final report · Apr 9, 1987 · N517SJ · Destroyed
  > Crashed in steep left turn drg go-around after balked landing. Instructor took controls and initiated go-around after student lndd in improper attitude. Engines number 1 & 2 failed to respond when throttles advanced. Both engines decelerated. Airspeed…
- [NTSB BFO87MA007](https://openairdocs.org/ntsb/BFO87MA007.md): Beech 65-A80 · Baltimore, MD · Accident · 1 fatal · Major investigation · Final report · Nov 8, 1986 · N304D · Destroyed
  > Drg clb after tkof, l eng seized. Plt said he atmtd 1 eng restart; prop would not rotate or feather. No emerg declared. Plt stated eng shut-dwn proc was used, scientific bus sws were shut off, r gen was recycled & appeared to oper normally. Plts got imt…
- [NTSB FTW86MA018](https://openairdocs.org/ntsb/FTW86MA018.md): Bell 222UT · East Cameron · Accident · 2 fatal · Major investigation · Final report · Oct 24, 1985 · N3194M · Destroyed
  > Three pax rprtd that just prior to reaching the helipad, the helicopter's forward movement stopped and the helicopter wobbled or yawed from side to side. The pax's rprted that the pilot appeared to be trying to gain altitude and go forward when they heard a…
- [NTSB DCA85AA036](https://openairdocs.org/ntsb/DCA85AA036.md): Douglas DC-9-14 · Milwaukee, WI · Accident · 31 fatal · Final report · Sep 6, 1985 · N100ME · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&occurrence=352

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