Skip to content

NTSB investigations: Piper PA-31-350, TX

15 cases on aircraft the registry lists as Piper PA-31-350. 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

19752026

Where

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 ('7103110', '7103125')) 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 ('7103110', '7103125'))
  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 ('7103110', '7103125'))
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 CEN25LA060Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Victoria, TXThe pilot’s inadequate preflight planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Dec 11, 2024 · N818BR · Substantial damage NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.Sep 28, 2007 · N45014 · Substantial damage NTSB DFW05FA020Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.Nov 14, 2004 · N40731 · Destroyed NTSB FTW04LA238Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sweeny, TXThe fracture failure of the left engine crankshaft for undetermined reasons.Sep 14, 2004 · N555MC · Substantial damage NTSB FTW03LA046Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kerrville, TXThe propeller shaft seal leak resulting in an in-flight fire.Nov 6, 2002 · N698VW · Substantial damage NTSB FTW95LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Brownsville, TXThe fuel starvation loss of engine power due to the pilot's improper use of the fuel tank selector. Factors were the pilot's qualification and the lack of suitable terrain for landing.Jan 9, 1995 · N50WT · Destroyed NTSB FTW94LA136Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Laredo, TXThe fuel exhaustion induced power loss due to the pilot's inadequate preflight and his failure to refuel the airplane prior to departure. A factor was the lack of suitable terrain for the forced landing.Apr 21, 1994 · N44AC · Substantial damage NTSB FTW92LA121Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe failure of the hydraulic system seal and the subsequent fluid leak.Apr 28, 1992 · N140RD · Substantial damage NTSB FTW85LA250Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dallas, TXThe plt filed and flt planned for an overwater route between clearwater, FL, and Dallas, TX, which was denied due to ATC restrictions. On arrival over new orleans, a planned re-fueling stop, the plt determined that he would make it to Dallas. On arrival in…Jun 9, 1985 · N7697L · Substantial damage NTSB FTW82FA137Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot was trying to land after both engines failed during takeoff after the aircraft was refueled with jet fuel instead of gasoline. The weather was IFR with fog, low ceiling and rain. The aircraft collided with trees during a forced landing and was…Apr 19, 1982 · N3580D · Destroyed NTSB FTW82DQG08Accident · No injuriesClosedPiper PA-31 · Guthrie, TXNov 29, 1981 · N7691L · Substantial damage NTSB FTW80AA057Accident · 7 fatalClosedPiper PA-31 · Houston, TXMar 21, 1980 · N59932 · Destroyed NTSB FTW79DA053Accident · Serious injuriesClosedPiper PA-31 · Claude, TXFeb 23, 1979 · N61517 · Substantial damage NTSB FTW78FPA24Accident · No injuriesClosedPiper PA-31 · Dallas, TXMay 17, 1978 · N27367 · Substantial damage NTSB FTW75HF073Accident · 1 fatalClosedPiper PA-31 · Guerra, TXFeb 11, 1975 · N61446 · Destroyed