# Fatal NTSB investigations: 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 LAX01FA160](https://openairdocs.org/ntsb/LAX01FA160.md): Bellanca 14-19 · Casa Grande, AZ · Accident · 1 fatal · Field investigation · Final report · May 1, 2001 · N521A · Destroyed
  > A fuel leak on the cabin and engine sides of the firewall with a probable origin at the firewall pass-through fitting for the fuel pressure gage line. The fire likely began on the engine side of the firewall near the bottom with the explosive ignition of the…
- [NTSB ATL00FA009](https://openairdocs.org/ntsb/ATL00FA009.md): Cessna 210N · Chamblee, GA · Accident · 1 fatal · Field investigation · Final report · Nov 7, 1999 · N7317A · Destroyed
  > The failure of the flex hydraulic line and the chaffing of an electrical line under the pilot seat that resulted in an inflight fire. The pilot's inflight decision to continue flight with a known airplane deficiencies.
- [NTSB MIA93FA155](https://openairdocs.org/ntsb/MIA93FA155.md): Beech 95-A55 · Jacksonville, FL · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1993 · N2200Q · Destroyed
  > An explosion and fire from undetermined fuel and ignition sources in the left wing.
- [NTSB CHI93FA139](https://openairdocs.org/ntsb/CHI93FA139.md): Cessna 172I · Ettrick, WI · Accident · 2 fatal · Field investigation · Final report · Apr 18, 1993 · N8337L · Destroyed
  > An inflight explosion of a toluene-based fluid inside the airplane's cockpit.
- [NTSB NYC83FFJ03](https://openairdocs.org/ntsb/NYC83FFJ03.md): Sopwith Triplane · Allegany, NY · Accident · 1 fatal · Final report · Jul 22, 1983 · N5004 · Destroyed
  > The owner/plt of the home built, Sopwith triplane took off on a local flt. This was the 1st flt since some maintenance rework & a new propeller installation. After the acft was airborne for aprx 20 min, it was observed flying at about 500 ft AGL. Reportedly,…

## 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."highestInjuryLevel" = 'Fatal'
  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?fatal=1&occurrence=170

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