NTSB investigations: Piper PA-23-250, OK

11 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Piper PA-23-250, OK per year, 1965–2026: 11 cases
1965	1
1970	1
1973	2
1978	1
1982	1
1985	1
1993	1
2001	1
2005	2

Where

Open the map

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" = 'OK' 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

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\" = 'OK' 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" = 'OK' 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

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 DFW06CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Bixby, OKThe loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.Nov 23, 2005 · N859DA · Substantial damage NTSB DFW05LA081Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Westport, OKThe collapsing of the right main landing gear as a result of the failure of the scissors assembly.Mar 5, 2005 · N33AC · Substantial damage NTSB FTW02LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Duncan, OKThe pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.Dec 13, 2001 · N127CA · Substantial damage NTSB FTW93FA132Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Henryetta, OKThe pilot's decision to fly into known adverse weather conditions and the ensuing spatial disorientation. Factors were the weather, and the pilot's decision to fly into IMC with inadequate flight and navigational equipment installed in the aircraft.Apr 18, 1993 · N4689P · Destroyed NTSB FTW85FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Foss, OKInflt fire at rear of lft eng caused by fitting of inlet fuel line to eng driven fuel pump being more than 1 & 1/2 turns from finger tight plt was A&P mech and did maint on a/c and had helped install lft eng 19.8 hrs prior to accident . Lft wing separated…Mar 5, 1985 · N6310U · Destroyed NTSB FTW83FPM04Accident · 2 fatalFinal reportPiper PA23-250 · 8 Miles Se Bris, OKThe acft departed at 2220 with a planned enroute stop at holdenville, OK. 55 minutes later the acft crashed approximately 8.5 miles from its original departure point. Witnesses describe the wx as very bad due to heavy rain & fog.Nov 11, 1982 · N6145Y · Destroyed NTSB FTW78FA048Accident · 1 fatalClosedPiper PA-23 · Longdale, OKMay 29, 1978 · N5850Y · Destroyed NTSB FTW74AF044Accident · 2 fatalClosedPiper PA-23 · Weatherford, OKDec 18, 1973 · N14099 · Destroyed NTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · Destroyed NTSB FTW70AF049Accident · No injuriesClosedPiper PA-23 · Tulsa, OKJan 23, 1970 · N6847Y · 2 aircraft · Substantial damage NTSB FTW66D0170Accident · No injuriesClosedPiper PA-23 · Fairview, OKJul 28, 1965 · N5630Y · Substantial damage