# NTSB investigations: Piper J3C-85

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 CEN10CA468](https://openairdocs.org/ntsb/CEN10CA468.md): Piper J3C-85 · Auburn, IN · Accident · No injuries · Data collection · Final report · Aug 3, 2010 · N98022 · 2 aircraft · Substantial damage
  > The pilot of the other airplane failing to monitor the position this airplane.
- [NTSB FTW83LA020](https://openairdocs.org/ntsb/FTW83LA020.md): Piper J-3 · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · Oct 24, 1982 · N38449 · Substantial damage
  > When the confederate air force failed to show up for an airshow the pilot was asked to make some low passes over the airport and explosive charges were to be set off to simulate bomb bursts. During one low pass the charges were exploded too soon. The…
- [NTSB SEA80FYM44](https://openairdocs.org/ntsb/SEA80FYM44.md): Piper J3C-85 · Hood River, OR · Accident · No injuries · Closed · Jul 7, 1980 · N7116H · Substantial damage
- [NTSB SEA79FTA01](https://openairdocs.org/ntsb/SEA79FTA01.md): Piper J-3 · Belfry, MT · Accident · No injuries · Closed · Sep 28, 1978 · N33160 · Substantial damage
- [NTSB MIA74FLD59](https://openairdocs.org/ntsb/MIA74FLD59.md): Piper J3 · Titusville, FL · Accident · Serious injuries · Closed · Jan 27, 1974 · N33JG · Substantial damage
- [NTSB FTW73DRJ26](https://openairdocs.org/ntsb/FTW73DRJ26.md): Piper J3C-85 · Glenmora, LA · Accident · No injuries · Closed · Mar 7, 1973 · N6529H · Substantial damage
- [NTSB DIA70F0048](https://openairdocs.org/ntsb/DIA70F0048.md): Piper J3C-65 · Mt Airy, NC · Accident · No injuries · Closed · Aug 12, 1969 · N38449 · Substantial damage
- [NTSB MIA66A0069](https://openairdocs.org/ntsb/MIA66A0069.md): Piper J3C-65 · Metter, GA · Accident · 2 fatal · Closed · Dec 17, 1965 · N7060H · Substantial damage
- [NTSB NYC65F0209](https://openairdocs.org/ntsb/NYC65F0209.md): Piper J3C · W Winfield, NY · Accident · No injuries · Closed · May 6, 1965 · N42782 · Substantial damage
- [NTSB UNK64X0377](https://openairdocs.org/ntsb/UNK64X0377.md): Piper J3C-65 · Puget Sound, WA · Accident · 1 fatal · Closed · Jan 26, 1964 · N98319 · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100525'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7100525

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