NTSB investigations: Piper PA-28-180
2,065 cases on aircraft the registry lists as Piper PA-28-180. 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 ('7102808'))
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 ('7102808'))
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 IAD02LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, MAThe pilot's delayed aborted landing and his failure to attain obstacle clearance. The pilot's misjudgment of distance is a contributing factor.NTSB LAX02LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · La Verne, CAThe pilot's failure to maintain directional control following his misjudged landing flare and hard touchdown.NTSB NYC02FA025Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mansfield, OHthe pilot's improper use of carburetor heat, and subsequent forced landing. Factors were the carburetor icing condition, night conditions, trees, and the pilot's impairment from ingestion of an over-the-counter antihistamine.NTSB CHI02LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Wayne, INThe pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.NTSB LAX01FA274Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Boulder City, NVthe pilot's failure to maintain an adequate terrain and obstruction clearance altitude while maneuvering in a non-standard visual approach to land. The pilot's misjudgment of his altitude and distance from the airport was due to impairment by alcohol. Factors…NTSB CHI01LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Union, ILThe total failure of the crankshaft as a result of fatigue and the unsuitable terrain encountered during the forced landing. Factors associated with the accident were the soft terrain on which the forced landing was made and the subsequent gear collapse.NTSB NYC01LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · New Milford, CTSeparation of the number two connecting rod for reasons undetermined.NTSB NYC01LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · West Milford, NJThe student pilot's failure to maintain directional control while landing. Factor’s in this accident were a wind gust and the rocks located off the left side of the runway.NTSB SEA01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oak Harbor, WAThe pilot's inadequate remedial action while on final approach. The encounter with wake turbulence was a factor.NTSB FTW01LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bridgeport, TXthe non-certificated pilot's improper flare which resulted in a hard landing.NTSB CHI01FA204Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Lafayette, INThe fuel exhaustion due to the pilot's alcohol impaired decision making. Additional factors were the trees and night.NTSB LAX01FA199Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe student pilot's selection of a takeoff runway conducive to a tailwind weather condition and his failure to maintain airspeed and his inadvertent stall during takeoff initial climb. Factors in the accident were the partial loss engine power resulting from…NTSB LAX01LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Cameron Park, CAthe pilot's failure to maintain an adequate clearance altitude from en route obstructions.NTSB CHI01FA100Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Erhard, MNThe pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…NTSB FTW01FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Stillwater, OKthe pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…NTSB DEN00FA169Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Englewood, COthe pilot's failure to maintain aircraft control, which resulted in a collision with terrain. A contributing factor was the high-density altitude weather condition.NTSB LAX00LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Payson, AZThe pilot's failure to maintain directional control during the takeoff roll due to over-rotation, inadequate airspeed, and improper remedial action under the high density altitude condition.NTSB IAD00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Headwaters, VAPilot's failure to maintain aircraft control during take-off, which resulted in a stall.NTSB CHI00LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Plattsmouth, NEthe pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.NTSB LAX00LA298Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Grass Valley, CAThe pilot's failure to attain proper alignment with the runway during approach for landing. Contributing factors were the pilot's inadequate and improper preflight planning and in-flight decision.NTSB NYC00LA215Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Taberg, NYThe pilot's improper decision to attempt a second takeoff from the short grass runway at maximum gross weight, which resulted in the inadvertent stall/mush. Factors in this accident were the airplane's high gross weight and the short grass surface runway.NTSB NYC00LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norwood, MAthe pilot's improper bounced landing recovery. A factor was the pilot's lack of total flight experience.NTSB LAX00LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Maria, CAThe pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.NTSB LAX00LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZThe student pilot's failure to maintain directional control of the airplane during landing.NTSB MIA00LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ocracoke, NCThe pilot's failure to compensate with rudder control for engine torque and 'p' factor during a go-around resulting in the aircraft drifting to the left, colliding with brush, and spinning around coming to rest in the brush.NTSB LAX00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Selma, CAThe pilot's inadequate preflight planning that resulted in fuel exhaustion and subsequent collision with grapevines during an off airport forced landing.NTSB DEN00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Loveland, COThe failure of the pilot to maintain directional control during takeoff roll. A factor was lack of recent experience.NTSB FTW00LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.NTSB FTW00FA079Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Frisco, TXThe pilot's failure to maintain clearance with trees during an intentional low altitude flight maneuver.NTSB LAX00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Barbara, CAThe dual student's loss of directional control and the flight instructor's inadequate supervision of the flight.NTSB CHI00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNthe pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.NTSB SEA99LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Vaughn, WAThe separation of a propeller blade tip due to fatigue, and the improper maintenance procedure.NTSB CHI99FA346Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Scott, KSthe failure of the pilot to maintain control of the aircraft. Factors were the pilot's lack of total experience, his lack of familiarity with the airplane, and the stall/spin encountered.NTSB SEA99LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Eatonville, WAInadequate inflight planning/preparation and terrain clearance not maintained. Mountainous terrain, cloudy conditions and delayed remedial action are factorsNTSB DEN99LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Peyton, COThe pilot's loss of control resulting in inadvertent stall/mush during initial climb following takeoff. Factors were the unfavorable, sudden windshift conditions, the high density altitude, and the manufacturer's failure to provide adequate density altitude…NTSB FTW99LA230Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Weatherford, TXThe loss of engine power during the initial takeoff climb for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Harsens Island, MIthe loss of engine power for undetermined reasons. Factors were the berm and the pond.NTSB CHI99FA276Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Lake Geneva, WIthe aborted takeoff not performed by the safety-pilot and airspeed not obtained/maintained by the safety-pilot. Factors to the accident were directional control and runway alignment not maintained by the pilot-in-command, the inadequate supervision of the…NTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..NTSB LAX99LA259Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hayward, CAthe pilot's failure to apply carburetor heat to prevent the formation of carburetor ice while operating in IFR conditions which resulted in the loss of engine power.NTSB CHI99LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Butler, MOloss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.NTSB ATL99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chuckey, TNThe loss of engine power for undetermined reasons.NTSB DEN99LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burlington, WYThe pilots' inadequate preflight planning for take off in that he failed to consider the takeoff surface not being a paved surface. A factor was loose material on the roadway used for take off.NTSB CHI99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEThe pilot's inadequate compensation for gusty wind conditions. Factors associated with the accident were the gusty, high, wind conditions, and the pilot's continued flight into adverse weather.NTSB LAX99LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Truckee, CAThe pilot's failure to obtain and maintain the proper climb airspeed during the initial takeoff climb, including his failure to anticipate the gust factor and density altitude effects in determining a safe airspeed.NTSB NYC99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Myerstown, PAThe student pilot's improper flare which resulted in a hard landing.NTSB DEN99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Colorado Sprngs, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A factor was the sign.NTSB MIA99LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Knoxville, TNThe engines excessive fuel consumption for undetermined reasons and the pilot's failure to plan the flight with adequate fuel reserves resulting in engine failure due to fuel exhaustion.NTSB LAX99LA068Accident · 2 fatalLimited investigationFinal reportPiper PA-28 · Thermal, CAThe occurrence of an in-flight incapacitating heart rhythm to the pilot. A factor was the pilot's ingestion of over-the-counter medications that made him more susceptible to an abnormal heart rhythm.