NTSB investigations: Piper PA-25, FL

11 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 per year

19642026

NTSB investigations: Piper PA-25, FL per year, 1964–2026: 11 cases
1964	2
1966	1
1967	2
1971	1
1972	1
1974	1
1977	1
1981	1
2020	1

Where

Open the map

Latest cases

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."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 ('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.\"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 ('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."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 ('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 ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.Sep 23, 2020 · N6106Z · Destroyed NTSB MIA81DKJ11Accident · Minor injuriesClosedPiper PA-25 · Navarre, FLJun 30, 1981 · N6224Z · Substantial damage NTSB MIA77FKT74Accident · Minor injuriesClosedPiper PA25 · Boynton, FLSep 27, 1977 · N6162Z · Destroyed NTSB MIA75FLA09Accident · Minor injuriesClosedPiper PA-25 · Graceville, FLAug 17, 1974 · N6449Z · Destroyed NTSB MIA72FLA50Accident · Serious injuriesClosedPiper PA-25 · Live Oak, FLJun 9, 1972 · N6448Z · Substantial damage NTSB MIA72DLA02Accident · No injuriesClosedPiper PA-25 · Branford, FLJun 2, 1971 · N6448Z · Substantial damage NTSB MIA68A0027Accident · 1 fatalClosedPiper PA-25 · Taylorsville, FLSep 1, 1967 · N6251Z · Destroyed NTSB MIA67D0509Accident · No injuriesClosedPiper PA-25 · Dover, FLApr 3, 1967 · N6503Z · Substantial damage NTSB MIA67D0119Accident · No injuriesClosedPiper PA-25 · Sarasota, FLJul 28, 1966 · N6027Z · Substantial damage NTSB UNK64X4110Accident · No injuriesClosedPiper PA25 · Bartow, FLSep 23, 1964 · N6027Z · Substantial damage NTSB UNK64X1282Accident · No injuriesClosedPiper PA25 · Plant City, FLApr 12, 1964 · N6503Z · Substantial damage