NTSB investigations: Piper PA-28-140, 1997
30 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\") = 1997
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") = 1997
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 FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.NTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.NTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.NTSB NYC98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Middlefield, OHloss of engine power for undetermined reasons.NTSB CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.NTSB IAD98LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmingdale, NYThe student pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A factor was the cross wind condition.NTSB LAX98LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lanai City, HIInterference on the controls by the passenger as the aircraft neared touchdown, and the pilot's failure to adequately brief and supervise the passenger on the use and relinquishing of the flight controls. A factor in the accident was the intentional control…NTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.NTSB CHI97LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INthe pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.NTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.NTSB CHI97LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's fixation on the end of the runway, his failure to place the airplane in an attitude to land (flare) which resulted in a hard landing, and the pilot's failure to recover from the subsequent bounced landing.NTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.NTSB IAD97LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Gardiner, NYThe pilot's failure to initiate a go-around. A related factor is the pilot's misjudgment of speed and altitude.NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB CHI97LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mapleton, IAthe loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.NTSB ATL97LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Spruce Pine, NCThe pilot's failure to maintain terrain clearance after turning the wrong way in a traffic pattern.NTSB FTW97LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ashdown, ARThe inadvertent stall/mush. A factor was the high density altitude.NTSB FTW97LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Leadville, COan attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.NTSB MIA97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sanford, FLFailure of the oil cooler radiator hose which resulted in oil exhaustion and subsequent engine failure. Contributing to the accident was the failure of the FAA to require a recurrent detailed examination and or require those hoses be life limited to prevent…NTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.NTSB NYC97LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJA loss of engine power due to a partially blocked engine muffler.NTSB SEA97LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldport, ORthe pilot's inadequate preflight planning/preparation to ensure he could execute a safe departure in the meteorological conditions present at the time. Related factors included: the unfavorable/variable/gusty wind conditions; and a power line near the…NTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.NTSB CHI97LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Flushing, MIthe pilot's misjudgment of distance and speed on final approach, his failure to attain the proper touchdown point for landing, and his delay in initiating a go-around (aborted landing). Factors related to the accident were: darkness, and the proximity of…NTSB CHI97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dickinson, NDthe student pilots failure to maintain directional control of the airplane. A factor associated with the accident was the pilot's runway selection.NTSB SEA97LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYThe pilot's inadequate preflight planning. Factors include high density altitude, downdrafts, and rough/uneven terrain in the area where the pilot attempted the emergency landing.NTSB ANC97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Alsworth, AKloss of engine power, due to failure of the number 2 connecting rod assembly (rod, bearing, & bolts). The lack of suitable terrain for a forced landing was a related factor.NTSB FTW97LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Fort Collins, COa total loss of power for reasons undetermined. A factor was unsuitable terrain for a forced landing.NTSB LAX97LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Barbara, CAthe pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.NTSB FTW97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sulphur, OKThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.