NTSB investigations: Piper PA-28-181, 2001
15 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\") = 2001
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") = 2001
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 MIA02LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Deland, FLThe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB ATL02FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · McEwen, TNThe pilot initiated a VFR flight into known IMC conditions which resulted in a loss of control of the airplane due to spatial disorientation. Factors were the low ceilings.NTSB ATL02LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Brunswick, GAThe pilot's improper inflight planning which resulted in fuel exhaustion, and subsequent loss of engine power. A factor was the none suitable terrain.NTSB NYC01LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mattituck, NYThe pilot's failure to attain a proper touchdown point. A factor was the tailwind.NTSB CHI01LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Gladwin, MIThe pilot's poor decision to exit the airplane onto the wing while the propeller was running.NTSB SEA01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tekoa, WAThe non-current pilot's failure to maintain sufficient altitude or clearance with wheat crops on short final, and the flight instructor's inadequate remedial action. Factors included wheat crops and a dirt bank on short final, the runway's lack of a visual…NTSB CHI01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brooklyn, MIThe proper touchdown point exceeded, all of the available runway not used, and aircraft control not being maintained by the pilot during the landing. Factors to the accident were the pilot mistaking the taxiway for the runway, the pilot not performing a…NTSB LAX01LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sedona, AZthe induction manifold fire resulting from an engine backfire during engine start. The reason for the engine backfire was not determined.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB MIA01LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bennettsville, SCThe pilot failure to obtain the proper touchdown point on the runway resulting in the airplane landing long, over running the runway, colliding with a telephone pole separating the right wing, and coming to rest in the parking lot of a restaurant.NTSB LAX01FA308Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lytle Creek, CAThe pilot's inadequate decision to fly into an area of rising terrain.NTSB ATL01FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Jasper, GAThe pilot disregarded preflight weather briefing information, and continued visual flight into known instrument weather conditions and collided with trees.NTSB LAX01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gila Bend, AZFailure of the CFI to properly supervise the flight and the failure of the dual studen to maintain flying airspeed. A contributing factor was the wind shear encountered.NTSB SEA01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · North Bend, ORThe pilot's failure to maintain clearance from the delivery truck while taxing. The pilot being distracted is a factor.NTSB LAX01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAFuel starvation due to the pilot inadvertently shutting off its supply on approach for landing.