NTSB investigations: Piper PA-32R-300, TX

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

19762026

NTSB investigations: Piper PA-32R-300, TX per year, 1976–2026: 10 cases
1976	1
1977	1
1980	1
1989	1
1995	2
2004	2
2016	1
2026	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" = 'TX' 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 ('7103213')) 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\" = 'TX' 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 ('7103213'))
  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" = 'TX' 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 ('7103213'))
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 CEN26LA202Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-32R-300 · Comanche, TXOn May 22, 2026, about 1840 central daylight time, a Piper PA-32R-300 airplane, N4556Q, was substantially damaged during an accident near Comanche, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…May 22, 2026 · N4556Q · Substantial damage NTSB CEN16FA261Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Houston, TXThe pilot's failure to maintain adequate airspeed after becoming distracted by the open baggage door while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at…Jul 8, 2016 · N32KK · Destroyed NTSB FTW04FA235Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rachel, TXThe total failure of the vacuum pump that resulted in an inoperative attitude gyro and spatial disorientation and a subsequent loss of aircraft control by the pilot. Factors were; the prevailing instrument meteorological conditions, and the dark night light…Sep 9, 2004 · N6209J · Destroyed NTSB FTW04LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Dalhart, TXloss of engine power due to a corroded magneto for undetermined reasons.Jun 25, 2004 · N49KG · Substantial damage NTSB FTW95FA363Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Wichita Falls, TXthe pilot's failure to maintain airspeed while diverting attention to an open cargo door. A factor was the pilot's inadequate preflight inspection.Aug 26, 1995 · N9296K · Destroyed NTSB FTW95FA112Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Conroe, TXThe pilot's failure to follow published IFR procedures. Factors were the weather conditions, the dark night, and the pilot's failure to activate the approach lighting system.Feb 10, 1995 · N5373F · Destroyed NTSB FTW89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Stratford, TXImproper planning/decision by the pilot, and his inadequate compensation for wind conditions, which resulted in a loss of aircraft control. The wind condition was a related factor.May 30, 1989 · N3279Q · Substantial damage NTSB FTW80FRA22Accident · No injuriesClosedPiper PA-32R · Houston, TXApr 2, 1980 · N43829 · Substantial damage NTSB FTW77FA048Accident · 6 fatalClosedPiper PA-32R · Commerce, TXApr 1, 1977 · N6127J · Destroyed NTSB FTW76AF063Accident · 2 fatalClosedPiper PA-32R · Monahans, TXFeb 6, 1976 · N7053C · Destroyed