NTSB investigations: Piper PA-28-151, NY
15 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 |
|---|---|
| 1976 | 3 |
| 1978 | 3 |
| 1981 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2024 | 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\" = 'NY' 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" = 'NY' 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 ERA24LA277Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Fire Island, NYA total loss of engine power for undetermined reasons.NTSB ERA20LA163Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · East Hampton, NYThe partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB GAA18CA032Accident · No injuriesData collectionFinal reportPiper PA28 · West Seneca, NYThe airplane's collision with a deer during the landing roll.NTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).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 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 NYC88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Carlton Center, NYPlt stated he was landing to the west and touched down about half way down a 2,000 ft grass strip. The plt also said the grass was wet and the wheel braking was ineffective. The plt elected to keep the airplane on the ground due to obstacles at the end of the…NTSB NYC82FFJ06Accident · No injuriesClosedPiper PA-28 · Rochester, NYNTSB NYC78FA080Accident · No injuriesClosedPiper PA-28 · Cassadaga, NYNTSB NYC78FA071Accident · 3 fatalClosedPiper PA-28 · Campbell, NYNTSB NYC78FA042Accident · No injuriesClosedPiper PA-28 · Fishers Island, NYNTSB NYC77FHJ03Accident · No injuriesClosedPiper PA-28 · Mattituck, NYNTSB NYC77DFJ03Accident · No injuriesClosedPiper PA-28 · Arcade, NYNTSB NYC76DHM24Accident · No injuriesClosedPiper PA-28 · Warwick, NYNTSB NYC75FHJ20Accident · No injuriesClosedPiper PA-28 · Mattituck, NY