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 CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.NTSB MIA93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Tarpon Springs, FLThe pilot's failure to maintain the minumum descent altitude (mda) while on a non-precision instrument approach. Factors which contributed to the accident were: the flight service station (fss) specialist's failure to provide the published notice to airmen…NTSB SEA93FA025Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTClearance from mountainous terrain was not maintained. Factors to the accident were: dark night condition, snow showers, and intentional flight into known adverse weather.NTSB NYC93LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Akron, NYThe failure of the pilot to compensate for adverse winds and wind shear. A factor related to the accident was the adverse wind conditions.NTSB FTW92LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Fort Worth, TXThe pilot's failure to maintain proper clearance with the hole. Factors were the lack of markings and the poor maintenance of the taxiway and runway.NTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.NTSB LAX92LA398Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's intentional flight at an altitude which provided insufficient clearance from the water.NTSB ATL92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oviedo, FLThe failure of the dual student to properly flare the aircraft during the landing attempt, and the flight instructor's failure to perform remedial action to prevent the hard landing.NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.NTSB DEN92LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200R · Nederland, COA partial loss of power for undetermined reasons. A factor was: no suitable terrain for a forced landing.NTSB SEA92LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · W. Yellowstone, MTA stall/mush encountered due to poor pre-flight planning/preparation. Factors to the accident were: high density altitude and gross weight exceeded.NTSB LAX92FA172Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Placerville, CAThe pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…NTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…NTSB BFO92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Manville, NJThe pilot's failure to maintain obstacle clearance.NTSB ATL92FA047Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.NTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.NTSB LAX92LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Altadena, CAThe pilot's improper use of the fuel selector by selecting an empty tank. Contributing to the accident was the pilot's decision to operate the airplane with a known deficiency without having maintenance performed to determine the cause of a previous loss of…NTSB NYC92LA040Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Piqua, OHThe pilot allowed the airplane to get too low on short final and struck the terrain short of the runway. Factors in the accident were the proper glide path was not maintained, resulting in the intended touchdown point not being attained.NTSB CHI92LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-200 · Lakeville, MNThe failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.NTSB SEA91LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lewiston, IDThe pilot's failure to maintain directional control.NTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.NTSB LAX91LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Redwood City, CAThe fatigue failure of the number two connecting rod and rod cap due to an engine overspeed condition which the rods and rod caps were exposed at some undetermined historical point.NTSB LAX91LA314Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · So. Lake Tahoe, CAEngine failue due to the failure of the crankshaft resulting from failure induced by a non-metallic inclusion in the shaft.NTSB CHI91LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pulaski, WIThe pilot's failure to select a proper touchdown point. A factor in the accident was inadequate runway maintenance by airport personnel.NTSB ATL91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bessemer, ALRupture of a high-time, rubber, oil cooler hose, which resulted in a loss of engine oil, oil exhaustion, and seizure of the engine.NTSB MIA91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sanford, FLExcessive flare by the dual student during the forced landing following a simulated engine failure shortly after takeoff. Also, failure of the student to maintain vs, and failure of the CFI to take remedial action.NTSB ATL91FA069Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Ashland, ALContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficience altitude/clearance above the wooded terrain. Factors related to the accident were: the adverse weather conditions, high terrain, and the…NTSB LAX91FA116Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Monterey Park, CASuicide.NTSB FTW91LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Wichita Falls, TXThe pilot's inadequate compensation for crosswind conditions encountered on final and his failure to maintain directional control during the attempted go around. A factor in the accident was the unfavorable gusting crosswind conditions.NTSB CHI91FA091Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Dutchtown, MOThe pilot's failure to maintain control of the airplane in instrument meteorological conditions and the pilot exceeding the design stress limits of the airplane during the loss of control. Contributing factors were the existing weather conditions.NTSB NYC91LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Sherburne, VTThe pilots intentional flight into icing conditions with an airplane not equipped for flight in known icing conditions. This resulted in an uncontrolled descent and contact with trees in instrument meteorological conditions. Factors related to the accident…NTSB ATL91LA029Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Senoia, GAImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion. Factors to the accident were the dark night operation and the collision with utility lines.NTSB MIA91WA039Accident · No injuriesForeign investigationPiper PA-28R200 · St. Mary, JamaicaNTSB FTW91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fort Worth, TXThe pilot's misjudgment of airplane attitude, airspeed and distance while on final approach. A factor was the instructor pilot's inadequate supervision.NTSB FTW91FA010Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Kingsland, TXThe pilot's failure to avoid flying into the mountain.NTSB FTW90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denver City, TXThe pilot's improper leaning of the fuel mixture.NTSB CHI90LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roseville, ILMisjudged flare for landing, an improper recovery from a bounced landing, and his failure to maintain directional control.NTSB BFO90FA064Accident · Serious injuriesField investigationFinal reportPiper PA-28-200 · Baltimore, MDThe pilot failed to maintain adequate airspeed which resulted in a stall. Contributing was the loss of power for undetermined reasons.NTSB CHI90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Monee, ILEngine failure due to oil starvation resulting from improper maintenance and directive compliance associated with the failed part.NTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.NTSB SEA90FA074Accident · 2 fatalField investigationFinal reportPiper PA28R-200 · Prairie City, ORUncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.NTSB BFO90LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Petersburg, VAFuel starvation and improper use of emergency procedures (fuel selector) by the pilot.NTSB NYC90LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Simsbury, CTThe pilot's misjudgement of airspeed and distance during landing resulting in an overshoot and swerve off the runway. The dusk light conditions, snow, and frozen terrain were contributing factors to the accident.NTSB NYC90FA030Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · New Castle, NYThe pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.NTSB LAX90FA031Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Camarillo, CAImproper IFR procedure by the pilot, and his failure to maintain the minimum descent altitude (mda) for that segment of the VOR approach. Factors related to the accident were: darkness, low ceiling, fog, haze, the pilot's lack of recent instrument experience,…NTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…NTSB LAX89LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Van Nuys, CAA loss of engine power for undetermined reasons.NTSB MIA89LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hilliard, FLThe inadequate pre-flight examination by the pilot, after refueling, which failed to detect water in the fuel.NTSB NYC89LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Middletown, RIThe failure of both magnetos shortly after takeoff. .