NTSB investigations: Piper PA-28-140, OK
67 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 4 |
| 1968 | 3 |
| 1969 | 8 |
| 1970 | 2 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 5 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2022 | 1 |
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 c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA'
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 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 GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN14FA019Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Talihina, OKThe pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.NTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.NTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB CEN09CA282Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Seminole, OKThe pilot's failure to maintain directional control during takeoff.NTSB FTW02LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKThe loss of engine power as a result of the pilot's failure to remove the engine cowling plugs during the preflight inspection. A contributing factor was lack of suitable terrain for the forced landing.NTSB FTW01LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKthe pilot's delay in switching the fuel selector, which resulted in fuel starvation in cruise flight.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 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.NTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.NTSB FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB FTW90LA089Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Durant, OKPilot's failure to maintain adequate airspeed (vso) and subsequent stall of the aircraft at an altitude from which recovery was not possible. A factor in the accident was the pilot's improper procedures for the landing approach.NTSB FTW85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hinton, OKDuring takeoff on an instructional flt with a CFI aboard, the acft struck a grain wagon. The CFI stated that on takeoff, the student lifted off prematurely and the acft struck the parked vehicle. The CFI took no corrective action.NTSB FTW83LA390Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Buffalo, OKThe acft hit the ground while trying to stay VFR under low ceilings at night. The student plt was returning from a x-country, for which he had no briefing on the weather, when the weather became worse. The student plt circumnavigated some of the thunderstorms…NTSB FTW83FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hennessey, OKThe plt was giving taxi rides to his grandchildren at a private farm strip. Accompanied by two teenage granddaughters, the plt was observed in the right front seat holding the entry door open while taxiing the acft up & down the strip. A witness heard the…NTSB FTW82DA398Accident · No injuriesFinal reportPiper PA-28-140 · Kansas, OKAircraft collided with a hole in a pasture after a precautionary landing due to low fuel state brought on by head winds.NTSB FTW82DA345Accident · No injuriesFinal reportPiper PA-28-140 · Oklahoma City, OKThe student pilot reported that during a landing, the aircraft ballooned and he overcorrected. The nose gear assembly was damaged during touchdown and the rudder pedals became inoperative. The student lost directional control andcollided with a parked…NTSB FTW82FPJ17Accident · 1 fatalFinal reportPiper 28-140 · Harrah, OKDuring takeoff, the pilot elected to cross under a power line near the end of the runway when he realized he could not fly over. As the plane crossed under the power line, the right main gear struck a steel perimeter fence post. Across the street form the…NTSB FTW81DQG60Accident · No injuriesClosedPiper PA-28 · Texhoma, OKNTSB FTW80FA062Accident · 1 fatalClosedPiper PA-28 · Wagoner, OKNTSB FTW79FPJ06Accident · No injuriesClosedPiper PA-28 · Altus, OKNTSB FTW78FPM20Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW78FPM09Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW78FA014Accident · 1 fatalClosedPiper PA-28 · Langley, OKNTSB FTW78DPM01Accident · No injuriesClosedPiper PA-28 · Big Cedar, OKNTSB FTW77FPJ35Accident · No injuriesClosedPiper PA-28 · Oklahoma City, OKNTSB FTW76AF126Accident · 1 fatalClosedPiper PA-28 · Greenfield, OKNTSB FTW76DPJ38Accident · No injuriesClosedPiper PA-28 · Boise City, OKNTSB FTW76FPM19Accident · No injuriesClosedPiper PA-28 · Quinton, OKNTSB FTW76FPJ13Accident · No injuriesClosedPiper PA-28 · Hennessey, OKNTSB FTW76FPM03Accident · Serious injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW75FPM15Accident · No injuriesClosedPiper PA-28 · Boley, OKNTSB FTW75FPM13Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW75DPJ19Accident · Minor injuriesClosedPiper PA-28 · Kingfisher, OKNTSB FTW75FPM08Accident · Minor injuriesClosedPiper PA-28 · Beggs, OKNTSB FTW75FPM06Accident · Minor injuriesClosedPiper PA-28 · Westport, OKNTSB FTW73FPJ09Accident · Minor injuriesClosedPiper PA-28 · Duncan, OKNTSB FTW73DPM01Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW72FPM25Accident · Minor injuriesClosedPiper PA-28 · Atoka, OKNTSB FTW72AF034Accident · 1 fatalClosedPiper PA-28 · Piedmont, OKNTSB FTW72DPM11Accident · No injuriesClosedPiper PA-28 · Morris, OKNTSB FTW71FPM20Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW71DPM19Accident · No injuriesClosedPiper PA-28 · Bernice, OKNTSB FTW71DPM03Accident · No injuriesClosedPiper PA-28 · Westville, OKNTSB FTW70DPJ03Accident · No injuriesClosedPiper PA-28 · Goodwell, OKNTSB FTW70D0075Accident · No injuriesClosedPiper PA-28 · Waynoka, OK