NTSB investigations: Piper PA-32RT-300T, MI

6 cases on aircraft the registry lists as Piper PA-32RT-300T. 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

19792026

NTSB investigations: Piper PA-32RT-300T, MI per year, 1979–2026: 6 cases
1979	1
1981	2
1992	1
1994	1
2018	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."eventStateOrRegion" = 'MI' 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 ('7103216')) 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.\"eventStateOrRegion\" = 'MI' 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 ('7103216'))
  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" = 'MI' 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 ('7103216'))
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 CEN18FA368Accident · 1 fatalField investigationFinal reportPiper PA32RT · St Ignace, MIThe pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.Sep 1, 2018 · N500MJ · Destroyed NTSB CHI94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Newberry, MIan engine fire which started as the result of an oil leak around the engine oil filter.Jan 22, 1994 · N39505 · Destroyed NTSB CHI92FA280Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pullman, MIThe pilot in command's exceeding the design stress limits of the aircraft.Sep 17, 1992 · N39652 · Destroyed NTSB CHI81FEM31Accident · No injuriesClosedPiper PA-32R · Harbor Springs, MIJul 26, 1981 · N39659 · Substantial damage NTSB CHI81FA040Accident · 1 fatalClosedPiper PA-32 · Corunna, MIMar 31, 1981 · N2158D · Destroyed NTSB CHI80FEM03Accident · No injuriesClosedPiper PA-32R · Manistee, MIOct 20, 1979 · N39591 · Substantial damage