Skip to content

NTSB investigations: Piper PA-31-350

302 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, 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 ('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.\"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."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 ATL83AA029Accident · 1 fatalFinal reportPiper PA-31-350 · Brevard, NCAfter a missed approach at asheville the flt was cleared to the greenville-spartanburg arpt at greer,SC. Enroute to greer radar contact was lost. In response to a query from atlanta ARTCC the plt verified his position as being on the 235 deg radial of…Nov 12, 1982 · N59771 · Destroyed NTSB LAX83LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Alturas, CAThe aircraft was landed long on a wet runway, and after overrunning the departure end, it collided with a fence and a dirt bank.Nov 10, 1982 · N4079J · Substantial damage NTSB FTW83FA027Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Baton Rouge, LAThe aircraft crashed and burned shortly after taking off in darkness on an IFR flight plan. The weather was reported as indefinite ceiling, zero obscuration, visibility 1/4 mi with fog, wind 120 deg at 5 KTS. A number of witnesses heard the aircraft, both…Oct 31, 1982 · N41045 · Destroyed NTSB MIA82AA177Accident · 2 fatalFinal reportPiper PA-31-350 · Near Lakeland, FLThe flt was conducting single-eng flt tests with the inboard gear doors removed & was being photographed by a chase acft. At the end of the tests the plt was unable to restart the left eng & returned for a single-eng landing. The plt overshot the landing…Sep 2, 1982 · N62957 · Destroyed 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 MIA82IA110Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tallahassee, FLWhile cruising at 8000 feet, the right alternator light came on and the pilot accomplished the required procedures for an alternator failure. Shortly thereafter, he noticed an area of discoloration on the inboard nacelle of the right engine and saw flames…Apr 3, 1982 · N41045 · Minor damage NTSB MIA82DA103Accident · No injuriesFinal reportPiper PA-31-350 · Miami, FLThe pilot was taxiing to gate H-2 to pick up a charter passenger when the aircraft and a vehicle collided. The pilot reported that about five seconds before impact, he saw the vehicle approaching from his ten o'clock position. He applied the brakes, but the…Apr 1, 1982 · N3587D · Substantial damage NTSB SEA82DA017Accident · No injuriesFinal reportPiper PA-31-350 · Spokane, WAAfter arriving in the Spokane area, a full ILS was commenced. It was terminated about 200 ft above the decision height with a missed approach. The aircraft was vectored for a second ILS. During the last 400 ft of this approach, about 3/4 to one inch of mixed…Jan 13, 1982 · N36PB · Substantial damage NTSB DCA82AA007Accident · 4 fatalClosedPiper PA-31 · Durango, CODec 31, 1981 · N41070 · Destroyed NTSB FTW82DQG08Accident · No injuriesClosedPiper PA-31 · Guthrie, TXNov 29, 1981 · N7691L · Substantial damage NTSB LAX81DA107Accident · No injuriesClosedPiper PA-31 · Tusayan, AZJul 22, 1981 · N27687 · Substantial damage NTSB SEA81IA045Incident · No injuriesClosedPiper PA-31 · Hailey, IDJun 30, 1981 · N3516A · Minor damage NTSB MIA81DA077Accident · No injuriesClosedPiper PA-31 · Grand Cayman, Burkina FasoMay 17, 1981 · N35803 · Destroyed NTSB ANC81FA037Accident · 4 fatalClosedPiper PA-31 · Galena, AKMar 27, 1981 · N66856 · Destroyed NTSB CHI81DA030Accident · No injuriesClosedPiper PA-31 · North Canton, OHFeb 25, 1981 · N74931 · Substantial damage NTSB LAX81FA045Accident · Serious injuriesClosedPiper PA-31 · Prescott, AZFeb 10, 1981 · N27661 · Substantial damage NTSB ATL81IA039Incident · No injuriesClosedPiper PA-31 · Baltimore, MDJan 28, 1981 · N400RA · 2 aircraft · Minor damage NTSB LAX80FVD06Accident · No injuriesClosedPiper PA-31 · Oakland, CAOct 31, 1980 · N62858 · Substantial damage NTSB LAX81OA021Accident · 2 fatalClosedPiper PA-31 · Magdelena, MexicoSep 30, 1980 · N3542X · Destroyed NTSB MIA80FA090Accident · 2 fatalClosedPiper PA-31 · Dania, FLAug 10, 1980 · N27906 · Destroyed NTSB FTW80AA057Accident · 7 fatalClosedPiper PA-31 · Houston, TXMar 21, 1980 · N59932 · Destroyed NTSB MIA80FA029Accident · Serious injuriesClosedPiper PA-31 · St.Croix, VIJan 18, 1980 · N25VM · Destroyed NTSB MIA80FA008Accident · 5 fatalClosedPiper PA-31 · Greenville, SCNov 2, 1979 · N66893 · Destroyed NTSB IAD79IA090Incident · No injuriesClosedPiper PA-31 · Morristown, NJSep 25, 1979 · N7697L · Minor damage NTSB CHI79DA066Accident · 1 fatalClosedPiper PA-31 · Bluffton, OHAug 23, 1979 · N27715 · Destroyed NTSB DEN79FA039Accident · 2 fatalClosedPiper PA-31 · Albuquerque, NMMay 13, 1979 · N54286 · Destroyed NTSB NYC79FA029Accident · 4 fatalClosedPiper PA-31 · Springfield, VTMar 10, 1979 · N27530 · Substantial damage NTSB FTW79DA053Accident · Serious injuriesClosedPiper PA-31 · Claude, TXFeb 23, 1979 · N61517 · Substantial damage NTSB NYC79FA017Accident · 5 fatalClosedPiper PA-31 · Templeton, MAJan 11, 1979 · N33TN · 2 aircraft · Destroyed NTSB NYC79FA044Accident · 3 fatalClosedPiper PA-31 · Saranac Lake, NYDec 25, 1978 · N114TA · Substantial damage NTSB MIA79FA010Accident · 1 fatalClosedPiper PA-31 · Missing AircraftNov 3, 1978 · N59912 · Destroyed NTSB IAD78IA112Incident · No injuriesClosedPiper PA-31 · Washington, DCSep 19, 1978 · N59911 · Minor damage NTSB NYC78FA095Accident · 2 fatalClosedPiper PA-31 · Granville, MASep 18, 1978 · N63731 · Destroyed NTSB UNK78X0134Accident · 10 fatalClosedPiper PA-31 · Las Vegas, NVAug 30, 1978 · N44LV · Destroyed NTSB IAD78IA080Incident · No injuriesClosedPiper PA-31 · Baltimore, MDJul 13, 1978 · N66892 · Minor damage NTSB FTW78FPG60Accident · Minor injuriesClosedPiper PA-31 · Mena, ARJul 12, 1978 · N404RC · Destroyed NTSB FTW78FPA24Accident · No injuriesClosedPiper PA-31 · Dallas, TXMay 17, 1978 · N27367 · Substantial damage NTSB NYC78FNAZ1Accident · No injuriesClosedPiper PA-31 · East Boston, MAMay 2, 1978 · N66860 · Substantial damage NTSB CHI78FA035Accident · 9 fatalClosedPiper PA-31 · Arlington, INApr 23, 1978 · N49MC · Destroyed NTSB ANC77FA090Accident · Serious injuriesClosedPiper PA-31B · Lke Minchumina, AKSep 24, 1977 · N103TA · Destroyed NTSB LAX77FA053Accident · 5 fatalClosedPiper PA-31 · Grand Canyon, AZJun 25, 1977 · N54727 · Destroyed NTSB NYC77FA045Accident · No injuriesClosedPiper PA-31 · Latrobe, PAApr 4, 1977 · N7694L · Substantial damage NTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYDec 4, 1976 · N59825 · 2 aircraft · Destroyed NTSB CHI77FA006Accident · 2 fatalClosedPiper PA-31 · Spring Lake, MINov 11, 1976 · N74941 · Destroyed NTSB IAD77FA008Accident · 4 fatalClosedPiper PA-31 · Hampton, VAOct 20, 1976 · N61436 · Destroyed NTSB DEN76AD072Accident · 2 fatalClosedPiper PA-31 · Pinon, NMSep 19, 1976 · N54294 · Destroyed NTSB IAD76II040Incident · No injuriesClosedPiper PA-31 · Chantilly, VANov 15, 1975 · N4FA · No damage NTSB MIA76AM028Accident · No injuriesClosedPiper PA-31 · Greenwood, SCSep 10, 1975 · N59982 · Substantial damage NTSB IAD76II010Incident · No injuriesClosedPiper PA-31 · Baltimore, MDAug 27, 1975 · N66873 · No damage NTSB FTW75HF073Accident · 1 fatalClosedPiper PA-31 · Guerra, TXFeb 11, 1975 · N61446 · Destroyed