# NTSB investigations: Piper PA-28R-201, GA

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 ERA23LA303](https://openairdocs.org/ntsb/ERA23LA303.md): Piper PA-28R-201 · Macon, GA · Accident · No injuries · Class 4 · Limited · Final report · Jun 24, 2023 · N285MG · Substantial damage
  > An inflight collision with a bird.
- [NTSB ATL07CA074](https://openairdocs.org/ntsb/ATL07CA074.md): Piper PA-28R-201 · Waynesboro, GA · Accident · No injuries · Data collection · Final report · Apr 12, 2007 · N47944 · Substantial damage
  > Company maintenance personnel’s improper installation of an unapproved oil quick drain plug which resulted in oil exhaustion and subsequent loss of engine power during cruise flight.
- [NTSB ATL87FA104](https://openairdocs.org/ntsb/ATL87FA104.md): Piper PA-28R-201 · Rhine, GA · Accident · 1 fatal · Field investigation · Final report · Apr 3, 1987 · N47887 · Destroyed
  > The non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide.
- [NTSB ATL82FA278](https://openairdocs.org/ntsb/ATL82FA278.md): Piper PA-28R-201 · Alma, GA · Accident · 2 fatal · Field investigation · Final report · Sep 10, 1982 · N39685 · Destroyed
  > During his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day…

## 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" = 'GA' 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 ('7102816', '7102833'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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