Skip to content

NTSB investigations: Piper PA-30, CO

19 cases on aircraft the registry lists as Piper PA-30. 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

19642026

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 ('7103002')) 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 ('7103002'))
  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 ('7103002'))
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 CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.Dec 6, 2023 · N7790Y · Substantial damage NTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.Aug 26, 2011 · N75BA · Substantial damage NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.Feb 17, 2006 · N7743Y · Substantial damage NTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.Jul 16, 1998 · N444BP · Substantial damage NTSB FTW96LA403Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COthe pilot-in-command's failure to use proper procedures and engage the turbochargers for takeoff from a high altitude airport. A factor was the high density altitude.Sep 28, 1996 · N37P · Substantial damage NTSB DEN93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe student's failure to maintain proper touchdown alignment, and the instructor pilot's inadequate supervision.May 11, 1993 · N7198Y · Destroyed NTSB DEN93LA037Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Eckert, COThe pilot-in-command's failure to maintain adequate clearance from the truck during the landing. Factors which contributed to the accident were: the pilot's poor judgement in attempting the operation, and the driver's poor judgement in not vacating all…Apr 2, 1993 · N8210Y · Substantial damage NTSB DEN91FA126Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ft. Carson, COThe loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.Sep 11, 1991 · N7730Y · Destroyed NTSB DEN91LA004Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Englewood, COThe pilot's inadequate preflight inspection.Oct 6, 1990 · N85VL · Substantial damage NTSB DEN80FTE60Accident · No injuriesClosedPiper PA-30 · Elbert, COJun 24, 1980 · N8172Y · Substantial damage NTSB DEN79FTE07Accident · No injuriesClosedPiper PA-30 · Englewood, CODec 15, 1978 · N5EE · Substantial damage NTSB DEN74AD047Accident · 5 fatalClosedPiper PA-30A · Aspen, COMar 24, 1974 · N8269Y · Destroyed NTSB DEN74AD002Accident · 2 fatalClosedPiper PA-30B · Aurora, COJul 20, 1973 · N7973Y · Destroyed NTSB DEN70F0158Accident · No injuriesClosedPiper PA-30 · Denver, CONov 27, 1969 · N7973Y · Substantial damage NTSB DEN70A0027Accident · 2 fatalClosedPiper PA-30 · Greeley, COOct 17, 1969 · N8584Y · Destroyed NTSB DEN69D0077Accident · No injuriesClosedPiper PA-30 · Littleton, COAug 24, 1968 · N8469Y · Substantial damage NTSB DEN68A0005Accident · 2 fatalClosedPiper PA-30 · Windsor, COJul 20, 1967 · N8389Y · Destroyed NTSB DEN67F0106Accident · No injuriesClosedPiper PA-30 · Fountain, COSep 27, 1966 · N7903Y · Substantial damage NTSB UNK64X1523Accident · No injuriesClosedPiper PA30 · Broomfield, COApr 30, 1964 · N7296Y · Substantial damage