NTSB investigations: Piper PA-28-181, 1995
22 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\") = 1995
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") = 1995
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 LAX96TA046Accident · No injuriesFinal reportPiper PA-28-181 · Edwards, CAthe pilot's failure to completely release the parking brakes prior to taxi, which produced a brake over temperature condition and brake fire.NTSB SEA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Syracuse, UTFuel exhaustion due to the pilot's failure to refuel.NTSB ANC95IA173Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Gustavus, AKfatigue failure of the propeller blade due to previous foreign object damage.NTSB CHI95LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lyons, WIThe pilot's lack of experience in the type of operation being conducted, the pilot not maintaining the proper airspeed while on final approach to landing, and a delayed decision to abort the landing.NTSB FTW95LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure by the pilot to properly plan his flight and check NOTAMS prior to departure. A factor was obstructions in the runway construction zone.NTSB FTW95LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was: a misreading or misunderstanding of the NOTAMS.NTSB ANC95IA151Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Juneau, AKfailure and separation of the propeller blade due to foreign object damage and fatigue.NTSB NYC95LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's failure to obtain the proper touchdown point which resulted in insufficient runway stopping distance and a subsequent overrun of the runway, and collision with trees.NTSB CHI95FA259Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fifield, WIthe pilot's attempted visual flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control. A factor was the fog.NTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.NTSB CHI95LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, MOThe pilot's failure to maintain control of the airplane while landing and his inadequate compensation for wind conditions. A factor in the accident was the gusty crosswind conditions.NTSB LAX95LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palm Springs, CAthe failure of the pilot to maintain clearance from a fence post while taxiing.NTSB NYC95FA127Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Jefferson Twp, OHThe pilot's failure to maintain control of the airplane which resulted in a collision with terrain during a descent.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB FTW95LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baytown, TXThe pilot failed to maintain the proper glidepath during landing.NTSB BFO95LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Oneonta, NYThe pilot's failure to maintain aircraft control during the attempted landing. The gusty crosswind condition was a related factor in this accident.NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB CHI95LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ann Arbor, MIthe failure of the mechanic to close the drain valve after changing oil, resulting in complete loss of engine oil. A factor was the soft terrain, which resulted in the nose wheel digging in and the airplane nosing over.NTSB SEA95LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Boise, IDFuel exhaustion due to the pilot's failure to refuel.NTSB CHI95LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INthe pilot's failure to perform a go-around. The gusty crosswind was a factor in the accident.NTSB CHI95LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Brookfield, WIThe instructor's failure to maintain clearance with trees. Factors associated with the accident were the trees and the night lighting conditions.NTSB BFO95FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Miamisburg, OHThe pilot's failure to switch fuel tanks which led to fuel starvation and subsequent loss of engine power.