NTSB investigations: Piper PA-28-140, 2022
17 cases on aircraft the registry lists as Piper PA-28-140. 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 | 35 |
|---|---|
| 1965 | 102 |
| 1966 | 177 |
| 1967 | 263 |
| 1968 | 182 |
| 1969 | 227 |
| 1970 | 220 |
| 1971 | 230 |
| 1972 | 189 |
| 1973 | 183 |
| 1974 | 169 |
| 1975 | 141 |
| 1976 | 129 |
| 1977 | 123 |
| 1978 | 118 |
| 1979 | 83 |
| 1980 | 66 |
| 1981 | 76 |
| 1982 | 63 |
| 1983 | 40 |
| 1984 | 48 |
| 1985 | 35 |
| 1986 | 40 |
| 1987 | 42 |
| 1988 | 46 |
| 1989 | 30 |
| 1990 | 45 |
| 1991 | 46 |
| 1992 | 30 |
| 1993 | 31 |
| 1994 | 45 |
| 1995 | 29 |
| 1996 | 25 |
| 1997 | 30 |
| 1998 | 27 |
| 1999 | 21 |
| 2000 | 30 |
| 2001 | 21 |
| 2002 | 24 |
| 2003 | 19 |
| 2004 | 17 |
| 2005 | 21 |
| 2006 | 20 |
| 2007 | 23 |
| 2008 | 16 |
| 2009 | 12 |
| 2010 | 16 |
| 2011 | 8 |
| 2012 | 17 |
| 2013 | 20 |
| 2014 | 15 |
| 2015 | 18 |
| 2016 | 16 |
| 2017 | 15 |
| 2018 | 21 |
| 2019 | 17 |
| 2020 | 16 |
| 2021 | 20 |
| 2022 | 17 |
| 2023 | 18 |
| 2024 | 13 |
| 2025 | 9 |
| 2026 | 12 |
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\") = 2022
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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") = 2022
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 ANC23LA014Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane during landing.NTSB ERA23LA068Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Manassas, VAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN23LA041Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Saint Joseph, MOThe pilot lost control of the airplane while on the ground due to temporary incapacitation.NTSB ERA23LA055Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Allentown, PAThe flight instructor’s decision to remove the nosewheel chock while the engine was still operating.NTSB CEN22FA436Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Allentown, PAA partial loss of engine power for undetermined reasons.NTSB WPR22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Sisters, ORThe non-instrument-rated pilot’s flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s degraded judgement due to fatigue.NTSB ERA22LA401Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Wadsworth, OHA total loss of engine power for reasons that could not be determined.NTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.NTSB ERA22LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Marathon, FLA total loss of power for undetermined reasons.NTSB ERA22LA371Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Talladega, ALA collision with a deer during takeoff.NTSB WPR22LA301Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Laurel, MTThe loss of climb performance due to undetermined reasons.NTSB CEN22LA385Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Sparta, MIThe pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.NTSB CEN22LA377Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Vernon Hills, ILThe pilot’s improper in-flight fuel management, which led to a loss of engine power due to fuel starvation. Contributing to the accident was the collapsed carburetor heat induction tube that restricted airflow to the engine preventing engine restart.NTSB CEN22LA303Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-140 · Oklahoma City, OKThe pilot’s failure to maintain adequate airspeed for unknown reasons during the initial climb, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB ERA22LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Manassas, VAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB CEN22LA239Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Braunfels, TXThe pilot’s failure to maintain directional control during takeoff.NTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.