NTSB investigations: Piper PA-23, AZ
7 cases on aircraft the registry lists as Piper PA-23. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1981 | 1 |
| 1994 | 1 |
| 2013 | 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 ('7102302'))
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 ('7102302'))
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 WPR14LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Tucson, AZThe pilot’s failure to maintain airplane control during takeoff following the loss of left engine power due to the failure of the left engine-driven fuel pump’s diaphragm. Contributing to the accident was the pilot’s failure to use the electric fuel boost…NTSB LAX94LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Fairfield, AZThe flight instructor's inadvertent movement of the left engine propeller control into the feather position, his decision to by-pass suitable landing sites in an attempt to restart the left engine as the aircraft energy and performance capability…NTSB LAX82DUJ01Accident · No injuriesClosedPiper PA-23 · Show Low, AZNTSB LAX71DUJ45Accident · No injuriesClosedPiper PA-23 · Tucson, AZNTSB LAX68D0274Accident · Minor injuriesClosedPiper PA-23 · Bullhead Cty, AZNTSB DEN65D0049Accident · No injuriesClosedPiper PA-23 · Tucson, AZNTSB UNK64X1306Accident · No injuriesClosedPiper PA23 · Phoenix, AZ