# NTSB investigations: Piper PA-28-236, NJ

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 NYC06FA133](https://openairdocs.org/ntsb/NYC06FA133.md): Piper PA-28-236 · Manahawkin, NJ · Accident · 4 fatal · Field investigation · Final report · May 31, 2006 · N48ED · Substantial damage
  > The noninstrument-rated pilot's inadvertent VFR cruise flight into instrument meteorological conditions, and his subsequent loss of aircraft control, which resulted in his exeeding the design stress limits of the airplane, and an in-flight separation of the…
- [NTSB NYC94FA178](https://openairdocs.org/ntsb/NYC94FA178.md): Piper PA-28-236 · Vernon, NJ · Accident · 2 fatal · Field investigation · Final report · Sep 16, 1994 · N81X · Destroyed
  > The pilot's failure to maintain aircraft control which resulted a loss of control and inflight collision with the terrain.
- [NTSB NYC93LA129](https://openairdocs.org/ntsb/NYC93LA129.md): Piper PA-28-236 · West Milford, NJ · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1993 · N8220J · Substantial damage
  > A manufacturer's defect which resulted in fatigue failure of the magneto impluse coupling spring and the loss of engine power. A factor was unsuitable terrain.
- [NTSB NYC91LA054](https://openairdocs.org/ntsb/NYC91LA054.md): Piper PA-28-236 · Wildwood, NJ · Accident · No injuries · Limited investigation · Final report · Jan 1, 1991 · N81839 · Substantial damage
  > The pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.
- [NTSB NYC85FA029](https://openairdocs.org/ntsb/NYC85FA029.md): Piper PA-28-236 · Atlantic City, NJ · Accident · 4 fatal · Field investigation · Final report · Nov 17, 1984 · N2831Y · Destroyed
  > The aircraft was observed in close proximity to another aircraft in the traffic pattern. The pilot extended the downleg leg leg. During the turn to align the aircraft with the runway the pilot suffered a disabling heart attack. Unable to recover the aircraft…

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

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

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