NTSB investigations: Piper PA-28-151, PA
13 cases on aircraft the registry lists as Piper PA-28-151. 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
| 1974 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND 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'))
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."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA'
AND 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'))
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 ERA15LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Perkasie, PAThe pilot's failure to use the mixture control to override a throttle anomaly and reduce engine power, which resulted in excessive airspeed upon landing and a subsequent runway overrun. Contributing to the accident was the pilot’s inability to reduce the…NTSB NYC95LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Warminster, PAthe pilot's improper positioning of the fuel selector which resulted in a total loss of engine power due to fuel starvation. A contributing factor was pilot distraction.NTSB BFO94LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Greentown, PAThe pilot's selection of the wrong runway, and his delay in attempting a go-around which resulted in an inflight collision with the trees. A related factor was the unfavorable wind.NTSB NYC93LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · New Cumberland, PAThe loss of engine power for undetermined reasons, resulting in a forced landing in the river.NTSB NYC90LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mt Pocono, PAA hard landing after the pilot perceived an engine problem. Contributing to the accident was the failure of the pilot to control his airspeed and flare during the emergency landing.NTSB NYC88LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Middletown, PAAfter landing the pilot was cleared to taxi to the parking area at stanbaugh's general aviation. During a maneuver between a de-icer truck and a parked airplane, the pilot allowed the aircraft to become too close to the truck and caught the wing tip on the…NTSB NYC78FHD15Accident · Minor injuriesClosedPiper PA-28 · Bristol, PANTSB NYC78DHA24Accident · Minor injuriesClosedPiper PA-28 · E.Stroudsburg, PANTSB NYC78FGM14Accident · No injuriesClosedPiper PA-28 · Martinsburg, PANTSB NYC78FGM46Accident · No injuriesClosedPiper PA-28 · Monroeville, PANTSB NYC76FGT24Accident · No injuriesClosedPiper PA-28 · Centre Hall, PANTSB NYC75FGM42Accident · No injuriesClosedPiper PA-28 · Latrobe, PANTSB NYC75AN034Accident · 1 fatalClosedPiper PA-28 · Allentown, PA