NTSB investigations: Piper PA-28-180, 1991
12 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 | 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\") = 1991
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") = 1991
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 FTW92LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe pilot's selection of unsuitable terrain. Factors were the fuel starvation and the tough terrain.NTSB BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.NTSB FTW91LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Friendswood, TXThe pilot's failure to maintain directional control during landing. A factor in the accident was mechanical turbulence caused by nearby buildings.NTSB LAX91FA342Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Reno, NVFailure of the pilot to maintain proper airspeed by employing an excessive angle of attack during the takeoff climb during a go-around resulting in an aerodynamic stall and subsequent inflight loss of control. Contributing to the accident was the pilot's poor…NTSB NYC91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Old Bridge, NJThe failure of both pilots to maintain proper visual lookout. Factor related to the accident was inadequate radio communications by the pilots.NTSB CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.NTSB CHI91FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Quincy, ILThe failure by the pilot of the other airplane to maintain clearance. Factors in the accident were the pilot's attempt to fly formation, his inadequate group briefing, and the lack of experience on the part of the pilot of the other airplane.NTSB NYC91LA116Accident · No injuriesLimited investigationFinal reportPiper 180 · Andes, NYThe failure of the pilot to maintain directional control during a landing with unfavorable winds.NTSB SEA91LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wamic, ORThe pilot's selection of an empty fuel tank for takeoff.NTSB CHI91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burwell, NEDirectional control not maintained by the pilot. Factors related to the accident were a gusty crosswind and lack of recent experience by the pilot.NTSB CHI91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Genesee, MIPositive liftoff airspeed was not attained, an aborted takeoff was not performed which resulted in a stall/mush descent to the terrain. Factors related to the accident were a dark raining night, soft, wet grass runway and a downwind surface wind.NTSB ATL91FA046Accident · Minor injuriesField investigationFinal reportPiper PA-28-180 · Greensboro, NCAn encounter with wake turbulence which resulted in an uncontrolled descent. An additional cause was pilot's physiological conditions and his use of medication.