# Major 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 DCA90MA002](https://openairdocs.org/ntsb/DCA90MA002.md): Boeing 727-232 · Salt Lake City, UT · Accident · Minor injuries · Major investigation · Final report · Oct 14, 1989 · N530DA · Destroyed
  > A fire which started in the passenger oxygen system for undetermined reasons. Contributing to the accident was the failure of delta airlines to recognize, attend to and correct repeated leaks in the oxygen system.
- [NTSB DCA88MA052](https://openairdocs.org/ntsb/DCA88MA052.md): de Havilland DHC-8 · Seattle, WA · Accident · Serious injuries · Major investigation · Final report · Apr 16, 1988 · N819PH · Destroyed
  > Shortly after tkof from Seattle-tacoma intl airport, the crew noted a rt eng power loss and decided to return for a precautionary lndg. After lowering the lndg gear, a massive fire was discovered in the rt eng nacelle. After lndg, directional control and all…
- [NTSB DCA88MZ002](https://openairdocs.org/ntsb/DCA88MZ002.md): Mcdonnell Douglas DC-9-83 · Nashville, TN · Incident · Minor injuries · Final report · Feb 3, 1988 · N569AA · Minor damage
  > American flt 132 was loaded with undeclared & improperly marked haz mtrl (hm) packed in a fiber drum. It contained 5 galof 50% hydrogen peroxide solution (oxidizer) & 25 lbs of textreat s-w (corrosive agent; sodium orthosilicate-based mix),shipped by textile…

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

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