NTSB investigations: Piper PA-28-181, 1993
19 cases on aircraft the registry lists as Piper PA-28-181. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 16 |
| 1977 | 16 |
| 1978 | 29 |
| 1979 | 23 |
| 1980 | 28 |
| 1981 | 36 |
| 1982 | 21 |
| 1983 | 24 |
| 1984 | 10 |
| 1985 | 33 |
| 1986 | 26 |
| 1987 | 23 |
| 1988 | 21 |
| 1989 | 10 |
| 1990 | 20 |
| 1991 | 19 |
| 1992 | 9 |
| 1993 | 19 |
| 1994 | 20 |
| 1995 | 22 |
| 1996 | 12 |
| 1997 | 17 |
| 1998 | 20 |
| 1999 | 16 |
| 2000 | 10 |
| 2001 | 15 |
| 2002 | 10 |
| 2003 | 10 |
| 2004 | 20 |
| 2005 | 15 |
| 2006 | 9 |
| 2007 | 14 |
| 2008 | 8 |
| 2009 | 8 |
| 2010 | 11 |
| 2011 | 7 |
| 2012 | 8 |
| 2013 | 7 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 13 |
| 2019 | 8 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 19 |
| 2024 | 15 |
| 2025 | 13 |
| 2026 | 11 |
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\") = 1993
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
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") = 1993
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
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 ATL94LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCThe pilot's inadequate in-flight planning in determining fuel requirements for the flight.NTSB ATL94LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · N. Myrtle Beach, SCThe pilot's improper inflight decision in that he failed to refuel the aircraft prior to exhausting the fuel supply. A factor was the soft terrain at the forced landing site.NTSB LAX94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain a proper glidepath.NTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.NTSB SEA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Merrill, ORFuel exhaustion and inadequate inflight planning/decision.NTSB CHI93LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Davison, MIImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB BFO93LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia Stn, OHThe pilot's delay in initiating a go-around (aborted landing), and his improper raising of the flaps at a low airspeed after lift-off, which resulted in a stall/mush. A factor related to the accident was: the pilot's failure to attain the proper touchdown…NTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…NTSB LAX93LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fresno, CAThe pilot's inadequate flare and his improper recovery from the resulting bounced landing. Factors related to this accident were the alternator failure and the night condition.NTSB CHI93LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Senter, MIThe pilot-in-command's inadequate pre-flight planning. Factors relating to this accident are fuel exhaustion, unsuitable terrain on which to make an emergency landing, as well as an inadvertent stall.NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.NTSB LAX93LA278Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia, CAa loss of engine power for undetermined reasons.NTSB FTW93LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rogers, ARThe pilot's failure to maintain control of the airplane. A factor was the tailwind.NTSB SEA93LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Provo, UTThe wild animals on the runway. A factor relating to the accident was the dark night light conditions.NTSB FTW93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dougherty, TXFuel exhaustion power loss due to refueling not performed by the pilot. A factor was lack of suitable terrainNTSB BFO93LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, VAFatigue failure of the engine crankshaft at the number 1 journal. A factor related to the accident was unsuitable terrain in the emergency landing area.NTSB LAX93LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Las Vegas, NVThe pilot's failure to maintain directional control of the aircraft during the touchdown. Factors in the accident were the pilot's lack of experience and his failure to maintain a balance between the wing fuel tanks.NTSB DEN93FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Elbert, COThe pilot's inadvertent VFR flight into IMC. Factors were his lack of instrument training/experience, existing weather, and dark night conditions.NTSB BFO93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springboro, OHThe pilot misjudged his distance, and altitude on final approach, and failed to attain the proper touchdown point.