# NTSB investigations, AL: 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 ERA24FA050](https://openairdocs.org/ntsb/ERA24FA050.md): Piper PA32R · Attalla, AL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 27, 2023 · N4187Q · Destroyed
  > The undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…
- [NTSB ERA18LA177](https://openairdocs.org/ntsb/ERA18LA177.md): Crawford RV-7 · Alexander City, AL · Accident · No injuries · Limited investigation · Final report · Jun 24, 2018 · N19MM · Destroyed
  > A total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [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 ERA16LA171](https://openairdocs.org/ntsb/ERA16LA171.md): Cessna 421 · Foley, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 2016 · N3372Q · Destroyed
  > The pilot's failure to obtain proper takeoff speed before breaking ground, which resulted in the airplane’s failure to gain altitude and a collision with trees and terrain.
- [NTSB ERA15LA296](https://openairdocs.org/ntsb/ERA15LA296.md): Bell 47G 3B 1 · Camden, AL · Accident · No injuries · Limited investigation · Final report · Aug 3, 2015 · N4002G · Substantial damage
  > A failure of the helicopter's hydraulic flight control systems for reasons that could not be determined due to the fire damage, and the pilot's inability to turn off the hydraulic system to relieve control pressure.
- [NTSB ERA14FA300](https://openairdocs.org/ntsb/ERA14FA300.md): Israel Aircraft Industries 1124A · Huntsville, AL · Accident · 3 fatal · Field investigation · Final report · Jun 18, 2014 · N793BG · Destroyed
  > The flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…
- [NTSB ERA14LA147](https://openairdocs.org/ntsb/ERA14LA147.md): Cessna 172D · Fairhope, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 8, 2014 · N2755U · Destroyed
  > The pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.
- [NTSB NYC08LA270](https://openairdocs.org/ntsb/NYC08LA270.md): Piper PA-12 · Brownsboro, AL · Accident · 2 fatal · Limited investigation · Final report · Aug 5, 2008 · N7820H · Substantial damage
  > The pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.

## 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" = 'AL' 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=AL

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