NTSB investigations: Piper PA-28-151
15 cases on aircraft the registry lists as Piper PA-28-151, 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 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
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\" = 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 ('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" = 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 LAX05CA066Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB NYC02LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Belmar, NJThe student pilot's failure to maintain runway alignment during landing. A factor in the accident was the winds.NTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…NTSB CHI99LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Red Wing, MNDirectional control not being maintained by the pilot. A factor to the accident was the ditch.NTSB CHI98LA203Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jefferson, IAthe pilot's lack of total experience in this type of aircraft and his failure to maintain directional control during an aborted takeoff. A factor was the ditch.NTSB NYC95LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering off the left side of the runway. A factor was the pilot's failure to abort the takeoff.NTSB MIA94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Boca Raton, FLThe failure of the dual student to maintain directional control during landing and the failure of the flight instructor to properly supervise the dual student and take corrective action in a timely manner.NTSB ATL93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lafayette, GAThe failure of the pilot to maintain control of the aircraft.NTSB NYC93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmingdale, NYThe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane. The crosswind was a related factor.NTSB MKC89LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeview, ARDuring a personal cross country flight, the newly certificated private pilot said he was attempting to land on a 3200 foot grass strip with an existing gusting crosswind. He lost directional control during the landing, hit a runway light, tearing off the left…NTSB NYC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bridgeport, NJThe pilot was making a night landing to Bridgeport airport when he lost directional control of the aircraft and it veered to the left. The airplane continued to roll off the end of the runway and collided with trees.NTSB CHI87LA043Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Marquette, MIWhile on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure.NTSB CHI83LA283Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Alma, MIThe acft collided with the VASI lights during landing. The pilot was landing on rwy 27 with winds from 210 degrees at 12 KTS. He reported gusty winds but gave no estimated velocity of the gusts. He said he touched down on the right main gear with the left…NTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…