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.

NTSB MIA72FLD72Accident · No injuriesClosedPiper PA-24 · Lakeland, FLMay 27, 1972 · N6381P · Substantial damageNTSB MIA72AM053Accident · 2 fatalClosedPiper PA-24 · Lamont, FLDec 7, 1971 · N7867P · DestroyedNTSB MIA72FLD07Accident · No injuriesClosedPiper PA-24 · Sarasota, FLAug 22, 1971 · N6276P · Substantial damageNTSB MIA71AM030Accident · No injuriesClosedPiper PA-24 · Pensacola, FLSep 11, 1970 · N8316P · Substantial damageNTSB MIA71FLD12Accident · No injuriesClosedPiper PA-24 · St Petersburg, FLAug 25, 1970 · N7934P · Substantial damageNTSB MIA70DKT25Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLJun 3, 1970 · N7392P · Substantial damageNTSB MIA70AM078Accident · 2 fatalClosedPiper PA-24 · Green Cove Sp, FLMar 28, 1970 · N6929P · DestroyedNTSB MIA70DLD22Accident · No injuriesClosedPiper PA-24 · Tampa, FLMar 21, 1970 · N7149P · Substantial damageNTSB MIA70AM058Accident · 2 fatalClosedPiper PA-24 · Clearwater, FLJan 18, 1970 · N7301P · DestroyedNTSB MIA69F0462Accident · Minor injuriesClosedPiper PA-24 · Brooksville, FLMar 15, 1969 · N7122P · DestroyedNTSB MIA69F0387Accident · No injuriesClosedPiper PA-24 · Tampa, FLJan 31, 1969 · N7984P · Substantial damageNTSB MIA69F0008Accident · No injuriesClosedPiper PA-24 · Cedar Key, FLApr 30, 1968 · N5231P · Substantial damageNTSB MIA68F0076Accident · No injuriesClosedPiper PA-24 · Destin, FLJul 15, 1967 · N7347P · Substantial damageNTSB MIA67F0390Accident · No injuriesClosedPiper PA-24 · Ft Lauderdale, FLFeb 4, 1967 · N8156P · Substantial damageNTSB MIA67F0468Accident · No injuriesClosedPiper PA-24 · Pensacola, FLDec 14, 1966 · N6992P · Substantial damageNTSB MIA67F0289Accident · No injuriesClosedPiper PA-24 · Nna Maria, FLNov 6, 1966 · N7929P · Substantial damageNTSB MIA67A0009Accident · No injuriesClosedPiper PA-24 · Pensacola, FLJul 16, 1966 · N6394P · Substantial damageNTSB MIA67F0201Accident · No injuriesClosedPiper PA-24 · Jacksonville, FLJul 8, 1966 · N6148P · Substantial damageNTSB MIA66F0571Accident · No injuriesClosedPiper PA-24 · St.Petersburg, FLMay 17, 1966 · N8387P · Substantial damageNTSB MIA66F0531Accident · No injuriesClosedPiper PA-24 · Pierson, FLApr 15, 1966 · N5385P · Substantial damageNTSB MIA66F0499Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLMar 20, 1966 · N354PC · Substantial damageNTSB MIA66F0379Accident · No injuriesClosedPiper PA-24 · Orlando, FLDec 22, 1965 · N8387P · Substantial damageNTSB MIA66D0283Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLOct 13, 1965 · N354PC · Substantial damageNTSB MIA66F0267Accident · No injuriesClosedPiper PA-24 · Gainesville, FLSep 15, 1965 · N5481P · Substantial damageNTSB MIA66D0206Accident · No injuriesClosedPiper PA-24 · W Palm Beach, FLAug 3, 1965 · N6061P · Substantial damageNTSB MIA66F0116Accident · No injuriesClosedPiper PA-24 · Tampa, FLJul 30, 1965 · N8351P · Substantial damageNTSB MIA66F0085Accident · No injuriesClosedPiper PA-24 · Clearwater, FLJul 11, 1965 · N5443P · Substantial damageNTSB MIA66F0016Accident · No injuriesClosedPiper PA-24 · Panama City, FLMay 27, 1965 · N7796P · Substantial damageNTSB MIA65F0017Accident · No injuriesClosedPiper PA-24 · Ft Meyers, FLMar 12, 1965 · N8053P · Substantial damageNTSB UNK65X1411Accident · No injuriesClosedPiper PA24 · Daytona Beach, FLFeb 8, 1965 · N8408P · Substantial damageNTSB UNK65X1395Accident · No injuriesClosedPiper PA24 · Lakeland, FLFeb 5, 1965 · N7745P · Substantial damageNTSB MIA65A0071Accident · 4 fatalClosedPiper PA24 · Aripeka, FLJan 3, 1965 · N7418P · DestroyedNTSB UNK65X1061Accident · No injuriesClosedPiper PA24 · Bunnell, FLDec 19, 1964 · N6407P · Substantial damageNTSB UNK65X0733Accident · No injuriesClosedPiper PA24 · Lake City, FLNov 16, 1964 · N7796P · Substantial damageNTSB UNK65X0668Accident · No injuriesClosedPiper PA24 · Ft Lauderdale, FLNov 12, 1964 · N5504P · Substantial damageNTSB UNK64X3809Accident · Serious injuriesClosedPiper PA24 · Wauchula, FLSep 5, 1964 · N5350P · DestroyedNTSB UNK64X2379Accident · No injuriesClosedPiper PA24 · Melbourne, FLJun 19, 1964 · N5569P · Substantial damageNTSB UNK64X0777Accident · No injuriesClosedPiper PA24 · Orlando, FLMar 1, 1964 · N7684P · Substantial damage