NTSB investigations: Piper PA-23, NY

10 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Piper PA-23, NY per year, 1964–2026: 10 cases
1964	1
1965	1
1966	1
1971	2
1974	1
1975	1
1981	1
1990	1
1996	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" = 'NY' 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 ('7102302')) 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\" = 'NY' 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 ('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."eventStateOrRegion" = 'NY' 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 ('7102302'))
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 NYC96FA126Accident · 3 fatalField investigationFinal reportPiper PA-23-150 · Cortland, NYthe pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…Jun 14, 1996 · N2189P · Destroyed NTSB NYC90LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Shirley, NYThe pilot's lack of qualifications, the improper use of flight controls, the second pilot's lack of qualifications, and his decision to simulate the engine failure.Jul 14, 1990 · N44HH · Substantial damage NTSB NYC81FA044Accident · Serious injuriesClosedPiper PA-23 · Mattituck, NYMay 4, 1981 · N2HD · Substantial damage NTSB NYC76AN052Accident · 1 fatalClosedPiper PA-23 · Spring Valley, NYDec 4, 1975 · N2191P · Destroyed NTSB NYC75FHM02Accident · Serious injuriesClosedPiper PA-23 · Montgomery, NYJul 13, 1974 · N1067P · Substantial damage NTSB NYC72FFJ19Accident · Minor injuriesClosedPiper PA-23 · Rochester, NYOct 18, 1971 · N2183P · Destroyed NTSB NYC72AN002Accident · 2 fatalClosedPiper PA-23 · Utica, NYJul 4, 1971 · N3373P · Destroyed NTSB NYC66F0621Accident · No injuriesClosedPiper PA-23 · Syracuse, NYApr 13, 1966 · N2183P · Substantial damage NTSB NYC65A0108Accident · 1 fatalClosedPiper PA-23 · Delancey, NYFeb 19, 1965 · N4827P · Destroyed NTSB UNK64X2197Accident · No injuriesClosedPiper PA23 · Bohemia, NYJun 9, 1964 · N1083P · Substantial damage