NTSB investigations: Piper PA-28RT-201, PA
6 cases on aircraft the registry lists as Piper PA-28RT-201. 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 |
| 1987 | 1 |
| 2006 | 1 |
| 2007 | 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\" = '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 ('7102818'))
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 ('7102818'))
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 ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.NTSB NYC06LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Philadelphia, PAA fatigue failure of the number 3 cylinder attachment studs, which resulted in a loss of engine power and subsequent forced landing.NTSB NYC88LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver Falls, PADuring hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury.NTSB NYC83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · West Chester, PAThe plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only…NTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…