# Fatal NTSB investigations: Piper J4A

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 CEN15FA181](https://openairdocs.org/ntsb/CEN15FA181.md): Piper J-4A · Pine River, MN · Accident · 2 fatal · Field investigation · Final report · Mar 28, 2015 · N30341 · Substantial damage
  > The pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…
- [NTSB ATL87FA136](https://openairdocs.org/ntsb/ATL87FA136.md): Piper J4A · Collierville, TN · Accident · 2 fatal · Field investigation · Final report · May 10, 1987 · N25020 · Destroyed
  > It was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…
- [NTSB NYC84FNE03](https://openairdocs.org/ntsb/NYC84FNE03.md): Piper J4A · Gardner, MA · Accident · 1 fatal · Final report · Jul 14, 1984 · N33290 · Destroyed
  > During climbout, plt noted slight pwr loss, applied carb heat & eng regained pwr. On removal of carb heat, pwr loss (aprx 200 RPM) again occurred. Application of carb heat again resorted pwr but plt elected to turn back to field and land. During turn, plt…
- [NTSB NYC73AN127](https://openairdocs.org/ntsb/NYC73AN127.md): Piper J4A · Pennington, NJ · Accident · 1 fatal · Closed · Mar 29, 1973 · N32780 · Destroyed
- [NTSB LAX70F0073](https://openairdocs.org/ntsb/LAX70F0073.md): Piper J4A · Ramona, CA · Accident · 1 fatal · Closed · Aug 3, 1969 · N27882 · Destroyed
- [NTSB OAK66A0041](https://openairdocs.org/ntsb/OAK66A0041.md): Piper J4 · Healdsburg, CA · Accident · 2 fatal · Closed · Mar 25, 1966 · N26807 · Destroyed
- [NTSB MIA66F0346](https://openairdocs.org/ntsb/MIA66F0346.md): Piper J4A · Greenville, MS · Accident · 1 fatal · Closed · Dec 4, 1965 · N24563 · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100604'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7100604

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