NTSB investigations: Piper PA-28-140
88 cases on aircraft the registry lists as Piper PA-28-140, where the first occurrence was “Loss of control - on ground/water”. 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 per year
| 1982 | 10 |
|---|---|
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 6 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
Where
Open the mapLatest cases
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 ('7102802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('7102802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.NTSB MIA07CA096Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fairmont, WVThe pilot's failure to maintain directional control during landing.NTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB NYC06CA149Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Louisville, KYThe pilot's failure to maintain directional control during landing. A factor in the accident was the wet grassy runway.NTSB ATL06CA081Accident · No injuriesData collectionFinal reportPiper PA28-140 · Murfreesboro, TNThe student pilot's failure to maintain directional control during landing roll.NTSB ATL05CA112Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dunnellon, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB ATL05CA069Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Griffin, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a ditch.NTSB CHI04CA170Accident · No injuriesData collectionFinal reportPiper PA28-140 · Rush City, MNThe pilot's inadequate compensation for wind conditions which led to his loss of aircraft control. Factors were the wind gusts, the ditch, and the fence.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.NTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.NTSB NYC02LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, PAThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.NTSB IAD01LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJpilot's failure to maintain directional control during the landing roll-out. A factor was the crosswind.NTSB CHI00LA299Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Morris, ILThe improper servicing of the left main landing gear tire which resulted in it having low air pressure and the pilot's inability to maintain directional control on landing. A factor associated with the accident was the ditch.NTSB CHI00LA308Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hallock, MNthe pilot not maintaining directional control of the airplane. Factors were the gusts, the crosswind weather conditions, and the ditch terrain condition.NTSB LAX00LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Long Beach, CAThe student pilot's failure to maintain directional control during takeoff and his subsequent failure to relinquish control of the airplane.NTSB MIA99LA256Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, GAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during.NTSB MIA99LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rock Hill, SCThe pilot's failure to maintain directional control. Related factors were the crosswind and the pilot's lack of experience.NTSB CHI99LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · East St. Louis, ILThe student pilot's failure to maintain directional control.NTSB LAX98LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, NVThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB MIA98LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, NCThe failure of the pilot to maintain directional control of the airport resulting in the collapse of the nose and left main landing gears.NTSB IAD98LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Downsville, NYThe pilot's failure to maintain directional control of the airplane.NTSB FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.NTSB IAD98LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmingdale, NYThe student pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A factor was the cross wind condition.NTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.NTSB CHI97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dickinson, NDthe student pilots failure to maintain directional control of the airplane. A factor associated with the accident was the pilot's runway selection.NTSB CHI97LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hart, MIthe pilot's failure to maintain directional control on rollout.NTSB LAX96LA332Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, CAfailure of the student pilot to maintain direction control of the airplane, which resulted in an inadvertent ground swerve and subsequent collapse of the nose gear, during an encountered with soft terrain.NTSB MIA96LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Williamson, GAThe failure of the pilot to maintain directional control during takeoff.NTSB LAX96LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Palm Springs, CAthe pilot's inadequate compensation for the crosswind condition and subsequent failure to maintain directional control. The crosswind was a factor.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB ATL95LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bolivar, TNThe student pilot's failure to maintain directional control and his improper use of the throttle.NTSB CHI95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boyceville, WIThe pilot's inadequate compensation for the wind conditions and subsequent failure to maintain runway alignment. The crosswind was a factor.NTSB BFO95LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean City, NJthe private pilot's inadequate compensation for the wind conditions during the landing/aborted landing sequence. Related factors are the unfavorable wind conditions and high obstructions.NTSB LAX95LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Corona, CAthe pilot's failure to maintain directional control due to his improper use of the rudder and brakes.NTSB CHI94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hutchinson, MNthe pilot's failure to maintain directional control. Factors associated with the accident were the crosswind, the pilot's lack of total experience, the concrete block and the dirt back.NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.NTSB BFO93LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belmar, NJThe pilot's inadequate compensation for wind and failure to maintain directional control during landing. Other related factors were the crosswind and the ravine.NTSB LAX93LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Reedley, CAA failure of the pilot to maintain proper runway alignment and improper remedial action during the balked landing. A factor in the accident was a lack of total aeronautical experience.NTSB ATL92LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocracoke, NCThe student pilot's failure to maintain directional control during the landing roll. Factors were the pilot's lack of recent total experience, and the crosswind conditions, and the dirt bank adjacent to the runway.NTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.NTSB CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.NTSB NYC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYThe failure of the pilot to attain the proper airspeed during an aborted landing, which resulted in a stall and loss of airplane control. Factors related to the accident were: the loss of directional control during landing, and the lack of recent flight…NTSB CHI91LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hibbing, MNThe student pilot's improper flare of the airplane and the cfi's failure to maintain directional control during the recovery. A factor was the soft terrain.NTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.NTSB BFO90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · S. Charleston, WVPilot's failure to maintain directional control of the airplane. A related factor crosswind conditions.NTSB CHI90LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harbor Springs, MIThe student pilot's failure to maintian adequate directional control of the aircraft. The unfavorable wind was a related factor.NTSB CHI90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INFailure of the student pilot to maintain directional control during the landing roll. The student's lack of aviation experience was a related factor.NTSB CHI90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Toledo, OHFailure of the pilot to maintain directional control, which resulted in a ground swerve. Factors related to the accident were: the crosswind and the pilot's improper compensation for wind condition.