NTSB investigations: Piper PA-28-181, 1991
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\") = 1991
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") = 1991
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 CHI92LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rochester, MNImproper use of autopilot during approach which resulted in proper alignment not maintained by the pilot. Factors related to the accident were turbulence and crosswinds, over confidence in aircraft's capability and overconfidence in personal ability.NTSB LAX91FA399Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Cupertino, CAThe pilot's failure to maintain the proper altitude, his improper inflight decision to attempt flight below the base of an overcast layer of clouds toward rising mountainous terrain and the flight's inadvertent entry into instrument meteorological conditions.…NTSB BFO92DOA01Accident · 1 fatalFinal reportPiper PA-28-181 · Belington, WVThe pilot's failure to maintain clearance above the terrain which resulted in inflight collision with the terrain. Contributing was mountainous terrain.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB LAX91FA333Accident · 3 fatalField investigationFinal reportPiper PA 28-181 · Sonora, CAFailure of the flight instructor/pilot-in-command to adequately supervise the flight and to maintain adequate airspeed by exceeding the climb performance of the airplane. Contributing to the accident was the pilot-in-command's inadequate planning and his…NTSB FTW91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heber Springs, ARThe pilot's touchdown at an improper point on the airstrip. A factor was the wet downsloping grass airstrip.NTSB LAX91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rio Vista, CAFuel exhaustion due to the pilots improper fuel consumption calculations and inadequate preflight planning.NTSB CHI91LA192Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marquette, MIThe pilot-in-command's failure to maintain proper altitude.NTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.NTSB NYC91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dushore, PAThe pilot landed with excessive airspeed, which resulted in ineffective braking and a loss of control.NTSB MIA91LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe pilot's selection of the wrong runway for wind conditions.NTSB FTW91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Longview, TXFuel exhaustion resulting in a complete power loss due to the pic/cfi's failure to refuel at intermediate destinations.NTSB LAX91FA181Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Carpenteria, CA1) Inadequate weather evaluation by the pilot, 2) poor inflight decision to try and continue VMC flight, and 3) the pilot's lack of total experience.NTSB CHI91LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · West Branch, MIThe pilot's failure to follow recommeded starting procedures/directives and precautions.NTSB CHI91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Morgan, MNA guy wire was struck on takeoff because of inadequate clearance. Factors related to the accident were poor planning/decision by the pilot and over confidence in personal ability.NTSB LAX91FA106Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Fredonia, AZThe pilot's inattention to the airspeed and subsequent loss of aircraft control after attempting VFR flight into adverse weather conditions. Contributing to the accident was the pilot's failure to recognize his limitations of his aircraft.NTSB CHI91LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, WIImproper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.NTSB LAX91LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Mokuleia, HIThe cfi's failure to use carburetor heat. A factor was the manufacturer's inadequate procedure.NTSB LAX91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ramona, CAThe pilot's failure to maintain directional control of the airplane during an attempted takeoff. A contributing factor was related to the student's improper use of rudder control.