NTSB investigations: Piper PA-25-235, IA
20 cases on aircraft the registry lists as Piper PA-25-235. 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
| 1966 | 1 |
|---|---|
| 1968 | 2 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 2009 | 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.\"eventStateOrRegion\" = 'IA' 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 ('7102504'))
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" = 'IA' 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 ('7102504'))
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 CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.NTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…NTSB MKC83LA142Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Corning, IAThe acft crashed in a swamp during a forced landing after the engine seized. The pilot noted a lack of oil pressure and rising oil temperature. He dumped his load and began to return to land. The engine began to run rough and soon seized. Post accident…NTSB MKC81DCD29Accident · No injuriesClosedPiper PA-25 · Indianola, IANTSB MKC79DCD44Accident · No injuriesClosedPiper PA-25 · Lost Nation, IANTSB MKC77DCD32Accident · No injuriesClosedPiper PA-25 · Minden, IANTSB MKC77FCD27Accident · 1 fatalClosedPiper PA-25 · Woodbine, IANTSB MKC76DCD52Accident · No injuriesClosedPiper PA-25 · Tipton, IANTSB MKC76FCD12Accident · No injuriesClosedPiper PA-25 · Lenox, IANTSB MKC75FCD09Accident · No injuriesClosedPiper PA-25 · Storm Lake, IANTSB MKC74FCD40Accident · Minor injuriesClosedPiper PA-25 · Unionville, IANTSB MKC73DCD69Accident · No injuriesClosedPiper PA-25 · Mediapolis, IANTSB MKC73DCD53Accident · No injuriesClosedPiper PA-25 · Hornick, IANTSB MKC73DCD25Accident · No injuriesClosedPiper PA-25 · Rodes, IANTSB MKC72DCD23Accident · No injuriesClosedPiper PA-25 · Manchester, IANTSB MKC72DCD19Accident · No injuriesClosedPiper PA-25 · Olin, IANTSB MKC69D0350Accident · Minor injuriesClosedPiper PA-25 · Dubuque, IANTSB MKC69D0175Accident · No injuriesClosedPiper PA-25 · Onawa, IANTSB MKC69D0096Accident · Minor injuriesClosedPiper PA-25 · Nevada, IANTSB MKC67F0148Accident · Serious injuriesClosedPiper PA-25 · Blairstown, IA