NTSB investigations: Piper PA-28R-201T
135 cases on aircraft the registry lists as Piper PA-28R-201T. 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 ('7102813'))
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 ('7102813'))
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 LAX93LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Concord, CAThe engine manufacturer failing to properly install tab washers during overhaul which resulted in one bolt becoming loose and being ingested through various engine gear drives. The ingestion and loose oil pump cover resulted in the engine running rough and a…NTSB FTW92FA180Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Tool, TXThe pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.NTSB SEA92FA077Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Briggsdale, COProper altitude was not maintained. Factors include ostentatious display.NTSB BFO92LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Brewer, METhe pilot's decision to land on an icy runway and then attempt to take off. Contributing to the accident was the pilot's decision to completely raise the flaps after the balked landing.NTSB LAX92LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Ludlow, CAThe failure of the repair station to adequately perform a top overhaul and comply with a service bulletin. Contributing to this accident was the failure of the connecting rod due to fatigue and unsuitable terrain.NTSB SEA92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Monticello, UTInadequate maintenance/overhaul of the engine, and subsequent failure of the #5 piston (hole burned in piston), due to pre-ignition and/or detonation. Rough/uneven terrain in the emergency landing area was a related factor.NTSB NYC91LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tuckhannock, PAThe failure of the pilot to achieve a proper touchdown point. A factor related to the accident was the pilot's failure to make a go-around.NTSB LAX91FA138Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Vacaville, CAThe pilot's continued VFR flight at night under low clouds, and his failure to maintain sufficient altitude over rising terrain. Factors related to the accident were: darkness, the adverse weather and terrain conditions, and the controller's inaccurate…NTSB LAX91LA101Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · So. Lake Tahoe, CAThe pilot failed to properly compensate for the wind conditions, abruptly flared the airplane, and inadvertenly stalled the airplane. Contributing to this accident was windshear.NTSB LAX91LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Arcadia, CAImproper installation of the recently overhauled powerplant by maintenance personnel and inadequate inspection by maintenance personnel which failed to detect that the engine fuel pressure gauge line was not properly secured to the fuel system manifold valve.NTSB BFO89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28R-201T · College Park, MDFailure of the pilot to maintain aircraft control due to spatial disorientation, and his exceeding the design stress limits of the aircraft, which resulted in overload failure of the stabilators and wings. Factors related to the accident were: the pilot's…NTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…NTSB LAX89LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Van Nuys, CAThe pilot lost control of the aircraft while descending for landing and collided with a pole. The pilot stated that he was cleared to land behind a king air, on runway 16R. The pilot stated that about the time he descended to 50 feet AGL, near the threshold,…NTSB ATL89FA024Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Bridgeport, WVThe plt was cleared to execute a visual approach to rwy 21 and was issued the current alt setting of 29.60' hg. The approach was made under dark night and gusty crosswind conditions to a lighted runway in rural mountainous/hilly terrain. During final approach…NTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…NTSB DEN88LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Erie, CONTSB FTW88DQG04Accident · No injuriesFinal reportPiper PA-28-201T · Shallowater, TXThe pilot lost directional control during the landing roll with a strong left crosswind on a narrow runway. A go-around was attempted but the aircraft drifted right and received substantial damage when it touched down in soft terrain.NTSB NYC88LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lincoln Park, NJDuring takeoff the aircraft was observed to become briefly airborne; then the wing dipped just before ground contact. The aircraft crashed about 50 feet from the departure end of the runway and about 300 feet to the right. The pilot said he experienced a…NTSB LAX88LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-201T · Bullhead City, AZShortly after takeoff, the engine failed. During the forced landing the aircraft ran into a rock quarry. Inspection of the engine revealed that the fuel injector lines were loose and that one line had separated.NTSB MIA88LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Sarasota, FLDrg arrival, while being transferred from tampa apch ctl to twr ctl, the plt was clrd to lnd on rwy 14. Bfr lndg, he was adzd the wind was fm 070 deg at 15 KTS. Rwy 4 was available, but it was not suggested by the twr ctlr or reqd by the plt. The plt stated…NTSB FTW87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Midland, TXDuring takeoff roll from mid-field on the wrong runway, the pilot realized he was running out of runway. He rotated the aircraft early and climbed to approximately 10 feet AGL. The aircraft would not climb. The pilot aborted the takeoff andapplied brakes…NTSB ATL87LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Bowling Green, OHThe instructor (CFI) rprtd he preflighted the acft & taxied to the refueling area. While there, he was apchd by another plt who wanted to go with him on this flt. They agreed & the CFI moved to the rgt seat. They commenced the start-up, run-up & takeoff…NTSB NYC86LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Teterboro, NJThe acft collided with a large bird while in cruise flt. The leading edge of the ry wing was damaged. The acft was landed without further incident.NTSB LAX86LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Concord, CAThe plt was landing at night at the conclusion of a cross country flt. On entry to the downwind for fwy 19R, the plt asked that the approach lights be turned up full bright. On short final, the plt said she encounted excessive glare in her contact lenses from…NTSB LAX85LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hesperia, CAUpon completing a x-c flt, the plt placed the landing gear selector in the down position, & thereafter observed 'three in the green.' The plt reported that the acft touched down normally, & as weight placed onto the gear the right main gear retracted. The…NTSB MKC85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Norfolk, NEThe plt confirmed an alternator failure a short time after departing fairmont, cancelled his IFR clearance and continued to Norfolk for landing. Upon reaching his destination the plt was unable to extend the landing gear due to the electrical failure and no…NTSB ATL85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Madison, WVFollowing a loss of eng power during a x-country flt, the plt landed on a bridge. During the ldg roll the wing struck a pole. Post crash examination of the engine disclosed that the camshaft gear teeth suffered fatigue failure.NTSB MIA85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Gainesville, FLThe acft collided with a tractor during taxi. The plt stated that he saw the tractor and thought there was room to pass.NTSB FTW85LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Crowell, TXThe plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…NTSB ATL84LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Henderson, KYThe acft was damaged in an off arpt forced landing after the engine lost oil pressure, overheated and quit running. The plt said she checked the oil quantity at 7 1/2 qts before takeoff for the local flt. The engine overheated after about one hour of flt…NTSB MIA84LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · St. Augustine, FLThe plt reported the eng lost partial power shortly after becoming airborne. He attempted to return to the field & land on rwy 24, but he missed the rwy & landed hard north of the rwy. Disassembly of the eng fuel pump revealed that the o-ring sealing the…NTSB LAX84LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hayward, CACompleting a night instrument private pilot biennial flight reivew, the acft was issued landing clearance for rwy 28L. On short final the pvt plt began to align the acft to land on rwy 28R which was closed for maintenance & not illuminated. The instructor plt…NTSB CHI84LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · East St. Louis, ILThe pilot was found lying on the ramp under the front of the aircraft, bleeding profusely from scalp wounds. Although he was unable to recall the circumstances preceding the accident, he noted that it would not have occurred had he not attempted to 'pull the…NTSB LAX84FA107Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Tehachapi, CAThe acft collided with the ground after stalling during a right climbing turn into clouds. Witnesses reported that the initial climb attitude was 'very steep'. No one observed the crash but the engine RPM 'revved up' to a very high RPM 4-5SECONDS prior to the…NTSB LAX84LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Chandler, AZPrior to landing the plt observed that the gear down light for the right gear did not illuminate. He recycled the gear 2 or 3 times, but the green gear down light would not illuminate. Ground personnel reported to the plt that the gear appeared to be down.…NTSB FTW84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Smithville, TXDuring cruise at 8,500 ft MSL the eng quit. A night emergency landing was made at an arpt that the acft had just flown over. On final approach the plt could not see thru the windshield very well due to oil building up on the windshield. The plt held the gear…NTSB FTW83LA411Accident · No injuriesLimited investigationFinal reportPiper PA28R-201T · Anton Chico, NMDuring flt, the plt heard a 'pop' noise which was followed by a loss of power. The fuel flow indicated zero & he was unable to start the eng. During a forced landing, the left wing hit a bush which caused the acft to swerve & the main gear to collapse. An…NTSB CHI83LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Jackson, MIComplete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the…NTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…NTSB ATL83FID02Accident · 2 fatalFinal reportPiper PA-28R · Chesapeake, VAThe aircraft had previously been flown from orlando, FL to norfolk/Chesapeake, VA. While the original non-instrument rated pilot was in Virginia, the weather deteriorated, so the owner flew up from orlando (via the airlines) to fly the original occupants back…NTSB CHI83FA044Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Evart, MIThe aircraft flew into trees during low flight in IMC weather. The pilot had received a weather briefing and was instrument rated but was not on an IFR flight plan. IMC weather was forecast for the route planned. Hunters heard the aircraft fly over at a low…NTSB ATL82FA251Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · State Road, NCThe plt reported his engine had quit. ARTCC advised the plt that the nearest arpt was elking at 12 mi. Several minutes later he reported that he didn't think he could make the arpt & was going to look for a field. Witnesses observed the landing gear down…NTSB ANC82DAG60Accident · 3 fatalFinal reportPiper PA-28R · Dillingham, AKPilot collided with mountainous terrain at the 1400 foot level. He proposed flight on V-452 which does not exist in that area. V-462 would have been appropriate but his position did not coincide with that route. He was on a VFR flight plan. Twilight ended…NTSB MIA82DA157Accident · 4 fatalFinal reportPiper PA-28R-201T · West Of Cross C, FLAt about 1605 CDT, the pilot activated his VFR flight plan from nashville, TN to venice, FL. At 1813, the pilot contacted tallahasee fss and was briefed on the weather conditions to sarasota, FL. This was the last known radio communication with the aircraft.…NTSB DEN82DA055Accident · No injuriesFinal reportPiper PA-28R-201T · Longmont, COThe pilot reported that he made a normal approach and touched down in the landing zone as defined by the VASI. However, during the landing roll, the right brake was inoperative. He was unable to stop on the remaining runway while rolling straight ahead. About…NTSB LAX82IA062Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201T · Truckee, CADuring the landing roll the aircraft veered sharply to the left and struck a snowbank, collapsing the nose and left main landing gear. Inspection of the runway revealed the presence of several large ice chunks adhering to the runway surface.NTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…NTSB NYC82FFJ09Accident · Minor injuriesClosedPiper PA-28R · Syracuse, NYNTSB NYC81FA081Accident · 1 fatalClosedPiper PA-28R · Randolph, NJNTSB FTW81FA118Accident · 1 fatalClosedPiper PA-28R · Livingston, TX