Skip to content

NTSB investigations: Piper PA-32RT-300T

134 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, newest first

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')) 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'))
  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'))
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 ATL82DA286Accident · No injuriesFinal reportPiper PA-32RT-300T · Athens, GAThe pilot initiated an intersection takeoff with 1400 ft of runway remaining. After starting the takeoff, he elected to abort; however, the aircraft continued off the end of the runway and collided with obstacles. The performance charts showed that a 3000 lb…Sep 27, 1982 · N39603 · Substantial damage NTSB DEN82DA110Accident · No injuriesFinal reportPiper PA-32RT-300T · Durango, COThe pilot reported that after taking off, dense white smoke began to fill the cockpit and seemed to come from under the instrument panel. He stated that the instruments were in the normal operating range, but the smoke became so dense that the visibility in…Jun 23, 1982 · N31912 · Substantial damage NTSB ATL82FKJ11Accident · Serious injuriesFinal reportPiper PA-32 · Muscle Shoals, ALDuring the approach the pilot stated that he could not extend the landing gear. At some point during the approach the aircraft broke out into VFR conditions. The pilot stated he had the airport in sight when the aircraft struck a 160,000 volt power line.…Jan 22, 1982 · N31937 · Destroyed NTSB SEA82DYA03Accident · No injuriesClosedPiper PA-32 · Rexburg, IDNov 17, 1981 · N2106J · Destroyed NTSB CHI81DER40Accident · Minor injuriesClosedPiper PA-32 · Crivitz, WISep 14, 1981 · N39628 · Substantial damage NTSB CHI81FEM31Accident · No injuriesClosedPiper PA-32R · Harbor Springs, MIJul 26, 1981 · N39659 · Substantial damage NTSB NYC81FHJ10Accident · No injuriesClosedPiper PA-32R · Farmingdale, NYJul 17, 1981 · N36201 · Substantial damage NTSB CHI81FA066Accident · 1 fatalClosedPiper PA-32R · Crystal, MNJun 18, 1981 · N21594 · Destroyed NTSB CHI81FA040Accident · 1 fatalClosedPiper PA-32 · Corunna, MIMar 31, 1981 · N2158D · Destroyed NTSB CHI81FER13Accident · Serious injuriesClosedPiper PA-32 · Webb Lake, MNJan 25, 1981 · N2174A · Destroyed NTSB SEA81FA006Accident · No injuriesClosedPiper PA32RT · Oakley, IDNov 20, 1980 · N21842 · Substantial damage NTSB LAX80FVA03Accident · 2 fatalClosedPiper PA-32 · Merced, CAOct 2, 1980 · N21307 · Destroyed NTSB FTW80DPD48Accident · No injuriesClosedPiper PA-32 · Decatur, TXSep 25, 1980 · N3049K · Substantial damage NTSB ATL80FID30Accident · No injuriesClosedPiper PA-32R · Orange, VASep 14, 1980 · N3026C · Substantial damage NTSB FTW80FQA34Accident · No injuriesClosedPiper PA-32 · Socorro, NMJul 6, 1980 · N36558 · Substantial damage NTSB SEA80FA036Accident · 4 fatalClosedPiper PA32RT · Granite, ORJun 26, 1980 · N39691 · Destroyed NTSB LAX80FVM33Accident · Minor injuriesClosedPiper PA-32R · San Carlos, CAJun 24, 1980 · N20817 · Substantial damage NTSB CHI80FET15Accident · No injuriesClosedPiper PA32RT · New Haven, INApr 19, 1980 · N36754 · Substantial damage NTSB FTW80FQD05Accident · No injuriesClosedPiper PA-32 · El Paso, TXMar 28, 1980 · N478GL · Substantial damage NTSB IAD80FKM06Accident · No injuriesClosedPiper PA-32R · Hickory, NCJan 4, 1980 · N36390 · Substantial damage NTSB SEA80FTI02Accident · Serious injuriesClosedPiper PA-32R · Chester, MTDec 19, 1979 · N2168D · Destroyed NTSB CHI80FEM03Accident · No injuriesClosedPiper PA-32R · Manistee, MIOct 20, 1979 · N39591 · Substantial damage NTSB MKC80DER01Accident · No injuriesClosedPiper PA-32 · Aitkin, MNOct 13, 1979 · N36815 · Substantial damage NTSB DEN79DTE63Accident · No injuriesClosedPiper PA-32R · Fort Collins, COJul 24, 1979 · N36782 · Substantial damage NTSB FTW79DQD11Accident · No injuriesClosedPiper PA-32 · Kent, TXJun 14, 1979 · N36367 · Substantial damage NTSB CHI79FEK12Accident · No injuriesClosedPiper PA32RT · Westerville, OHMay 9, 1979 · N36390 · Substantial damage NTSB MKC79DCJ10Accident · No injuriesClosedPiper PA-32R · Ainsworth, NEFeb 16, 1979 · N2174A · Substantial damage NTSB MIA79FLO32Accident · No injuriesClosedPiper PA-32 · Vero Beach, FLJan 16, 1979 · N21698 · Substantial damage NTSB LAX79FUA07Accident · Minor injuriesClosedPiper PA-32 · Fullerton, CAJan 13, 1979 · N39720 · Destroyed NTSB NYC78FHM26Accident · Serious injuriesClosedPiper PA-32 · Matawan, NJAug 27, 1978 · N9328C · Destroyed NTSB CHI78DET27Accident · No injuriesClosedPiper PA-32 · Fort Wayne, INJul 16, 1978 · N36754 · Substantial damage NTSB DEN68F0180Accident · No injuriesClosedPiper PA-23 · Tucumcari, NMDec 17, 1967 · N2225P · Substantial damage NTSB CHI68D0154Accident · No injuriesClosedPiper PA-23 · Fond Du Lac, WIJul 6, 1967 · N2225P · Substantial damage NTSB UNK64X1299Accident · No injuriesClosedPiper PA22 · Bennington, VTApr 13, 1964 · N36272 · Substantial damage