NTSB investigations: Piper PA-28-140, IL

4 cases on aircraft the registry lists as Piper PA-28-140, where the first occurrence was “Loss of engine power”. 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

19822026
NTSB investigations: Piper PA-28-140, IL per year, 1982–2026: 4 cases
19821
19861
20011
20071

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\" = 'IL' 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\" = 350))
  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 CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…Jun 23, 2007 · N1768T · Substantial damageNTSB CHI01LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Albion, ILthe maintenance performed on the airplane by the unqualified pilot The unsuitable takeoff area selected by the pilot was an additional cause. The ditch was a contributing factor.Jul 2, 2001 · N1828T · Substantial damageNTSB CHI86LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Midlothian, ILThe acft was being operated on a student instructional flt. On initial run up the CFI stated he had an excessive mag drop that cleared up. The acft was flown to an adjacent field to make two touch and go landings. During the last takeoff the CFI suspected a…Apr 27, 1986 · N33822 · Substantial damageNTSB CHI83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Schaumburg, ILThe newly purchased aircraft had just been delivered and the pilot elected to fly it a short period to check its operation. He performed one takeoff and landing, then started another takeoff. He reported that during the second takeoff, the engine lost power…Nov 5, 1982 · N56311 · Substantial damage