Skip to content

NTSB investigations: Piper PA-32R-300

301 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, 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 ('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.\"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."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 DEN84LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rawlins, WYThe plt stated that the approach into Rawlins was normal but while on short final he realized that the acft was too low. The acft was actually lower then the runway which is located on a plateau. He attempted to correct but lost airspeed and landed short. The…Nov 30, 1983 · N5802V · Substantial damage NTSB ATL84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Columbia, SCWhile en route, the acft's ammeter went to a zero reading, and subsequently, a complete electrical failure occurred. Prior to landing, the plt attempted to lower the landing gear by letting it freefall, in accordance with recommended procedures. The gear…Nov 7, 1983 · N1750H · Substantial damage NTSB CHI84LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ypsilanti, MIThe acft was struck by a truck as it taxied on the ramp after landing. The fire department reported the truck left a 25 ft skid mark as it came out from an area of parked acft and struck N47519.Oct 6, 1983 · N47519 · Substantial damage NTSB MIA83IA239Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Orlando, FLAcft made an intentional gear up landing after both normal & emergency procedures failed to lower the gear. It was determined that the hydraulic pump motor had failed. Normal & emergency systems were interdependent. The emergency gear diaphragm was blocked by…Sep 25, 1983 · N301WA · Minor damage NTSB ATL83FA270Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Cynthiana, KYThe acft crashed during a forced landing after an engine failure. The acft was cruising at 6000 ft MSL when the engine quit. The pilots set up a glide for Cynthiana/harrison arpt while trying to restart the engine. When it became apparent that they could not…Jul 12, 1983 · N6866J · Substantial damage NTSB MIA83FA180Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Islamorada, FLThe acft was ditched in the Florida bay after the engine malfunctioned. According to the plt, the eng started to run rough and he ditched the acft at about 0600 EDT. However, the acft clock was stopped at 0345 and a commercial fisherman said he saw a low…Jul 11, 1983 · N6207J · Destroyed NTSB MIA83LA084Accident · 1 fatalLimited investigationFinal reportPiper PA-32R · Cross City, FLThe acft collided with trees during a night landing on a lonely stretch of country road. The landing was an attempt to unload 662 pounds of marijuana in an illegal drug operation.a passenger was fatally injured and the injured pilot was found later in the…Mar 1, 1983 · N3898F · Destroyed NTSB NYC83LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Quakertown, PAThe acft touched down about 1 ft short of the rwy. The left gear & wing was damaged.Feb 28, 1983 · N38389 · Substantial damage NTSB CHI83LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ely, MNAbout 2 min after takeoff, at about 1,000 ft AGL, the eng siezed. The plt then glided onto a frozen lake. The acft did not have a current annual inspection. The last oil change recorded was during the annual on 7/15/81. Engine teardown revealed severe…Feb 25, 1983 · N38855 · Substantial damage NTSB SEA83LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Gustavus, AKThe pilot reported that slush accumulation on the runway prevented the aircraft from reaching takeoff speed. He aborted the takeoff and with braking action "nil" slid off the end of the runway. Gustavus airport is owned and operated by the state of Alaska and…Nov 26, 1982 · N6104J · Substantial damage NTSB FTW82DA335Accident · No injuriesFinal reportPiper PA-32R-300 · Alexandria, LAThe purpose of the flight was to prepare the pilot in the left seat for a commercial flight rating. After a power-off descent from 4000 ft to 2000 ft, the instructor gave the student a simulated forced landing. Reportedly, the throttle was opened briefly at…Aug 17, 1982 · N7744C · Substantial damage NTSB ATL82FLT04Accident · 3 fatalFinal reportPiper PA-32R-300 · Iuka, MSThe aircraft crashed during a pass across the airport. A witness was parked, facing east, in the runup area for runway 18. According to him, the the aircraft took off about 6 minutes earlier, made a traffic pattern, and crashed behind and to his right. The…May 11, 1982 · N444ME · Destroyed NTSB MIA82DA091Accident · No injuriesFinal reportPiper PA-32R · Moca, PRThe pilot landed on an unlighted grass strip at night with a load of marijuana. During the landing, the plane continued off the strip and into a sugar cane field.Apr 1, 1982 · N309MJ · Substantial damage NTSB NYC82FNA12Accident · Serious injuriesFinal reportPiper PA-32R · Rochester, MAThe pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An…Mar 29, 1982 · N1104Q · Substantial damage NTSB LAX82DVG19Accident · No injuriesFinal reportPiper PA-32R · Brownsville, CAThe pilot stated that the aircraft did not touchdown until halfway down the runway and he then applied too much left brake resulting in the aircraft running off the left side of the runway. Before coming to a stop the left landing gear collapsed.Mar 21, 1982 · N38795 · Destroyed NTSB ATL82FA047Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Lambsburg, VAThe aircraft was on an air taxi flight to transport 2 prisoners and was to be operated on a VFR flight plan in VFR conditions only. Prior to takeoff, the pilot had obtained 12 weather briefing. In 2 of the briefings, VFR flight was not recommended. At about…Feb 5, 1982 · N75225 · Destroyed NTSB ATL81FLG01Accident · Minor injuriesClosedPiper PA-23 · Georgetown, SCNov 12, 1981 · N221CS · Destroyed NTSB NYC82DHA02Accident · No injuriesClosedPiper PA-32R · Princeton, NJOct 22, 1981 · N38205 · Substantial damage NTSB ATL81FLQ20Accident · Serious injuriesClosedPiper PA-32R · Paducah, KYJul 24, 1981 · N2289Q · Substantial damage NTSB ATL81FKM14Accident · Serious injuriesClosedPiper PA-32R · Asheville, NCJul 13, 1981 · N17123 · Substantial damage NTSB MIA81FA094Accident · 3 fatalClosedPiper PA-32R · Naples, FLJul 11, 1981 · N6074H · Destroyed NTSB ATL81FA087Accident · 4 fatalClosedPiper PA-32R · Vicksburg, MSJul 1, 1981 · N3570Q · Destroyed NTSB SEA81DYA14Accident · No injuriesClosedPiper PA-32R · Stanley, IDJun 20, 1981 · N3402Q · Substantial damage NTSB MIA81DLD46Accident · Minor injuriesClosedPiper PA-32R · Groveland, FLMay 22, 1981 · N1887H · Substantial damage NTSB LAX81FVD16Accident · No injuriesClosedPiper PA-32R · Petaluma, CAMar 11, 1981 · N102EA · Substantial damage NTSB MKC81DCQ14Accident · No injuriesClosedPiper PA-32R · Osborne, KSFeb 22, 1981 · N6168H · Substantial damage NTSB CHI81FA027Accident · 1 fatalClosedPiper PA-32 · Loganspopt, INFeb 18, 1981 · N4341F · Destroyed NTSB MIA81FA046Accident · 5 fatalClosedPiper PA-32R · El Duque, PRFeb 16, 1981 · N7272F · Destroyed NTSB CHI81FEC07Accident · No injuriesClosedPiper PA-32R · Belleville, MIDec 20, 1980 · N5421F · Substantial damage NTSB FTW81FA017Accident · 2 fatalClosedPiper PA-32R · Hagarville, ARDec 14, 1980 · N12ML · Destroyed NTSB MIA81FA004Accident · 1 fatalClosedPiper PA-32R · Weeki Wachee, FLOct 19, 1980 · N1714H · Destroyed NTSB MKC81FCG04Accident · No injuriesClosedPiper PA-32R · Ozark, MOOct 15, 1980 · N7698C · Substantial damage NTSB ATL80IA089Incident · No injuriesClosedPiper PA-32 · Raeford, NCSep 3, 1980 · N2252Q · Minor damage NTSB CHI80FET26Accident · No injuriesClosedPiper PA-32R · Syracuse, INAug 18, 1980 · N1321H · Substantial damage NTSB CHI80FEC22Accident · Serious injuriesClosedPiper PA-32R · Troy, MIJul 10, 1980 · N7113F · Destroyed NTSB ANC80FA061Accident · Serious injuriesClosedPiper PA-32R · Fairbanks, AKJul 8, 1980 · N108NS · 2 aircraft · Substantial damage NTSB LAX80FUJ52Accident · 2 fatalClosedPiper PA-32R · Needles, CAMay 1, 1980 · N38352 · Destroyed NTSB FTW80FRA22Accident · No injuriesClosedPiper PA-32R · Houston, TXApr 2, 1980 · N43829 · Substantial damage NTSB MIA80FA042Accident · 5 fatalClosedPiper PA-32R · Ocala, FLMar 6, 1980 · N2543Q · Destroyed NTSB IAD80FLJ10Accident · No injuriesClosedPiper PA-32R · Redford, NCMar 3, 1980 · N2252Q · Substantial damage NTSB LAX80FA114Accident · 2 fatalClosedPiper PA-32R · Safford, AZDec 20, 1979 · N9877K · Destroyed NTSB MIA80FA014Accident · 4 fatalClosedPiper PA-32R · Anniston, ALNov 25, 1979 · N5RJ · Destroyed NTSB CHI79AA082Accident · 5 fatalClosedPiper PA-32R · Indianapolis, INSep 28, 1979 · N8425C · Destroyed NTSB NYC79FGM48Accident · No injuriesClosedPiper PA-32 · Erie, PASep 24, 1979 · N6838J · Substantial damage NTSB CHI79FEE78Accident · Minor injuriesClosedPiper PA-32R · West Chicago, ILAug 2, 1979 · N2654Q · Substantial damage NTSB CHI79FEP47Accident · No injuriesClosedPiper PA-32R · Burlington, WIJun 6, 1979 · N1134Q · 2 aircraft · Substantial damage NTSB LAX79DUJ78Accident · No injuriesClosedPiper PA-32R · Long Mesa, AZJun 1, 1979 · N6581F · Substantial damage NTSB NYC79FNC23Accident · No injuriesClosedPiper PA-32R · New London, NHApr 17, 1979 · N1982H · Substantial damage NTSB CHI79FEX19Accident · No injuriesClosedPiper PA-32R · Mooresville, INApr 5, 1979 · N56GS · Substantial damage NTSB LAX79FUJ56Accident · No injuriesClosedPiper PA-32R · Douglas, AZMar 12, 1979 · N9636K · Substantial damage