NTSB investigations: Piper PA-28-140, AR

5 cases on aircraft the registry lists as Piper PA-28-140, 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 per year

19842026
NTSB investigations: Piper PA-28-140, AR per year, 1984–2026: 5 cases
19841
19871
19891
19911
19941

Latest cases

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.\"eventStateOrRegion\" = 'AR' 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 ('7102802')
      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 FTW94LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Russellville, ARVFR flight into IMC.Aug 20, 1994 · N41472 · Substantial damageNTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.Oct 22, 1991 · N4616R · Substantial damageNTSB MKC90LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pine Bluff, ARAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of power.Nov 11, 1989 · N95177 · Substantial damageNTSB MKC87LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, ARThe pilot fueled the aircraft with 20 gallons of 100LL for his flight to Hot Springs, AR. Forty miles from Hot Springs the left fuel tank indicated empty and the pilot switched to the right tank. Approximately 10 miles from Hot Springs, the engine quit and…Aug 26, 1987 · N5683U · Substantial damageNTSB MKC84LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Morrilton, ARThe acft lost power during initial climb after takeoff at about 75 ft AGL. A forced landing was made in the trees. The acft was examined after the accident and no failures or malfunctions noted. The existing temperature and dewpoint were in carburetor icing…Feb 27, 1984 · N56255 · Substantial damage