NTSB investigations: Piper PA-28-236, NJ
5 cases on aircraft the registry lists as Piper PA-28-236. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1984 | 1 |
|---|---|
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2006 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC06FA133Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Manahawkin, NJThe 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 NYC94FA178Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Vernon, NJThe pilot's failure to maintain aircraft control which resulted a loss of control and inflight collision with the terrain.NTSB NYC93LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · West Milford, NJA 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 NYC91LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wildwood, NJThe pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.NTSB NYC85FA029Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Atlantic City, NJThe 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…