# NTSB investigations, TN: Fire

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 ATL97LA078](https://openairdocs.org/ntsb/ATL97LA078.md): Piper PA-31-350 · Sparta, TN · Accident · No injuries · Limited investigation · Final report · May 20, 1997 · N4105Q · Substantial damage
  > A fire in the left engine started by a leak in the fuel pump.
- [NTSB ATL97LA050](https://openairdocs.org/ntsb/ATL97LA050.md): Piper PA-32-300 · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Mar 16, 1997 · N1102N · Substantial damage
  > failure of maintenance personnel to properly inspect (and repair) the brake assembly, which allowed a subsequent brake fluid leak and eventual fire.
- [NTSB ATL86FA085](https://openairdocs.org/ntsb/ATL86FA085.md): Beech BE-90 · Mount Pleasant, TN · Accident · No injuries · Field investigation · Final report · Mar 4, 1986 · N861K · Substantial damage
  > On final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal…
- [NTSB ATL83FA174](https://openairdocs.org/ntsb/ATL83FA174.md): Piper PA 32RT-300T · Murfreesboro, TN · Accident · 2 fatal · Field investigation · Final report · May 2, 1983 · N22011 · Destroyed
  > The acft crashed in an open field after an in-flt fire. The fire started while the acft was cruising. No emergency callswere made and the engine which was the fire source was not shut down. A rear seat passenger said he tried to open a reardoor to let out…

## 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" = 'TN' AND c."eventCountry" = 'USA'
  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" = 171)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=171&state=TN

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