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.
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" DESCRun 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 CHI76FEV05Accident · No injuriesClosedPiper PA-28 · Jacksonville, ILNTSB CHI75FEE69Accident · No injuriesClosedPiper PA-28 · Belvidere, ILNTSB CHI75DEV33Accident · No injuriesClosedPiper PA-28 · Loda, ILNTSB CHI75FEE66Accident · Serious injuriesClosedPiper PA-28 · Kankakee, ILNTSB CHI75AC078Accident · 2 fatalClosedPiper PA-28 · Trimble, ILNTSB CHI75AC068Accident · 2 fatalClosedPiper PA-28 · Concord, ILNTSB CHI75FEV24Accident · No injuriesClosedPiper PA-28 · Bloomington, ILNTSB CHI75DEV18Accident · No injuriesClosedPiper PA-28 · Bloomington, ILNTSB CHI75DEE31Accident · No injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI75FEE19Accident · Serious injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI75FEE01Accident · No injuriesClosedPiper PA-28 · West Chicago, ILNTSB CHI74AC098Accident · Serious injuriesClosedPiper PA-28 · Hampshire, ILNTSB CHI74AC097Accident · Minor injuriesClosedCessna 120 · Manito, ILNTSB CHI74DEE71Accident · No injuriesClosedPiper PA-28 · Sandwich, ILNTSB CHI74FEV42Accident · No injuriesClosedPiper PA-28 · Savoy, ILNTSB CHI74FEE61Accident · No injuriesClosedPiper PA-28 · Tonica, ILNTSB CHI74DEE54Accident · No injuriesClosedPiper PA-28 · Kankakee, ILNTSB CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILNTSB CHI74DEV25Accident · No injuriesClosedPiper PA-28 · Rowe, ILNTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILNTSB CHI74DEV19Accident · Minor injuriesClosedPiper PA-28 · Bloomington, ILNTSB CHI74FEV16Accident · Serious injuriesClosedPiper PA-28 · Mt Sterling, ILNTSB CHI74FEE12Accident · No injuriesClosedPiper PA-28 · Elburn, ILNTSB CHI74FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILNTSB CHI73FEE62Accident · Minor injuriesClosedPiper PA-28 · Naperville, ILNTSB CHI73FEV26Accident · Minor injuriesClosedPiper PA-28 · Springfield, ILNTSB CHI73DEE41Accident · No injuriesClosedPiper PA-28 · Joliet, ILNTSB CHI73FEE40Accident · No injuriesClosedPiper PA-28 · Elgin, ILNTSB CHI73DEE39Accident · No injuriesClosedPiper PA-28 · Lansing, ILNTSB CHI73FEE35Accident · No injuriesClosedPiper PA-28 · Northbrook, ILNTSB CHI73FEE31Accident · Minor injuriesClosedPiper PA-28 · Northbrook, ILNTSB CHI73DEE26Accident · No injuriesClosedPiper PA-28 · New Lenox, ILNTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILNTSB CHI73FEE04Accident · No injuriesClosedPiper PA-28 · Lansing, ILNTSB CHI72DEV28Accident · No injuriesClosedPiper PA-28 · Urbana, ILNTSB CHI72DEE68Accident · No injuriesClosedPiper PA-28 · Hinsdale, ILNTSB CHI72DEE67Accident · No injuriesClosedPiper PA-28 · Wheeling, ILNTSB CHI72DEE53Accident · No injuriesClosedPiper PA-28 · Beecher, ILNTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILNTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILNTSB CHI72FEE18Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI72FEE17Accident · Minor injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI72FEE15Accident · No injuriesClosedPiper PA-28 · Grayslake, ILNTSB CHI72FEE09Accident · 1 fatalClosedPiper PA-28 · Western Spgs, ILNTSB CHI72DEV05Accident · No injuriesClosedPiper PA-28 · Wapella, ILNTSB CHI71DEE91Accident · No injuriesClosedPiper PA-28 · Midlothian, ILNTSB CHI71FEE87Accident · Serious injuriesClosedPiper PA-28 · Morris, ILNTSB CHI71DEE83Accident · No injuriesClosedPiper PA-28 · Roselle, ILNTSB CHI71FCA05Accident · No injuriesClosedPiper PA-28 · Collinsville, ILNTSB CHI71DEE73Accident · No injuriesClosedPiper PA-28 · Lansing, IL