NTSB investigations: Piper PA-28-180, 2004
18 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\") = 2004
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") = 2004
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 LAX05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jean, NVthe pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.NTSB DFW05FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hammond, LAA loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.NTSB MIA05LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Milton, FLA loss of engine power due to fuel starvation as a result of the improper fuel selector position.NTSB NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.NTSB DFW05CA011Accident · No injuriesData collectionFinal reportPiper PA-28 · Abilene, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the wet runway surface and rain.NTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.NTSB NYC04FA220Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Avondale, PAThe pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power.NTSB ATL04CA196Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Charlotte, NCThe pilot's misjudgment of speed and distance resulting in an overrun and collision with trees.NTSB CHI04CA266Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Hurdland, MOThe pilot's failure to maintain proper airspeed and directional control during the takeoff and his failure to properly abort the takeoff after the encountered tailstrike. A factor to the accident was the stall/mush encountered during the attempted takeoff and…NTSB LAX04CA238Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Anza, CAThe pilot's misjudged altitude and speed, which resulted in an undershoot and a collision with a berm. Also causal was the control interference from the passenger.NTSB LAX04LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Carson City, NVthe pilot's failure to maintain directional control during an aborted touch-and-go landing.NTSB CHI04CA106Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Columbia, MOThe pilot inadvertently became lost and over flew his destination in cruise flight and selected an unsuitable landing area for his precautionary landing. Factors were the rough/uneven terrain, the barbed wire fence, and the fence post encountered during the…NTSB NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.NTSB LAX04LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, NVthe pilot's premature flare and failure to maintain adequate airspeed resulted in an inadvertent stall and a hard landing, which collapsed the landing gear.NTSB LAX04LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mariposa, CAThe total loss of engine power for undetermined reasons.NTSB CHI04FA069Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rich Hill, MOSpatial disorientation experienced by the non-instrument rated pilot due to a lack of visual references and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's intentional flight into adverse weather conditions,…NTSB ATL04FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Alma, GAThe pilot's inadequate in-flight decision, and his failure to maintain aircraft control which resulted in continued VFR flight into IMC and the subsequent collision with trees during approach.NTSB LAX04CA107Accident · No injuriesData collectionFinal reportPiper PA-28-180C · Minden, NVThe student pilot's failure to maintain directional control during the landing roll.