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 OPS08IA006Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · St. Augustine, FLThe pilot's failure to adhere to the controller's takeoff instruction. Contributing to the incident was the controller's failure to properly monitor the flight, and the controller's decision to perform lesser duty priorities during the takeoff roll.NTSB MIA08LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Miami, FLA loss of engine power due to inadequate maintenance inspection resulting in a worn throttle housing going undetected and failing.NTSB MIA08CA022Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Orlando, FLThe student pilot's failure to maintain directional control during landing.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB NYC07CA216Accident · No injuriesData collectionFinal reportPiper PA28-161 · William-Sodus, NYThe pilot's improper flare at touchdown, which resulted in a hard landing.NTSB NYC07CA181Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight planning.NTSB ATL07LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Gardner, MAThe pilot's failure to maintain control of the airplane during an aborted landing.NTSB MIA07WA110Accident · No injuriesForeign investigationPiper PA-28-161 · Atlantic OceanNTSB SEA07LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Redlands, CAThe restriction of the carburetor float as a result of a misadjusted retractor clip. A contributing factor was the fire.NTSB LAX07LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAa loss of engine power for undetermined reasons.NTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.NTSB MIA07LA026Accident · No injuriesLimited investigationFinal reportLingwall Rebich-Pitts · Naples, FLThe experimental airplane's pilot inadequate visual lookout while taxiing for takeoff, which resulted in an on-ground collision with a Piper airplane which was standing with its engine operating in the runup area.NTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.NTSB DFW06LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Houston, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe loss of available engine power due to vapor lock. A contributing factor was the high temperature.NTSB ATL06CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Griffin, GAThe pilot's failure to maintain direction control of the airplane during the landing roll.NTSB DFW06CA179Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Georgetown, TXThe flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…NTSB CHI06CA180Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Jefferson City, MOThe dual student's excessive landing flare and his failure to maintain adequate airspeed, which resulted in the airplane stalling. A factor to the accident was the flight instructor's delayed remedial action and the runway edge light that the airplane struck.NTSB DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.NTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.NTSB CHI06CA134Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grayslake, ILThe student pilot's failure to maintain clearance from the parked vehicle during taxi and the flight instructor's inadequate operational oversight. A factor to the accident was the parked vehicle.NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.NTSB CHI06LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe loss of engine power for an undetermined reason during takeoff-initial climb.NTSB NYC06LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Smoketown, PAThe pilot's improper pre-flight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB NYC06CA057Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Haven, CTThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of aircraft control during landing and subsequent impact with a ditch.NTSB CHI06CA065Accident · No injuriesData collectionFinal reportPiper PA-28-161 · West Branch, MIAn encounter with a deer during landing.NTSB NYC06LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Yonkers, NYA loss of engine power for undetermined reasons, which resulted in a ditching.NTSB LAX06CA045Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Panamint Spring, CAthe pilot's improper in-flight selection of unsuitable terrain for landing.NTSB NYC06FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Leesburg, VAThe flight instructor's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with trees and terrain.NTSB LAX06CA026Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Payson, AZa loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…NTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.NTSB MIA06CA011Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with runway signs.NTSB IAD05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Babylon, NYA broken piston and exhaust valve tappet which resulted in a total loss of engine power, and a forced landing to unsuitable terrain. A contributing factor was the failure of the operator to overhaul the engine at the manufacturer's recommended interval.NTSB CHI05LA226Accident · 2 fatalLimited investigationFinal reportPiper PA-28-161 · Culver, INThe loss of engine power while maneuvering due to partial failure of the left magneto, and the flight instructor's failure to maintain sufficient airspeed to avoid a stall. An additional cause was improper maintenance by company maintenance personnel,…NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB CHI05CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · South Bend, INThe student pilot failed to compensate for the crosswind condition and failed to maintain directional control. Factors included the crosswind and the windsock.NTSB MIA05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe pilot's poorly planned approach during a precautionary landing following partial loss of engine power resulting in a go-around and subsequent in-flight collision with trees. A contributing factor in the accident was the inadequate maintenance by the…NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.NTSB LAX05CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Roosevelt, AZthe pilot's failure to maintain directional control.NTSB LAX05CA067Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB DFW05LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Decatur, TXThe student pilot's failure to maintain obstacle clearance and the instructor's inadequate supervision. Contributing factors were the prevailing dark night conditions, and the power line.NTSB LAX05CA047Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kapolei, HIthe pilot's failure to maintain directional control, which resulted in a collision with an obstacle.NTSB MIA05CA041Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Holly Springs, MSThe failure of the pilot to maintain directional control of the airplane while performing a go-around after a bounced landing, resulting in the on ground collision with trees.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB NYC05FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Madison, CTA loss of engine power due to separation of the propeller due to under-torqued retention bolts.NTSB IAD04FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Toughkenamon, PAThe pilot's decision to add power, in an attempt to abort the landing after the airplane had veered off the runway. A factor was the pilot's failure to maintain directional control after the landing.NTSB LAX04LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CAthe pilot's failure to attain an adequate altitude to clear mountainous terrain during a high density altitude condition.NTSB ATL04CA149Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Tallassee, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. A factor was pilot fatigue and the unauthorized use of the airplane .NTSB CHI04LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Waubun, MNThe pilot's failure to get the proper rest prior to the night cross country flight and the pilot's failure to maintain altitude. Contributing factors to the accident were fatigue as a result of inadequate sleep, conditions conducive to fatigue, and night.NTSB ATL04LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St. Marys, GAThe pilot failure to use carburetor heat when weather condition were favorable for the for the formation of carburetor ice. .