NTSB investigations: Piper PA-28-140, 2007
23 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\") = 2007
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") = 2007
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 NYC08CA040Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNThe flight instructor's inadequate remedial action and failure to maintain runway alignment.NTSB MIA08CA017Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hyannis, MAThe student pilot's mismanagement of the fuel supply and the flight instructor's inadequate supervision.NTSB LAX08CA020Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Fresno, CAThe pilot's failure to maintain the proper glide path to clear objects during approach for landing.NTSB LAX08FA002Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Oak Hills, CAThe pilot's continued flight into instrument meteorological conditions and failure to maintain terrain clearance during cruise flight. Contributing to the accident were mountainous terrain, dark night, and fog.NTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.NTSB SEA07CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Chandler, AZThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were the downdraft, the uneven terrain, and the flight instructor's delayed…NTSB SEA07CA265Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Flagstaff, AZThe pilot's failure to attain an adequate airspeed, which resulted in a forced landing off the end of the runway. A contributing factor to the accident was the gusting wind.NTSB SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB LAX07CA271Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Santa Paula, CAThe pilot's unstabilized approach, which resulted in a hard, bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing and his failure to maintain directional control.NTSB NYC07FA217Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Syria, VAThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain aircraft control. Contributing to the accident was the dark night conditions.NTSB ATL07CA118Accident · No injuriesData collectionFinal reportPiper PA28-140 · Front Royal, VAThe pilot's improper recovery from a bounced landing.NTSB CHI07LA260Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · West Bend, WIThe pilot's decision to depart in adverse weather conditions, and his failure to maintain clearance from the terrain. Contributing to the accident included the pilot's lack of an instrument rating, his lack of recent night experience, the night conditions and…NTSB LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB NYC07LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · E.Stroudsburg, PAThe pilot's improper fuel management resulting in loss of engine power.NTSB CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB LAX07CA165Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Moab, UTThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB LAX07LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZA loss of engine power while maneuvering due to a broken exhaust valve. Contributing to the accident was the rough terrain.NTSB CHI07CA118Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Williamston, MIThe pilot's improper recovery from a bounced landing which resulted in the collapse of the nose landing gear. The hilly runway was a contributing factor.NTSB SEA07FA106Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Tehachapi, CAThe pilot's VFR flight into IMC and his ensuing failure to maintain terrain clearance. Contributing factors were the cloudy weather conditions and the mountainous terrain.NTSB NYC07LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Catherine Twp., PAThe pilot's improper use of carburetor heat. Contributing to the accident were the weather conditions conducive to the formation of carburetor ice.NTSB SEA07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Crescent Lake, ORThe loss of a significant amount of engine power for undetermined reasons. Factors include no suitable place in which to make an emergency landing, and densely forested, mountainous/hilly terrain.NTSB NYC07LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Saluda, VAThe improper repair of the carburetor heat control linkage by person(s) unknown. Contributing to the accident was the pilot's improper decision to takeoff, with the engine developing partial power.