NTSB investigations: Piper PA-31-310
145 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.
Cases, newest first
Query with SQL
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 ('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."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" DESCRun 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 MKC86FA088Accident · 5 fatalField investigationFinal reportPiper PA-31 · Norfolk, NEThe airplane departed on runway 31 with a low ceiling and visibility variable from 1/4 mile to 1/16 mile and winds from 290 degrees at 38 knots, gusting to 47 knots. A witness stated that the airplane was airborne no more than two minutes after the engines…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…NTSB DEN86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Fargo, NDThe plt stated that during the ground taxi after landing, the right main gear collapsed. During the investigation, it was determined the down lock mechanism was not engaged. Upon examination, it was determined that the main gear lock activator rod was…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…NTSB ATL85FKG05Accident · No injuriesFinal reportPiper PA-31 · Atlanta, GAOn may 2, 1985, at 0714 EDT, a Piper PA-31, N902BH, regisered to paul m. furnee, was struck by a ground vehicle while taxiing for take off at hartsfield international airport, Atlanta, Georgia on an airtaxi cargo flight. Instrument meteorological conditions…NTSB NYC84FNC02Accident · Serious injuriesFinal reportPiper PA-31S 2 · Rockland, MEFollowing the rwy 03 LOC apch plt decided to land straight in with a tailwind rather than circling because of low clouds surrounding the arpt. Acft touched down with aprx 2000 ft of wet rwy remaining. Acft traveled off end of rwy until it contacted an…NTSB NYC84MA102Accident · 3 fatalMajor investigationFinal reportPiper PA-31 · Cumberland, MDApprox 16 min prior to the accident the plt was cleared for the localizer DME approach. The acft collided with the mountainous terrain on a hdg of about 220 degrees at approx 8.5 DME on a bearing of 051 degrees from the arpt. As indicated on the loc/dme rwy…NTSB FTW84LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Brownsville, TXThe plt was maneuvering for an ILS approach when he collided with the ground. He said he was distracted by the swinging CDI and was below the glide slope. He said he started to add power for a missed approach and the acft impacted the ground. A passenger said…NTSB CHI83IA360Incident · No injuriesIncident investigationFinal reportPiper PA31-310 · Mount Vernon, OHOn final approach both engines failed. The pilot elected to land intentional gear up short of therunway. Less than 1 pint of fuel was found on board.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…NTSB MIA83FA017Accident · 8 fatalField investigationFinal reportPiper PA-31 · Missing Acft (Atlantic Ocean)The flt departed anguilla at 0803 ast. At 0805 the plt radioed st. maarten & filed a VFR flt plan to st. thomas. The flt plan showed a direct route of flt at 4,500 ft MSL with a time enroute of 45 min. The flt failed to arrive at the destination. Search…NTSB ATL83FA003Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Dyersburg, TNAt 30 mi north of the destination, the inboard side of the right eng cowl popped loose & began vibrating severely, the plt was concerned that the cowling would break loose & strike the vert of horiz stabilizer so he feathered the r eng. Atthis point, the arpt…NTSB ATL82DA284Accident · No injuriesFinal reportPiper PA-31 · London, KYThe aircraft was on a flight from palm beach, FL to London, KY. Five miles short of runway 23 at London, both engines quit and the aircraft made a forced landing. Post crash examination revealed less than one gallon of fuel on board.NTSB NYC82FA134Accident · No injuriesField investigationFinal reportPiper PA-31 · Bennington, VTWhile on approach to land, the pilot noticed the aircraft's gear warning lights were out and the circuit breakers were tripped. The pilot advised operations and started a fly-by when he noticed a fire in the left engine. The pilot feathered the left engine…NTSB CHI82DA050Accident · No injuriesFinal reportPiper PA-31-310 · East Saint Loui, ILThe aircrew did not key the approach lights on during the first ILS approach at night. Therefore, a missed approach was made. On the second approach, the lead-in lights were visible from over one mile. However, the visibility was much worse at touchdown,…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…NTSB FTW82FRG21Accident · 1 fatalFinal reportPiper PA-31 · Port Mansfield, TXThe aircraft crashed and burned about 1/2 mile from the approach end of runway 12. A witness reported that "the plane just fell" while the pilot was making a sharp turn. An estimated 1500 lbs of marijuana was on board.NTSB DCA82AA009Accident · 2 fatalFinal reportPiper PA-31 · Ithaca, NYThe acft was on a scheduled commuter flt from utica, NY to Washington, DC with a stop at Ithaca, NY. The en route portion of the flt from utica to Ithaca was normal. At 0735 EST, the acft was at 6000 ft MSL when apch control informed the aircrew to expect an…NTSB MIA81FKT90Accident · No injuriesClosedPiper PA-31 · Ft.Lauderdale, FLNTSB MIA81FLD50Accident · No injuriesClosedPiper PA-31 · Fort Myers, FLNTSB ANC81IA047Incident · Minor injuriesClosedPiper PA-31 · Port Heiden, AKNTSB FTW81DPG11Accident · No injuriesClosedPiper PA-31 · Mountain Home, ARNTSB LAX81FA039Accident · 1 fatalClosedPiper PA-31 · Mt Shasta, CANTSB MIA81DKT09Accident · Minor injuriesClosedPiper PA-31 · Naples, FLNTSB NYC80FGM27Accident · Minor injuriesClosedPiper PA-31 · Windber, PANTSB ATL80FA049Accident · 6 fatalClosedPiper PA-31 · Mobile, ALNTSB CHI80DEX06Accident · No injuriesClosedPiper PA-31 · W Lafayette, INNTSB CHI80FET12Accident · No injuriesClosedPiper PA-31 · Michigan City, INNTSB MKC80FA013Accident · No injuriesClosedPiper PA-31 · Lee'S Summit, MONTSB NYC80FA009Accident · No injuriesClosedPiper PA-31 · Stamford, CTNTSB DCA80AA002Accident · 8 fatalClosedPiper PA-31 · Covington, KYNTSB CHI79FEI44Accident · No injuriesClosedPiper PA-31 · Sandusky, OHNTSB MIA79DKT79Accident · No injuriesClosedPiper PA-31 · Naples, FLNTSB MIA79FA077Accident · 2 fatalClosedPiper PA-31 · Labelle, FLNTSB MKC79FA020Accident · No injuriesClosedPiper PA-31 · Clinton, IANTSB IAD79IA030Incident · No injuriesClosedPiper PA-31 · Cincinnati, OHNTSB NYC79FNC16Accident · No injuriesClosedPiper PA-31 · Laconia, NHNTSB NYC79FA022Accident · No injuriesClosedPiper PA-31 · Lima, NYNTSB LAX79DUG12Accident · Minor injuriesClosedPiper PA-31 · Hart Mine, CANTSB OAK79FXQ03Accident · No injuriesClosedPiper PA-31 · Reno, NVNTSB CHI79FEX03Accident · No injuriesClosedPiper PA-31 · Indianapolis, INNTSB MIA79DLA05Accident · No injuriesClosedCessna 310 · Cairo, GANTSB CHI78FA064Accident · 6 fatalClosedPiper PA-31 · Savoy, ILNTSB MIA78DLA49Accident · No injuriesClosedPiper PA-31 · Jacksonville, FLNTSB MIA78DA119Accident · 2 fatalClosedPiper PA-31 · Missing AircraftNTSB NYC78FA058Accident · 1 fatalClosedPiper PA-31 · Fleetville, PANTSB MIA78FA054Accident · 1 fatalClosedPiper PA-31 · Leesburg, FLNTSB FTW78FA028Accident · 2 fatalClosedPiper PA-31 · Searcy, ARNTSB CHI78FEK08Accident · No injuriesClosedPiper PA-31 · Bluffton, OHNTSB ANC78DA010Accident · No injuriesClosedPiper PA-31 · Scammon Bay, AK