Skip to content

NTSB investigations: Piper PA-23-250, MA

21 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

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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 NYC04CA066Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Grt. Barrington, MAThe pilot's misjudgment of the airplane's distance/speed and failure to obtain the proper touchdown point, which resulted in an overrun. A factor was the cross wind.Feb 9, 2004 · N6760A · Substantial damage NTSB NYC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Edgartown, MAImproper recovery from a bounced landing by the pilot. Factors related to the accident were improper use of the flight controls and throttles.Oct 19, 1991 · N14189 · Substantial damage NTSB NYC91LA185Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Templeton, MAFuel starvation induced power loss on first the left engine due to a failed fuel fitting and then the right engine due to a worn fuel fitting. A factor was the lack of suitable terrain for the forced landing.Jul 22, 1991 · N54819 · Substantial damage NTSB NYC90FA176Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · North Andover, MAThe controller issued an unauthorized alternate missed approach procedure that did not provide adequate terrain clearance, and the pilot delayed obtaining a proper rate of climb during the missed approach. Factors related to the accident were: darkness and…Jul 29, 1990 · N333EP · Destroyed NTSB NYC87LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Nantucket, MAThe Piper PA-23-250 attempted a go-around after crossing the threshold and observing the runway lights were not on during a night instrument approach. The pilot reported that he added full power and retracted the wing flaps. The procedure in the Piper manual…Apr 17, 1987 · N40395 · Substantial damage NTSB NYC86LA044Accident · Minor injuriesLimited investigationFinal reportPiper Aztec · North Adams, MAThe flight departed albany new york under VFR conditions and picked up IFR clearance to pittsfield, MA. The pilot flew the approach until reaching VFR under a cloud layer at about 2500 ft. continuing VFR toward no. Adams at an altitude of 2000 ft, the pilot…Nov 26, 1985 · N6LQ · Destroyed NTSB NYC83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Pittsfield, MAOn the 1st takeoff, the CFI demonstrated an aborted takeoff by placing the rt selector gasoline valve in the off position and had the student pull the eng back, making a landing on the rwy. The flt then taxied back for another takeoff, again the CFI shut off…Jun 29, 1983 · N6638Y · Substantial damage NTSB NYC83LA043Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fall River, MAOn short final & aligned with the rwy lights the plt cancelled his IFR flt plan with approach control. The acft landed on the rwy which had the middle third of its width covered with 6-8 inches of snow. The outer thirds were plowed but icy.Dec 13, 1982 · N62635 · Substantial damage NTSB NYC80FNA15Accident · No injuriesClosedPiper PA-23 · Norwood, MAJun 23, 1980 · N129RM · Substantial damage NTSB NYC78FA077Accident · No injuriesClosedPiper PA-23 · Bedford, MAAug 10, 1978 · N40276 · Substantial damage NTSB NYC76AN078Accident · Serious injuriesClosedPiper PA-23 · Ludlow, MAFeb 12, 1976 · N7RW · Substantial damage NTSB NYC76IN058Incident · No injuriesClosedPiper PA-23 · Boston, MADec 23, 1975 · N48PB · Minor damage NTSB NYC74AN084Accident · 4 fatalClosedPiper PA-23 · Nantucket, MAApr 2, 1974 · N4623P · Destroyed NTSB NYC73FNA47Accident · Serious injuriesClosedPiper PA-23 · Wenham, MAMay 10, 1973 · N5991Y · Destroyed NTSB NYC73FNA47Accident · No injuriesClosedPiper PA-23 · Norwood, MAMar 22, 1973 · N6900Y · Substantial damage NTSB NYC72AN122Accident · 1 fatalClosedPiper PA-23 · Acton, MAApr 6, 1972 · N6342L · Destroyed NTSB NYC71FNA46Accident · No injuriesClosedPiper PA-23 · Norwood, MAApr 17, 1971 · N5376Y · Substantial damage NTSB NYC71FFD37Accident · No injuriesClosedPiper PA-23 · Shirley, MAFeb 6, 1971 · N4563P · Destroyed NTSB NYC69A0031Accident · No injuriesClosedPiper PA-23 · Westfield, MASep 11, 1968 · N6591Y · Substantial damage NTSB NYC68D0139Accident · No injuriesClosedPiper PA-23 · Fitchburg, MASep 1, 1967 · N5930Y · Substantial damage NTSB UNK64X3231Accident · 2 fatalClosedPiper PA-23 · E Falmouth, MAAug 5, 1964 · N5485Y · Destroyed