NTSB investigations: Piper PA-28-140, MA
100 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\" = 'MA' 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" = 'MA' 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 NYC73FNA09Accident · Serious injuriesClosedPiper PA-28 · Haverhill, MANTSB NYC73FNE02Accident · Minor injuriesClosedPiper PA-28 · Fitchburg, MANTSB NYC72FNA39Accident · No injuriesClosedPiper PA-28 · Brockton, MANTSB NYC72DNE33Accident · No injuriesClosedPiper PA-28 · Westboro, MANTSB NYC72FNA18Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC72FNA01Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC71FNA56Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC71DFD33Accident · No injuriesClosedPiper PA-28 · Mansfield, MANTSB NYC71DFD30Accident · No injuriesClosedPiper PA-28 · Plymouth, MANTSB NYC71DFD27Accident · Minor injuriesClosedPiper PA-28 · Beverly, MANTSB UNK71X0101Accident · No injuriesClosedPiper PA-28 · Taunton, MANTSB NYC71FFD17Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC71DFM09Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC71DFD04Accident · No injuriesClosedPiper PA-28 · New Bedford, MANTSB NYC71AN010Accident · 2 fatalClosedPiper PA-28 · Provincetown, MANTSB NYC70FFD08Accident · Minor injuriesClosedPiper PA-28 · Bedford, MANTSB NYC70DFD06Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC70FFD04Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC70DIF03Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC70A0052Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC70A0043Accident · 1 fatalClosedPiper PA-28 · So.Weymouth, MANTSB NYC70D0196Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC70D0202Accident · No injuriesClosedPiper PA-28 · Fitchburg, MANTSB NYC70A0032Accident · 1 fatalClosedPiper PA-28 · Sandisfield, MANTSB NYC70A0002Accident · 1 fatalClosedPiper PA-28 · Falmouth, MANTSB NYC69F0341Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC69D0290Accident · No injuriesClosedPiper PA-28 · Tewksbury, MANTSB NYC69D0255Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC69D0057Accident · No injuriesClosedPiper PA-28 · Pembroke, MANTSB NYC68F0345Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC68D0353Accident · No injuriesClosedPiper PA-28 · Fitchburg, MANTSB NYC68F0309Accident · Minor injuriesClosedPiper PA-28 · Danvers, MANTSB NYC68D0287Accident · No injuriesClosedPiper PA-28 · Chesterfield, MANTSB NYC68D0189Accident · No injuriesClosedPiper PA-28 · Hopedale, MANTSB NYC68D0181Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC68F0058Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC67F0668Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC67F0656Accident · Minor injuriesClosedPiper PA-28 · Norwood, MANTSB NYC67F0631Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC67D0621Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC67D0479Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC67D0427Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC67D0259Accident · No injuriesClosedPiper PA-28 · Barre, MANTSB NYC66F0553Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC66F0552Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC66F0389Accident · Minor injuriesClosedPiper PA-28 · Worcester, MANTSB NYC66F0327Accident · No injuriesClosedPiper PA-28 · Brookfield, MANTSB NYC66F0220Accident · No injuriesClosedPiper PA-28 · Gr Barringtn, MANTSB NYC66F0100Accident · No injuriesClosedPiper PA-28 · Taunton, MANTSB UNK64X4163Accident · No injuriesClosedPiper PA28 · Norwood, MA