# NTSB investigations, AZ: Fire/smoke (post-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 WPR23LA022](https://openairdocs.org/ntsb/WPR23LA022.md): Beech V35B · Nogales, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 20, 2022 · N50JM · Destroyed
  > The pilot’s failure to establish a positive rate of climb before retracting the landing gear when he executed an aborted landing, which resulted in a propeller strike, diminished climb performance, and the inadvertent contact with terrain.
- [NTSB WPR22FA348](https://openairdocs.org/ntsb/WPR22FA348.md): Trom Wayne Vans RV6A · Aztec, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Sep 16, 2022 · N646RV · Destroyed
  > The total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…
- [NTSB WPR18FA266](https://openairdocs.org/ntsb/WPR18FA266.md): Beech 33 · Cottonwood, AZ · Accident · 1 fatal · Class 2 · Field · Final report · Sep 17, 2018 · N2031D · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR18MA087](https://openairdocs.org/ntsb/WPR18MA087.md): Eurocopter EC130 · Peach Springs, AZ · Accident · 5 fatal · Class 3 · Major · Final report · Feb 11, 2018 · N155GC · Destroyed
  > A loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.
- [NTSB WPR17FA057](https://openairdocs.org/ntsb/WPR17FA057.md): Beech 300 · Tucson, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 23, 2017 · N385KA · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.
- [NTSB WPR12CA196](https://openairdocs.org/ntsb/WPR12CA196.md): Cessna 195 · Heber-Overgaard, AZ · Accident · No injuries · Data collection · Final report · May 5, 2012 · N3442V · Substantial damage
  > The pilot's loss of directional control during takeoff roll upon encountering a wind gust.
- [NTSB SEA08FA187](https://openairdocs.org/ntsb/SEA08FA187.md): Piper PA-28-180 · Springerville, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2008 · N5316L · Substantial damage
  > The pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.

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

This list as a web page: https://openairdocs.org/ntsb-events/170/sequence?state=AZ

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