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 NYC86LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westhampton Bch, NYThe instrument instructional flight returned to the airport late at night and successfully completed two instrument approaches with missed approaches. The pilots had been advised of a low layer of fog on the airport. On the third and final approach, after…NTSB BFO86FA023Accident · Minor injuriesField investigationFinal reportPiper PA-28R-200 · Camp Springs, MDDuring a flt to prepare the student for a CFI check ride, both the student and the CFI could not obtain a green light confirming the nose gear was down and locked. After numerous attempts to assure it was down and locked the acft was landed at andrews afb.…NTSB MIA86LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Umatilla, FLThe plt reported that he flared the acft too high while landing. The acft stalled too soon and a hard landing resulted.NTSB ATL86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hanceville, ALWhile enroute to birmingham the pilot experienced a complete power failure when no. 2 cylinder separated from the engine assembly. The pilot attempted to make an emergency landing on interstate 65 near Hanceville, AL, and the aircraftcollided with an…NTSB DEN86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sterling, COAccording to the plt, during the checkride for his commercial plt certificate, the flt examiner gave him a simulated electrical failure & turned the landing lights off. The plt stated that during the night landing flare, he lost visual reference with the rwy…NTSB LAX86LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Mammoth Lakes, CAThe plt reported that when he observed the arpt's wind sock in preparation for departure the wind was blowing down the rwy with occasional gusts that did not seem over 20 KTS. After taking off & climbing to abt 100 ft AGL, the acft encountered turbulence…NTSB MKC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gardner, KSThe pilot stated that he was landing on runway 8 with a right crosswind and had the right wing down for wind correction. The right wheel impacted a lip on the approach end of the runway, 6 inches below the level of the runway. The right gear collapsed, the…NTSB FTW85LA353Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Plainview, TXThe acft was substantially damaged during an emerg landing following an eng failure due to fuel exhaustion. Plt stated that during the 2nd leg of his flt, the ceiling and visibility deteriorated to the point that he was unable to find the arpt at his…NTSB ATL85FMG08Accident · Serious injuriesFinal reportPiper PA-28R-200 · Shuffletown, NCThe acft contacted a fence during a forced landing following a loss of pwr. The flt orginated at grand ledge, MI, at 1100 EST and an unscheduled landing was made at adrian, MI, because of wx. The flt departed adrian, MI, at 1320 EDT. The plt reported that…NTSB CHI85LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · New Richmond, WIThe acft veered to the rt & hit a rwy marker during the attempted go-around. The wind was from 210 degrees at 19 KTS gusting to 27 KTS. The plt said that if the marker had been 'break-away' plastic the damage would have been negliable.NTSB MIA85IA197Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Ft. Pierce, FLThe landing check list was not properly followed and both pilots neglected to extend the landing gear in preparation for landingNTSB DEN85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Los Almos, NMThe plt was making an apch to rwy 27 at the los alamos muni arpt in gusty x-wind conditions. The arpt was located atop a mesa & rwy 27 had a 1.5% uphill rwy gradient. The plt said he selected 2 notches (25 deg) of flaps. The winds were reported to be from 210…NTSB NYC85LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Montgomery, NYThe acft made a forced landing after the manifold pressure kept dropping. Some adjustment was made by throttle application and finally alt air was used. When the plt decided that the arpt could not be reached he landed on a highway. The left & nose gear…NTSB MKC85LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Kansas City, MOPlt inadvertently entered clouds on VFR flight. Plt sighted an arpt through breaks in clouds and decided to land. The acft touched down short of a closed rwy, partially collapsing the left gear. It then bounced up onto the rwy and fully collapsed the left…NTSB MIA85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wabasso, FLInstructional flight practicing steep turns. Engine lost oil through crack in propeller governor oil line and seized. Instructor took over control and landed on a road in a sand pit. Pilot was unable to steer through an 's' turn on the road and collided with…NTSB MIA85LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Merritt Island, FLPlt lost directional control and the acft collided with a dirt embankment while landing. The acft was landed with a right rear crosswind.NTSB NYC84LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Monticello, NYAccording to the plt, he was flying instrument approaches to touch and go landings and neglected to extend the landing gear. The automatic gear extension system extended the left main gear before the acft landed.NTSB CHI84LA350Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Put-In-Bay, OHPlt departed on flt with 30 gals fuel. En route weather required route deviation, extending flt. Calculated fuel reserve was consumed before reaching destination. When fuel exhaustion occurred, plt attempted forced landing on curving road. Acft departed road…NTSB FTW84LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Charles, LAThe plt landed on the edge of a 90 ft wide turf rwy which was soft due to recent rains. The acft drifted off into a ditch causing the collapse of the left main gear.NTSB LAX84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gila Bend, AZA forced landing was made on a road after the plt shut down the eng due to a 'run-away' prop. During the landing roll, the left wing tip struck a reflector post followed by the right wing striking a sign post. An eng overhaul & an annual inspection had been…NTSB CHI84LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lafayette, INThe pilot was practicing accuracy landings when he noticed that the acft had blown away from the rwy. When he attempted to increase the throttle setting there was no response. In an attempt to land on a highway on-ramp the acft struck an electric wire, a…NTSB MKC84FA115Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Garden City, KSThe plt departed kendallville, IN, at about 1800 EST & made a refueling stop at topeka, KS. At topeka, he obtained a wx briefing for a flt to pueblo, CO, his intended destination, & was advised of marginal VFR to IFR conditions on his proposed route. He then…NTSB ATL84IA135Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Clayton, NCDuring flt, the plt & a passenger noted a loss of eng power accompanied by a metallic sound. Subsequently, a wheels-up forced landing was made in a plowed field. An eng teardown revealed that the crankshaft, p/n 54297-1, had failed from fatigue. A…NTSB NYC84LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJAccording to the plt, a windshear was encountered during the final approach at approximately 100 ft AGL. The acft descended rapidly and bounced at the approach end of the rwy, ascended approximately 30 ft into the air, landed again striking the left wing on…NTSB NYC84FA108Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Groton, CTThe plt received 2 wx briefings prior to departing & both called for low ceilings. During arrival at the destination, the plt requested & was cleared for an ILS apch to rwy 5. While on the apch, the acft collided with a small tree & crashed. The wreckage came…NTSB CHI84LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Stow, OHThe acft ran off the rwy & collided with a snowbank during landing. The acft had been subjected to previous damage whichhad not been fully repaired when a mechanic released it for further flt. A bolt (slightly worn, according to the mechanic) was reused in…NTSB MIA84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cedar Key, FLDuring the 1st landing, the acft touched down at night, aprx half way down the rwy. The plt eleected to go around, then made a 2nd apch & landing. During the 2nd landing, the acft went off the end of the rwy & came to rest in water. The plt stated that…NTSB SEA84LA038Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Newport, ORThe acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown…NTSB LAX84FA138Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Tracy, CAThe flight departed under instrument meteorological conditions, with visibility restricted to one quarter mile by fog. The ceiling was obscured. After departure witnesses heard the aircraft make what appeared to be a left turn. Next they heard the engine…NTSB CHI84LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INThe acft made an off arpt forced landing after the engine quit. According to the plt, the flt departed wichita falls, TX at 1516 with 48 gallons of fuel on board. When about 7 miles south-southeast of Terre Haute, IN, the engine quit. Theplt tried to restart…NTSB CHI84LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Zanesville, OHAfter departing Zanesville, OH, the acft was at 2500 ft MSL when the eng began to 'knock'. The cockpit filed with smoke & the eng began to lose oil. The plt turned back to land at the arpt. He reported that the eng continued to run until the acft was about…NTSB LAX84LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · San Diego, CAAfter departing north island nas (naval air station), the plt attempted to change frequencies, but the megahertz (mhz) tuning knob came off at a setting of 122.1 mhz. He could still use the knob for tuning tenths of a mhz, so he contacted San Diego fss on…NTSB MKC84LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Carlisle, IAThe pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight.NTSB FTW84LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Spring, TXThe plt stated that while he was taxiing to takeoff, he misjudged his clearance from a 6 ft x 6 inch concrete block. The left brake housing hit the block which resulted in damage to the wing spar. He did not examine the acft until after the flt & was unaware…NTSB FTW84LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Brenham, TXThe pilot, accompanied by three passengers, landed hard, bounced and last control of the acft, which continued into a stock tank/pond. Examination revealed all three main gear assemblies were collapsed and both left and right wing assemblies were damaged.NTSB LAX83FA422Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Calexico, CAThe plt reported that during takeoff, the eng began to miss at aprx 300 ft AGL & he felt a definite loss of power. He tried to raise the gear, but the airspeed was below the automatic gear extenstion speed, so the gear did not retract. He repositioned the…NTSB ATL83LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Simons Isl., GADuring arrival, the plt began an apch to rwy 04 on a dark night. The apch to the rwy was over a bay inlet & river confluence. The plt thought that the acft was high when it was on final approach. However it collided with trees, impacted on a road short of the…NTSB FTW83FA406Accident · 1 fatalField investigationFinal reportPiper PA 28R-200 · Copan, OKThe acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…NTSB ATL83LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cornelia, GAThe left main gear reportedly jumped a partially obscured curb during a turn around at the end of the rwy after landing. The curb had been installed for erosion control for water runoff. The left wing and landing gear of the acft were damaged.NTSB NYC83LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oak Bluffs, MAThe plt report that during the landing roll, he encountered a bump on the rwy & the acft became airborne aprx 5 to 10 ft. he elected to go around rather than continue the landing since there was not enough room to recover & stop safely. While attempting to…NTSB CHI83LA308Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Chandlerville, ILThe acft made a forced landing after losing power at 1500 ft the pilot said the engine ran rough, oil pressure went to zero and the engine stopped. This pilot had been forced to land the same acft 3 days earlier when the engine lost power during takeoff.…NTSB ATL83LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Russell, KYAprx 3 hrs & 19 min after takeoff, the plt made a radio transmission, stating that he had run out of fuel. Reportedly, he had taken off with 43 gal of fuel on board. During an emergency landing, the acft was substantially damaged. After landing, the plt…NTSB FTW83LA291Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Leggett, TXThe acft was damaged in a forced landing after the engine failed while cruising at 2500 ft. the acft was landed in an open field. Post accident investigation disclosed a missing oil drain plug. 2 pistons failed from lack of oil. The acft had a 100 hour…NTSB FTW83FA253Accident · 1 fatalField investigationFinal reportPiper PA28R200 · Decatur, TXAfter landing due to poor wx the pilot obtained a wx briefing during which he was told of a long line of thunderstorms 150 miles wide covering the area in which he was located. The pilot departed & then attempted to land at an airport 15 miles away in gusty…NTSB NYC83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Teterboro, NJAcft collided with taxiway sign collapsing the right landing gear.NTSB MKC83FA066Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wichita, KSThe acft was cleared to make the approach and to descend not below 2300 ft. the pilot descended from 3000 after he reported passing hance, the final appoach fix. He descended to 2300 ft at 500 ft a minute and leveled the acft and lowered the landing gear. The…NTSB ATL83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hampton, SCThe left main landing gear of the aircraft collapsed during a hard landing. The pilot stated that he cleared tall pine trees north of the runway at about 90 mhp (78 KTS). Shortly thereafter the aircraft started to sink 'real fast'. The pilot stated that he…NTSB FTW83LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bandera, TXThe pilot stated that after a normal landing, he taxied to the end of the runway in order to allow another aircraft to land. He than taxied about 70 ft off the runway into a grass turnaround/taxi area where the aircraft hit an 18 inch deep hole with the left…NTSB LAX83FUG11Accident · Minor injuriesFinal reportPiper PA-28R-200 · Upland, CAThe aircraft crashed 150 yards short of the runway during landing. The pilot said the manifold pressure kept falling as he progressed around the field in the traffic pattern. The engine went to idle on the base leg. The pilot had lowered the gear but not the…NTSB FTW83FRD01Accident · 3 fatalFinal reportPiper PA-28R-200 · Henderson, LAThe pilot and two passengers were on a flight from beaumont, TX to covington, LA. The non-instrument rated pilot departed on a special VFR clearance. At that time, the weather at beaumont was 300 ft overcast, visibility 12 mi. When the aircraft was about 10…