NTSB investigations: Piper PA-32-260, IA
17 cases on aircraft the registry lists as Piper PA-32-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
| 1967 | 1 |
|---|---|
| 1968 | 3 |
| 1969 | 3 |
| 1971 | 2 |
| 1972 | 2 |
| 1978 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 2003 | 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 ('7103206'))
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 ('7103206'))
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 CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…NTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.NTSB MKC89LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Leon, IABlockage of the engine air induction system by a field mouse nest. The nest was positioned so that it could not be seen during the pre-flight inspection. It became dislodged during the takeoff roll on the rough runway.NTSB MKC83FA127Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Newton, IAThe non-instrument rated plt took off on a x-country flt at night. When advised of wx along his route, he requested & recieved radar advisories. A short time later, he reported that he was in a storm. For about 10 minutes, the radar controller was…NTSB MKC81IA031Incident · No injuriesClosedPiper PA-32 · St.Ansgar, IANTSB MKC78FA053Accident · 4 fatalClosedPiper PA-32 · Denison, IANTSB MKC73DCD31Accident · No injuriesClosedPiper PA-32 · Carroll, IANTSB MKC72FCD50Accident · No injuriesClosedPiper PA-32 · Mason City, IANTSB MKC71DCD72Accident · No injuriesClosedPiper PA-32 · Kingsley, IANTSB MKC71DCD59Accident · No injuriesClosedPiper PA-32 · Guthrie Cntr, IANTSB MKC70F0217Accident · No injuriesClosedPiper PA-32 · Carroll, IANTSB MKC70D0111Accident · No injuriesClosedPiper PA-32 · Eagle Grove, IANTSB MKC69F0344Accident · No injuriesClosedPiper PA-32 · Chariton, IANTSB MKC69A0002Accident · No injuriesClosedPiper PA-32 · Denison, IANTSB MKC69D0030Accident · No injuriesClosedPiper PA-32 · State Center, IANTSB MKC68D0464Accident · No injuriesClosedPiper PA-32 · Denison, IANTSB MKC68F0127Accident · No injuriesClosedPiper PA-32 · Des Moines, IA