Skip to content

NTSB investigations: Piper PA-25

281 cases on aircraft the registry lists as Piper PA-25. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102502')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102502'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102502'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW66F0105Accident · No injuriesClosedPiper PA-25 · Laredo, TXJun 21, 1965 · N6365Z · Substantial damage NTSB MKC66F0064Accident · No injuriesClosedPiper PA-25 · Scottsbluff, NEJun 18, 1965 · N6470Z · Substantial damage NTSB FTW66D0042Accident · No injuriesClosedPiper PA-25 · Howland, TXMay 21, 1965 · N6114Z · Substantial damage NTSB MIA65D0045Accident · No injuriesClosedPiper PA-25 · Trenton, TNApr 22, 1965 · N6208Z · Substantial damage NTSB DEN65D0066Accident · No injuriesClosedPiper PA-25 · Parker, AZApr 11, 1965 · N6317Z · Substantial damage NTSB UNK64X4213Accident · Minor injuriesClosedPiper PA25 · Aspermont, TXSep 30, 1964 · N6134Z · Destroyed NTSB UNK64X4110Accident · No injuriesClosedPiper PA25 · Bartow, FLSep 23, 1964 · N6027Z · Substantial damage NTSB UNK64X3929Accident · 1 fatalClosedPiper PA-25 · Hereford, TXSep 12, 1964 · N6481Z · Destroyed NTSB UNK64X3906Accident · Serious injuriesClosedPiper PA25 · Mclean, TXSep 10, 1964 · N6477Z · Destroyed NTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNAug 31, 1964 · N6276Z · Substantial damage NTSB UNK64X3555Accident · No injuriesClosedPiper PA25 · Columbia, LAAug 23, 1964 · N6080Z · Destroyed NTSB UNK64X3412Accident · No injuriesClosedPiper PA25 · Abilene, TXAug 16, 1964 · N6213Z · Substantial damage NTSB UNK64X3356Accident · Minor injuriesClosedPiper PA25 · Lemoore, CAAug 13, 1964 · N6235Z · Destroyed NTSB UNK64X3218Accident · Serious injuriesClosedPiper PA25 · Berlin, GAAug 4, 1964 · N11984 · Destroyed NTSB UNK64X3129Accident · Serious injuriesClosedPiper PA25 · Quanah, TXJul 30, 1964 · N6199Z · Destroyed NTSB UNK64X3122Accident · No injuriesClosedPiper PA25 · Martin, SCJul 30, 1964 · N6132Z · Substantial damage NTSB UNK64X2897Accident · No injuriesClosedPiper PA25 · Reserve, LAJul 18, 1964 · N6151Z · Substantial damage NTSB UNK64X2676Accident · Minor injuriesClosedPiper PA25 · Warden, WAJul 6, 1964 · N6100Z · Destroyed NTSB UNK64X2298Accident · No injuriesClosedPiper PA25 · Spearman, TXJun 15, 1964 · N6520Z · Substantial damage NTSB UNK64X2219Accident · No injuriesClosedPiper PA25 · Raymondville, TXJun 10, 1964 · N6201Z · Substantial damage NTSB UNK64X2153Accident · No injuriesClosedPiper PA25 · South Haven, MIJun 6, 1964 · N6388Z · Substantial damage NTSB UNK64X2051Accident · No injuriesClosedPiper PA25 · Bass Lake, INMay 31, 1964 · N6035Z · Substantial damage NTSB UNK64X1819Accident · No injuriesClosedPiper PA25 · Keiser, ARMay 18, 1964 · N6184Z · Destroyed NTSB UNK64X1801Accident · No injuriesClosedPiper PA25 · Preston, MDMay 17, 1964 · N6079Z · Substantial damage NTSB UNK64X1496Accident · No injuriesClosedPiper PA24 · Howard Lake, MNApr 28, 1964 · N6293Z · Substantial damage NTSB UNK64X1494Accident · No injuriesClosedPiper PA25 · Terrell, TXApr 28, 1964 · N6407Z · Substantial damage NTSB UNK64X1439Accident · No injuriesClosedPiper PA25 · Lonoke, ARApr 25, 1964 · N6010Z · Substantial damage NTSB UNK64X1282Accident · No injuriesClosedPiper PA25 · Plant City, FLApr 12, 1964 · N6503Z · Substantial damage NTSB UNK64X1135Accident · No injuriesClosedPiper PA25 · Claude, TXApr 2, 1964 · N6249Z · Substantial damage NTSB UNK64X0595Accident · No injuriesClosedPiper PA25 · Aspermont, TXFeb 17, 1964 · N6134Z · Substantial damage NTSB UNK64X0189Accident · Minor injuriesClosedPiper PA25 · Mendota, CAJan 8, 1964 · N6323Z · Substantial damage