Skip to content

NTSB investigations: Piper PA-30, NY

25 cases on aircraft the registry lists as Piper PA-30. 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 ('7103002')) 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 ('7103002'))
  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 ('7103002'))
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 ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.Feb 28, 2022 · N7943Y · Substantial damage NTSB ERA09LA158Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lakeville, NYThe pilot's failure to maintain aircraft control following a loss of engine power on the left engine for undetermined reasons.Feb 8, 2009 · N10JR · Substantial damage NTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.Sep 7, 1992 · N400RD · Substantial damage NTSB ATL86FA039Accident · 1 fatalField investigationFinal reportPiper PA-30 · Corning, NYDuring ILS runway 6 approach acft hit high terrain short of the outer marker. When on downwind for approach pilot said he was not receiving the localizer and asked for a surveillance approach. Controller said he could not provide. When cleared for the ILS…Dec 11, 1985 · N7770Y · Destroyed NTSB NYC83FA050Accident · Minor injuriesField investigationFinal reportPiper PA-30 · Montgomery, NYThe acft experienced a power loss on one engine during take-off initial climb. The pilot regained control of the acft and continued to fly the landing pattern. On the downwind leg the engines ran intermittently. Turning final both enginesstopped. A forced…Jan 7, 1983 · N223JN · Destroyed NTSB NYC81FA027Accident · No injuriesClosedPiper PA-30 · North Castle, NYFeb 19, 1981 · N750HK · Substantial damage NTSB NYC80FA070Accident · 1 fatalClosedPiper PA-30 · Cutchogue, NYAug 14, 1980 · N7094Y · Destroyed NTSB NYC80FHM22Accident · Minor injuriesClosedPiper PA-30 · Lagrangeville, NYAug 7, 1980 · N7103Y · Substantial damage NTSB NYC78FA050Accident · No injuriesClosedPiper PA-30 · Flushing, NYMay 8, 1978 · N7432Y · Substantial damage NTSB NYC77FA026Accident · Serious injuriesClosedPiper PA-30 · College Point, NYDec 31, 1976 · N44SS · Destroyed NTSB NYC76FFA17Accident · No injuriesClosedPiper PA-30 · White Lake, NYOct 10, 1975 · N7963Y · Substantial damage NTSB NYC75FFJ17Accident · Serious injuriesClosedPiper PA-30 · Blasdell, NYNov 14, 1974 · N20JF · Substantial damage NTSB NYC74FFJ20Accident · Serious injuriesClosedPiper PA-30 · Ithaca, NYJan 16, 1974 · N7345Y · Destroyed NTSB NYC72FHM04Accident · No injuriesClosedPiper PA-30 · Spring Valley, NYAug 18, 1971 · N8608Y · Substantial damage NTSB NYC70FFA14Accident · No injuriesClosedPiper PA-30 · Albany, NYMar 15, 1970 · N7169Y · Substantial damage NTSB NYC70AN092Accident · No injuriesClosedPiper PA-30 · Wappinger Fals, NYFeb 24, 1970 · N8555Y · Substantial damage NTSB NYC70D0002Accident · No injuriesClosedPiper PA-30 · Watertown, NYNov 21, 1969 · N8514Y · Substantial damage NTSB NYC69A0003Accident · 5 fatalClosedPiper PA-30 · Gasport, NYJul 3, 1968 · N7027Y · Destroyed NTSB NYC68D0477Accident · No injuriesClosedPiper PA-30 · Montauk, NYMay 5, 1968 · N7282Y · Substantial damage NTSB NYC67A0101Accident · No injuriesClosedPiper PA-30 · Jamaica, NYJan 11, 1967 · N8006Y · Substantial damage NTSB NYC67F0248Accident · No injuriesClosedPiper PA-30 · Penn Yan, NYSep 2, 1966 · N7345Y · Substantial damage NTSB NYC67A0038Accident · 6 fatalClosedPiper PA-30 · Ronkonkoma, NYAug 23, 1966 · N7266Y · Destroyed NTSB NYC66A0065Accident · 1 fatalClosedPiper PA-30 · White Plains, NYDec 12, 1965 · N7056Y · Destroyed NTSB UNK65X1102Accident · No injuriesClosedPiper PA30 · Niagara Falls, NYDec 23, 1964 · N7547Y · Substantial damage NTSB UNK65X0167Accident · No injuriesClosedPiper PA30 · Skaneateles, NYOct 6, 1964 · N7484Y · Substantial damage