Fatal NTSB investigations: Piper PA-28RT-201T
21 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 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1999 | 2 |
| 2002 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2021 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 ERA21FA189Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201T · Brownsville, TNThe student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…NTSB CEN15FA101Accident · 1 fatalField investigationFinal reportPiper PA 28RT-201T · Brighton, COThe pilot's intentional descent into the terrain.NTSB CEN13WA307Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Tallard, FranceNTSB FTW02FA095Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Marianna, ARThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.NTSB CHI99FA164Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Great Bend, KSthe chafed through turbocharger oil supply hose, the failure of maintenance personnel to install a clamp on the turbocharger oil supply hose, and the inability of the pilot to maintain aircraft control.NTSB NYC99FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA28RT-201T · Plymouth, MAundetermined (missing airplane)NTSB CHI93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Ft. Riley, KSThe non-current student pilot's failure to maintain adequate clearance from terrain while operating at night, in instrument meteorological conditions.NTSB ATL92FA008Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Spring Lake, NCThe inadvertent flight from visual flight rules flight conditions into instrument flight rules flight conditions by the non-instrument rated pilot, and his subsequent failure to maintain control of the aircraft.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 LAX90FA106Accident · 1 fatalField investigationFinal reportPiper PA28-201T · Yountville, CAThe pilot used poor judgement by attempting a v.f.r. flight to an area with forecasted instrument meteorological conditions and continuing the flight when I.f.r. conditions were encountered.NTSB LAX90FA002Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201T · Palm Springs, CAImproper in-flight planning/decision by the pilot, and his failure to follow wake turbulence avoidance procedures, which resulted in a vortex turbulence encounter. A factor related to the accident was: the pilot's failure to assure the aircraft was loaded…NTSB NYC89FA036Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Gans, PAPilot's bad judgement in flying in weather conditions beyond the capabilities of his aircraft. The pilot overstressed the aircraft and sheared the left wing by making an abrupt turn in turbulent air above the design maneuvering speed (VA). The accumulation of…NTSB DEN88FA141Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Capitan, NMNTSB DEN86FA028Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Cheyenne Wells, COThe plt obtained a wx briefing prior to departing apa. There was a cold frontal system moving down from the north but wx was forecast to be VFR for the remainder of the day. The plt and a plt-pax flew to jln where the plt-pax disembarked. The plt did not…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 CHI84FA369Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Muncie, INWitnesses reported that when the acft was taking off, the eng sounded 'rough & was backfiring.' They observed the acft cross the departure end of the rwy at a lower alt & slower speed than what they considered as normal. They saw the acft's wings rock, then…NTSB SEA84FA071Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Humphrey, IDWhile on a x-country flt, the acft entered an area of rising terrain & blowing snow & the plt initiated a turn to reverse direction. During the turn, he encountered reduced visibility & the acft collided with the top of a knoll on snow covered rolling…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 SEA83FA118Accident · 4 fatalField investigationFinal reportPiper PA28RT-201T · Gov'T Camp, ORWx conditions along the flt route indicated ceilings of 25,000 ft & unrestricted visibility except for the area south & west of mount hood. Mount hood, elevation 11,239 ft MSL, on the sw side of government Camp & clear lake (accident site),was covered by…NTSB FTW82FA009Accident · 2 fatalClosedPiper PA-28R · Hale Center, TXNTSB SEA81FA023Accident · 1 fatalClosedPiper PA28RT · Astoria, OR