NTSB investigations: Piper PA-28-180, 2003
17 cases on aircraft the registry lists as Piper PA-28-180. 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
| 1964 | 47 |
|---|---|
| 1965 | 72 |
| 1966 | 117 |
| 1967 | 131 |
| 1968 | 107 |
| 1969 | 92 |
| 1970 | 98 |
| 1971 | 99 |
| 1972 | 78 |
| 1973 | 85 |
| 1974 | 82 |
| 1975 | 64 |
| 1976 | 76 |
| 1977 | 54 |
| 1978 | 59 |
| 1979 | 37 |
| 1980 | 38 |
| 1981 | 26 |
| 1982 | 21 |
| 1983 | 29 |
| 1984 | 16 |
| 1985 | 24 |
| 1986 | 18 |
| 1987 | 23 |
| 1988 | 21 |
| 1989 | 29 |
| 1990 | 20 |
| 1991 | 12 |
| 1992 | 25 |
| 1993 | 17 |
| 1994 | 18 |
| 1995 | 21 |
| 1996 | 21 |
| 1997 | 16 |
| 1998 | 24 |
| 1999 | 17 |
| 2000 | 17 |
| 2001 | 13 |
| 2002 | 18 |
| 2003 | 17 |
| 2004 | 18 |
| 2005 | 19 |
| 2006 | 9 |
| 2007 | 13 |
| 2008 | 7 |
| 2009 | 15 |
| 2010 | 9 |
| 2011 | 15 |
| 2012 | 12 |
| 2013 | 10 |
| 2014 | 9 |
| 2015 | 10 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 11 |
| 2019 | 12 |
| 2020 | 9 |
| 2021 | 11 |
| 2022 | 6 |
| 2023 | 24 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 10 |
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\") = 2003
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
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") = 2003
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
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 CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.NTSB LAX04GA051Accident · 2 fatalFinal reportPiper PA-28-180 · Big Bear City, CAThe pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.NTSB NYC04LA007Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Cheswold, DEThe pilot's failure to maintain a proper glide path to the runway, and his failure to maintain obstacle clearance which resulted in an in-flight collision with an unlit utility pole. Factors related to the accident were the unlit utility pole, and the dark…NTSB LAX04LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · San Rafael, CAa loss of engine power due to fuel exhaustion.NTSB DEN04FA002Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Teasdale, UTThe student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…NTSB ATL03LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Talladega, ALThe pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.NTSB LAX03CA263Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Pauma Valley, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall. The rising terrain was a factor.NTSB SEA03LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Nampa, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. A factor was the unsuitable terrain for the forced landing.NTSB CHI03FA246Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Clarkfield, MNThe pilot not maintaining altitude/clearance from terrain and his continued VFR flight into IMC during cruise flight. A factor was the low ceilings.NTSB DEN03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Green River, UTpilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.NTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.NTSB NYC03FA113Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bruceton Mills, WVThe pilot's intentional decision to continue visual flight into instrument meteorological conditions, and his failure to maintain obstacle clearance which resulted in the airplane striking a guy wire on the communications antenna. A factor was the fog.NTSB NYC03LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montgomery, NYThe inadequate 100-hour inspection by maintenance personnel, which resulted in a loose fuel line and loss of power. A factor related to the accident was the dark night conditions.NTSB NYC03FA082Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Conesus, NYThe flight instructor's failure to maintain adequate airspeed which resulted in an inadvertent spin.NTSB FTW03LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bonham, TXThe loss of engine power due to fuel starvation as result of the unapproved fuel selector valve handle installed on the aircraft by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Richfield, UTthe pilot's failure to maintain aircraft control during landing roll resulting in a ground loop/swerve and subsequent nose over. A contributing factor was the gusty wind conditions.NTSB NYC03LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Poughkeepsie, NYThe pilot's failure to maintain an adequate amount of engine power while maneuvering to land, which produced delayed engine response times. A facture in the accident was the cold day.