NTSB investigations: Piper PA-28-161
728 cases on aircraft the registry lists as Piper PA-28-161. 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 ('7102803', '7102834'))
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 ('7102803', '7102834'))
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 CHI91LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDInadequate visual outlook by the pilot in command.NTSB CHI91LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe mechanic's not understanding the identifying marks on the replacement part. A factor in the accident was that the mechanic was provided with an improper part.NTSB MIA91LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe loss of control on the ground by the student pilot due to a lack of total experience and apprehension on his first solo flight.NTSB NYC91LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PADue to failure of the induction air control/air filter/screen, which blocked airflow through the carburetor throat.NTSB MIA91LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Valkaria, FLThe failure of the instructor pilot to supervise the student pilot's actions, resulting in a stall at a low altitude where recovery was not possible.NTSB LAX91FA065Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glendale, CAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his improper inflight decision to turn to the left, which resulted in flight toward higher terrain. The terrain and weather conditions were related factors.NTSB CHI91FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Gardner, KSA loss of engine power for undetermined reasons. Darkness was a related factor.NTSB NYC91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Easton, PAThe flight instructor allowed the airplane to get too low on final approach during the demonstration of a power off landing.NTSB NYC91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe failure of the pilot to abort the takeoff in sufficient time to prevent an overrun. Factors related to the accident were a partial power loss due to a faulty ignition system.NTSB MIA91FA035Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bunnell, FLFailure of the pilot to maintain altitude, while maneuvering at night over an unlighted area, which resulted in a collision with trees. Factors related to the accident were: darkness and possible spatial disorientation of the pilot due to lack of visual ques.NTSB NYC91LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, MAThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain in which the emergency landing was made.NTSB LAX91LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Livermore, CAInadvertent flight by the pilot into instrument meteorological conditions (IMC), and her failure to maintain adequate altitude and/or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB NYC91LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Saxton, PAAn engine failure due to fuel starvation and the subsequent forced landing in unsuitable terrain. Factors related to the accident were the cfi's inadequate execution of emergency procedures.NTSB MIA91FA011Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Everglades City, FLThe pilot's failure to maintain altitude and his spatial disorientation during a night takeoff over water.NTSB CHI90LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greenwood, INThe pilot misjudged the landing flare and the airplane stalled and landed hard.NTSB FTW90FA141Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Garfield, COThe pilot's decision to fly into the mountain pass and the subsequent inability to maintain adequate ground clearance.NTSB CHI90LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pulaski, WIThe pilot's failure to maintain positive control of the airplane while landing. Factors related to the accident were the pilot's lack of total flight experience, and inadequate compensation for crosswind conditions.NTSB NYC90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA power loss due to fuel starvation. Factors related to the accident were: improper emergency procedures by the pilot and an improperly reading fuel gauge.NTSB NYC90FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, MEFailure of the pilot to maintain the proper altitude, while searching for the destination airport at night. Factors related to the accident were: darkness, fog obscuring the destination airport lights, mountainous terrain, and the lack of visual perception at…NTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB SEA90FA098Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Susanville, CAAn improper inflight decision on the part of the pilot when he misjudged the aircraft's climb in close proximity to rising terrain.NTSB NYC90LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fraconia, PAThe pilot failed to maintain sufficient airspeed to flare for landing. Factors related to the accident were: a power loss due to oil exhaustion, the failure of the pilot to conduct an adequate pre-flight and departing with the oil dip stick loose.NTSB LAX90LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot inadvertently stalling the aircraft and an inadequate altitude to perform a stall recovery. Factors in this accident were: lack of total experience and student's anxiety.NTSB LAX90FA113Accident · 4 fatalField investigationFinal reportPiper PA28-161 · Malibu, CAThe pilot's decision to turn into an area of known high terrain after inadvertently encountering instrument meteorological conditions.NTSB DEN90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nephi, UTFailure of the pilot to maintain direction control and correct the resultant ground swerve. The snow bank was a related factor.NTSB CHI90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pontiac, MIOverload failure of the left main landing gear attach bolts for an undetermined reason.NTSB MIA90FA071Accident · No injuriesField investigationFinal reportPiper PA-28-161 · Roseland, FLThe engine failure due to fuel starvation caused by a needle valve in the carburetor which allows fuel to enter the carburetor bowl, stuck in the closed position for undetermined reasons resulting in the forced landing.NTSB ATL90FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Norris, TNThe student pilot's misjudged descent which resulted in a collision with trees and the ground. A factor was that the pilot was buzzing when the accident occurred.NTSB MIA90FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Sebastian, FLFailure of the AA-1A pilot to see-and-avoid the Piper PA-28 which had entered traffic first. A factor related to the accident was: failure of the PA-28 pilot to see the American AA-1A, when the AA-1A was on a base leg and the PA-28 was further out on final…NTSB DEN90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COThe pilot's encounter with severe turbulence during landing, and his failure to divert to an alternate airport after becoming aware of the wind conditions. Contributing to the accident was the pilot's low level of experience.NTSB FTW90LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Austin, TXFailure of the rocker arm in the engine driven fuel pump.NTSB LAX90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Coalinga, CAThe pilot's misjudgement of distance and altitude to the runway, while on final approach, which resulted in his failure to attain the proper touchdown point for landing. Factors related to the accident were: darkness, haze, and soft terrain in the area where…NTSB LAX90FA070Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Burbank, CAPoor judgement of the instructor pilot (CFI) due to his impairment from use of marijuana, inadequate supervision of the flight by the CFI, and his failure to assure that adequate airspeed was maintained, which resulted in an inadvertent stall. Factors related…NTSB MIA90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Immokalee, FLThe loss of engine power due to an undetermined reason. A factor related to the accident was: rough terrain in the emergency landing area.NTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.NTSB LAX90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hayward, CAInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Collision with a vehicle in the emergency landing area contributed to the damage and injuries.NTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.NTSB MKC90FA017Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Elkader, IAThe pilot's failure to maintain clearance from the runway marker at the departure end of the runway.NTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.NTSB MIA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Titusville, FLFailure of the pilot to go around after landing long with excessive airspeed.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MIA89IA249Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · Fort Pierce, FLThe student's failure to maintain directional control of the airplane. Contributing to the accident was the student's lack of experience.NTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.NTSB BFO89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC), and his failure to maintain proper alignment, while landing at night on a road. The weather conditions, dark night, and…NTSB NYC89LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe pilot overshooting a landing during a precautionary landing due to deteriorating weather conditions. Contributing factor(s) was: the pilot's decision to attempt the flight after being advised that VFR flight was not recommended and inadequate preflight by…NTSB LAX89LA254Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Oceanside, CAThe failure of the pilot-in-command to attain proper airspeed during the go-around. The lack of airspeed did not permit the airplane to climb and the pilot intentionally stalled the airplane into the trees. Contributing to the accident was the pilot delaying…NTSB NYC89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Stonington, CTThe pilot's inadvertent flight into instrument meteorological conditions (IMC) and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the environmental conditions (dark night & fog) and the pilot's lack of…NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.NTSB NYC89LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beverly, MACollision with trees during an aborted landing and attempted go-around with insufficient remaining runway.NTSB CHI89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Houghton, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion from lack of fuel. Factors related to the accident were: obstructions (road sign & guard rail) in the emergency landing area.