NTSB investigations: Piper PA-28-161, 1998
13 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\") = 1998
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") = 1998
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 MIA99LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Conyers, GAThe pilot's decision to attempt a touch-and-go landing with insufficient runway remaining, and his failure to maintain adequate clearance from an object (tree).NTSB IAD99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Melfa, VAThe loss of engine power for undetermined reasons.NTSB DEN99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erie, COThe shorting of the aluminum battery wire and the subsequent failure of the fuel line. Factors were the weak/deteriorated battery, the insufficient information in the airplane's POH about charging an airplane's battery, and the fire in the crew compartment.NTSB LAX99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Barbara, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain proper runway alignment during landing flare.NTSB FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…NTSB FTW98LA329Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Rockwall, TXThe pilot's improper use of the fuel tank selector resulting in the loss of engine power due to fuel starvation. A factor was the pilot's failure to follow the check list.NTSB MIA98LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLTotal loss of engine power due to a hydraulic valve lifter failure.NTSB NYC98LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Whitefield, NHThe instructor pilot's failure to maintain control of the aircraft during landing roll. Contributing factors were the instructor pilot's improper in-flight decision, tailwind and gusty conditions, and wet (standing water) runway conditions.NTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.NTSB ATL98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Homestead, FLThe pilot's improper flare that resulted in a hard landing and porpoise, and his improper recovery from the bounced landing.NTSB LAX98LA172Accident · 4 fatalLimited investigationFinal reportPiper PA-28-161 · Half Moon Bay, CAThe non-instrument rated pilot's loss of aircraft control due to spatial disorientation in dark night conditions.NTSB CHI98LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INthe student pilot's failure to adequately compensate for the gusty wind conditions during landing. A factor was the gusty wind conditions.NTSB MIA98WA098Accident · No injuriesForeign investigationPiper PA-28-161 · Cat Cay, Bahamas