# NTSB investigations: Piper PA-22-108, LA

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 GAA18CA297](https://openairdocs.org/ntsb/GAA18CA297.md): Piper PA22 · Start, LA · Accident · Minor injuries · Data collection · Final report · May 23, 2018 · N4913Z · Substantial damage
  > The pilot’s improper landing flare, which resulted in a bounced landing.
- [NTSB DFW08LA130](https://openairdocs.org/ntsb/DFW08LA130.md): Piper PA-22-108 · Opelousas, LA · Accident · Minor injuries · Limited investigation · Final report · May 3, 2008 · N4515Z · Substantial damage
  > Loss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.
- [NTSB FTW83LA248](https://openairdocs.org/ntsb/FTW83LA248.md): Piper PA-22-108 · Breaux Bridge, LA · Accident · No injuries · Limited investigation · Final report · May 25, 1983 · N5208Z · Substantial damage
  > The acft nosed over during landing on a wet soft private grass strip. During landing the nose gear dug in and the acft nosed over. The plt stated that he needed more experience in judging grass strip conditions.
- [NTSB FTW72FRJ22](https://openairdocs.org/ntsb/FTW72FRJ22.md): Piper PA-22 · Downsville, LA · Accident · Serious injuries · Closed · Apr 14, 1972 · N5012Z · Substantial damage
- [NTSB FTW67D0252](https://openairdocs.org/ntsb/FTW67D0252.md): Piper PA-22 · Cloutierville, LA · Accident · No injuries · Closed · Sep 12, 1966 · N4964Z · Substantial damage
- [NTSB UNK64X1618](https://openairdocs.org/ntsb/UNK64X1618.md): Piper PA22 · Baton Rouge, LA · Accident · 2 fatal · Closed · May 4, 1964 · N3646Z · 2 aircraft · Destroyed

## 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" = 'LA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102204&state=LA

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