Skip to content

NTSB investigations: Piper PA-28-235, IL

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('7102810')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102810'))
  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.

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 ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN25LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Mount Vernon, ILThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a collision with terrain.Jan 20, 2025 · N8997W · Substantial damage NTSB CEN22LA135Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Monee, ILThe loss of engine power due to fuel starvation for undetermined reasons during a departure climb that resulted in a forced landing and impact with terrain.Mar 5, 2022 · N5078M · Substantial damage NTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.Jul 21, 2020 · N284M · Substantial damage NTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.May 31, 2020 · N8991W · Destroyed NTSB CEN19LA126Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Dwight, ILA partial loss of engine power due to a restriction in fuel flow for undetermined reasons.Apr 19, 2019 · N838JH · Substantial damage NTSB CHI07FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Wellington, ILSpatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…Nov 20, 2006 · N8990W · Destroyed NTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.Mar 2, 1997 · N9420W · Substantial damage NTSB CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.Nov 22, 1989 · N9465W · Destroyed NTSB CHI89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Monee, ILInadequate maintenance/inspection of the aircraft after metal fragments were found in the oil, and worn cam lobes/followers/piston pin plugs, which resulted in oil contamination, restriction (blockage) in the oil system, oil starvation, and subsequent engine…Mar 31, 1989 · N55191 · Substantial damage NTSB CHI81FCA07Accident · No injuriesClosedPiper PA-28 · Highland, ILMay 11, 1981 · N49887 · Substantial damage NTSB CHI79FEE53Accident · No injuriesClosedPiper PA-28 · Cherry, ILApr 25, 1979 · N5KS · Substantial damage NTSB CHI79FA035Accident · 2 fatalClosedPiper PA-28 · Park Forrest, ILMar 17, 1979 · N9458W · Destroyed NTSB CHI77DEV04Accident · No injuriesClosedPiper PA-28 · Keens, ILNov 23, 1976 · N8971W · Substantial damage NTSB CHI71DBD04Accident · No injuriesClosedPiper PA-28 · Northbrook, ILJul 10, 1970 · N8519W · Substantial damage NTSB CHI70F0152Accident · No injuriesClosedPiper PA-28 · Bunker Hill, ILAug 2, 1969 · N9178W · Substantial damage NTSB CHI69F0511Accident · Serious injuriesClosedPiper PA-28 · Monticello, ILSep 12, 1968 · N9114W · Substantial damage NTSB CHI68D0539Accident · No injuriesClosedPiper PA-28 · Roselle, ILDec 19, 1967 · N9105W · Substantial damage NTSB CHI68F0459Accident · No injuriesClosedPiper PA-28 · Canton, ILOct 23, 1967 · N9114W · Substantial damage NTSB CHI68D0107Accident · No injuriesClosedPiper PA-28 · Northbrook, ILMay 21, 1967 · N9175W · Substantial damage NTSB CHI67F0530Accident · Minor injuriesClosedPiper PA-28 · Chicago, ILJan 28, 1967 · N8887W · Substantial damage NTSB CHI66D0642Accident · No injuriesClosedPiper PA-28 · Lombard, ILFeb 26, 1966 · N9098W · Substantial damage NTSB CHI65A0071Accident · 3 fatalClosedPiper PA28 · El Paso, ILJan 31, 1965 · N8709W · Destroyed NTSB UNK64X2751Accident · No injuriesClosedPiper PA28 · Midlothian, ILJul 10, 1964 · N8694W · Substantial damage