NTSB investigations: Piper PA-24-250

63 cases on aircraft the registry lists as Piper PA-24-250, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 ('7102404')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
  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.

NTSB MIA87LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Meridian, MSThe pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and…Mar 14, 1987 · N6290P · Substantial damageNTSB SEA86LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fallon, NVWhile on final apch to the arpt, the acft's eng ceased operating due to fuel exhaustion. The acft was damaged during a hard forced landing on a baseball fld.Mar 31, 1986 · N6282P · DestroyedNTSB FTW85LA326Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Farmerville, LAThe plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…Aug 20, 1985 · N8050P · Substantial damageNTSB SEA85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mccall, IDThe acft was damaged during a forced landing in a fld following fuel exhaustion. The plt reported he departed yellow pine, ID, with the fuel gages indicating 1/2. Upon reaching an alt of 10,000 ft, the eng quit due to fuel exhaustion. The right fuel tank was…Jul 5, 1985 · N5829P · Substantial damageNTSB MIA85LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fellsmere, FLThe acft made a forced landing due to fuel exhaustion in an open field. On the landing roll, the nosewheel struck a ditch causing it to fold and the acft came to a stop resting on it's nose. The plt had determined the amount of fuel on board prior to takeoff…Apr 19, 1985 · N5836P · Substantial damageNTSB LAX85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Essex, CAThe plt reported that he visually checked the quantity of fuel in the acft's fuel tanks prior to departure & that he apparently overestimated the amount in the tanks. Following the accident the plt reported that he opened the fuel caps to both tanks & they…Oct 7, 1984 · N6481P · Substantial damageNTSB ATL84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Vicksburg, MSThe acft landed short of the rwy during a forced landing after the engine lost power during cruise flt. The plt reportedthat power was lost at 2000 ft 10 miles north of Vicksburg. He applied the fuel boost pump and successfully restarted the eng but it quit…Oct 6, 1983 · N7691P · Substantial damageNTSB MKC83LA176Accident · No injuriesLimited investigationFinal reportPiper PA-24-235 · Alliance, NEThe pilot stated that he departed oshrosh for scottsbluff with an estimated 80 gallons of fuel on board the air craft his ete was 4 hours 30 minutes and fuel consumption at 15 gph. Aprx 37 NM short of scotts bluff he noticed the right fuel gauge indicating…Aug 5, 1983 · N777EE · Substantial damageNTSB NYC83FA107Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Coram, NYThe acft crashed shortly after declaring an 'emergency.' A witness saw the acft, but heard no eng sound prior to the crash. Examination of eng failed to reveal any discrepancies. However, when the carburetor was examined no fuel was found in the line between…May 1, 1983 · N5738P · DestroyedNTSB NYC82DA226Accident · No injuriesFinal reportPiper PA-24 · Erie, PAThe aircraft was on final approach for landing when the engine lost power. The power loss occurred when the plane was about 40 to 50 ft AGL and 1/4 mile from the runway. The plane touched down short of the runway and collided with approach lights. After…Sep 18, 1982 · N6253P · Substantial damageNTSB LAX82FA308Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Los Angeles, CAThe flt departed santa monica at 0830 for a local flt. At 0926 the plt called from downtown Los Angeles for landing at santa monica. At 9028 the plt 3 mi east of a VFR reporting point with eng trouble & that he had to come down. The acft wing struck the roof…Aug 22, 1982 · N6825P · DestroyedNTSB DEN82FA075Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Wheatland, WYThe acft struck a tree approximately 1/2 mi from the approach end of rwy 08. No fuel was on board the acft. The gear were down & the flaps were in the 10 deg position.May 1, 1982 · N6695P · DestroyedNTSB FTW82DA037Accident · Serious injuriesFinal reportPiper PA-24-250 · Lonoke, ARThe pilot stated that the engine failed at 2000 ft as he was descending for an approach. He switched the fuel selector from the right tank to the left tank, turned on the boost pump, and pumped the throttle but the engine failed to start. The aircraft landed…Jan 5, 1982 · N5304P · Substantial damage