# NTSB investigations, 1987: Fire/explosion

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 MIA88LA033](https://openairdocs.org/ntsb/MIA88LA033.md): Piper PA-23-250 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 1987 · N5086Y · Destroyed
  > Plt stated that shortly after starting the left engine he heard an explosion and saw flame spreading from the accessory area of the left engine toward the left wing tip and the cabin. He shut down the engine by turning off the magnetos and he and his…
- [NTSB NYC87LA256](https://openairdocs.org/ntsb/NYC87LA256.md): Cessna 310N · Williamsport, PA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1987 · N4166Q · Substantial damage
  > After landing, the cargo was unloaded & the acft was prepared for departure. The plt stated the preflight was normal & satisfactory. He rprtd that when the left eng was started, he heard a loud 'pop' & observed 'flame traces and smoke.' He immediately shut…
- [NTSB DEN87LA217](https://openairdocs.org/ntsb/DEN87LA217.md): Rockwell 200D · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Aug 14, 1987 · N2909T · Substantial damage
  > The pilot stated that he was on a ferry flight to Ogden, UT and experienced smoke in the cockpit shortly after deprt. The pilot executed a straight in visual approach to runway 34 and before he was able to stop the aircraft a fire erupted. The aircraft was…
- [NTSB SEA87IA119](https://openairdocs.org/ntsb/SEA87IA119.md): de Havilland DHC-8-101 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jun 19, 1987 · N813PH · Minor damage
  > The crew of the scheduled airline passenger flight experienced an explosion and fire in the right engine at approx 800 ft AGL during initial climb after takeoff. The pilot shut the engine down, activated two fire bottles, which extinguished the fire and…

## 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 year(c."eventDate") = 1987
  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" = 170)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=170&year=1987

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