Skip to content

NTSB investigations: Piper PA-23, TX

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

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

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

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 CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…Apr 27, 2019 · N233P · Substantial damage NTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.Jul 21, 1998 · N3154P · Substantial damage NTSB FTW93LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Jayton, TXThe pilot failed to maintain flying speed while maneuvering for landing and allowed the a/c to stall. Factors were the low ceilings, the pilots disregard of the forecast weather, the carburetor icing conditions, and the pilots delayed application of…Nov 11, 1992 · N2078P · Substantial damage NTSB FTW86LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Georgetown, TXThe instructor pilot was instructing his student pilot in an engine shutdown for a multi-engine instructor rating, after which the engine would not restart. The instructor decided to land at the closest airport. While on final approach another aircraft landed…Jul 13, 1986 · N2155P · Substantial damage NTSB FTW84FA074Accident · 4 fatalField investigationFinal reportPiper PA-23 · Comfort, TXWitnesses stated that the acft barely cleared trees at the end of the arpt & that smoke was seen trailing from the righteng. The acft entered a right turn, stalled & impacted a ridge in a steep, near vertically banked dive. Teardowns of both engs & both props…Nov 25, 1983 · N215EC · Destroyed NTSB FTW83LA385Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Catarina, TXThe acft was damaged when the landing gear was retracted during landing rollout at Catarina, TX. The plt identifed himself as larry day from chattanooga, TN. He claimed to have had engine trouble and was unable to extend the gear for landing. Post accident…Aug 13, 1983 · N3003P · Substantial damage NTSB FTW82FA111Accident · No injuriesField investigationFinal reportPiper PA-23-150 · Newark, TXThe plt reported a loud bang was heard and he observed the left eng cowl raised to a vertical position & the eng drooped downward. The excessive amount of drag caused the acft to be uncontrollable. The plt was able to gain control of the acft by feathering…Apr 7, 1982 · N1196P · Destroyed NTSB FTW81FRG56Accident · No injuriesClosedPiper PA-23 · Hondo, TXJul 27, 1981 · N215EC · Substantial damage NTSB FTW80FA031Accident · 2 fatalClosedPiper PA-23 · Ft Worth, TXJan 8, 1980 · N2021P · Destroyed NTSB FTW79FPA26Accident · No injuriesClosedPiper PA-23 · Addison, TXAug 21, 1979 · N3036P · Substantial damage NTSB FTW77FA004Accident · 4 fatalClosedPiper PA-23 · College Sta, TXOct 16, 1976 · N1434P · Destroyed NTSB FTW76AF112Accident · 1 fatalClosedPiper PA-23 · Dalhart, TXAug 2, 1976 · N1459P · Destroyed NTSB FTW75FPD49Accident · No injuriesClosedPiper PA-23 · Grand Prairie, TXJun 27, 1975 · N1495P · Substantial damage NTSB FTW75AF035Accident · 2 fatalClosedPiper PA-23 · Falfurrias, TXNov 17, 1974 · N1395P · Destroyed NTSB FTW74FRH01Accident · No injuriesClosedPiper PA-23 · Corpus Chrsti, TXJun 22, 1974 · N321W · Substantial damage NTSB FTW74AF038Accident · 2 fatalClosedPiper PA-23 · Navasota, TXNov 25, 1973 · N2067P · Destroyed NTSB FTW74AF022Accident · 1 fatalClosedPiper PA-23 · Liberty, TXOct 12, 1973 · N3188P · Destroyed NTSB FTW73DRA15Accident · No injuriesClosedPiper PA-23 · Lagrange, TXJan 20, 1973 · N64K · Substantial damage NTSB FTW71FPA12Accident · No injuriesClosedPiper PA-23 · Plano, TXNov 16, 1970 · N20A · 2 aircraft · Substantial damage NTSB FTW70F0299Accident · No injuriesClosedPiper PA-23 · Plainview, TXNov 15, 1969 · N1065P · Substantial damage NTSB FTW69A0025Accident · 1 fatalClosedPiper PA-23 · La Grange, TXOct 12, 1968 · N1472P · Destroyed NTSB FTW67F0344Accident · No injuriesClosedPiper PA-23 · Fort Worth, TXDec 8, 1966 · N1408P · Substantial damage NTSB FTW66D0304Accident · No injuriesClosedPiper PA-23 · Crystal City, TXAug 31, 1965 · N1225P · Substantial damage NTSB FTW66F0182Accident · Minor injuriesClosedPiper PA-23 · Fort Worth, TXJul 23, 1965 · N1159P · Substantial damage NTSB FTW65F0022Accident · Minor injuriesClosedPiper PA-23 · San Antonio, TXApr 13, 1965 · N1429P · Destroyed NTSB UNK65X0618Accident · No injuriesClosedPiper PA23 · Ft Worth, TXNov 8, 1964 · N2181P · Destroyed NTSB UNK65X0372Accident · No injuriesClosedPiper PA23 · Laporte, TXOct 22, 1964 · N1119P · Substantial damage NTSB UNK64X1334Accident · No injuriesClosedPiper PA23 · Comstock, TXApr 16, 1964 · N1452P · Substantial damage NTSB UNK64X0537Accident · No injuriesClosedPiper PA23 · Beeville, TXFeb 11, 1964 · N3115P · Substantial damage