NTSB investigations: Piper PA-23-250, AR
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 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 'AR' 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" = 'AR' 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 DFW06CA153Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Mena, ARThe pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB CHI05FA053Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Eureka Springs, ARThe pilot misjudged his distance/speed which resulted in the overrun and subsequent impact with trees. The wet turf runway and the trees were factors in the accident.NTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.NTSB FTW93LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Searcy, ARTotal power loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB MKC85FA059Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Hot Springs, ARPilot had been cleared for an ILS approach to Hot Springs, Arkansas. After he crossed the initial approach fix, he said he was going to climb back above the clouds for just a second. He climbed 500 feet in the next 12 seconds, then started a fast descent. The…NTSB FTW81FPG61Accident · No injuriesClosedPiper PA-23 · Malvern, ARNTSB FTW79DPG52Accident · No injuriesClosedPiper PA-28 · Benton, ARNTSB FTW78FPG02Accident · No injuriesClosedPiper PA-23E · Little Rock, ARNTSB FTW76AF072Accident · 2 fatalClosedPiper PA-23 · Hope, ARNTSB FTW75FPG36Accident · Serious injuriesClosedPiper PA-23 · Brookland, ARNTSB FTW73DRJ31Accident · No injuriesClosedPiper PA-23 · Texarkana, ARNTSB FTW72DPG61Accident · No injuriesClosedPiper PA-23 · Camden, ARNTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARNTSB FTW68D0175Accident · No injuriesClosedPiper PA-23 · Gurdon, ARNTSB FTW67F0077Accident · No injuriesClosedPiper PA-23 · Stuttgart, ARNTSB FTW66D0375Accident · No injuriesClosedPiper PA-23 · Siloam Sps, ARNTSB FTW66D0104Accident · No injuriesClosedPiper PA-23 · Herber Springs, AR