# NTSB investigations, AL: Powerplant sys/comp malf/fail

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 ERA23LA286](https://openairdocs.org/ntsb/ERA23LA286.md): Grumman American Avn. AA5A · Redstone Arsenal, AL · Accident · No injuries · Class 3 · Limited · Final report · Jul 4, 2023 · N26387 · Substantial damage
  > The separation of the clamp assembly securing the throttle control cable outer housing, which resulted in the pilot’s inability to control the throttle.
- [NTSB ERA22LA380](https://openairdocs.org/ntsb/ERA22LA380.md): Cessna 150 · Berry, AL · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2022 · N8797G · Substantial damage
  > A partial loss of engine power due to the No. 3 cylinder’s stuck exhaust valve.
- [NTSB ERA22LA071](https://openairdocs.org/ntsb/ERA22LA071.md): Cessna 210 · Brent, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 21, 2021 · N5779J · Substantial damage
  > The inadequate maintenance of the oil filter adapter, which resulted in in an engine oil leak and subsequent loss engine oil pressure, and the subsequent off-airport landing.
- [NTSB ERA14LA257](https://openairdocs.org/ntsb/ERA14LA257.md): P&M Quikr · Gulf Shores, AL · Accident · Serious injuries · Limited investigation · Final report · May 22, 2014 · N428PM · Minor damage
  > The pilot’s failure to maintain aircraft control during engine startup, which resulted in a collision with a parked airplane. Contributing to the accident was the pilot’s failure to follow engine startup procedures and a sudden surge of engine power for…
- [NTSB NYC08CA208](https://openairdocs.org/ntsb/NYC08CA208.md): Cessna 177RG · Bessemer, AL · Accident · Minor injuries · Data collection · Final report · Jun 8, 2008 · N45133 · Substantial damage
  > Failure of the left magneto for undetermined reasons resulting in a partial loss of engine power during takeoff.

## 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" = '340' 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/340/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.