NTSB investigations: Piper PA-23-250, WA

13 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, WA per year, 1965–2026: 13 cases
1965	1
1966	1
1967	3
1972	3
1974	1
1976	1
1999	1
2006	1
2019	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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 WPR19LA066Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA23 · Ellensburg, WAThe instrument rated pilot’s loss of control due to spatial disorientation.Jan 17, 2019 · N14372 · Destroyed NTSB SEA06CA171Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Greenacres, WAThe pilot's selection of an unsuitable landing runway which resulted in a runway overrun and collision with a fence. A contributing factor was the wet runway condition.Aug 7, 2006 · N6549A · Substantial damage NTSB SEA99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Snohomish, WABrake system failure due to the presence of air bubbles in the hydraulic fluid.Jul 12, 1999 · N65PR · Substantial damage NTSB SEA76AS040Accident · 2 fatalClosedPiper PA-23 · Pullman, WAMar 28, 1976 · N6199Y · Destroyed NTSB SEA74FYG23Accident · Serious injuriesClosedPiper PA-23 · Ritzville, WAFeb 9, 1974 · N6012Y · Destroyed NTSB SEA73ASO09Accident · 1 fatalClosedPiper PA-23 · Dixie, WAOct 10, 1972 · N6707Y · Destroyed NTSB SEA72DYG47Accident · No injuriesClosedPiper PA-23 · Lind, WAJun 15, 1972 · N6982Y · Substantial damage NTSB SEA72AS050Accident · 6 fatalClosedPiper PA-23 · Amboy, WAMay 15, 1972 · N14194 · Destroyed NTSB SEA68D0136Accident · No injuriesClosedPiper PA-23 · Georgetown, WAAug 15, 1967 · N4893P · Substantial damage NTSB SEA67D0331Accident · No injuriesClosedPiper PA-23 · Kennewick, WAMay 18, 1967 · N5834Y · Substantial damage NTSB SEA67D0247Accident · Minor injuriesClosedPiper PA-23 · Royal City, WAFeb 7, 1967 · N4619P · Substantial damage NTSB SEA67D0203Accident · No injuriesClosedPiper PA-23 · Almira, WADec 3, 1966 · N4947P · Substantial damage NTSB SEA66D0053Accident · No injuriesClosedPiper PA-23 · Wenatchee, WAJul 20, 1965 · N4850P · Substantial damage