NTSB investigations: Piper PA-16, NY

9 cases on aircraft the registry lists as Piper PA-16. 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-16, NY per year, 1964–2026: 9 cases
1964	1
1965	1
1967	2
1968	1
1976	1
1977	1
1985	1
1990	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 ('7101602')) 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 ('7101602'))
  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 ('7101602'))
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 NYC90LA217Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Red Hook, NYThe pilot's loss of directional control and departure off the side of the runway during the landing roll, resulting in a collision with a tree. Contributing to the accident was the pilot's lack of expereince in the aircraft.Sep 9, 1990 · N5972H · Substantial damage NTSB NYC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Livingston, NYThe acft departed the right side of the rwy where it collided with a corn crop during a landing roll. The acft owner, a pvt plt, stated a mechanic on board was flying at the time of the accident. The mechanic stated that the owner was at the controls when the…Jul 18, 1985 · N5739H · Substantial damage NTSB NYC77FA061Accident · 1 fatalClosedPiper PA-16 · Collins, NYMay 26, 1977 · N6862K · 2 aircraft · Destroyed NTSB NYC76DFA43Accident · No injuriesClosedPiper PA-16 · Duanesburg, NYJun 30, 1976 · N5644H · Substantial damage NTSB NYC68D0443Accident · No injuriesClosedPiper PA-16 · Quaker Springs, NYFeb 22, 1968 · N5837H · Substantial damage NTSB NYC68D0198Accident · Minor injuriesClosedPiper PA-16 · Long Lake, NYSep 24, 1967 · N5212H · Substantial damage NTSB NYC68F0260Accident · No injuriesClosedPiper PA-16 · Canastota, NYSep 7, 1967 · N5971H · Substantial damage NTSB NYC65F0019Accident · No injuriesClosedPiper PA-16 · Deer Park, NYFeb 2, 1965 · N5682H · Substantial damage NTSB UNK64X3641Accident · No injuriesClosedPiper PA16 · Islip, NYAug 28, 1964 · N5781H · Substantial damage