NTSB investigations: Piper PA-28-161, 1989
22 cases on aircraft the registry lists as Piper PA-28-161. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1977 | 5 |
| 1978 | 19 |
| 1979 | 30 |
| 1980 | 30 |
| 1981 | 37 |
| 1982 | 31 |
| 1983 | 14 |
| 1984 | 16 |
| 1985 | 20 |
| 1986 | 20 |
| 1987 | 26 |
| 1988 | 19 |
| 1989 | 22 |
| 1990 | 28 |
| 1991 | 22 |
| 1992 | 23 |
| 1993 | 21 |
| 1994 | 17 |
| 1995 | 14 |
| 1996 | 13 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 15 |
| 2000 | 16 |
| 2001 | 11 |
| 2002 | 11 |
| 2003 | 9 |
| 2004 | 15 |
| 2005 | 14 |
| 2006 | 17 |
| 2007 | 8 |
| 2008 | 22 |
| 2009 | 8 |
| 2010 | 10 |
| 2011 | 13 |
| 2012 | 8 |
| 2013 | 8 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 6 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 2 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 3 |
| 2026 | 4 |
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\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834'))
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") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834'))
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 CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.NTSB LAX90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hayward, CAInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Collision with a vehicle in the emergency landing area contributed to the damage and injuries.NTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.NTSB MKC90FA017Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Elkader, IAThe pilot's failure to maintain clearance from the runway marker at the departure end of the runway.NTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.NTSB MIA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Titusville, FLFailure of the pilot to go around after landing long with excessive airspeed.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MIA89IA249Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · Fort Pierce, FLThe student's failure to maintain directional control of the airplane. Contributing to the accident was the student's lack of experience.NTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.NTSB BFO89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC), and his failure to maintain proper alignment, while landing at night on a road. The weather conditions, dark night, and…NTSB NYC89LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe pilot overshooting a landing during a precautionary landing due to deteriorating weather conditions. Contributing factor(s) was: the pilot's decision to attempt the flight after being advised that VFR flight was not recommended and inadequate preflight by…NTSB LAX89LA254Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Oceanside, CAThe failure of the pilot-in-command to attain proper airspeed during the go-around. The lack of airspeed did not permit the airplane to climb and the pilot intentionally stalled the airplane into the trees. Contributing to the accident was the pilot delaying…NTSB NYC89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Stonington, CTThe pilot's inadvertent flight into instrument meteorological conditions (IMC) and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the environmental conditions (dark night & fog) and the pilot's lack of…NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.NTSB NYC89LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beverly, MACollision with trees during an aborted landing and attempted go-around with insufficient remaining runway.NTSB CHI89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Houghton, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion from lack of fuel. Factors related to the accident were: obstructions (road sign & guard rail) in the emergency landing area.NTSB NYC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dushore, PACollision with trees during a rejected takeoff from a private turf strip due to the pilots failure to take advantage of the existing wind.NTSB LAX89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fullerton, CAEngine failure due to fuel starvation, the selection of the improper fuel tank by the student, and poor supervision by the instructor. Contributing to the cause of the accident was an inadequate preflight of the airplane by the dual student.NTSB ATL89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tiffin, OHThe pilots improper recovery from a bounced landing which led to inadvertent porpoising and loss of directional control.NTSB FTW89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · New Orleans, LAThe pilot diverting his attention from flying the aircraft while complying with the departure control instructions, and allowing the aircraft to descend into the water.NTSB NYC89LA083Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA loss of engine power and subsequent forced landing which resulted from binding of the carbuerator throttle shaft. The binding resulted from an improper overhaul of the carbuertor approximately 10 flight hours prior to the accident.NTSB LAX89LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Martin, CAEngine failure due to a loose spark plug with the reminaing plugs fouled with carbon deposits.