NTSB investigations: Piper PA-28RT-201T
8 cases on aircraft the registry lists as Piper PA-28RT-201T, 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1996 | 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 ('7102817')
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 ('7102817')
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 CHI96LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Wichita, KSthe pilot's failure to maintain directional control of the airplane during landing. A factor associated with the accident was the gusty crosswind condition.NTSB MIA93LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe failure of the pilot-in-command to maintain directional control while landing with a crosswind.NTSB DEN89LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Red Lodge, MTInadequate compensation for the wind conditions during landing roll, resulting in a loss of control. Contributing to the accident was the gusty wind condition.NTSB CHI87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grayslake, ILThe aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The…NTSB MKC86LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Aurora, MOThe pilot stated there was patches of snow and ice on the runway surface a snow on the sides and as he pulled up the flaps, the airplane veered right, off the runway. He said that after he got the airplane back on the runway, it ground- looped to the left and…NTSB FTW85FA247Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Pineville, LAThe aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high…NTSB DEN85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Nucla, COAccording to the plt, after landing on centerline brakes were applied and ice on the rwy caused the acft to veer left. An abort was initiated but realizing that the acft was going off the side of the rwy the plt secured the eng. The nose gear collapsed as the…NTSB LAX83LA368Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Novato, CAThe acft left the rwy during landing and collided with a dirt embankment. The plt was practicing takeoffs and landings. The tower had advised him that rwy 13 was in use and there was right crosswind. During the 3rd landing as the plt was raising the flaps he…