# NTSB investigations: Piper J-3C, 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 ERA10CA366](https://openairdocs.org/ntsb/ERA10CA366.md): Piper J-3C · Buckhead, GA · Accident · No injuries · Data collection · Final report · Jul 18, 2010 · N98342 · Substantial damage
  > An in-flight encounter with a downdraft during a go-around, resulting in a collision with trees and the ground.
- [NTSB ATL83LA109](https://openairdocs.org/ntsb/ATL83LA109.md): Piper J-3C · Stockbridge, GA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1983 · N88037 · Substantial damage
  > The acft collided with a tree during a forced landing. The plt stated that the acft engine quit shortly after takeoff. Examination of the engine and fuel system failed to reveal any discrepancies or malfunctions. An external fuel tank was connected to the…
- [NTSB MIA73FKG51](https://openairdocs.org/ntsb/MIA73FKG51.md): Piper J3C-65 · Cordele, GA · Accident · No injuries · Closed · Dec 3, 1972 · N3545N · 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 ('7100503'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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