NTSB investigations: Piper PA-32RT-300T

6 cases on aircraft the registry lists as Piper PA-32RT-300T, where the first occurrence was “Loss of control - in flight”. 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

19842026

NTSB investigations: Piper PA-32RT-300T per year, 1984–2026: 6 cases
1984	1
1985	1
1986	1
1987	1
1989	1
2002	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 ('7103216') 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" = 250)) 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 ('7103216')
      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\" = 250))
  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 ('7103216')
    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" = 250))
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 CHI02LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Valparaiso, INThe pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.Apr 19, 2002 · N3034A · Substantial damage NTSB LAX89LA186Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Phoenix, AZThe failure of the pilot to maintain adequate clearance behind the B-737 which resulted in the inadvertent encounter with wake turbulence.May 24, 1989 · N39520 · Substantial damage NTSB MIA87LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Tallahassee, FLControl of the acft was lost due to a strong wind gust created by the tree line next to the rwy & the acft crashed next to the rwy. A plt who had landed just prior to that time stated that he had sustained a momentary lost of acft control during the flare due…Mar 6, 1987 · N39588 · Substantial damage NTSB ATL86FA064Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Milwaukee, NCThe acft was observed to descend and level off at low alt. Witnesses indicated that it leveled off just above the trees, then rolled to the right and dove into wooded terrain. The eng was reported to be running loud and steady until impact. No preimpact part…Jan 27, 1986 · N222HD · Destroyed NTSB CHI85FA258Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Merom, INThe aircraft was on a visual flight from fairfield Iowa to indianapolis, IN and was about 55 mautical miles south of course when the aircraft broke up in flight. The main wreckage, empennage, and outer wing sections landed within about a quarter of a mile of…Jun 28, 1985 · N39554 · Destroyed NTSB ATL84FA093Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300T · Bluefield, WVThe non-instrument rated plt began his takeoff during the hours of darkness, but in VMC wx. He stated that during the takeoff roll at about 65 to 75 KTS just prior to rotation, the landing light extinguished. Plt stated that 2 to 3 seconds later, he rotated &…Feb 9, 1984 · N22457 · Destroyed