NTSB investigations: Piper PA-28-235
579 cases on aircraft the registry lists as Piper PA-28-235. 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, newest first
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
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 CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.NTSB NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.NTSB LAX92LA371Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Casa Grande, AZThe pilots inadequate compensation for the existing wind conditions. The gusty nature of the cross wind condiitons encountered was a factor.NTSB NYC92FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Honesdale, PAA loss of control in flight due to pilot incapacitation as a result of a heart attack.NTSB LAX92LA144Accident · No injuriesLimited investigationFinal reportPiper PA28-235 · Havasu Lake, CAThe dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.NTSB FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB LAX91FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Redlands, CAA total loss of engine power due to fuel starvation as a result of a fuel system leak of an undetermined origin.NTSB NYC90LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Reading, PAA loss of engine power for unknown reasons and an off airport landing on unsuitable terrain.NTSB NYC90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Middleton, RILoss of direction control by the pilot when he came in high and fast and touched down at improper touchdown point.NTSB FTW90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Granbury, TXFuel starvation due to the pilot's disregard for the position of the fuel tank selector.NTSB SEA90LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Yamhill, ORThe pilot's failure to use the proper touchdown point for landing. The tailwind was a factor related to the accident.NTSB BFO90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Tappahannock, VAFailure of fixed base operator (FBO) personnel to assure that the fuel tank was free of water, and failure of the pilot to insure that the aircraft was properly preflighted. Soft/marshy terrain in the emergency landing area was a related factor.NTSB CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.NTSB LAX90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rancho Calif, CAThe pilot's loss of directional control during a crosswind landing.NTSB DEN89LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Dove Creek, COImproper planning/decision by the pilot. Factors related to the accident were: high density altitude, uphill sloping runway, failure of the pilot to follow the checklist and use all of the available runway, and the rising terrain and obstruction (power line)…NTSB DEN89FA192Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Bullfrog, UTImproper flare by the pilot, his failure to maintain runway alignment, and the improper remedial action which resulted in a loss of control. The high density altitude and objects (runway light and smudge pot) were considered to be contributing factors.NTSB ATL89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Somerset, OHThe pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.NTSB LAX89LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Long Beach, CAThe pilot's failure to select the proper fuel tank for an adequate fuel supply for the takoeff.NTSB CHI89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Monee, ILInadequate maintenance/inspection of the aircraft after metal fragments were found in the oil, and worn cam lobes/followers/piston pin plugs, which resulted in oil contamination, restriction (blockage) in the oil system, oil starvation, and subsequent engine…NTSB ATL89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Liberty, NCThe pilot's inadvertent landing at the wrong airport, contributing to the accident was the failure of the airport personnel to notify the FAA of the existance of the airport so it could be properly designated on aviation charts.NTSB MKC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Leon, IAWhile cruising about 3000 feet AGL during a personal flight, the engine had a complete power failure. A successful emergency ldg was made on a farm hay field with no damage incurred. Shortly after the ldg, smoke was observed coming from the engine…NTSB LAX88FA312Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Camarillo, CAThe pilot decided to operate the aircraft with a known electrical deficiency during night instrument meteorlogical conditions and the decision of the pilot to conduct a flight operation in which he was not certified. Contributing to this accident was the…NTSB LAX88LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Lower Lake, CAThe pilot departed NOVAT0, CA with the fuel selector in the right tip tank position. She did not switch the selector to the main tank position. Four miles from Lower Lake, CA the engine lost all power. After the accident, only the right tip tank was found…NTSB FTW88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Littlefield, TXThe connecting rod cap attaching bolt failed in flight which caused the engine to stop. The pilot was on final approach at the time but was unable to reach the runway. A forced landing was made in a farm field short of the airport. Upon touchdown the aircraft…NTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…NTSB FTW87FA225Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Houston, TXPlt executed an emergency landing into trees after he experienced an inflight fire and eng failure shortly after t/o. the lndg in the trees was executed after the plt decided that he could not make it to a clear area. Investigation revealed that the fire had…NTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…NTSB NYC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Toms River, NJThe flight was involved in short field landing practice. On the third landing, the pilot allowed the aircraft to stall above the runway surface and then touch down hard, damaging the outboard sections of the wings.NTSB LAX87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · San Luis Obispo, CAAfter take-off, the pilot was flying a downwind departure when the engine quit. The pilot was unable to return to the runway and collided with the terrain a half mile from the airport. Inspection of the engine at the time of the accident found that the main…NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…NTSB NYC87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Shelburne, VTPilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage.NTSB LAX87LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hayward, CAA Piper PA-28-235 collided with a dirt bank after a loss of power while on a night VFR pleasure flight. The plt indicated that aprx 3 min after takeoff while cruising at 1,400 ft MSL the engine RPM abruptly decreased to idle. The fuel selector control was…NTSB NYC87FA021Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Jamestown, NYThe non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to…NTSB CHI86FA200Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Shelby, INThe non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…NTSB DEN86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Last Chance, COThe plt said while on landing roll a cross wind drifted N8844W off right hand side of rwy on a farm strip. Lost control in soft dirt and nosed over. The vehicle was substantially damaged, and the plt was uninjured.NTSB NYC86LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westport, NYThe Piper PA-28-235 made an off airport landing at night in conditions of reduced visibility, with rain, gusty winds and thunderstorms in the area. The aircraft received substantial damage and the pilot received serious injuries. Post crash examination of the…NTSB ATL86LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Middle Bass Is., OHHeavy rains had flooded the causeway that connected Middle Bass island to the main island. A family was in need of transportation off the island and the pilot was attempting to fly them to the mainland using the 2,100 foot grass airstrip. The airstrip was wet…NTSB FTW86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Springtown, TXThe pilot reported colliding with a fence at the end of the runway when he landed short while on final approach into kezer airport near Springtown, TX. His aircraft sustained substanial damage to the left wing, nose gear and propeller after travelling 200 ft.…NTSB NYC86LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mttituck, NYPilot states on landing flair the aircraft was tracking on a 190 degree heading for rwy 29 winds were from 260 pt 20 KTS on flair acft drifted approx 16 ft to the left and left wide extended beyond rwy making contact with shrubbry on the edge of the rwy. Acft…NTSB FTW86FPA03Accident · Minor injuriesFinal reportPiper PA-28-235 · Yantis, TXThe acft contacted a tree and a large bale of hay during a forced landing following a loss of pwr. Post accident inspection disclosed 18 gallons of fuel remained in the left main tank and 3 gallons remained in the left wing tip tank. Both right wing fuel…NTSB CHI85FA357Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Worthington, MNThe acft had progreesed 16 miles on a 95 mile x-country flt when it was witnessed in low flt over a corn fld. The acft was about 200 ft AGL when it entered a descending right power on turn until ground impact. An autopsy report on the plt disclosed,…NTSB SEA85LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Cold Meadows, IDThe plt was attempting to land on an airstrip with a density alt of 9000 ft. during a go-around the acft was unable to out climb rising terrain due to the density alt. A departure stall into trees resulted. A post-impact fire destroyed the acft. The plt…NTSB LAX85LA321Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Monterey, CAThe pilot took off on a training flight to practice holding over a VOR intersection 12 miles off shore. Approximately 12MINUTES after take off the pilot declared 'mayday,rough engine', to the Monterey,calfornia control tower control specialist. The control…NTSB NYC85LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Batavia, NYThe acft was substantially damaged during a forced landing following a loss of pwr on initial takeoff climb. The plt reported that at an alt of aprx 100 ft AGL, the eng quit operating. A forced landing was made 100 yrds off the end of rwy 28. Inspection of…NTSB CHI85LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Valparaiso, INAcft contacted a ditch following a loss of directional control during landing roll. Plt reported, 'more experience in handling crosswinds' could have prevented the accident.NTSB FTW84LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Odessa, TXDuring the takeoff ground roll the plt noticed the inop airspeed indicator but continued the takeoff. The acft bounced during the long fast landing and traveled off the right side of the rwy. The plt corrected back to the left and the acft touchdown hard off…NTSB ANC84FA072Accident · No injuriesField investigationFinal reportPiper PA-28-235 · Egegik, AKThe acft crashed during a forced landing on unsuitable terrain. The plt said the acft engine lost oil-pressure about 20 minutes after takeoff and he turned toward the closest arpt. The engine operated a few minutes and then stopped. The acft was landed off…NTSB SEA84LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Touchet, WAThe acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…