NTSB investigations: Piper PA-28-181, 1996
12 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
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\") = 1996
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") = 1996
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 NYC97LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Long Pond, PAThe pilot's inadequate preflight planning/preparation and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related…NTSB LAX97LA013Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAthe student pilot's impairment of judgment and performance due to alcohol, his subsequent flight into adverse weather conditions, and his failure to maintain clearance from obstructions (power lines). Factors related to the accident were: darkness, low…NTSB LAX96FA340Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Caliente, CAimproper in-flight planning/decision by the flight instructor (CFI) by allowing the airplane to flying into a box canyon area, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with wooded terrain. The CFI's…NTSB NYC96LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's misjudgment of distance and speed during the approach to land, and his failure to go around while there was still sufficient runway remaining, which resulted in an overrun of the runway and collision with trees. The lack of natural lighting at…NTSB CHI96FA284Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Muncie, INthe inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.NTSB NYC96FA158Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Sea Bright, NJthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane, due to spatial disorientation, which resulted in a collision with water. Factors relating to the accident were the pilot's…NTSB LAX96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lanai, HIFuel exhaustion due to the pilot's inadequate fuel planning and failure to refuel the aircraft prior to initiating a 280-mile over water nonstop leg of the flight.NTSB NYC96FA085Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Granville, OHthe pilot's intentional flight into known icing conditions and his overconfidence in his ability, which led to a partial loss of engine power as a result of induction system ice. Also causal was ATC's excessive vectoring of the airplane in icing conditions,…NTSB ATL96FA049Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Johns Island, SCthe pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.NTSB LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.NTSB FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.NTSB BFO96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Coshocton, OHloss of engine power for an undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.