NTSB investigations: Piper PA-24-260, MI
14 cases on aircraft the registry lists as Piper PA-24-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 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 3 |
| 1971 | 2 |
| 1972 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1984 | 1 |
| 1991 | 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\" = 'MI' 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 ('7102406'))
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" = 'MI' 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 ('7102406'))
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 CHI03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Blaney Park, MIThe pilot's failure to maintain clearance with the tree line. Factors contributing to this accident were the wind gusts and the trees.NTSB CHI91LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Flint, MIPropeller pitch change mechanism sheared. Factors related to the accident were powerplant vibration and proper touchdown point not possible.NTSB CHI85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ypsilanti, MIThe acft collided with a fence & two parked cars during a forced landing while on a personal flt. The plt reported that after a 40 to 50 min ground delay he made a normal climb to 5000 ft MSL where he trimmed the acft & leaned the mixture to 75 percent power.…NTSB CHI77DET08Accident · No injuriesClosedPiper PA-24 · Three Rivers, MINTSB CHI76FEC14Accident · No injuriesClosedPiper PA-24 · Salem, MINTSB CHI72FEM58Accident · No injuriesClosedPiper PA-24 · Battle Creek, MINTSB CHI72AC036Accident · 3 fatalClosedPiper PA-24 · Brighton, MINTSB CHI71FEC59Accident · No injuriesClosedPiper PA-24 · Troy, MINTSB CHI70F0366Accident · No injuriesClosedPiper PA-24 · Menominee, MINTSB CHI70D0229Accident · No injuriesClosedPiper PA-24 · Onstead, MINTSB CHI69F0654Accident · No injuriesClosedPiper PA-24 · Grand Rapids, MINTSB CHI68F0780Accident · No injuriesClosedPiper PA-24 · Pontiac, MINTSB CHI67F0631Accident · No injuriesClosedPiper PA-24 · Grand Rapids, MINTSB CHI66A0094Accident · No injuriesClosedPiper PA-24 · Greenville, MI