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 MIA08LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Kingston, RIThe pilot's misjudgment of speed and altitude while maneuvering to land during an emergency descent. Contributing to the accident was the partial loss of engine power.NTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.NTSB DFW08CA077Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · San Antonio, TXThe pilot's failure to maintain airspeed during the landing flare which resulted in a hard landing.NTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB NYC08FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Augusta, GAA loss of engine power due to the fatigue fracture of the number 2 cylinder attach studs, and the subsequent separation of the number 2 cylinder.NTSB DFW08FA031Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Ranger, TXThe pilot's intentional performance of aerobatic maneuvers that exceeded the design limits of the airplane structure.NTSB LAX08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident were the dark conditions.NTSB NYC07CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Tampa, FLThe pilot's misjudged altitude/distance, which resulted in a hard landing, prior to the runway.NTSB DFW07CA147Accident · No injuriesData collectionFinal reportPiper PA28R-200 · Lubbock, TXThe inadvertent stall and subsequent hard landing as result of the pilot's failure to maintain airspeed and his delayed relinquishing of the airplane's controls when requested by the flight instructor.NTSB DFW07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rockport, TXThe pilots improper landing flare which resulted in a hard landing. Contributing factors were the pilot's delayed actions to abort a wheels-up landing.NTSB CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.NTSB NYC06CA210Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · West Milford, NJThe pilot's inadequate compensation for the wind conditions, which resulted in a hard landing. A factor was the wind.NTSB NYC06FA169Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Block Island, RIThe pilot's inadequate preflight decision making and his failure to maintain terrain clearance during departure. Contributing, were low ceilings, rain, and thunderstorms.NTSB NYC06FA156Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Philipsburg, PAThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into trees. Factors in the accident were the low cloud ceiling, and dark night conditions.NTSB LAX06CA191Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Alpine, CAa loss of engine power due to the aviation maintenance technician's failure to install the correct oil sump quick drain, which resulted in the inadvertent draining of engine oil during flight.NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.NTSB DFW05LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pollock, LAThe loss of engine power due to a loose engine lubrication system component in the crankcase. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL05CA114Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Daytona Beach, FLThe private pilots improper landing flare. Factors were flight instructors inadequate supervision, and landing crosswind.NTSB LAX05LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Happy Jack, AZThe fracture/separation of an engine intake valve during cruise flight, which resulted in a partial loss of engine power and a forced landing.NTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.NTSB DFW05FA099Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Jefferson, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…NTSB LAX05LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Phoenix, AZsubstantial damage to the airplane during an unknown phase of flight for undetermined reasons.NTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.NTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.NTSB LAX04CA215Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Galt, CAthe pilot under instruction's failure to maintain an adequate airspeed on final and misjudged flare, which resulted in stall/mush and hard landing. The certified flight instructor's inadequate supervision and failure to initiate timely remedial action were…NTSB ATL04CA091Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Delco, NCThe flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation. A factor was the flight instructor's failure to use the checklist.NTSB CHI04LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Peru, ILThe inadvertent landing gear retraction by the dual student during the landing roll.NTSB CHI04LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lone Rock, WIThe pilot's continued flight into icing conditions resulting in ice accretion on the wing and his failure to maintain airspeed resulting in a stall.NTSB CHI04LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mountain Grove, MOImproper use of the brakes during landing by the pilot, resulting in failure of the left main landing gear tire and a loss of directional control. Contributing factors were the failure of the main landing gear, as well as the grass and the ditch adjacent to…NTSB LAX04FA061Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chino Hills, CAthe pilot's inadequate in-flight planning/decision by which he conducted VFR flight into night instrument meteorological conditions. Mountainous terrain, dark night conditions and the pilot's failure to obtain a preflight weather briefing are contributing…NTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.NTSB ATL04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Columbia, SCThe pilot's mismanagement of the fuel supply, and his inadequate preflight planning which resulted in fuel exhaustion.NTSB LAX04LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Pacoima, CAthe pilot's failure to maintain an adequate glide path on final approach and his failure to ensure adequate clearance from obstacles. The dark night was a factor.NTSB LAX03FA298Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · North Las Vegas, NVthe failure of the Federal Aviation Administration Air Traffic Control Tower local controller and local assist controller to effectively monitor the runway operation and ensure proper separation was maintained between aircraft on intersecting runways.NTSB ATL03LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Collegedale, TNA loss of engine power due to oil exhaustion as a result of the installation of the incorrect quick-drain valve that opened during flight.NTSB SEA03LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Nampa, IDLanding gear collapse for undetermined reasons during the landing roll. On ground collision with a runway light was a factor.NTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.NTSB DEN03FA038Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · La Sal, UTthe loss of engine power (total) due to fuel starvation, the pilot not following procedures/directives (fuel management procedures), and the pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the pilot's inadequately…NTSB FTW03LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roanoke, TXThe failure of the main landing gear assembly and attach points for undetermined reasons.NTSB ATL03LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Laurel Bloomery, TNThe pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…NTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.NTSB MIA02LA175Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Irvington, ALThe loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…NTSB FTW02FA262Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chromo, COThe flight instructor's failure to maintain clearance with the mountainous terrain during the cross-country flight. A contributing factor was the dark night light conditions.NTSB LAX02FA255Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Echo Summit, CAThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB CHI02FA177Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Steward, ILA loss of engine power due to the fatigue failure of several number three cylinder through bolts and case studs, which resulted in the separation of the number three engine cylinder. A factor contributing to the accident was the rough terrain.NTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.NTSB LAX02LA129Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Redlands, CAThe pilot failed to compensate for the wind condtions when he encountered an updraft followed by a downdraft.NTSB NYC02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fredericksburg, VAThe private pilot's failure to verify the fuel tank selector position, which resulted in fuel starvation and a subsequent forced landing.NTSB NYC02LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cattaraugus, NYA separation of the cylinder from the engine for undetermined reason(s). A factor was the hidden ground obstruction (hole) which the airplane struck during the landing roll.