NTSB investigations: Piper PA-23
331 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, newest first
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.\"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."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 CHI86FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Warren, MIThe acft developed a small oil leak during a x-country flt. The plt reduced power to idle to conserve oil even though the oil pressure was still in the normal range. During the descent the acfts airspeed was not maintained and the acft contacted the ground in…NTSB ATL86FA092Accident · 1 fatalField investigationFinal reportPiper PA-23 · Toledo, OHN3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a…NTSB LAX85LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Clovis, CAOn initial climb, at 400 ft AGL, the acft's rt engine lost fuel pressure. Then all right engie power was lost. The lt eng continued to operate normally. The plt failed to feather the rt prop & allowed the acft to slow to the point where a mvc roll commenced.…NTSB MIA85FA097Accident · 3 fatalField investigationFinal reportPiper PA-23 · Everglades City, FLThe acft departed the airport for a short flight to drop off one passenger. Shortly after takeoff witnesses stated that the acft started a shallow turn to the left in a nose high attitude. The acft continued to lose speed and rolled rapidly to the left at…NTSB CHI84LA408Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Defiance, OHDuring initial takeoff climb at alt of 300 ft AGL, 9 1/4 inches of rt engine prop blade separated. Forced landing was make in field during which time the rt wing contacted a tree. Metallurgical examination revealed progressive fatigue over 75% of the…NTSB NYC84LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23 · No. Andover, MAThe acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…NTSB DEN84FA148Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Parker, COAccording to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…NTSB NYC84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Lawrence, MAAs the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the…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…NTSB LAX83LA432Accident · Minor injuriesLimited investigationFinal reportPiper PA23-150 · San Diego, CAThe student & instructor (CFI) were practicing touch & go landings. During takeoff from the 4th touch & go, the left eng lost power while climbing thru about 200 ft AGL. The CFI took control of the acft. At about the same time, the student saw oil coming from…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…NTSB DEN83LA139Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Jamestown, NDThe acft landed wheels-up with one engine feathered and nosed over during the slide-out. The pilot had intentionally feathered the left engine to 'try out' the acft. The left engine has the only engine driven hydraulic pump. This pump isnecessary to lower…NTSB ATL82DA115Accident · No injuriesFinal reportPiper PA-23 · Louisville, KYThe pilot stated that during level flight at 9000 ft, he noticed smoke coming from under the instrument panel, followed by a vibration for 15 to 20 seconds. He diverted and landed at Louisville, KY without further incident. An examination revealed that the…NTSB ATL82LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-170 · Tuscaloosa, ALDuring an instructional flight the right engine was shut down and the prop feathered after a vibration was felt. The flight continued to its intended destination. Witnesses stated that they observed the right prop rotating while on final approach, even though…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…NTSB CHI82FA048Accident · 1 fatalField investigationFinal reportPiper PA-23 · Corydon, INPrior to this flight, the aircraft had not been flown for an extended period. On the day of the accident, it had been sold. The aircraft did not have a current annual inspection and had several maintenance discrepancies. These included problems that prevented…NTSB LAX82FA010Accident · 2 fatalClosedPiper PA-23 · San Fernando, CANTSB LAX82DUJ01Accident · No injuriesClosedPiper PA-23 · Show Low, AZNTSB FTW81FRG56Accident · No injuriesClosedPiper PA-23 · Hondo, TXNTSB MIA81FA099Accident · 1 fatalClosedPiper PA-23 · St.Thomas, VINTSB NYC81FA044Accident · Serious injuriesClosedPiper PA-23 · Mattituck, NYNTSB CHI81FA035Accident · 1 fatalClosedPiper PA-23 · Lowell, MINTSB NYC81FNC10Accident · Serious injuriesClosedPiper PA-23 · Brookfield, VTNTSB CHI81FEK10Accident · No injuriesClosedPiper PA-23 · Van Wert, OHNTSB ATL81FLQ07Accident · Minor injuriesClosedPiper PA-23 · Louisville, KYNTSB ATL80FKG28Accident · Minor injuriesClosedPiper PA-23 · Cartersville, GANTSB NYC80FHA23Accident · No injuriesClosedPiper PA-23 · Somerville, NJNTSB NYC80FGM17Accident · No injuriesClosedPiper PA-23 · New Castle, PANTSB ANC80DAG27Accident · No injuriesClosedPiper PA-23 · Nondalton, AKNTSB IAD80FA020Accident · 1 fatalClosedPiper PA-23 · New Bern, NCNTSB FTW80FA031Accident · 2 fatalClosedPiper PA-23 · Ft Worth, TXNTSB MIA80FLA09Accident · No injuriesClosedPiper PA-23 · Jacksonville, FLNTSB DEN80FA014Accident · 1 fatalClosedPiper PA-23 · Grand Lake, CONTSB MIA80DA023Accident · 4 fatalClosedPiper PA-23 · Missing AircraftNTSB DEN80FTE04Accident · No injuriesClosedPiper PA-23 · Peyton, CONTSB NYC8OFA001Accident · 1 fatalClosedPiper PA-23 · Ashford, CTNTSB IAD79FA082Accident · 1 fatalClosedPiper PA-23 · Linville, NCNTSB NYC79FGM45Accident · No injuriesClosedPiper PA-23 · Connellsville, PANTSB FTW79FPA26Accident · No injuriesClosedPiper PA-23 · Addison, TXNTSB CHI79FEI40Accident · Serious injuriesClosedGeronimo PA-23 · Middlefield, OHNTSB CHI79FEV29Accident · No injuriesClosedPiper PA-23 · Champaign, ILNTSB MIA79FLT04Accident · No injuriesClosedPiper PA-23 · Southaven, MSNTSB OAK79DVA21Accident · No injuriesClosedPiper PA-23 · Visalia, CANTSB NYC78FHM29Accident · No injuriesClosedPiper PA-23 · Marlboro, NJNTSB CHI78FEE64Accident · No injuriesClosedPiper PA-23 · Frankfort, ILNTSB NYC78FGM36Accident · No injuriesClosedPiper PA-23 · Coraopolis, PANTSB OAK78DVD14Accident · No injuriesClosedPiper PA-28R · San Francisco, CANTSB OAK78FVD08Accident · No injuriesClosedPiper PA-23 · Hayward, CANTSB MIA77FLA53Accident · Serious injuriesClosedPiper PA-23 · Valdosta, GANTSB DEN77FTE49Accident · No injuriesClosedPiper PA-23 · Lamar, CO