Skip to content

NTSB investigations: Piper PA-18-150, NY

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

Where

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 ('7101828', '7104221', '7102835')) 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 ('7101828', '7104221', '7102835'))
  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 ('7101828', '7104221', '7102835'))
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 GAA20CA008Accident · No injuriesData collectionFinal reportPiper PA18 · Big Flats, NYThe pilot's improper flight planning and his subsequent failure to maintain clearance from wires during takeoff.Oct 10, 2019 · N4138Z · Substantial damage NTSB ERA12CA311Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Eaton, NYThe pilot's improper approach to landing, which resulted in the airplane touching down short of the runway.Apr 29, 2012 · N82398 · Substantial damage NTSB NYC06CA217Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · White Lake, NYThe flight instructor's failure to ensure the landing gear was retracted prior to attempting a water landing.Aug 31, 2006 · N6774B · Substantial damage NTSB NYC03LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ava, NYThe pilot's inadequate preflight which did not detect the contamination in the fuel, and subsequent power loss due to contaminated fuel while operating over unsuitable terrain.May 4, 2003 · N9834P · Substantial damage NTSB NYC02LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middleville, NYThe pilot's failure to maintain proper alignment with the runway after being struck by a gust of wind. Factors were the gusty winds and the berm struck by the airplane.May 4, 2002 · N4151F · Substantial damage NTSB IAD00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dansville, NYthe loss of engine power during take-off for undetermined reasons.Jul 8, 2000 · N4456Z · Substantial damage NTSB NYC94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Monticello, NYThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertent stall at too low an altitude to allow recovery.Jan 10, 1994 · N3999Z · Substantial damage NTSB NYC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Speculator, NYThe plt had been practicing short water takeoffs with full flaps. After svcg the acft with a full load of fuel, he began a takeoff with 20 deg of flaps & got the float plane on the step. He rprtd that as he was applying full flaps, the acft enctrd a gust of…Jun 6, 1987 · N8118 · Substantial damage NTSB NYC83LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Little Ferry, NYStudent pilot step-taxiing from landing collided with a submerged object in the river and damaged the float. The river was at low tide.Oct 31, 1982 · N3593P · Substantial damage NTSB NYC78DFJ20Accident · No injuriesClosedPiper PA-18 · Syracuse, NYMay 11, 1978 · N83679 · Substantial damage NTSB NYC78FHM11Accident · No injuriesClosedPiper PA-18 · Stormville, NYMar 6, 1978 · N9563P · Substantial damage NTSB NYC77FFJ33Accident · Serious injuriesClosedPiper PA-18 · Elmira, NYJul 9, 1977 · N83350 · Destroyed NTSB NYC77DFA26Accident · No injuriesClosedPiper PA-18 · Fort Plain, NYMay 22, 1977 · N8093D · Substantial damage NTSB NYC74FHJ22Accident · No injuriesClosedPiper PA-18 · Brookhaven, NYMar 10, 1974 · N4016Z · Substantial damage NTSB NYC73DFJ25Accident · No injuriesClosedPiper PA-18 · Lakewood, NYMay 24, 1973 · N4712Y · Substantial damage NTSB NYC70DFA22Accident · No injuriesClosedPiper PA-18 · Hinckley, NYMay 24, 1970 · N4284Z · Substantial damage NTSB NYC70DFA02Accident · No injuriesClosedPiper PA-18 · Lawrenceville, NYJan 9, 1970 · N411X · Substantial damage NTSB NYC68D0475Accident · No injuriesClosedPiper PA-22 · Rochester, NYApr 14, 1968 · N3596Z · Substantial damage NTSB UNK64X2581Accident · No injuriesClosedPiper PA18A · Marion, NYJun 30, 1964 · N1982P · Substantial damage NTSB UNK64X1559Accident · No injuriesClosedPiper PA18 · Tupper Lake, NYMay 2, 1964 · N8093D · Substantial damage