NTSB investigations: Piper PA-28-236, 1985
4 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
| 1979 | 3 |
|---|---|
| 1980 | 4 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 5 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 5 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 1 |
| 2021 | 1 |
| 2024 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 NYC86FA015Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Tobyhanna, PAAt about the time N4298K was departing pocono mountains mun icipal airport, recorded radar information from new york ARTCC displayed an aircraft in that area. The aircraft flew eastward and then northward. The aircraft disappeared from the radar screen about…NTSB NYC85LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · New Milford, CTAccording to the plt, the preflt and runup checks were normal. The plt then applied full pwr for takeoff and rotation was initiated at 60 KTS. After liftoff, the acft appeared to loose pwr and began to yaw to the left. The stall warning horn sounded and the…NTSB MKC85LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Concordia, KSThe student plt was making a night flt. He received wind information from an arpt 48 miles from the destination but used an indication from lighted wind indicator. Plt made a go around because the ground speed was fast. During the next attempt, he landed, ran…NTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…