Skip to content

NTSB investigations: Piper PA-32-260, CO

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

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

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

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 CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.May 22, 2022 · N85CT · Substantial damage NTSB CEN21LA261Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Lafayette, COThe flight crew’s improper fuel management that resulted in fuel starvation and the loss of engine power.Jun 11, 2021 · N3793W · Substantial damage NTSB DEN02LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Victor, COthe pilot's failure to refuel, resulting in fuel exhaustion and a subsequent loss of engine power. Contributing factors were the pilot's use of inappropriate medication, and the unsuitable terrain on which to make a forced landing.Aug 11, 2002 · N222SH · Substantial damage NTSB DEN99LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Aspen, COThe pilot's inadequate in flight planning. Factors were the high density altitude, the lack of suitable terrain for a forced landing, and the sign post that the right wing impacted.Aug 16, 1999 · N991RC · Destroyed NTSB DEN88LA144Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe plt and pax departed st. louis and stopped twice enroute due to wx. The plt was given landing clearance on rwy 17 at Colorado springs and the wind was reported to be from 190 degrees at 12 KTS. Witnesses at the arpt stated N4878S 'porpoised' several times…Jul 3, 1988 · N4878S · Substantial damage NTSB DEN88LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left…Jan 28, 1988 · N1246T · Substantial damage NTSB DEN82FTE01Accident · No injuriesClosedPiper PA-32 · Akron, COOct 3, 1981 · N3900W · Substantial damage NTSB DEN77FA056Accident · Minor injuriesClosedPiper PA-32T · Colorado Spgs, COAug 5, 1977 · N4864S · Substantial damage NTSB DEN76FTE04Accident · Minor injuriesClosedPiper PA-32 · Eads, COOct 17, 1976 · N4842S · Substantial damage NTSB DEN74FTE25Accident · Serious injuriesClosedPiper PA-32 · Aspen, COOct 7, 1973 · N3234W · Substantial damage NTSB DEN73FTE66Accident · Serious injuriesClosedPiper PA-32 · Aurora, COMar 14, 1973 · N3234W · Minor damage NTSB DEN73FTE44Accident · No injuriesClosedPiper PA-32 · Broomfield, COJan 12, 1973 · N3700W · Substantial damage NTSB DEN72AD059Accident · 6 fatalClosedPiper PA-32 · Nucla, COJun 8, 1972 · N3681W · Destroyed NTSB DEN72FTE11Accident · No injuriesClosedPiper PA-32 · Leadville, COAug 7, 1971 · N3649W · Substantial damage NTSB DEN71FXD44Accident · Minor injuriesClosedPiper PA-32 · Littleton, COJan 4, 1971 · N3935W · Substantial damage NTSB DEN69F0114Accident · No injuriesClosedPiper PA-32 · Littleton, COSep 19, 1968 · N3284W · Substantial damage NTSB DEN67A0063Accident · 3 fatalClosedPiper PA-32 · Estes Park, COApr 9, 1967 · N3511W · Destroyed NTSB DEN67D0197Accident · No injuriesClosedPiper PA-32 · Denver, COJan 28, 1967 · N3730W · Minor damage NTSB DEN67A0019Accident · 1 fatalClosedPiper PA-32 · Granby, COSep 12, 1966 · N3387W · Destroyed