NTSB investigations: Piper PA-23-250, VA

15 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

19672026

NTSB investigations: Piper PA-23-250, VA per year, 1967–2026: 15 cases
1967	1
1968	1
1969	2
1973	1
1976	1
1977	1
1981	1
1984	1
1986	2
1991	1
1992	1
1996	1
2016	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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA16LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-250 · Danville, VAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Mar 27, 2016 · N22AM · Substantial damage NTSB IAD96FA050Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Marion, VAthe pilot's failure to maintain adequate altitude/clearance during the instrument approach (FAF/Outer Marker to Threshold IFR), which resulted in the in-flight collision with trees. A related factor was the foggy weather conditions.Mar 18, 1996 · N54839 · Destroyed NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.Mar 6, 1992 · N100LC · Destroyed NTSB BFO91LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · New Market, VAThe pilot's inadequate inflight decision that resulted in VFR flight into IMC.Jul 4, 1991 · N63817 · Destroyed NTSB BFO86LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Mt. Holly, VAThe nose gear was sheared off when the acft contacted a ditch during an overrun landing. Upon arriving at the pvt airstrip the plt circled the rwy and decided it was suitable for landing. Touchdown was made 400 ft down the rwy and normal deceleration was…Jun 11, 1986 · N6264Y · Substantial damage NTSB ATL86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Rural Retreat, VAPilot said first adf approach terminated by missed approach due to oscillating directional needle. On second approach acft broke out of clouds with trees in front of acft. It impacted a cloud obscured ridge 3.5 miles southeast of airport on a southerly…Jan 20, 1986 · N14259 · Substantial damage NTSB ATL84LA121Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Warrenton, VAThe CFI shut down one engine during takeoff for a simulated emergency and the plt taking instruction applied the incorrect rudder action during the aborted takeoff and left full power on the operating right engine. The CFI was unableto correct the resulting…Mar 15, 1984 · N63857 · Substantial damage NTSB ATL81FA081Accident · No injuriesClosedPiper PA-23 · Manassas, VAJun 10, 1981 · N222WB · 2 aircraft · Substantial damage NTSB IAD78FA016Accident · 1 fatalClosedPiper PA-23 · Reston, VANov 30, 1977 · N6241Y · Destroyed NTSB IAD76AI068Accident · 3 fatalClosedPiper PA-23 · Lynchburg, VAMay 1, 1976 · N6835Y · Destroyed NTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VADec 11, 1973 · N1905T · Destroyed NTSB IAD70F0060Accident · No injuriesClosedPiper PA-23 · Alexandria, VAAug 20, 1969 · N6389Y · Substantial damage NTSB DIA69F0200Accident · No injuriesClosedPiper PA-23 · Roanoke, VAApr 18, 1969 · N5590Y · Substantial damage NTSB DIA69A0025Accident · 1 fatalClosedPiper PA-23 · Charlottesvlle, VANov 18, 1968 · N5943Y · Destroyed NTSB DIA68A0022Accident · Serious injuriesClosedPiper PA-23 · Sandston, VANov 24, 1967 · N6106Y · Destroyed