NTSB investigations: Piper PA-28-151
16 cases on aircraft the registry lists as Piper PA-28-151, where the first occurrence was “Loss of control - in flight”. 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 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 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 ('7102805', '7104223')
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\" = 250))
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 ('7102805', '7104223')
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" = 250))
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 SEA07LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Cibecue, AZThe pilot's failure to maintain proper control of the airplane during an off airport landing. Contributing factors were the pilot's psychological condition, impairment due to overdose of prescription medication, inadequate in-flight planning and mountainous…NTSB NYC07FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Howell, NJThe pilot's improper decision to attempt a flight with known serious medical conditions, which resulted in impairment during cruise flight, likely due to a stroke or transient ischemic attack. A factor was the pilot providing false information on his medical…NTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.NTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.NTSB CHI99LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vincennes, INthe pilot's failure to maintain directional control of the airplane during the soft field takeoff. Factors associated with the accident were inadequate airspeed and the cable fence which was contacted.NTSB ATL96LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, TNthe student pilot's improper recovery from a bounced landing and his failure to maintain directional control. A factor was the improper level-off.NTSB NYC95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Wilmington, OHThe flight instructor's inadequate supervision of the student pilot during the approach, resulting in a loss of control and hard landing. The gusty wind condition was a factor.NTSB MIA94FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Daytona Beach, FLLoss of aircraft control for an undetermined reason.NTSB LAX89LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Modesto, CADuring an ILS approach in night instrument meteorological conditions, the pilot allowed the airspeed to diminish resulting in the airplane stalling. Before the pilot could regain control, the airplane collided with the terrain short of the runway. There were…NTSB LAX88LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Valley Center, CAWitnesses observed the acft rotate to a high pitch attitude during the initial climb after takeoff. They said the acft then entered a left turn & descended to the ground. Impact occurred on rising terrain, beyond a gully, about 200 ft east of the departure…NTSB MIA86LA236Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jacksonville, FLThe plt stated that just after takeoff, the eng sputtered and lost power. He landed the acft in the grass on the right side of runway 31, rolled aprx 100 yards, struck a sign, and veered left into soft dirt collapsing the nose gear. Post crash examination and…NTSB SEA84LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Shady Cove, ORThe pilot stated after the accident that he stalled the aircraft at an altitude of 50 ft AGL during takeoff and the acftdescended in a nose low attitude into trees and the ground.NTSB LAX83FA387Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Trinity Center, CAThe acft departed creswell, OR, sometime after 1800 PST on 3/19/83. At 2110 PST, the plt contacted portland flt watch by radio & stated that he was over roseburg, or at 9500 ft. he requested pireps of wx over the siskiyou mountains & into the san francisco…NTSB LAX83LA107Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Grand Canyon, AZThe acft was blown off the right side of the runway during the flare for landing and the gear collapsed after landing. The pilot received a weather briefing and wind warning. He stated that the acft floated about 2000 feet down the runway after he flared…NTSB ATL82DA185Accident · No injuriesFinal reportPiper PA-28-151 · Duncan, MSPilot attempted takeoff from strip with 4 inch deep grass and a 75 degree crosswind. Occupants weighed total of 490 lbs. Temperature was 94 degrees. Aircraft mushed back into ground and pushed gear struts through wing.NTSB CHI82DA219Accident · Minor injuriesFinal reportPiper PA-28-151 · Pardeeville, WIThe pilot reported that he was making an approach to the sod runway (36). He stated that when he was about treetop high, a gust of wind picked up the left wing of the aircraft and it drifted to the right of the runway. Subsequently, the right wing struck a…