NTSB investigations: Piper PA-28-161, 1997
15 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
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\") = 1997
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") = 1997
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 CHI98LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boone, IAfailure of the pilot to maintain sufficient altitude/clearance from obstruction(s), while flying low over a river. The obstruction (power line) was a related factor.NTSB NYC98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PAThe pilot's failure to maintain proper distance and altitude during approach which resulted in an undershoot and collision with a fence.NTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.NTSB NYC98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pittstown, NJthe pilot's misjudgment of distance and speed during the approach, and her failure to perform a go-around.NTSB NYC97LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blairsville, PAthe pilot's inaccurate fuel consumption calculations and improper in-flight planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB IAD97LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Block Island, RIThe pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.NTSB FTW97LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, TXThe pilot's misjudgment of distance and altitude. A contributing factor was a tailwind.NTSB NYC97LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Butler, PAthe pilot's misjudgment of distance and speed on final approach; his failure to attain the proper touchdown point; and his failure to perform a go-around, while there was still sufficient airspeed and runway remaining, which resulted in an overrun and…NTSB CHI97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INa fatigue failure of the fight main landing gear strut/spar attachment screws.NTSB LAX97LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Little River, CAThe pilot's failure to properly judge the flare altitude.NTSB FTW97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COthe student pilot's improper use of the fuel tank selector which led to fuel starvation and loss of engine power. Factors were the pilot's inadequate fuel management and the lack of suitable terrain for the forced landing.NTSB NYC97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, MEthe pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…NTSB MIA97LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLthe pilot's excessive taxispeed.NTSB LAX97FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-161 · Avalon, CAundetermined.NTSB SEA97LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sun River, ORinadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude/clearance above moutainous/wooded terrain. Factors relating to the accident were: darkness, adverse weather conditions, and the proximity…