NTSB investigations: Piper PA-24-260, MT

9 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

NTSB investigations: Piper PA-24-260, MT per year, 1967–2026: 9 cases
1967	1
1970	1
1975	2
1978	1
1980	1
1988	1
1997	1
2025	1

Where

Open the map

Latest cases

Query with SQL

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" = 'MT' 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

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\" = 'MT' 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" = 'MT' 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

Run 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 WPR25LA301Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24-260 · West Yellowstone, MTOn June 29, 2025, at 1033 mountain daylight time, a Piper PA-24-260, N9366P, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Jun 29, 2025 · N9366P · Substantial damage NTSB SEA97FA044Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Winston, MTPilot incapacitation due to hypoxia. Failure of the pilot to use available oxygen is a factor.Jan 7, 1997 · N9080P · Destroyed NTSB DEN88LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Hamilton, MTThe private plt was descending to the destination arpt at the conclusion of a 3.5 hr x-country flight. The plt said he selected the right main fuel tank and flew until the 'fuel was low to the point of exhaustion.' During a right turn, with the gear extended,…Sep 2, 1988 · N9436P · Substantial damage NTSB SEA80FTI06Accident · No injuriesClosedPiper PA-24 · Havre, MTMar 30, 1980 · N8820P · Substantial damage NTSB SEA79FTA04Accident · No injuriesClosedPiper PA-24 · Billings, MTDec 2, 1978 · N8758P · Substantial damage NTSB SEA76FTA18Accident · No injuriesClosedPiper PA-24 · Ekalaka, MTOct 18, 1975 · N11CG · Substantial damage NTSB SEA76FTA04Accident · No injuriesClosedPiper PA-24 · Lewiston, MTAug 28, 1975 · N8881P · Substantial damage NTSB SEA70FDG07Accident · No injuriesClosedPiper PA-24 · Wisdom, MTMay 7, 1970 · N9057P · Substantial damage NTSB SEA68F0208Accident · No injuriesClosedPiper PA-24 · Pryor, MTOct 27, 1967 · N8551P · Substantial damage