NTSB investigations: Piper PA-28R-200, 1982
15 cases on aircraft the registry lists as Piper PA-28R-200. 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
| 1969 | 5 |
|---|---|
| 1970 | 10 |
| 1971 | 11 |
| 1972 | 27 |
| 1973 | 37 |
| 1974 | 39 |
| 1975 | 39 |
| 1976 | 44 |
| 1977 | 50 |
| 1978 | 41 |
| 1979 | 25 |
| 1980 | 27 |
| 1981 | 25 |
| 1982 | 15 |
| 1983 | 20 |
| 1984 | 13 |
| 1985 | 11 |
| 1986 | 15 |
| 1987 | 15 |
| 1988 | 17 |
| 1989 | 15 |
| 1990 | 11 |
| 1991 | 14 |
| 1992 | 17 |
| 1993 | 13 |
| 1994 | 18 |
| 1995 | 8 |
| 1996 | 8 |
| 1997 | 18 |
| 1998 | 12 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 11 |
| 2004 | 6 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 4 |
| 2009 | 8 |
| 2010 | 7 |
| 2011 | 3 |
| 2012 | 7 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 10 |
| 2016 | 9 |
| 2017 | 11 |
| 2018 | 5 |
| 2019 | 8 |
| 2020 | 4 |
| 2021 | 5 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 5 |
| 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\") = 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 ('7102811'))
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 ('7102811'))
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 FTW83FRD01Accident · 3 fatalFinal reportPiper PA-28R-200 · Henderson, LAThe pilot and two passengers were on a flight from beaumont, TX to covington, LA. The non-instrument rated pilot departed on a special VFR clearance. At that time, the weather at beaumont was 300 ft overcast, visibility 12 mi. When the aircraft was about 10…NTSB ATL83FLG03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Cleveland, SCThe plt stated he was VFR on top of a broken cloud layer & decided to descend through an opening. After descending clear of the clouds he was in a pass with hills on each side & not enough room to turn around. He continued north along the highway hoping the…NTSB LAX82DA348Accident · No injuriesFinal reportPiper PA-28R-200 · Prescott, AZAccording to the pilot, he planned a fuel stop at needles, CA, but was unaware that services were not available until after arrival. He departed needles with low fuel in both tanks and attempted to reach Prescott, AZ before dark. However, darkness occurred…NTSB ATL82DA264Accident · No injuriesFinal reportPiper PA-28R · Sewanee, TNEnroute the oil pressure dropped to zero & shortly thereafter the prop seized due to oil starvation. Post exam revealed a crack in the prop governor oil line, P/N76157, at the bend about 1 inch away from the "b" nut attaching the line to the elbow fitting at…NTSB MKC82FA161Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Mediapolis, IADuring the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…NTSB DEN82DA137Accident · No injuriesFinal reportPiper PA-28R · Near Almosa, COThe pilot stated that during flight, his oil temperature began to rise and he elected to land on an abandoned air strip. During the landing, the aircraft encountered rough, uneven terrain, and subsequently, the landing gear and right wing were damaged. An…NTSB CHI82DA238Accident · No injuriesFinal reportPiper PA-28-200R · Black River Fal, WIThe pilot stated that during flight, he encountered an engine problem and started to land on a road, but then the engine began to run better, so he continued to his destination. After landing, he discovered that a portion of the vertical stabilizer (about 18…NTSB ATL82FKW07Accident · Serious injuriesFinal reportPiper PA-28 · Hohenwald, TNOriginally, the pilot departed on a flight from olive branch, ms to lawrenceburg, TN. While en route, he became disoriented and landed at lafayette, TN. From there he proceeded to lawrenceburg via lebanon, TN. After departing lebanon, he became disoriented…NTSB SEA82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Hillsboro, OROn touchdown the left main gear collapsed. No green down and locked light was observed prior to touchdown and the pilot made no attempt to go around, recycle the gear, OR other landing gear malfunction procedures. A retraction check after the accident showed…NTSB CHI82DA165Accident · No injuriesFinal reportPiper PA-28R · Stow, OHThe instructor pilot and his student, a rated private pilot, were on a flight to provide dual instruction for a commercial pilot certificate. A landing approach was made to a runway with a slight downslope in the touchdown area. The instructor estimated that…NTSB MIA82DA122Accident · No injuriesFinal reportPiper PA-28 · High Springs, FLThe pilot stated that the wind shifted while landing and the aircraft overran runway 18 colliding with a fence. The gainsville 1018 EDT weather observation reported the winds from 190 degrees at 18 knots.NTSB LAX82FVW03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Las Vegas, NVThe pilot reported that during the night landing, he maintained a little more than normal speed and power since this was his first night landing at the mccarran airport. He stated that on final approach for landing, heavy left rudder was needed. He stated he…NTSB NYC82DA067Accident · No injuriesFinal reportPiper PA-28R-200 · Butler, PAApproximately 100 feet after touchdown a gust of wind lifted the left wing of the aircraft turning it into the wind. Directional control was lost and the aircraft collided with two parked aircraft. A PA-22, N54572, and an Ercoupe, N93552, both of which…NTSB ATL82DA028Accident · No injuriesFinal reportPiper PA-28R-200 · Gastonia, NCDuring flight, the engine surged and the propeller speed went to 3000 RPM. The pilot retarded the prop control, and maintained 2400 RPM. He proceeded to the Gastonia airport and landed without further incident. A ground run-up was made and all instruments and…NTSB FTW82DA035Accident · Minor injuriesFinal reportPiper PA-28R-200 · Estancia, NMThe pilot stated he experienced an engine stoppage in flight and attempted to land on a dirt road. Both fuel tanks were found empty and a total of 3 to 4 ounces of fuel was drained from the aircraft fuel system.