Fatal NTSB investigations: Piper PA-25-260
16 cases on aircraft the registry lists as Piper PA-25-260. 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 per year
| 1970 | 2 |
|---|---|
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 2 |
| 1981 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 2015 | 1 |
Where
Open the mapLatest cases
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102508'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102508'))
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 WPR15FA250Accident · 1 fatalField investigationFinal reportPiper PA 25 · Llano, CAThe pilot's loss of airplane control during the landing approach due to an incapacitating medical event.NTSB NYC93FA166Accident · 1 fatalField investigationFinal reportPiper PA-25-260 · Plymouth, MAwas the failure of the pilot to attain proper alignment for the banner pickup which resulted in picking up the banner tow rope on the wing, and an inflight loss of control and uncontrolled contact with the ground.NTSB CHI93LA017Accident · 1 fatalLimited investigationFinal reportPiper PA-25-260 · Trenton, NDThe pilot's improper aircraft handling while maneuvering at low altitude.NTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.NTSB FTW88DQG05Accident · 1 fatalFinal reportPiper PA-25-260 · Stratford, TXWhile maneuvering during an aerial application flt, the pilot allowed the right wing to contact the ground. The aircraft was destroyed in the accident with fatal injuries to the pilot.NTSB MKC81FCJ16Accident · 1 fatalClosedPiper PA-25 · Beatrice, NENTSB DEN80FTE69Accident · 1 fatalClosedPiper PA-25 · Mosca, CONTSB FTW80FQG35Accident · 1 fatalClosedPiper PA-25 · Dumas, TXNTSB SEA78FYK07Accident · 1 fatalClosedPiper PA-25 · Christmas Vly, ORNTSB FTW77FQD28Accident · 1 fatalClosedPiper PA-25 · Coyanosa, TXNTSB FTW75FQG59Accident · 1 fatalClosedPiper PA-25 · Hereford, TXNTSB DEN75FQG07Accident · 1 fatalClosedPiper PA-25 · Clovis, NMNTSB FTW74FPA26Accident · 1 fatalClosedPiper PA-25 · Venus, TXNTSB SEA72FYG06Accident · 1 fatalClosedPiper PA-25 · Ephrata, WANTSB MKC71AK013Accident · 1 fatalClosedPiper PA-28 · Ewing, MONTSB MKC71FCJ14Accident · 1 fatalClosedPiper PA-25 · Minden, NE