NTSB investigations: Piper PA-23-250, AZ
17 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 |
| 1969 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 2003 | 1 |
| 2005 | 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\" = 'AZ' 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" = 'AZ' 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 LAX05LA168Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Seligman, AZthe pilot's fuel system mismanagement that led to a fuel starvation induced loss of power in the left engine. Also causal was the pilot's improper use of the emergency landing gear extension system.NTSB LAX03FA069Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Flagstaff, AZthe pilot's failure to comply with his instrument clearance route instruction and to maintain his assigned altitude. A factor in the accident was the poor quality of radio communications due to the severance of underground fiber optic voice and data lines for…NTSB LAX95LA314Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Marana, AZthe pilot's poor installation of the propeller which allowed the propeller to become loose, and the pilot's improper emergency procedure by feathering the wrong propeller.NTSB LAX95LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Overgaard, AZthe pilot's improper use of the mixture controls, failure to maintain a proper glidepath, failure to maintain an adequate approach airspeed, and failure to maintain directional control of the aircraft.NTSB LAX94LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Showlow, AZthe pilot's poorly planned approach, improper emergency procedures, and his failure to feather the propeller. The inoperative fuel selector valve was a factor in this accident.NTSB LAX87LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Chandler, AZWhile clbg fm a go-arnd at abt 400' AGL, the instructor (CFI) shut dwn the l eng by closing the mixture & the student (pvt plt) feathered the left prop. The CFI then moved the prop ctl out of the feather psn, but the prop rmnd feathered. The CFI was unable to…NTSB LAX86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mesa, AZThe pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading.NTSB LAX86FA167Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Mesa, AZWhile on the fourth leg of an IFR business flight from stow, Ohio to santa paula, California, the airplane experienced fuel exhaustion and crashed about 1 1/2 miles northeast of falcon field (ffz), Mesa, Arizona. The flight was being conducted under the…NTSB LAX82FUJ25Accident · Serious injuriesFinal reportPiper PA-23-250 · Bagdad, AZThe pilot attempted to fly from phoenix to Bagdad, AZ under a low overcast. When it became obvious that weather conditions were too poor for a landing the pilot attempted to reverse direction and the aircraft struck high terrain.NTSB LAX82FUJ17Accident · 2 fatalClosedPiper PA-23 · Tucson, AZNTSB LAX78FUJ90Accident · Minor injuriesClosedPiper PA-23 · Scottsdale, AZNTSB LAX78FA041Accident · 1 fatalClosedPiper PA-23 · Mesa, AZNTSB LAX77DUJ08Accident · No injuriesClosedPiper PA-23 · San Carlos, AZNTSB LAX72DUJ74Accident · No injuriesClosedPiper PA-23 · Bowie, AZNTSB LAX70F0046Accident · Serious injuriesClosedPiper PA-23 · Cottonwood, AZNTSB LAX67A0013Accident · No injuriesClosedPiper PA-23 · Grand Canyon, AZNTSB DEN65F0027Accident · No injuriesClosedPiper PA-23 · Tucson, AZ