NTSB investigations: Piper PA-28-180, 1992
25 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
Latest 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\") = 1992
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") = 1992
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 CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.NTSB NYC93LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, CTThe pilot's improper level off which resulted in a hard landing. Contributing were wind gusts and the pilot's inadequate compensation for wind conditions.NTSB FTW93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Orleans, LALoss of engine power due to fuel exhaustion. Factors were the inaccurate fuel consumption calculations and the unsuitable terrain.NTSB CHI93LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Makoti, NDThe pilot not maintaining a proper glidepath during his approach to landing.NTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.NTSB CHI93LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Maryland Height, MOBlockage of the induction air system by a mouse nest.NTSB NYC93FA015Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Elkton, VAThe pilot's delay in aborting the landing which resulted in insufficient runway remaining to allow the airplane to reach sufficient altitude to clear the obstacles at the end of the runwayNTSB ANC93FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Talkeetna, AKThe pilot's continued visual flight into instrument meteorological conditions at night which resulted in a loss of airplane control, spatial disorientation, and an inflight breakup. Factors which contributed to the accident were: the adverse weather and the…NTSB SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.NTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.NTSB CHI92LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, MIThe pilot's inadequate planning and decision-making.NTSB CHI92LA269Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gary, INThe pilot's failure to land at the proper touchdown point on the runway and landing with excessive airspeed.NTSB CHI92FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Ness City, KSThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB BFO92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Windham, CTThe pilot's improper IFR operation. Contributing was the pilot's instrument flight inexperience.NTSB ANC92LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Iliamna, AKThe pilot's failure to abort the takeoff. Contributing to the accident was the rough/uneven terrain.NTSB FTW92LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Nevada, TXThe PIL0T'S inadvertent stall of the airplane during the forced landing and his failure to refuel the airplane en route.NTSB CHI92LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Belmont, WIThe pilot's poor planning/decision making. Related factors are the low ceilings and fog, the dark night, the pilot's inaccurate weather evaluation and diverted attention, and the pilot's failure to maintain clearance from the higher terrain encountered.NTSB CHI92DCA03Accident · 1 fatalFinal reportPiper PA-28-180 · Mokane, MOAn inadequate visual lookout by the pilot and his failure to maintain clearance from the wires.NTSB CHI92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Troy, MIThe pilot's failure to maintain control of the airplane.NTSB BFO92LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Saxonburg, PAThe pilot mismanaged the fuel supply, which resulted in fuel starvation and the lost of engine power.NTSB CHI92LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Springfield, MOFailure of the pilot in command to maintain control of the airplane during a downwind landing.NTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.NTSB MIA92IA075Incident · No injuriesIncident investigationFinal reportPiper PA-28-180 · Destin, FLImproper procedures/directives by the pilot-in-command while attempting to restart the engine, resulting in the engine compartment fire.NTSB LAX92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Young, AZThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the soft muddy runway conditions at the dirt airstrip.NTSB BFO92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glasgow, KYDeer on the runway. Other related factor ws a dark night.