# NTSB investigations: Piper PA-36-300, 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 ERA12LA195](https://openairdocs.org/ntsb/ERA12LA195.md): Piper PA-36-300 · Americus, GA · Accident · No injuries · Limited investigation · Final report · Feb 25, 2012 · N59661 · Substantial damage
  > The failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.
- [NTSB ATL81FKG39](https://openairdocs.org/ntsb/ATL81FKG39.md): Piper PA-36 · Kildare, GA · Accident · No injuries · Closed · Jul 29, 1981 · N57865 · Substantial damage
- [NTSB MIA79DKG56](https://openairdocs.org/ntsb/MIA79DKG56.md): Piper PA-36 · Denton, GA · Accident · No injuries · Closed · Jul 25, 1979 · N57880 · Substantial damage
- [NTSB MIA78FKG71](https://openairdocs.org/ntsb/MIA78FKG71.md): Piper PA-36 · Cordele, GA · Accident · Minor injuries · Closed · Aug 13, 1978 · N59692 · Destroyed
- [NTSB MIA77FKG76](https://openairdocs.org/ntsb/MIA77FKG76.md): Piper PA36 · Byromville, GA · Accident · No injuries · Closed · Sep 12, 1977 · N57831 · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=7103612&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.