NTSB investigations: Piper PA-28RT-201
88 cases on aircraft the registry lists as Piper PA-28RT-201. 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 ('7102818'))
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 ('7102818'))
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 FTW88LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Oklahoma City, OKThe air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…NTSB FTW88DRG10Accident · Minor injuriesFinal reportPiper PA-28RT-201 · Lampasas, TXThe pilot experienced a partial loss of engine power during cruise, while on a night, VFR, cross-country flight. He attempted to spiral down to an airport for an emergency landing but reported that he became disoriented and attempted to land downwind,…NTSB NYC88LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Millbrook, NYThe aircraft departed runway 17 at sky acres airport and after reachng an altitude of about 100 feet, witnesses observed the engine cowling extended vertically, partially attached. The pilot said he was unable to return to the departure airport, and the…NTSB ATL88FA068Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Rutherfordton, NCThe pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…NTSB MIA88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLDuring an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear…NTSB NYC88LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver Falls, PADuring hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury.NTSB CHI87LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chelsea, MIThe pilot and three passengers attempted a takeoff from a 1800 foot sod, upsloping runway with tall, wet grass. Density altitude was 2700 feet. As the aircraft climbed out of ground effect the pilot said the engine sounded 'funny' and aborted the takeoff. The…NTSB MIA87IA134Incident · No injuriesIncident investigationFinal reportPiper PA-28RT-201 · Grant, FLThe CFI closed the throttle & announced a simulated forced ldg. Moments later, he advanced the throttle to clear the engine & found it would not respond. A forced ldg was then performed in a field without further incident. A subsequent exam of the engine,…NTSB BFO87DID01Accident · No injuriesFinal reportPiper PA-28RT-201 · Lynchburg, VAWhile on the takeoff roll, the acft collided with a deer. The plt rprtd that he had accelerated to 50 KTS & was about 1000 ft down the rwy when the deer ran in front of theNTSB NYC87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Caldwell, NJThe pilot in command allowed the aircraft to become too low during a night simulated emergency (engine out) during an instructional flight. The aircraft contacted the tops of trees, became uncontrollable and crashed to the ground.NTSB ATL86LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Robbinsville, NCThe acft was flown from troy, mi to knoxville, TN and landed, but it was not refueled. The plt proceeded on to the assume destination, but the acft did not arrive. According to the plt's original flt plan (from troy to andrews, NC), the estimated time en…NTSB MIA86LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe plt stated that they were doing touch & go landings & on liftoff, the eng sputtered & lost power. She then took over the controls from the student & attempted to land on another rwy & landed hard. Post crash examination of the eng revealed that the eng…NTSB CHI85FA354Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot was flying on a south casterly heading of approximately 150' at a low altitude when he struck a set of static lines at approximately 170' AGL. The aircraft flipped over and hit the terrain at approximately 60, nose down in a stand of corn. The pilot…NTSB NYC85LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Newbury, MAAccording to a passenger, after a long ground roll, the acft lifted off and the plt attempted to increase airspeed by lowering the pitch attitude. As the acft approached the end of the rwy and trees, the stall warning horn sounded. The plt again attempted to…NTSB NYC84LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Smyrna, DEAcft contacted a ditch and nosed over during a precautionary landing after plt noticed engine was running rough. Cause of engine roughness could not be determined through inspection of the engine.NTSB SEA84FA068Accident · 6 fatalField investigationFinal reportPiper PA-28RT-201 · Hood River, ORAfter crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…NTSB ATL84FA057Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Atlanta, GAAfter gompleting a preflt, the plt entered the acft & attempted to start the eng with the starter & on board battery. He stated that the eng turned slowly & would not start. After several attempts to make a normal start, the plt exited the acft, chocked the…NTSB LAX83LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Meadview, AZThe pilot stated that shortly after takeoff at aprx 100 feet, the engine lost power. He then switched the boost pumps from low to high and the engine momentarily surged before losing power. During the forced landing the landing gear collapsed and the wings…NTSB NYC83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · West Chester, PAThe plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only…NTSB LAX82FYM18Accident · No injuriesFinal reportPiper PA-28RT-201 · San Carlos, CAAfter landing at the airport, the pilot taxied to the transient parking area, parked and got a cup of coffee. He stated that he then made a quick preflight check, but did not visually inspect the fuel tanks. During the takeoff, the engine began to surge at…NTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…NTSB NYC82AA125Accident · 4 fatalFinal reportPiper PA-28RT-201 · Dunkirk, NYThe flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200…NTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…NTSB CHI82DA043Accident · No injuriesFinal reportPiper PA-28R-201 · Mattoon, ILThe pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…NTSB DEN82FA005Accident · 3 fatalClosedPiper PA-28 · Provo, UTNTSB CHI81FEX30Accident · No injuriesClosedPiper PA-28 · Noblesville, INNTSB FTW81FA145Accident · 2 fatalClosedPiper PA-28R · Dallas, TXNTSB ANC81DAG82Accident · No injuriesClosedPiper PA-28 · Cantwell, AKNTSB ATL81FIA09Accident · No injuriesClosedPiper PA-28R · Woodbridge, VANTSB LAX81DVW10Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNTSB MIA81DLA16Accident · No injuriesClosedPiper PA-28 · Daytona Beach, FLNTSB LAX81FUG19Accident · No injuriesClosedPiper PA-28R · Rancho, CANTSB NYC81FNA09Accident · No injuriesClosedPiper PA-28R · Falmouth, MANTSB DEN81FTM11Accident · No injuriesClosedPiper PA-28R · Ogden, UTNTSB NYC81FA016Accident · 4 fatalClosedPiper PA-28R · Jamaica, NYNTSB CHI80DEE31Accident · No injuriesClosedPiper PA28RT · West Chicago, ILNTSB IAD80FA032Accident · 1 fatalClosedPiper PA-28R · Alcoa, TNNTSB DEN80DTE19Accident · No injuriesClosedPiper PA28RT · Dove Creek, CO