NTSB investigations: Piper PA-32-260, IN
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
| 1966 | 1 |
|---|---|
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 3 |
| 1973 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1994 | 1 |
| 1998 | 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\" = 'IN' 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" = 'IN' 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 CHI98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Mc Cordsville, INThe pilot's failure to maintain airspeed and control of the airplane. Factors were his self-induced pressure.NTSB CHI94LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Williamsport, INThe continued flight into adverse weather conditions, the student's failure to maintain a proper glideslope and the CFI's delay in initiating remedial action. Factors related to the accident were the lightning and turbulent thunderstorm conditions.NTSB CHI84LA171Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Marion, INThe student plt reported that during a landing, he reduced the power too soon & flared the acft too high, then the acft bounced about 8 to 10 ft in the air. The hard landing resulted in spar damage to the right wing.NTSB CHI84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Warsaw, INThe acft collapsed the landing gear during a forced landing following eng failure. The acft had been flown 5.5 hours before landing 3 miles NE of the intended refueling stop. The pilot had passed ft wayne at flt time of 5+ hours with about 10 gallons of fuel…NTSB CHI83LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Demotte, INThe plt stated he overflew the unfamiliar arpt & landed to the south (downwind) because of power lines on the approach to the north. He was high on final due to a tree in the approach path. The acft floated during the flare. He then raisedthe nose & the right…NTSB CHI77FEA03Accident · No injuriesClosedPiper PA-32 · Plainville, INNTSB CHI76AC014Accident · 5 fatalClosedPiper PA-32 · Fort Wayne, INNTSB CHI73AC091Accident · No injuriesClosedPiper PA-32 · Portland, INNTSB CHI73FEA26Accident · Minor injuriesClosedPiper PA-32 · Connersville, INNTSB CHI73DEA20Accident · Serious injuriesClosedPiper PA-32 · Muncie, INNTSB CHI73FEA06Accident · No injuriesClosedPiper PA-32 · Kokomo, INNTSB CHI72FEA42Accident · Minor injuriesClosedPiper PA-32 · Crawfordsvile, INNTSB CHI70FBA22Accident · No injuriesClosedPiper PA-32 · Brazil, INNTSB CHI70A0003Accident · No injuriesClosedPiper PA-32 · Madison, INNTSB CHI68F0615Accident · Minor injuriesClosedPiper PA-28 · Orleans, INNTSB CHI68D0565Accident · No injuriesClosedPiper PA-32 · Warsaw, INNTSB CHI67D0132Accident · No injuriesClosedPiper PA-32 · Richmond, IN