NTSB investigations: Piper PA-28-140, IL

165 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, newest first

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'))
  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 CHI76FEV05Accident · No injuriesClosedPiper PA-28 · Jacksonville, ILJul 25, 1975 · N9602W · Substantial damageNTSB CHI75FEE69Accident · No injuriesClosedPiper PA-28 · Belvidere, ILJun 21, 1975 · N6398R · 2 aircraft · Minor damageNTSB CHI75DEV33Accident · No injuriesClosedPiper PA-28 · Loda, ILMay 31, 1975 · N7535R · Substantial damageNTSB CHI75FEE66Accident · Serious injuriesClosedPiper PA-28 · Kankakee, ILMay 23, 1975 · N4836T · Substantial damageNTSB CHI75AC078Accident · 2 fatalClosedPiper PA-28 · Trimble, ILApr 14, 1975 · N95243 · DestroyedNTSB CHI75AC068Accident · 2 fatalClosedPiper PA-28 · Concord, ILMar 19, 1975 · N15004 · DestroyedNTSB CHI75FEV24Accident · No injuriesClosedPiper PA-28 · Bloomington, ILMar 18, 1975 · N33312 · Substantial damageNTSB CHI75DEV18Accident · No injuriesClosedPiper PA-28 · Bloomington, ILJan 5, 1975 · N41789 · Substantial damageNTSB CHI75DEE31Accident · No injuriesClosedPiper PA-28 · Grayslake, ILNov 25, 1974 · N55617 · Substantial damageNTSB CHI75FEE19Accident · Serious injuriesClosedPiper PA-28 · Elgin, ILSep 5, 1974 · N1403T · Substantial damageNTSB CHI75FEE01Accident · No injuriesClosedPiper PA-28 · West Chicago, ILJul 14, 1974 · N15003 · Substantial damageNTSB CHI74AC098Accident · Serious injuriesClosedPiper PA-28 · Hampshire, ILJun 23, 1974 · N8282N · 2 aircraft · Substantial damageNTSB CHI74AC097Accident · Minor injuriesClosedCessna 120 · Manito, ILJun 18, 1974 · N1762N · 2 aircraft · DestroyedNTSB CHI74DEE71Accident · No injuriesClosedPiper PA-28 · Sandwich, ILApr 26, 1974 · N459FL · Substantial damageNTSB CHI74FEV42Accident · No injuriesClosedPiper PA-28 · Savoy, ILMar 27, 1974 · N8710N · Substantial damageNTSB CHI74FEE61Accident · No injuriesClosedPiper PA-28 · Tonica, ILMar 17, 1974 · N15533 · Substantial damageNTSB CHI74DEE54Accident · No injuriesClosedPiper PA-28 · Kankakee, ILFeb 16, 1974 · N7443R · Substantial damageNTSB CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILDec 12, 1973 · N5796F · Substantial damageNTSB CHI74DEV25Accident · No injuriesClosedPiper PA-28 · Rowe, ILOct 24, 1973 · N6762W · Substantial damageNTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILSep 30, 1973 · N8225N · Substantial damageNTSB CHI74DEV19Accident · Minor injuriesClosedPiper PA-28 · Bloomington, ILSep 7, 1973 · N2341T · Substantial damageNTSB CHI74FEV16Accident · Serious injuriesClosedPiper PA-28 · Mt Sterling, ILSep 2, 1973 · N98013 · Substantial damageNTSB CHI74FEE12Accident · No injuriesClosedPiper PA-28 · Elburn, ILAug 12, 1973 · N8863N · Substantial damageNTSB CHI74FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILJul 21, 1973 · N7261F · Substantial damageNTSB CHI73FEE62Accident · Minor injuriesClosedPiper PA-28 · Naperville, ILJun 3, 1973 · N8014N · Substantial damageNTSB CHI73FEV26Accident · Minor injuriesClosedPiper PA-28 · Springfield, ILApr 29, 1973 · N8719N · Substantial damageNTSB CHI73DEE41Accident · No injuriesClosedPiper PA-28 · Joliet, ILJan 20, 1973 · N1786T · Substantial damageNTSB CHI73FEE40Accident · No injuriesClosedPiper PA-28 · Elgin, ILJan 7, 1973 · N1403T · Substantial damageNTSB CHI73DEE39Accident · No injuriesClosedPiper PA-28 · Lansing, ILJan 4, 1973 · N7261F · Substantial damageNTSB CHI73FEE35Accident · No injuriesClosedPiper PA-28 · Northbrook, ILDec 14, 1972 · N5393S · Substantial damageNTSB CHI73FEE31Accident · Minor injuriesClosedPiper PA-28 · Northbrook, ILNov 21, 1972 · N1790T · Substantial damageNTSB CHI73DEE26Accident · No injuriesClosedPiper PA-28 · New Lenox, ILOct 15, 1972 · N4408J · Substantial damageNTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILSep 3, 1972 · N5677U · Substantial damageNTSB CHI73FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILJul 8, 1972 · N7346J · Substantial damageNTSB CHI72DEV28Accident · No injuriesClosedPiper PA-28 · Urbana, ILApr 17, 1972 · N4393J · Substantial damageNTSB CHI72DEE68Accident · No injuriesClosedPiper PA-28 · Hinsdale, ILMar 19, 1972 · N5796F · Substantial damageNTSB CHI72DEE67Accident · No injuriesClosedPiper PA-28 · Wheeling, ILMar 11, 1972 · N1862J · Substantial damageNTSB CHI72DEE53Accident · No injuriesClosedPiper PA-28 · Beecher, ILJan 11, 1972 · N537FL · Substantial damageNTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILOct 9, 1971 · N6597W · 2 aircraft · Substantial damageNTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILSep 1, 1971 · N5875U · Substantial damageNTSB CHI72FEE18Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILAug 22, 1971 · N6652W · Substantial damageNTSB CHI72FEE17Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILAug 22, 1971 · N8415R · Substantial damageNTSB CHI72FEE15Accident · No injuriesClosedPiper PA-28 · Grayslake, ILAug 16, 1971 · N5691U · Substantial damageNTSB CHI72FEE09Accident · 1 fatalClosedPiper PA-28 · Western Spgs, ILJul 28, 1971 · N98008 · DestroyedNTSB CHI72DEV05Accident · No injuriesClosedPiper PA-28 · Wapella, ILJul 24, 1971 · N8242N · Substantial damageNTSB CHI71DEE91Accident · No injuriesClosedPiper PA-28 · Midlothian, ILJun 27, 1971 · N8225N · Substantial damageNTSB CHI71FEE87Accident · Serious injuriesClosedPiper PA-28 · Morris, ILJun 21, 1971 · N9613W · Substantial damageNTSB CHI71DEE83Accident · No injuriesClosedPiper PA-28 · Roselle, ILJun 3, 1971 · N9782W · Substantial damageNTSB CHI71FCA05Accident · No injuriesClosedPiper PA-28 · Collinsville, ILMay 6, 1971 · N4538R · Substantial damageNTSB CHI71DEE73Accident · No injuriesClosedPiper PA-28 · Lansing, ILMay 6, 1971 · N95472 · Substantial damage