NTSB investigations: Piper PA-28-140, WA
67 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\" = 'WA' 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" = 'WA' 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 SEA71FWG46Accident · Minor injuriesClosedPiper PA-28 · Creston, WANTSB SEA71DWG30Accident · No injuriesClosedPiper PA-28 · Royal City, WANTSB SEA71DWG13Accident · Minor injuriesClosedPiper PA-28 · Othello, WANTSB SEA71FWA13Accident · Minor injuriesClosedPiper PA-28 · Glenwood, WANTSB SEA70F0137Accident · Serious injuriesClosedPiper PA-28 · Bremerton, WANTSB SEA69F0040Accident · Serious injuriesClosedPiper PA-28 · Friday Harbr, WANTSB SEA68F0324Accident · No injuriesClosedPiper PA-28 · Bellevue, WANTSB SEA68F0212Accident · No injuriesClosedPiper PA-24 · Ocean Shores, WANTSB SEA68D0141Accident · No injuriesClosedPiper PA-28 · Yakima, WANTSB SEA68F0079Accident · No injuriesClosedPiper PA-28 · Kelso, WANTSB SEA68F0030Accident · Minor injuriesClosedPiper PA-28 · Nortgat Mall, WANTSB SEA68F0027Accident · Serious injuriesClosedPiper PA-28 · Port Orchard, WANTSB SEA67D0291Accident · No injuriesClosedPiper PA-28 · Cashmere, WANTSB SEA67D0246Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WANTSB SEA67F0244Accident · Minor injuriesClosedPiper PA-28 · Tacoma, WANTSB SEA67D0212Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WANTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WA