NTSB investigations: Piper PA-28RT-201T

7 cases on aircraft the registry lists as Piper PA-28RT-201T, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Piper PA-28RT-201T per year, 1982–2026: 7 cases
1982	1
1983	1
1984	1
1985	1
1987	2
1994	1

Where

Open the map

Latest cases

Query with SQL

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" = 351)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 351))
  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" = 351))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 NYC94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Warfordsburg, PAThe engine failure as a result of a main bearing shift and restricted lubrication, and the lack of suitable terrain for a forced landing.Mar 15, 1994 · N8335X · Substantial damage NTSB DEN87FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Ogden, UTAcft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…May 25, 1987 · N2888B · Destroyed NTSB LAX87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Santa Ynez, CAJust after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…Mar 9, 1987 · N8162X · Substantial damage NTSB DEN85LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Clovis, NMWhile in level cruise flight at 17,000 ft, pilot noticed sound change in cabin. All instrument readings were normal with the exception of manifold pressure drop from 32 to 25 inches. Engine began to sputter and run rough. Oil pressure warning light blinked…Aug 1, 1985 · N2232R · Destroyed NTSB DEN84LA221Accident · Minor injuriesLimited investigationFinal reportPiper 28RT-201T · Glendo, WYThe acft was damaged in a forced landing in a wooded area after the engine failed. The plt said that he was cruising at 7500 ft MSL when without warning the engine began making noises and then lost oil pressure. After the landing the enginewas examined at the…Jul 20, 1984 · N8168Q · Substantial damage 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…Nov 21, 1983 · N2124N · Destroyed NTSB LAX82FA347Accident · No injuriesField investigationFinal reportPiper PA-28RT-201T · Malibu, CAThe eng seized approximately 3500 ft & the acft was ditched off the beach. The right mag distributor block showed evidence of carbon tracking & cross firing. Neither end of the right mag had breather plugs installed. All spark plugs were excessively fouled &…Sep 21, 1982 · N8094F · Substantial damage