# NTSB investigations, 2017: 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 CEN18FA061](https://openairdocs.org/ntsb/CEN18FA061.md): Cessna 340 · Bartow, FL · Accident · 5 fatal · Field investigation · Final report · Dec 24, 2017 · N247AT · Destroyed
  > The pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.
- [NTSB WPR18FA046](https://openairdocs.org/ntsb/WPR18FA046.md): Beech A36 · San Diego, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2017 · N248SB · Destroyed
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ANC18FA012](https://openairdocs.org/ntsb/ANC18FA012.md): Cessna U206 · Maunaloa, HI · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2017 · N732DF · Destroyed
  > The pilot's decision to continue visual flight into an area of instrument meteorological conditions while conducting an instrument approach, which resulted in a loss of visual reference and subsequent controlled flight into terrain.
- [NTSB GAA18CA077](https://openairdocs.org/ntsb/GAA18CA077.md): Czech Sport Aircraft a.s. Sport Cruiser · Sacramento, CA · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N227US · Destroyed
  > The pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.
- [NTSB ERA18LA039](https://openairdocs.org/ntsb/ERA18LA039.md): Kevin Leue Sparrow Hawk · Hernando, MS · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2017 · N481ZK · Destroyed
  > Impact with trees and terrain for reasons that could not be determined based on available evidence.
- [NTSB CEN18LA019](https://openairdocs.org/ntsb/CEN18LA019.md): Air Tractor AT 502B · Olton, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 24, 2017 · N502G · Destroyed
  > The pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.
- [NTSB WPR17LA202](https://openairdocs.org/ntsb/WPR17LA202.md): Beech A24R · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 2017 · N9798L · Substantial damage
  > The airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.
- [NTSB CEN17FA334](https://openairdocs.org/ntsb/CEN17FA334.md): Vans RV-12 · Fishers, IN · Accident · 1 fatal · Field investigation · Final report · Aug 31, 2017 · N212ZF · Destroyed
  > The pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.
- [NTSB ERA17FA274](https://openairdocs.org/ntsb/ERA17FA274.md): Bell 407 · Charlottesville, VA · Accident · 2 fatal · Field investigation · Final report · Aug 12, 2017 · N31VA · Destroyed
  > The pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…
- [NTSB WPR17FA149](https://openairdocs.org/ntsb/WPR17FA149.md): Aviat A · Herriman, UT · Accident · 2 fatal · Field investigation · Final report · Jul 13, 2017 · N211AM · Destroyed
  > The flight instructor's decision to conduct a low-altitude flight into a box canyon in high density altitude conditions and his failure to maintain airspeed while maneuvering to escape the canyon, which resulted in an exceedance of the airplane's critical…
- [NTSB WPR17LA138](https://openairdocs.org/ntsb/WPR17LA138.md): Piper PA 28-140 · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2017 · N4244T · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.
- [NTSB GAA17CA365](https://openairdocs.org/ntsb/GAA17CA365.md): Beech 58 · Ingleside, TX · Accident · Minor injuries · Data collection · Final report · Jun 26, 2017 · N58SM · Destroyed
  > The pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.
- [NTSB WPR17LA097](https://openairdocs.org/ntsb/WPR17LA097.md): Robinson Helicopter R44 · Santa Barbara, CA · Accident · Serious injuries · Limited investigation · Final report · May 5, 2017 · N981RR · Destroyed
  > A total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.
- [NTSB ERA17FA167](https://openairdocs.org/ntsb/ERA17FA167.md): Cirrus Design SR22 · Wallingford, CT · Accident · 1 fatal · Field investigation · Final report · Apr 24, 2017 · N94LP · Destroyed
  > The pilot's unstablilized approach and improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain control during a go-around. Contributing to the accident was the pilot's lack of experience in the accident airplane…
- [NTSB ERA17FA140](https://openairdocs.org/ntsb/ERA17FA140.md): Beech A36 · Dadeville, AL · Accident · 2 fatal · Field investigation · Final report · Mar 28, 2017 · N8169Y · Destroyed
  > A loss of engine power for reasons that could not be determined due to postcrash thermal damage to the engine accessories and the airframe. Contributing to the accident was the pilot's failure to navigate to any of the available forced landing sites within…
- [NTSB CEN17FA138](https://openairdocs.org/ntsb/CEN17FA138.md): Beech V35 · Union City, OK · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2017 · N2053Y · Destroyed
  > The pilot's improper recovery from a spin.
- [NTSB ERA17FA131](https://openairdocs.org/ntsb/ERA17FA131.md): Air Tractor AT 602 · Minter City, MS · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2017 · N2049D · Destroyed
  > The pilot's incapacitation for reasons that could not be determined, which resulted in collision with trees and terrain.
- [NTSB ANC17LA017](https://openairdocs.org/ntsb/ANC17LA017.md): Beech G18 · Metlakatla, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 2017 · N103AF · Substantial damage
  > An engine power loss for reasons that could not be determined because the airplane was not recovered.
- [NTSB WPR17FA066](https://openairdocs.org/ntsb/WPR17FA066.md): Cessna T310Q · Riverside, CA · Accident · 4 fatal · Field investigation · Final report · Feb 28, 2017 · N1246G · Destroyed
  > The pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…
- [NTSB GAA17CA164](https://openairdocs.org/ntsb/GAA17CA164.md): Air Tractor AT 802 · Prentiss, MS · Accident · No injuries · Data collection · Final report · Feb 28, 2017 · N422BR · Substantial damage
  > The pilot's decision to take off with a gusting tailwind and his subsequent failure to maintain directional control.
- [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.

## 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 year(c."eventDate") = 2017
  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?year=2017

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