NTSB investigations: Piper PA-32-300, CO
16 cases on aircraft the registry lists as Piper PA-32-300. 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
| 1970 | 1 |
|---|---|
| 1973 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1999 | 2 |
| 2002 | 1 |
| 2005 | 1 |
Where
Latest 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\" = '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 ('7103212'))
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 ('7103212'))
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 DEN05FA128Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Vail, COthe pilot's improper in-flight planning and decision making and failure to maintain clearance from the terrain. Contributing factors include the pilot's attempt to takeoff from the highway, high density altitude, the downdrafts, and the sign.NTSB DEN03FA028Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Steamboat Spgs, COthe pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density…NTSB DEN99LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rifle, COThe pilot's failure to maintain aircraft control during landing roll. Factors were the strong crosswind weather conditions, and the runway sign that the airplane impacted.NTSB DEN99FA064Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Pagosa Springs, COThe pilot's continued VFR flight into IMC conditions. Related factors were flight into known adverse weather, the adverse weather, mountain obscuration, snow, icing, and high density altitude.NTSB FTW95LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Howard, COThe pilot's flight into known adverse weather over mountainous terrain at an inadequate altitude to recover from turbulence/downdraft. Factors related to the accident were: inadequate preflight planning/preparation by the pilot, his inadequate weather…NTSB DEN93LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Las Animas, COFailure by the pilot in command to maintain control of the aircraft. A factor was: wind gusts.NTSB DEN91FA111Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Colorado Spring, COThe pilot exceeded weight and balance limitations. Factors were: high density altitude and unsuitable terrain.NTSB DEN91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Englewood, COThe pilot's failure to maintain visual lookout. A factor was: the pilot's improper use of the throttle controls and brakes.NTSB DEN90FA103Accident · 6 fatalField investigationFinal reportPiper PA-32C-300 · Leadville, COVFR flight into instrument meteorological conditions (IMC) by the pilot, and his failure to maintain sufficient altitude and clearance from mountainous terrain. Factors related to the accident were: the terrain and weather conditions, the pilot's…NTSB DEN82FTE14Accident · 1 fatalClosedPiper PA-32 · Buena Vista, CONTSB DEN79FA058Accident · No injuriesClosedPiper PA-32 · Denver, CONTSB DEN77FA011Accident · 2 fatalClosedPiper PA-32 · Denver, CONTSB DEN76FTE45Accident · Serious injuriesClosedPiper PA-32 · Saint Elmo, CONTSB DEN76AD025Accident · No injuriesClosedPiper PA-32 · Delta, CONTSB DEN74FTE23Accident · No injuriesClosedPiper PA-32 · Eagle, CONTSB DEN70DXD17Accident · No injuriesClosedPiper PA-32 · Akron, CO