Fatal NTSB investigations: Piper PA-28-140, IL

12 cases on aircraft the registry lists as Piper PA-28-140. 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

19692026
Fatal NTSB investigations: Piper PA-28-140, IL per year, 1969–2026: 12 cases
19691
19702
19712
19753
19772
19811
20261

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.\"highestInjuryLevel\" = 'Fatal'
    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'))
  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 CEN26FA141Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Rock Falls, ILOn March 20, 2026, about 1503 central daylight time, a Piper PA-28-140 airplane, N9913W, was destroyed when it was involved in an accident near Rock Falls, Illinois. The student pilot sustained fatal injuries. The airplane was being operated as a Title 14…Mar 20, 2026 · N9913W · DestroyedNTSB CHI81FA086Accident · 3 fatalClosedPiper PA-28 · Altamont, ILAug 12, 1981 · N4565X · DestroyedNTSB CHI77FEE32Accident · 2 fatalClosedPiper PA-28 · Wadsworth, ILJul 18, 1977 · N6899J · DestroyedNTSB CHI77FA034Accident · 1 fatalClosedPiper PA-28 · Chicago, ILMar 6, 1977 · N40922 · DestroyedNTSB CHI76AC022Accident · 2 fatalClosedPiper PA-28 · Orland Park, ILSep 6, 1975 · N5968U · 2 aircraft · DestroyedNTSB CHI75AC078Accident · 2 fatalClosedPiper PA-28 · Trimble, ILApr 14, 1975 · N95243 · DestroyedNTSB CHI75AC068Accident · 2 fatalClosedPiper PA-28 · Concord, ILMar 19, 1975 · N15004 · DestroyedNTSB CHI72FEE09Accident · 1 fatalClosedPiper PA-28 · Western Spgs, ILJul 28, 1971 · N98008 · DestroyedNTSB CHI71FBD65Accident · 1 fatalClosedPiper PA-28 · Kewanee, ILApr 19, 1971 · N6418R · Substantial damageNTSB CHI71AC042Accident · 3 fatalClosedPiper PA-28 · Effingham, ILDec 17, 1970 · N4253J · DestroyedNTSB CHI71AC016Accident · 4 fatalClosedPiper PA-28 · Manteno, ILAug 22, 1970 · N5684U · DestroyedNTSB CHI70F0111Accident · 1 fatalClosedPiper PA-28 · Grayslake, ILJun 17, 1969 · N6788W · Destroyed