Skip to content

NTSB investigations: Piper PA-31-310, FL

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

19702026

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" = 'FL' 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 ('7103102')) 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\" = 'FL' 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 ('7103102'))
  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" = 'FL' 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 ('7103102'))
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 ERA12LA165Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Palm Beach, FLThe pilot’s in-flight misjudgment of fuel remaining resulting in fuel exhaustion and a total loss of engine power. Contributing to the accident was an inadequate fuel quantity for the flight for reasons that could not be determined during postaccident…Jan 28, 2012 · N30DC · Substantial damage NTSB MIA03FA167Accident · 2 fatalField investigationFinal reportPiper PA-31 · Clearwater, FLThe failure of the flightcrew to maintain airspeed (Vs) resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with the ground.Aug 21, 2003 · N93DC · Destroyed NTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.Aug 2, 2003 · N876RD · Substantial damage NTSB MIA98FA200Accident · 1 fatalField investigationFinal reportPiper PA-31-310 · Miami, FLThe pilot's inadequate preflight inspection which led to fuel contamination and subsequent loss of engine power. Also causal was the pilot's failure to maintain single engine flying speed (VMC).Jul 17, 1998 · N7578L · Destroyed NTSB MIA91LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-B-310 · Fernandina Bch, FLDelay by the pilot to perform a missed approach and failure to correct the descent before impact with terrain.Jan 25, 1991 · N31HL · Substantial damage NTSB MIA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · West Palm Beach, FLThe plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…Nov 11, 1987 · N112AG · Substantial damage NTSB MIA86FA080Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Moore Haven, FLOn February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…Feb 17, 1986 · N7EA · Destroyed NTSB MIA86LA008Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Opa Locka, FLThe plt stated that on final apch after lowering the landing gear he got an unsafe gear light. He then flew by the twr & the controller stated that the gear appeared to be down. He then recycled the landing gear & received a normal gear down indication. Upon…Oct 7, 1985 · N9135Y · Substantial damage NTSB MIA83FA064Accident · No injuriesField investigationFinal reportPiper PA-31 · Miami Lakes, FLThe plt & a prospective buyer/passenger were on a local demonstration flt. Prior to this flt, the acft had been parked for nearly 1 yr. Since the last annual inspection on 1/12/82, it had been flown only 66 hrs. During the preflt, the plt found the fuel tanks…Jan 26, 1983 · N9003Y · Destroyed NTSB MIA82FLD15Accident · Serious injuriesFinal reportPiper PA-31 · Ft. Pierce, FLThe aircraft crashed at night near a private strip in marginal weather conditions. The gear was found in the up position, the right engine was broken off, the nose section was crushed back to the windshield, and both propellers were bent and twisted. About…Feb 7, 1982 · N747CE · Destroyed NTSB MIA81FKT90Accident · No injuriesClosedPiper PA-31 · Ft.Lauderdale, FLAug 23, 1981 · N9100Y · Substantial damage NTSB MIA81FLD50Accident · No injuriesClosedPiper PA-31 · Fort Myers, FLJun 5, 1981 · N747CE · Substantial damage NTSB MIA81DKT09Accident · Minor injuriesClosedPiper PA-31 · Naples, FLNov 5, 1980 · N9044Y · Destroyed NTSB MIA79DKT79Accident · No injuriesClosedPiper PA-31 · Naples, FLJul 20, 1979 · N101MC · Destroyed NTSB MIA79FA077Accident · 2 fatalClosedPiper PA-31 · Labelle, FLApr 28, 1979 · N6478L · Destroyed NTSB MIA78DLA49Accident · No injuriesClosedPiper PA-31 · Jacksonville, FLSep 8, 1978 · N6768L · Substantial damage NTSB MIA78FA054Accident · 1 fatalClosedPiper PA-31 · Leesburg, FLMar 16, 1978 · N7488L · Destroyed NTSB MIA77FA010Accident · 3 fatalClosedPiper PA-31 · Tallahassee, FLNov 17, 1976 · N50BB · Destroyed NTSB MIA74FLA14Accident · No injuriesClosedPiper PA-31 · Jacksonville, FLSep 11, 1973 · N6614L · Substantial damage NTSB MIA72FLA19Accident · No injuriesClosedPiper PA-31 · Pensacola, FLOct 28, 1971 · N41DL · Substantial damage NTSB MIA70FLA19Accident · Serious injuriesClosedPiper PA-31 · Tallahassee, FLApr 14, 1970 · N411AA · Destroyed