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”. 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	2
1984	1
1985	1
1986	1
2004	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" = 350)) 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\" = 350))
  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" = 350))
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 CHI04CA210Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201T · Plymouth, MIThe loss of engine power at a low altitude due to a fuel flow restriction caused by vapor lock. Factors to the accident included the high atmospheric temperature and the road sign that the airplane impacted during the forced landing.Jul 31, 2004 · N77782 · Destroyed NTSB LAX87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Madera, CADuring a dual instructional flight, the pilots were practicing a simulated engine out procedure. Engine power had been reduced to 15' of manifold pressure. When an attempt was made to add power at an altitude of about 500 ft, the engine quit. The instructor…Oct 23, 1986 · N2853X · Substantial damage 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…Mar 31, 1985 · N3562X · Destroyed 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…Aug 29, 1984 · N4355N · Destroyed NTSB ATL83LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28AT-201T · Basye, VAThe flt instructor (CFI) was giving the private plt a familiarization flt. During an apch to rwy 23 at Basye, VA, at dusk, the acft got low & the CFI instructed the plt to add power. However, when the throttle was advanced, the eng reportedly did not respond.…Aug 16, 1983 · N8242L · Substantial damage NTSB DEN83LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Vernal, UTDuring takeoff initial climb, as the gear was retracted, the turbo charger overboost light flashed once & the eng coughed & quit. The plt stated all gages were normal until the eng quit. The acft was still over the rwy, & the plt maintained 75 KTS with 1…Aug 13, 1983 · N29649 · Substantial damage NTSB DEN82DA174Accident · No injuriesFinal reportPiper PA-28RT-201T · 15mi. Ne Of Chr, COWhile en route, the engine began to lose power, and subsequently, there was a total power loss. The pilot landed in a small clearing, but during the landing roll, the right main gear hit a large rock. The gear failed and punctured a hole in the fuel tank. The…Aug 16, 1982 · N3072Z · Destroyed