NTSB investigations: Piper PA-28-181
787 cases on aircraft the registry lists as Piper PA-28-181. 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 ('7102807', '7102832'))
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 ('7102807', '7102832'))
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 NYC96FA085Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Granville, OHthe pilot's intentional flight into known icing conditions and his overconfidence in his ability, which led to a partial loss of engine power as a result of induction system ice. Also causal was ATC's excessive vectoring of the airplane in icing conditions,…NTSB ATL96FA049Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Johns Island, SCthe pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.NTSB LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.NTSB FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.NTSB BFO96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Coshocton, OHloss of engine power for an undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB LAX96TA046Accident · No injuriesFinal reportPiper PA-28-181 · Edwards, CAthe pilot's failure to completely release the parking brakes prior to taxi, which produced a brake over temperature condition and brake fire.NTSB SEA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Syracuse, UTFuel exhaustion due to the pilot's failure to refuel.NTSB ANC95IA173Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Gustavus, AKfatigue failure of the propeller blade due to previous foreign object damage.NTSB CHI95LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lyons, WIThe pilot's lack of experience in the type of operation being conducted, the pilot not maintaining the proper airspeed while on final approach to landing, and a delayed decision to abort the landing.NTSB FTW95LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure by the pilot to properly plan his flight and check NOTAMS prior to departure. A factor was obstructions in the runway construction zone.NTSB FTW95LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was: a misreading or misunderstanding of the NOTAMS.NTSB ANC95IA151Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Juneau, AKfailure and separation of the propeller blade due to foreign object damage and fatigue.NTSB NYC95LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's failure to obtain the proper touchdown point which resulted in insufficient runway stopping distance and a subsequent overrun of the runway, and collision with trees.NTSB CHI95FA259Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fifield, WIthe pilot's attempted visual flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control. A factor was the fog.NTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.NTSB CHI95LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, MOThe pilot's failure to maintain control of the airplane while landing and his inadequate compensation for wind conditions. A factor in the accident was the gusty crosswind conditions.NTSB LAX95LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palm Springs, CAthe failure of the pilot to maintain clearance from a fence post while taxiing.NTSB NYC95FA127Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Jefferson Twp, OHThe pilot's failure to maintain control of the airplane which resulted in a collision with terrain during a descent.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB FTW95LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baytown, TXThe pilot failed to maintain the proper glidepath during landing.NTSB BFO95LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Oneonta, NYThe pilot's failure to maintain aircraft control during the attempted landing. The gusty crosswind condition was a related factor in this accident.NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB CHI95LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ann Arbor, MIthe failure of the mechanic to close the drain valve after changing oil, resulting in complete loss of engine oil. A factor was the soft terrain, which resulted in the nose wheel digging in and the airplane nosing over.NTSB SEA95LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Boise, IDFuel exhaustion due to the pilot's failure to refuel.NTSB CHI95LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INthe pilot's failure to perform a go-around. The gusty crosswind was a factor in the accident.NTSB CHI95LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Brookfield, WIThe instructor's failure to maintain clearance with trees. Factors associated with the accident were the trees and the night lighting conditions.NTSB BFO95FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Miamisburg, OHThe pilot's failure to switch fuel tanks which led to fuel starvation and subsequent loss of engine power.NTSB MIA95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLIn flight planning decision delay by the pilot-in-command in that he failed to divert to an alternate airport before loss of engine power due to fuel exhaustion.NTSB NYC95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gr. Barrington, MAThe pilot landed with excessive airspeed which resulted in a long landing, runway overrun, and collision with trees.NTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.NTSB CHI95LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILthe pilot's failure to maintain airspeed during the landing which resulted in a stall. A factor related to the accident was the loss of engine power for undetermined reasons.NTSB LAX95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rialto, CAthe flight instructor's loss of airplane control during the landing flare as a result of his inadequate supervision of the flight and delayed corrective action over his presolo student's control inputs.NTSB NYC94LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Buffalo, NYThe pilot's improper recovery from a bounced landing. A factor is the pilot's improper landing flare.NTSB CHI94LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Madison, WIThe pilot-in-command not maintaining a proper glidepath during his final approach to landing. A factor associated with the accident was the lack of recent experience in the type operation performed by the pilot.NTSB BFO94LA148Accident · No injuriesLimited investigationFinal reportPiper PA -28-181 · Skowhegan, METhe pilot's failure to do a go around which resulted in an inflight collision with trees during a delayed aborted landing to avoid a runway overrun.NTSB ANC94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northway, AKThe pilot's inadequate evaluation of the weather and his failure to maintain visual lookout during the maneuver. Factors were the low ceilings and obscuration.NTSB BFO94LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Waynesboro, VAThe pilot's misjudgement of speed and distance which resulted in a landing overrun. A contributing factor is the pilot's delay in intiating a go-around.NTSB CHI94LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Lone Rock, WIthe pilot's failure to attain a proper touchdown point on the runway.NTSB CHI94FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wellington, KSthe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall-spin. Factors were fuel exhaustion resulting from improper fuel calculations by the pilot.NTSB NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.NTSB LAX94FA272Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · So. Lake Tahoe, CAthe pilot's failure to maintain adequate airspeed during initial climb under high-density altitude weather conditions and a resultant inadvertent stall/spin. Factors which contributed to the accident were the pilot's overconfidence in his personal ability,…NTSB CHI94LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Weeping Water, NEthe pilot-in-command's misjudging compensation for wind conditions. Factors were tailwind, and wind information confusing.NTSB CHI94LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Chapman, NEThe pilot-in-command's attempted VFR flight into instrument weather conditions which resulted in spatial disorientation. Factors associated with the accident were the pilot-in-command's over confidence in his personal ability.NTSB NYC94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Danbury, CTThe student pilot's inadequate compensattion for wind conditions. The crosswind was a factor.NTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…NTSB ATL94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Winston-Salem, NCThe pilot's failure to place the aircraft fuel selector to the tank with fuel remaining.NTSB CHI94FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Waseca, MNContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the ground. Factors related to the accident were: an inaccurate weather forecast by…NTSB ATL94LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCThe pilot's inadequate in-flight planning in determining fuel requirements for the flight.NTSB ATL94LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · N. Myrtle Beach, SCThe pilot's improper inflight decision in that he failed to refuel the aircraft prior to exhausting the fuel supply. A factor was the soft terrain at the forced landing site.NTSB LAX94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain a proper glidepath.