NTSB investigations: Piper PA-28RT-201T, TX
12 cases on aircraft the registry lists as Piper PA-28RT-201T. 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
| 1981 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 2 |
| 1991 | 2 |
| 1996 | 1 |
| 2010 | 1 |
| 2014 | 1 |
| 2022 | 1 |
| 2023 | 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\" = 'TX' 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 ('7102817'))
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" = 'TX' 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 ('7102817'))
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 CEN23LA259Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Baytown, TXThe total loss of engine power for undetermined reasons and the subsequent impact with terrain.NTSB CEN22LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Morgan, TXA partial loss of engine power due to a corrosion-related fatigue crack of the No. 3 cylinder barrel.NTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.NTSB CEN11CA103Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Spring, TXThe failure of the right landing gear down-lock mechanism to fully engage. Contributing to the accident was the pilot’s inability to verify the landing gear extension due to the inoperative alternator.NTSB FTW96LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Columbus, TXthe pilot's improper inflight planning/decision to continue the flight instead of returning to the takeoff airport after encountering adverse weather. Factors were: the inaccurate weather forecast, the low ceiling and the lack of suitable terrain for the…NTSB FTW91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Midland, TXThe pilot's inability to control the airplane due to his physiological incaapacitation. A factor was the pilot's impairment due to the usage of pain medications.NTSB FTW91LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Sonora, TXThe pilot's improper aircraft control during the takeoff ground run. Factors were the density altitude and the rough terrain.NTSB FTW85LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Fort Worth, TXPlt was taxiing to parking ramp/hangar after landing and following lineman's signals. He turned off the angling taxiway too soon and the nose and right main gears fell into a hole/low area off the edge of the taxiway. The propeller and right wing struck the…NTSB FTW85LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Matagorda Is., TXThe pilot executed a VFR go-around while on final approach due to livestock on the runway and reportedly experienced engine power loss. The aircraft made a forced landing on the beach and flipped inverted, coming to rest in the water alongside the beach. The…NTSB FTW84LA070Accident · No injuriesLimited investigationFinal reportPiper PA28RT-201T · Cameron, TXThe acft collided with trees during a forced landing after engine failure. During post accident examination the clamp which secures the turbocharger inlet tube to the engine exhaust was found to be off the threads of the bolt and were not damaged and the nut…NTSB FTW83FA361Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201T · Seminole, TXPrior to the flt, the plt & passengers were observed drinking beer in a lounge. They told witnesses that they were going to the arpt to eat & were later seen at a restaurant on the arpt. After that, they decided to fly. The takeoff time & purpose of the flt…NTSB FTW82FA009Accident · 2 fatalClosedPiper PA-28R · Hale Center, TX