NTSB investigations: Piper PA-28-161, 1992
23 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\") = 1992
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") = 1992
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 CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.NTSB CHI93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Kokomo, INFailure to maintain aircraft control, and spatial disorientation of the pilot.NTSB BFO93LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Red Hook, NYThe pilot's inadvertent deactivation of the electric fuel boost pump. A factor related to the accident was the failure of the engine driven fuel pump during takeoff.NTSB NYC93LA014Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · St. Clairsville, OHThe pilot's improper in-flight planning and decision to land on a short grass runway with a tail wind. A factor in this accident was the pilots failure to obtain and evaluate a weather briefing prior to the flight.NTSB MIA93LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St Augustine, FLFailure of the instructor pilot (CFI) to assure adequate compensation for wind conditions. Factors related to the accident were: the crosswind and turbulent weather conditions.NTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.NTSB LAX92LA323Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ravendale, CAThe loss of engine power for undetermined reasons. The short length of the runway was a factor in the accident.NTSB FTW92LA187Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Midland, TXA loss of control for reasons undetermined.NTSB BFO92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dayton, OHAn encounter with a strong wind gust which resulted in loss of control and nose over.NTSB BFO92LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA28-161 · Brentwood, NHA delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.NTSB LAX92LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · El Monte, CAThe student pilot's failure to maintain directional control and improper use of the brakes.NTSB ATL92LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bainbridge, GAThe pilot's misjudged distance of runway remaining, resulting in a delayed decision to abort the takeoff, and subsequent collision with trees. Factors were the high obstructions (trees) at the departure end of the runway.NTSB BFO92LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Morrisville, VTThe pilot's failure to maintain clearance with the terrain. Contributing to the accident was a dark night and the lack of familiarity with the geographic area.NTSB ATL92LA087Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Rutherfordton, NCThe pilot's failure to maintain directional control during a landing roll which resulted in a collision with trees.NTSB LAX92LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Douglas, AZAn encounter with an unforecasted high velocity wind gust which caused the airplane to nose over to an inverted position.NTSB ANC92LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kenai, AKTerrain clearance was not maintained. Factors to the accident were: snow covered hilly terrain, and diverted attention.NTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.NTSB CHI92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hanover, KSThe pilot's failure to abort the takeoff earlier in the takeoff roll, and the inadvertent stall/mush after lift-off. A factor was the soft terrain.NTSB MIA92LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Fernandina Bch, FLSpatial disorientation and failure of the pilot-in-command to set the altimeter to the field elevation prior to departure. Contributing to the accident was the pilot's lack of total and recent experience.NTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…NTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB LAX92FA102Accident · 4 fatalField investigationFinal reportPiper PA28-161 · Mountain Pass, CAThe pilots failure to maintain the aircraft's airspeed above the stall speed (vs) that resulted in an inadvertent entry into a stall/spin.NTSB MIA92FA062Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Homestead, FLThe non-instrument rated pilot's continued VFR flight into instrument flight conditions resulting in spatial disorientation and inflight loss of control.