NTSB investigations: Piper PA-28-235, 1986
7 cases on aircraft the registry lists as Piper PA-28-235. 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
| 1964 | 27 |
|---|---|
| 1965 | 40 |
| 1966 | 30 |
| 1967 | 32 |
| 1968 | 34 |
| 1969 | 16 |
| 1970 | 24 |
| 1971 | 13 |
| 1972 | 30 |
| 1973 | 14 |
| 1974 | 16 |
| 1975 | 14 |
| 1976 | 18 |
| 1977 | 14 |
| 1978 | 15 |
| 1979 | 8 |
| 1980 | 10 |
| 1981 | 11 |
| 1982 | 9 |
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 7 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 7 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 5 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 7 |
| 2001 | 6 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 7 |
| 2009 | 4 |
| 2010 | 5 |
| 2011 | 7 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 5 |
| 2020 | 6 |
| 2021 | 2 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 3 |
Where
Latest 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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
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 LAX87LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hayward, CAA Piper PA-28-235 collided with a dirt bank after a loss of power while on a night VFR pleasure flight. The plt indicated that aprx 3 min after takeoff while cruising at 1,400 ft MSL the engine RPM abruptly decreased to idle. The fuel selector control was…NTSB NYC87FA021Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Jamestown, NYThe non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to…NTSB CHI86FA200Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Shelby, INThe non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…NTSB DEN86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Last Chance, COThe plt said while on landing roll a cross wind drifted N8844W off right hand side of rwy on a farm strip. Lost control in soft dirt and nosed over. The vehicle was substantially damaged, and the plt was uninjured.NTSB NYC86LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westport, NYThe Piper PA-28-235 made an off airport landing at night in conditions of reduced visibility, with rain, gusty winds and thunderstorms in the area. The aircraft received substantial damage and the pilot received serious injuries. Post crash examination of the…NTSB ATL86LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Middle Bass Is., OHHeavy rains had flooded the causeway that connected Middle Bass island to the main island. A family was in need of transportation off the island and the pilot was attempting to fly them to the mainland using the 2,100 foot grass airstrip. The airstrip was wet…NTSB FTW86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Springtown, TXThe pilot reported colliding with a fence at the end of the runway when he landed short while on final approach into kezer airport near Springtown, TX. His aircraft sustained substanial damage to the left wing, nose gear and propeller after travelling 200 ft.…