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 DEN02LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Paonia, COimpact with a deer during initial climb immediately following rotation, resulting in the separation of the left main landing gear assembly.NTSB LAX01LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Carson City, NVThe pilot's incorrect setting of the fuel selector valve during the prelanding checklist to a position between usable tanks, resulting in fuel starvation.NTSB CHI01FA291Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Crestline, KSThe airplane's departure from level flight and subsequent impact with the terrain as a result of a maneuver initiated by the pilot, and the pilot's failure to maintain clearance from the terrain. The reason for the pilot's actions were not determined.NTSB LAX01LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Flagstaff, AZThe loss of engine power during cruise flight for undetermined reasons that resulted in a forced landing in rough terrain.NTSB FTW01LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Almyra, ARthe loss of engine power due to the crankshaft idler gear's loose lower retaining screw, which resulted in the fatigue failure of the crankshaft idler gear's upper retaining screw.NTSB DEN00LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Broomfield, COThe pilot's failure to maintain adequate clearance from a vehicle parked beside the ramp while he was taxiing the aircraft from landing.NTSB ATL00LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Adel, GAThe pilot's selection of a closed runway for landing. Contributing factors were his inadequate inflight planning/decision and the wood block on the runway..NTSB CHI00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mackinac Island, MIthe pilot not maintaining aircraft control in response to the uncommanded roll, and the excessive descent to the runway resulting in the hard landing. Factors relating to the accident were the pilot's attempted recovery from the uncommanded roll, the high…NTSB NYC00LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Chester, CTThe CFI's delayed remedial action.NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.NTSB LAX99LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Boulder City, NVthe student pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.NTSB FTW99LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sulphur Springs, TXThe delayed aborted takeoff by the pilot-in-command. Factors were the short runway, the tall grass, and the tree.NTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…NTSB DEN99FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Buffalo, WYThe non-instrument rated pilot's initiated flight into adverse weather conditions and inadvertently flew into IMC weather conditions. Factors were the low ceiling weather conditions, the dark night light conditions, and a non operating VOR navigational aid.NTSB FTW98LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mineola, TXThe flight instructor's failure to maintain clearance from the fence post. A factor was the flight instructor's delay in taking remedial action to remedy the student's improper glidepath.NTSB CHI98LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Liberal, KSthe inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.NTSB FTW98FA170Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · New Orleans, LAThe pilot's inability to maintain control of the airplane after experiencing spatial disorientation. Factors were the total failure of the vacuum pump, fog, drizzle, and night conditions.NTSB ATL98FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Clinton, MSThe pilot's lack of recent instrument flight experience that led to spatial disorientation and loss of airplane control; and his improper use of carburetor heat that resulted in a loss of engine power and subsequent collision with the ground during an…NTSB CHI98LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Ulysses, KSthe pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…NTSB CHI97FA308Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · St. Ignaces, MIThe noninstrument-rated pilot's improper decision to depart in instrument meteorological conditions, which resulted in impact with terrain.NTSB IAD97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Morgantown, PAThe pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.NTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.NTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.NTSB MIA97FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Okeechobee, FLthe noninstrument-rated pilot's decision to conduct a VFR flight into instrument meteorological flight conditions. The weather was a factor.NTSB SEA96LA223Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Paisley, ORTotal loss of engine power secondary to geartrain failure.NTSB IAD96LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westminster, MDthe pilot's misjudgement of his speed and distance, his failure to attain the proper touchdown point during the landing, and his delay in executing a go-around (aborted landing), which resulted in an overrun.NTSB FTW96LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Tulsa, OKlow fluid level in the hydraulic reservoir, due to inadequate maintenance/inspection, which resulted in an inoperative brake system. Factors relating to the accident were: the down sloping runway, and trees at the departure end of the runway.NTSB LAX96LA297Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Truckee, CAThe pilot's failure to properly compensate for a crosswind component during the go-around in a high density altitude environment that led to a loss of aircraft control..NTSB SEA96FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Lehi, UTcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: darkness, low ceiling, and snow.NTSB CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…NTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.NTSB LAX95LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Gilbert, AZThe pilot's fuel system mismanagement and improper emergency procedure. The pilot's misjudging the flare was a factor.NTSB NYC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Poestenkill, NYthe pilot's decision to continue an approach during which the airplane was high and fast, and his improper recovery from a bounced landing. The pilot's failure to use the seat belt was a factor.NTSB ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.NTSB FTW95LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hobart, OKThe pilot's inadequate compensation for the wind conditions. A factor was the gusty wind condition.NTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.NTSB FTW95FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Aurora, COTHE CFI's FAILURE TO MAINTAIN AIRCRAFT CONTROL DUE TO SPATIAL DISORIENTATION. FACTORS WERE: A DARK, MOONLESS NIGHT WITH NO VISIBLE HORIZON AND RECENCY OF NIGHT EXPERIENCE BY THE FLIGHT INSTRUCTOR.NTSB LAX94LA263Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cloverdale, CALoss of engine power for an unknown reason.NTSB FTW94FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Wingate, TXWas the pilot's failure to maintain proper alignment. Factors were the wind, and the pilot's improper corrections.NTSB MIA94LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sebring, FLThe failure of the muffler in flight for unknown reasons, allowing hot exhaust gasses to impinge on the carburetor igniting the fuel and the subsequent fire.NTSB LAX94LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Jackpot, NVthe failure of the pilot to maintain control of the aircraft after his loss of visual contact with outside references. Factors in the accident were the dark night lighting conditions and spatial disorientation.NTSB LAX94LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Oakdale, CAthe pilot's failure to maintain an adequate visual lookout, and his failure to adequately communicate his postion and intentions on the Common Traffic Advisory Frequency. A factor in the accident was the pilot's misidentification of the Cessna aircraft he was…NTSB LAX94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lovelock, NVThat the pilot's failure to maintain adequate airspeed while on final approach which resulted in an inadvertent stall during the flare.NTSB ANC94LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKFuel starvation from water and/or ice crystals in the fuel system. A factor in the accident was the improper preflight of the fuel sumps by the pilot-in-command.NTSB CHI93LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bloom, KSimproper refueling by a person or persons unknown. A factor was deteriorated fuel.NTSB NYC93FA076Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Oxford, MAThe pilot's selection of the wrong runway for takeoff which resulted in not being able to obtain adequate airspeed for climbout. A factor which contributed to the accident was the tailwind.NTSB LAX93WA145Accident · 3 fatalForeign investigationPiper PA-28-235 · Loreto, Mexico