NTSB investigations: Piper PA-28-235, 1982
9 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
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\") = 1982
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") = 1982
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 SEA83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Vernonia, ORThe acft was observed high & fast during the approach & touched down about 300 ft from the departure end of the turf rwy. During the go-around the acft struck a wood fence, crossed a road & crashed in a "stumped off" area.NTSB DEN82DA167Accident · Serious injuriesFinal reportPiper PA-28-235 · Englewood, COThe engine quit on downwind and the pilot attempted to land downwind on the runway but crashed off the airport. The fuelselector was found on an auxiliary tank. According to the pilot and other operators of the aircraft, only about three gallons of fuel are…NTSB MKC82DA144Accident · No injuriesFinal reportPiper PA-28-235 · Springfield, MOAfter passing over an imaginary obstacle during a short field landing, the student flared high without adding sufficientpower causing the acft to increase the descent rate. The CFI took control but was too late resulting in a hard landing.NTSB MKC82DA127Accident · No injuriesFinal reportPiper PA-28-235D · Falls City, NEThe pilot reported that while he was landing with a 6 to 7 kt crosswind, the plane was blown toward the left side of the runway. In order to avoid the runway lights, he intentionally maneuvered the aircraft off the side of the runway, into the grass. When he…NTSB ANC82DAG35Accident · Minor injuriesFinal reportPiper PA-28-140 · Wasilla, AKPilot had opportunity to refuel and did not. On one flight before accident he successfully made a forced landing due to fuel starvation. He figured he had enough fuel for one more flight. During this flight engine quit and the pilot landed in a ditch…NTSB CHI82DA122Accident · Minor injuriesFinal reportPiper PA-28-235 · Graytown, OHDuring landing roll the aircraft contacted a soft area on the pilot's privately owned sod runway. The nose gear collapsed and the aircraft came to rest with the tail in the air.NTSB FTW82DA106Accident · Minor injuriesFinal reportPiper PA-28-235 · Tulsa, OKThe aircraft experienced a partial power loss during takeoff at an altitude of about 150 AGL. The pilot turned left with the intention of landing on a perpendicular taxiway. During the turn the aircraft developed a high sink-rate and struck the taxiway in a…NTSB LAX82FA049Accident · 2 fatalField investigationFinal reportMooney M20C · Victorville, CAThe pilot had planned to fly to the big bear airport, but changed his destination to apple valley, California. While on an easterly heading at about 6800 ft MSL, a collision occurred with another aircraft, a Mooney M20C, N7860V. The Piper pilot believed that…NTSB LAX82FA050Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · 10nm N. Of Mcna, AZWhile on a cross country flight the pilot flew into weather which included severe to moderate icing conditions. Although the weather was forecast for the intended route of flight in a SIGMET it was not provided to the pilot during the initial weather…