# NTSB investigations, OR: Fire/smoke (non-impact)

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 WPR19LA237](https://openairdocs.org/ntsb/WPR19LA237.md): Cessna T210 · Eugene, OR · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2019 · N501SF · Substantial damage
  > The failure of the landing gear electric motor to shut off after landing gear retraction, which resulted in the motor overheating, burning out, and producing smoke in the cockpit. The pilot’s decision to land with the landing gear retracted resulted in…
- [NTSB WPR19LA189](https://openairdocs.org/ntsb/WPR19LA189.md): Vans RV14 · Aumsville, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N365EM · Destroyed
  > An inflight fire that originated in the engine compartment for reasons that could not be determined based on available evidence.
- [NTSB WPR09LA361](https://openairdocs.org/ntsb/WPR09LA361.md): Piper PA-46-350P · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Jul 21, 2009 · N117KR · Substantial damage
  > An undetermined hydraulic system malfunction in the engine compartment during descent from cruise flight which resulted in an in-flight fire.

## 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" = 'OR' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '150')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/150/cases?state=OR

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