NTSB investigations: Piper PA-28-140, MN

6 cases on aircraft the registry lists as Piper PA-28-140, where the first occurrence was “Loss of control - on ground/water”. 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

19872026
NTSB investigations: Piper PA-28-140, MN per year, 1987–2026: 6 cases
19871
19912
19941
20001
20041

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\" = 'MN' 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\" = 260))
  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 CHI04CA170Accident · No injuriesData collectionFinal reportPiper PA28-140 · Rush City, MNThe pilot's inadequate compensation for wind conditions which led to his loss of aircraft control. Factors were the wind gusts, the ditch, and the fence.Jul 5, 2004 · N55930 · Substantial damageNTSB CHI00LA308Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hallock, MNthe pilot not maintaining directional control of the airplane. Factors were the gusts, the crosswind weather conditions, and the ditch terrain condition.Sep 10, 2000 · N8319R · Substantial damageNTSB CHI94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hutchinson, MNthe pilot's failure to maintain directional control. Factors associated with the accident were the crosswind, the pilot's lack of total experience, the concrete block and the dirt back.Mar 9, 1994 · N6625W · Substantial damageNTSB CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.Jul 31, 1991 · N55924 · Substantial damageNTSB CHI91LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hibbing, MNThe student pilot's improper flare of the airplane and the cfi's failure to maintain directional control during the recovery. A factor was the soft terrain.Apr 25, 1991 · N95406 · Substantial damageNTSB CHI87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Duluth, MNRprtdly, the winds were prevailing from the northeast & were variable & gusty. The plt entered the traffic pattern to land on rwy 14, but aborted his 1st attempt. During the 2nd apch, he used a notch of flaps & corrected for the x-wind by slipping the acft…Jul 5, 1987 · N56808 · Substantial damage