NTSB investigations: Piper PA-28-140, 1998
27 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\") = 1998
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") = 1998
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 CHI99LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · East St. Louis, ILThe student pilot's failure to maintain directional control.NTSB ATL99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aiken, SCThe pilot's failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.NTSB CHI99LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Liberty, MOThe excessive rotation by the pilot-in-command. The climb not obtained by the pilot-in-command, the fence and the trees were contributing factors.NTSB CHI99LA001Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Bad Axe, MIThe pilot's failure to maintain adequate altitude/clearance from the wires.NTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.NTSB LAX98LA300Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dayton, NVLoss of engine power for unknown reasons. Factors were conditions conducive to carburetor icing and the use of automotive fuel.NTSB LAX98LA283Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Truckee, CAThe pilot's failure to use carburetor heat in temperature conditions conducive to carburetor icing and his failure to lean the engine in a high density altitude environment, which combined, led to a partial loss of engine power and the onset of a stall during…NTSB LAX98LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Phoenix, AZFuel starvation due to the pilot's inadequate in-flight fuel management and his failure to select a tank containing fuel prior to the loss of power.NTSB LAX98LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, NVThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB CHI98LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Laporte, INwas the student pilot s inadequate compensation for the wind conditions he encountered during the landing phase. A factor in this accident was the pilot s lack of total experience.NTSB ANC98LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cantwell, AKThe pilot's intentional continued VFR flight into IMC. Factors were the scattered to broken clouds, and the mountainous terrain.NTSB IAD98LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Salem, NJThe pilot's failure to maintain adequate altitude/clearance from the reeds. A related factor was the wind gusts.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB MIA98LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, NCThe failure of the pilot to maintain directional control of the airport resulting in the collapse of the nose and left main landing gears.NTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.NTSB CHI98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Napoleon, MIthe pilot inadequate pre-flight planning. Factors in this accident were the airplane's weight and balance limitations had been exceeded by the pilot and an improper top overhaul of the engine's cylinder by the mechanic.NTSB ANC98LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bethel, AKThe fracture of the flap handle position locking pin, which resulted in an uncommanded raising of the flaps during takeoff. A factor was the pilot's decision to takeoff with a suspected problem in the flap system.NTSB LAX98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Chico, CALoss of engine power for undetermined reasons.NTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.NTSB CHI98LA208Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Winchester, MOThe pilot's low altitude flight and failure to maintain clearance, resulting in collision with trees. A factor was trees.NTSB CHI98LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrison, NEthe pilot's improper positioning of the magneto switch and his improper use of the mixture control.NTSB IAD98LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Minden, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. A related factor was the rough/uneven runway.NTSB IAD98FA059Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Fort Washington, MDThe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.NTSB MIA98LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Luvurne, ALThe loss of engine power due to a leaking engine oil seal, resulting in a forced landing, and subsequent impact with the ground. A factor in this accident was improper maintenance and checks after rebuilding and reinstalling the airplane's engine.NTSB IAD98LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Downsville, NYThe pilot's failure to maintain directional control of the airplane.NTSB CHI98FA130Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Kalamazoo, MIThe pilot's failure to maintain adequate flying airspeed resulting in a stall condition. Contributing factors were the tailwind condition and the pilot's exceeding the gross weight of the airplane on takeoff.NTSB MIA98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Graniteville, SCfailure of the number three exhaust valve, which resulted in loss of engine power and a forced landing. Related factors were: the obstructions (earthen embankment and fence) in the emergency (forced) landing area.