NTSB investigations: Piper PA-28-181, 1990
20 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\") = 1990
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") = 1990
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 FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.NTSB BFO91FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Elkton, MDLoss of engine power for an undetermined reason, and the pilot's failure to maintain adequate airspeed, which resulted in a stall and an inflight collision with the terrain.NTSB MIA91LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Orlando, FLInadequate planning by the pilot.NTSB SEA91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Princeton, ORThe pilot's failure to maintain clearance from obstacles at the side of the runway.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB MIA90TL#06Accident · Minor injuriesClass 3Final reportPiper PA-28-181 · Labelle, FLNTSB CHI90LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fridley, MNEngine failure due to fuel exhaustion because of fuel consumption calculations mis-judged by the pilot in command. Contributing factors were unsuitable terrain and a railroad sign.NTSB CHI90LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Drummand Island, MIPilot-in-command's failure to plan his approach and landing to use all available runway. Contributing factors are inadequate preflight preparation, lack of familiarity with the destination airport, and inadequate runway markings.NTSB NYC90FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Rome, PAAn inflight loss of control due to spatial disorientation. Contributing to the accident was the pilot's lack of an instrument rating, and his decision to make the flight after receiving three separate briefings where he was told 'VFR flight not recommended.'NTSB CHI90FA130Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · East Lansing, MIThe failure of the pilot to maintain aircraft control while flying in clouds during an instrument approach. Factors were: instrument meteorological conditions, self-induced pressure, operation with known deficiencies in equipment, and anxiety/apprehension.NTSB NYC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, NYThe pilot's poor judgement in attempting to land the airplane under the existing wind conditions.NTSB CHI90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Anderson, INThe pilot-in-command failed to select the fuel valve to a tank containing usable fuel resulting in fuel starvation.NTSB DEN90LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bountiful, UTThe flight instructor's inadequate supervision of the dual student. Factors in the accident were the premature lift-off by dual student, the rough terrain and the fence.NTSB DEN90LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Price, UTThe pilot's inadequate conpensation for the gusty wind conditions, which were a factor.NTSB NYC90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orange, MAFailure of the pilot to maintain runway alignment while aborting the takeoff. The crosswind, turbulence, and snowbank were related factors.NTSB LAX90LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Big Bear, CAThe pilot's failure to maintain adequate clearance between the aircraft wing tip and the snow bank. A factor in the accident was the snow berms alongside the runway.NTSB LAX90LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Truckee, CAThe pilot's loss of directional control after landing on a recently plowed runway. Contributing to the accident was the four foot high snow berm alongside the runway and the icy spots on the runway.NTSB NYC90LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Worcester, MAA power loss due to an oil pump failure while operating over unsuitable terrain. A factor related to the accident was night conditions.NTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.