NTSB investigations: Piper PA-24-250, FL
88 cases on aircraft the registry lists as Piper PA-24-250. 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\" = 'FL' 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 ('7102404'))
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" = 'FL' 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 ('7102404'))
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 MIA72FLD72Accident · No injuriesClosedPiper PA-24 · Lakeland, FLNTSB MIA72AM053Accident · 2 fatalClosedPiper PA-24 · Lamont, FLNTSB MIA72FLD07Accident · No injuriesClosedPiper PA-24 · Sarasota, FLNTSB MIA71AM030Accident · No injuriesClosedPiper PA-24 · Pensacola, FLNTSB MIA71FLD12Accident · No injuriesClosedPiper PA-24 · St Petersburg, FLNTSB MIA70DKT25Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLNTSB MIA70AM078Accident · 2 fatalClosedPiper PA-24 · Green Cove Sp, FLNTSB MIA70DLD22Accident · No injuriesClosedPiper PA-24 · Tampa, FLNTSB MIA70AM058Accident · 2 fatalClosedPiper PA-24 · Clearwater, FLNTSB MIA69F0462Accident · Minor injuriesClosedPiper PA-24 · Brooksville, FLNTSB MIA69F0387Accident · No injuriesClosedPiper PA-24 · Tampa, FLNTSB MIA69F0008Accident · No injuriesClosedPiper PA-24 · Cedar Key, FLNTSB MIA68F0076Accident · No injuriesClosedPiper PA-24 · Destin, FLNTSB MIA67F0390Accident · No injuriesClosedPiper PA-24 · Ft Lauderdale, FLNTSB MIA67F0468Accident · No injuriesClosedPiper PA-24 · Pensacola, FLNTSB MIA67F0289Accident · No injuriesClosedPiper PA-24 · Nna Maria, FLNTSB MIA67A0009Accident · No injuriesClosedPiper PA-24 · Pensacola, FLNTSB MIA67F0201Accident · No injuriesClosedPiper PA-24 · Jacksonville, FLNTSB MIA66F0571Accident · No injuriesClosedPiper PA-24 · St.Petersburg, FLNTSB MIA66F0531Accident · No injuriesClosedPiper PA-24 · Pierson, FLNTSB MIA66F0499Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLNTSB MIA66F0379Accident · No injuriesClosedPiper PA-24 · Orlando, FLNTSB MIA66D0283Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLNTSB MIA66F0267Accident · No injuriesClosedPiper PA-24 · Gainesville, FLNTSB MIA66D0206Accident · No injuriesClosedPiper PA-24 · W Palm Beach, FLNTSB MIA66F0116Accident · No injuriesClosedPiper PA-24 · Tampa, FLNTSB MIA66F0085Accident · No injuriesClosedPiper PA-24 · Clearwater, FLNTSB MIA66F0016Accident · No injuriesClosedPiper PA-24 · Panama City, FLNTSB MIA65F0017Accident · No injuriesClosedPiper PA-24 · Ft Meyers, FLNTSB UNK65X1411Accident · No injuriesClosedPiper PA24 · Daytona Beach, FLNTSB UNK65X1395Accident · No injuriesClosedPiper PA24 · Lakeland, FLNTSB MIA65A0071Accident · 4 fatalClosedPiper PA24 · Aripeka, FLNTSB UNK65X1061Accident · No injuriesClosedPiper PA24 · Bunnell, FLNTSB UNK65X0733Accident · No injuriesClosedPiper PA24 · Lake City, FLNTSB UNK65X0668Accident · No injuriesClosedPiper PA24 · Ft Lauderdale, FLNTSB UNK64X3809Accident · Serious injuriesClosedPiper PA24 · Wauchula, FLNTSB UNK64X2379Accident · No injuriesClosedPiper PA24 · Melbourne, FLNTSB UNK64X0777Accident · No injuriesClosedPiper PA24 · Orlando, FL