NTSB investigations: Piper PA-28R-200
794 cases on aircraft the registry lists as Piper PA-28R-200. 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 ('7102811'))
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 ('7102811'))
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 FTW89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Port Aransas, TXThe collapse of the taxiway, which was inadequately maintained.NTSB CHI89FA109Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Saint Charles, ILThe failure of the mechanic to properly inspect the alternate air door during annual inspection. This failure led to air starvation, loss of power, and a forced landing by the pilot onto rough terrain.NTSB DEN89LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Angel Fire, NMThe pilot's failure to properly evaluate the existing weather conditions and the subsequent takeoff into adverse conditions which degraded the airplane's climb capability. The pilot performed an intentional gear up landing.NTSB FTW89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Edmond, OKImproper maintenance performed by the company mechanic who failed to tighten the oil sump plug, and also failed to safety it.NTSB MIA89FA093Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Inverness, FLThe failure of the propeller governor oil line due to fatigue which was caused by bending damage to the line and the failure of mechanics to install support clamps on the line which caused the fatigue to propagate at a faster rate.NTSB ATL89FA090Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Tipp City, OHImproper planning by the pilot resulting in fuel exhaustion. The pilots lack of equipment and ability to handle the weather situation was ignored by the pilot in his planning for the flight.NTSB MIA89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Rose Hill, MSLoss of electrical power for an undetermined reason and fuel starvation from improper use of the fuel selector. Factors related to the accident were: night and adverse weather conditions.NTSB CHI89FA040Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Carmel, INThe pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft.NTSB MIA89IA032Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Melbourne, FLThe plt stated that while doing touch and go landings at Melbourne, he put the gear handle down but did not check to confirm that it was down. He continued the approach and landed gear up. Afterward, the pilot noticed that the gear pump circuit breaker had…NTSB LAX89FA032Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Anaheim, CAFive minutes after departure and during normal cruise flight, the certified flight instructor noticed a prop overspeed. He immediately pulled back on the prop control to reduce engine r.p.m. and instructed the student, a private pilot, to divert to the…NTSB BFO89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dover, DEAfter takeoff the plt began a cruise climb to 5500 ft. he rprtd that when the acft reached 5200 ft, he noticed oil spraying from underneath the front of the eng cowling. The oil eventually covered the windscreen. The plt diverted toward a nearby arpt, but the…NTSB ATL88LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gray, GAInstructor said that after completing a stall series the engine began to backfire continously & power was lost so that he could not maintain altitude. An off airport landing was made and a fence was hit during the landing roll. Eng had been overhauled &…NTSB LAX88LA315Accident · No injuriesLimited investigationFinal reportBillings/Humbyrd Thorp T-18 · Corona, CAJust prior to touchdown a thorp T-18 and a Piper collided in flight. The Piper struck the thorp from above at aprx 10 ft AGL over the threshold. The thorp landed without further incident. The Piper completed a normal landing until the propeller contacted the…NTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…NTSB BFO88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, WVThe plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was…NTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.NTSB DEN88LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Cheyenne, WYThe flight originated in omaha, NE. Three passengers and the commercial plt embarked on a fishing trip into Wyoming. The pilot departed Cheyenne after having several problems with the engine and correcting the problem by proper leaning. He said he took off…NTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNNTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.NTSB ATL88FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCA Piper PA-28R (lead acft, N44018) & a Cessna 172 (#2 acft, N737GU) were departing Raleigh-durham arpt on a formation flt to petersburg, VA. The Cessna plt (wingman) rprtd that drg takeoff & initial climb, the lead acft bgn to accelerate ahead of him. The…NTSB CHI88LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INNTSB DEN88FA098Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Pintura, UTThe plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…NTSB SEA88LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Elma, WADuring landing roll the pilot applied toe brakes. The right brake pedal went to the floor. The aircraft then veered to the left of the centerline despite the pilots attempt to groundloop the aircraft. The aircraft then rolled over an embankment, collapsing…NTSB ATL88FA081Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Barnardsville, NCNTSB NYC88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Old Bridge, NJThe flight made a normal approach and touched down on runway 24. As the pilot applied pwr for takeoff due to the hazardous runway conditions, the pilot lost directional control and the left main landing gear impacted plowed snow at the edge of the runway.NTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…NTSB DEN88FA033Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · San Jose, CASeveral min after takeoff, the plt noted a loss of oil pressure & elected to return to the arpt. As he was returning, the eng began to overspeed, but he controlled the RPM by retarding the throttle. The wind was from 150 deg at 10 KTS. The plt was clrd to…NTSB BFO88IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Baltimore, MDTwa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr…NTSB ATL88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Homer, GAThe pilot reported a gradual decrease in power after reaching 4000 feet. The plt was unable to obtain a restart. He then elected to attempt a forced landing in a field. The aircraft collided with a tree prior to landing. The aircraft collided with and came to…NTSB BFO88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dares Beach, MDThe plt stated that after climbing about 2000' & proceeding aprx 3 to 4 mi out over the chesapeake bay, the oil temp began to rise & the oil pressure decreased. He turned toward land, but the eng lost power. Subsequently, he was forced to land in a swampy…NTSB ATL87FA230Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Offerman, GADuring a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,…NTSB DEN87LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lordsburg, NMWhile en route on a x-country flt, a severe eng vibration began. The plt reduced power & slowed the airspeed to reduce the severity of the vibration. Subsequently, he elected to make a wheels-up landing on rocky desert terrain. After landing, he discovered…NTSB CHI87FA153Accident · 2 fatalField investigationFinal reportPiper PA-28R · Milwaukee, WIDrg arr at the Milwaukee/lawrence j timmerman arpt, the plt made 2 atmts to use the localizer 15L apch. After the 2nd missed apch, he elected to divert to Milwaukee/general mitchell fld (mke). At that time, he was adzd the mke wx was 300' ovc, 1/4 mi vis with…NTSB ATL87FA174Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Asheville, NCDuring a personal night x-country VFR flight over mountainous terrain the plt was informed by ATC that vip level 3 and 4 thunderstorms were positioned across the intended flt path. The 128 hour non-instrument rated private plt acknowledged and continued the…NTSB ATL87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Maxwell Afb, ALDuring the landing roll, the pilot lost directional control of the acft. The right main and nose gears collapsed. Inspection of the acft failed to reveal any system malfunction/failure.NTSB LAX87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Calexico, CAAt the end of a pleasure cross country flight, the plt reported that upon landing, the acft veered to the left, the plt corrected to the right. The acft veered to the left again and the plt corrected to the right. The acft then began to turn in a clockwise…NTSB ATL87LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Darien, GADuring normal cruise flight at 6,000' the plt reported hearing a loud bang simultaneous with a total loss of power. The plt declared mayday and made a forced landing in small pine trees. Examination of the engine revealed cyl.#2 connecting rod had become…NTSB CHI87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Holland, MIDuring a local flight the aircraft's engine lost oil pressure. The engine continued to run for about two minutes and then totally seized. The pilot made a hard landing on 58th street in Holland (the only available landing area he could see in the dark night…NTSB NYC87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marlboro, MAThe pilot allowed the aircraft to stall and touch down hard causing substantial damage. The pilot was unfamiliar with the short field at this airport.NTSB BFO87LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200R · West Point, VAAfter making a low pass over the uncontrolled airport the CFI decided to let the student pilot make a touch and go landing on runway 27 at West Point municipal airport. West Point, Virginia. The maneuver was successfully completed and the aircraft came around…NTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.NTSB FTW87FA029Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Petersburg, TXAcft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given…NTSB CHI87LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · South Bend, INDuring cruise at 7000' MSL, the plt assumed that he was having an electrical failure because he had not heard any ARTCC transmissions, fuel gauges were indicating low fuel, ammeter reading was zero, and landing gear would not cycle. He shut off all electrical…NTSB BFO87FA004Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Mount Pleasant, MDThe acft was on the second apch attempt for ILS rwy 23 when the accident occurred- on the first attempt the pilot flew outbound instead of inbound on the localizer course. For the second attempt the pilot was cleared for a full apch for ILS rwy 23; which…NTSB MIA87LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Lakeland, FLThe plt stated the acft lost power and he was unable to make it to the arpt. The acft crashed in a field about 3/4 of a mile from the Lakeland arpt. Post crash examination of the eng revealed a complete failure of both magnetos, resulting in the loss of power…NTSB FTW86LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Afton, OKThe pilot stated he was making a precautionary landing at night due to engine roughness and impacted electrical transmission wires. Investigation failed to disclose any reason for the reported engine roughness.NTSB MIA86LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marathon, FLFlight experienced loss of engine oil and subsequent seizing of the engine at which time the aircraft was ditched in the gulf of Mexico. Post crash examination of the engine revealed the oil line from the propeller govenor to the engine nose case had failed…NTSB SEA86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Royal City, WAThe plt was landing the acft on rwy 27, toward the sun. With the sun in her eyes, she did not see a 300 lb calf on the rwy. The acft struck & killed the calf & was substantially damaged.NTSB BFO86FID09Accident · No injuriesFinal reportPiper PA-28R-200 · Montpelier Sta., VAThe acft collided with 2 fences during an off arpt forced landing after a pwr loss. Post acc eng inspection showed internal failure of the eng. #2 connecting rod bolt failed in fatigue through 40 percent of the diameter. The remainder failed in tension. The…NTSB MKC86LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mammoth Spring, ARThe pilot stated that the aircraft had plenty of oil prior to departure and that the flight was proceeding normally when, suddenly, the oil pressure dropped to zero. While subsequently heading for a nearby airport, the engine lost power and seized, forcing an…