NTSB investigations: Piper PA-18, NY

9 cases on aircraft the registry lists as Piper PA-18. 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

19662026

NTSB investigations: Piper PA-18, NY per year, 1966–2026: 9 cases
1966	1
1971	2
1972	1
1974	1
1984	1
1985	1
1991	1
2000	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 ('7101802')) 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 ('7101802'))
  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 ('7101802'))
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 NYC00LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Westhampton, NYThe pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.Aug 5, 2000 · N17080 · Substantial damage NTSB NYC91FA123Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Hancock Village, NYThe loss of aircraft control and subsequent collision with trees after the pilot became physically incapacitated.Apr 28, 1991 · N102LW · Destroyed NTSB NYC85LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moose River, NYThe acft collided with trees during takeoff and crashed. The plt said he encountered turbulence at about 100 ft AGL which' forced' the acft into the trees.May 17, 1985 · N8105D · Destroyed NTSB NYC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Hastings, NYThe acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear…Feb 12, 1984 · N3264P · Substantial damage NTSB NYC75FFA04Accident · No injuriesClosedPiper PA-18 · Three Mile Bay, NYJul 14, 1974 · N288NY · Substantial damage NTSB NYC72FFA38Accident · No injuriesClosedPiper PA-18 · Oneonta, NYMay 6, 1972 · N1209A · Substantial damage NTSB NYC72AN014Accident · 1 fatalClosedPiper PA-18 · Essex, NYJul 29, 1971 · N16689 · Destroyed NTSB NYC72DFA21Accident · No injuriesClosedPiper PA-18 · Potsdam, NYJun 16, 1971 · N327T · Substantial damage NTSB NYC67D0401Accident · Serious injuriesClosedPiper PA-18 · Richland, NYNov 20, 1966 · N3258P · Destroyed