NTSB investigations: Piper PA-23-250, NC

19 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, NC per year, 1965–2026: 19 cases
1965	2
1968	1
1969	1
1971	1
1973	1
1974	1
1976	2
1977	1
1979	1
1980	1
1987	1
1989	1
1991	3
1994	1
2020	1

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA20LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Albemarle, NCThe pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.Mar 5, 2020 · N335W · Substantial damage NTSB ATL94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Blowing Rock, NCThe pilot's selection of unsuitable terrain (remote, wooded, mountainous) for an intentional crash landing.Jun 19, 1994 · N63872 · Destroyed NTSB ATL91FA142Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Manteo, NCThe loss of left engine power for undetermined reasons, and the failure of the pilot to maintain minimum controllable airspeed, which resulted in the stalling of the airplane.Jul 26, 1991 · N54746 · Destroyed NTSB ATL91FA051Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Liberty, NCFailure of the pilot to maintain a positive rate-of-climb after lift-off. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's limited experience in a Piper PA-23.Feb 7, 1991 · N6247Y · Destroyed NTSB ATL91LA048Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Lumberton, NCThe pilot suffered a stroke and lost control of the airplane on final approach.Feb 3, 1991 · N4749P · No damage NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.Feb 12, 1989 · N5112Y · Destroyed NTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…Jan 22, 1987 · N2489R · Substantial damage NTSB ATL80DA075Accident · No injuriesClosedPiper PA-23 · Banner Elk, NCJul 15, 1980 · N6145Y · 2 aircraft · Substantial damage NTSB IAD80FA001Accident · 1 fatalClosedPiper PA-23 · Mooresville, NCOct 2, 1979 · N12JW · Destroyed NTSB IAD78FA008Accident · 1 fatalClosedPiper PA-23 · Morganton, NCOct 27, 1977 · N5250Y · Destroyed NTSB IAD76FKM39Accident · Minor injuriesClosedPiper PA-23 · Huntersville, NCJul 1, 1976 · N5112Y · Substantial damage NTSB IAD76DLQ15Accident · No injuriesClosedPiper PA-23 · Banner Elk, NCMar 12, 1976 · N400BB · Substantial damage NTSB IAD75AI023Accident · 3 fatalClosedPiper PA-23 · Bryson City, NCOct 13, 1974 · N6980Y · Destroyed NTSB IAD73DKM41Accident · No injuriesClosedPiper PA-23 · Boone, NCMay 15, 1973 · N713BT · Substantial damage NTSB IAD71FLJ14Incident · No injuriesClosedPiper PA-23 · Durham, NCFeb 18, 1971 · N5044Y · Minor damage NTSB IAD70A0019Accident · 1 fatalClosedPiper PA-23 · Wake Forest, NCSep 16, 1969 · N6265Y · Destroyed NTSB DIA68A0052Accident · 1 fatalClosedPiper PA-23 · New Bern, NCJun 21, 1968 · N5355Y · Destroyed NTSB MIA66F0253Accident · No injuriesClosedPiper PA-23 · Albemarle, NCSep 19, 1965 · N5329Y · Substantial damage NTSB MIA65F0031Accident · No injuriesClosedPiper PA-23 · Charlotte, NCApr 13, 1965 · N5714Y · Substantial damage