NTSB investigations: Piper PA-23-250, CO
15 cases on aircraft the registry lists as Piper PA-23-250. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1982 | 2 |
| 1985 | 1 |
| 1992 | 1 |
| 2002 | 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\" = '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 ('7102308'))
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 ('7102308'))
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 DEN02LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Pagosa Springs, COthe total power failure of the right engine due to the failure of its lubricating system. Contributing factors were the lack of suitable terrain for a forced landing, and the terrain being above the airplane's single engine performance capability.NTSB FTW92LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Denver, COThe loss of hydraulic fluid due to a ruptured hydraulic line in the landing gear system.NTSB DEN86FA020Accident · 1 fatalField investigationFinal reportPiper PA-230-250 · Englewood, COThe plt had new avionics and autopilot system installed in the acft prior to the accident. Ntap data indicated that the acft did not attain the assigned alt of 8200 ft prior to reaching the outer marker. The acft did not get established on the localizer…NTSB DEN82DA146Accident · Minor injuriesFinal reportPiper PA-23C-250 · Gunnison, CODuring takeoff, the pilot was distracted by inbound traffic and delayed retracting his gear. At the same time, the engines were not synchronized and he was having difficulty getting them to sound good. He then noticed that a fire had started in the vicinity…NTSB DEN82DA080Accident · No injuriesFinal reportPiper PA-23 · Erie, COThe aircraft lost power during takeoff climb and was landed straight ahead resulting in substantial damage. The fuel selector valve was hard to move and during tests moving it caused the engines to quit. Piper AD 80-18-10 warns that scott manufactured…NTSB DEN76AD074Accident · 6 fatalClosedPiper PA-23 · Steamboat Spgs, CONTSB DEN75FTE52Accident · No injuriesClosedPiper PA-23 · Broomfield, CONTSB DEN74FTE57Accident · Serious injuriesClosedPiper PA-23 · Steamboat Sp, CONTSB DEN81FA070Accident · 1 fatalClosedPiper PA-23 · Estes Park, CONTSB DEN72AD002Accident · 5 fatalClosedPiper PA-23 · Alamosa, CONTSB DEN70D0043Accident · No injuriesClosedPiper PA-23 · Aspen, CONTSB DEN70F0002Accident · No injuriesClosedPiper PA-23 · Denver, CONTSB DEN68A0052Accident · No injuriesClosedPiper PA-23 · Conejos, CONTSB DEN67D0021Accident · No injuriesClosedPiper PA-23 · Littleton, CONTSB DEN66F0082Accident · No injuriesClosedPiper PA-23 · Las Animas, CO