Skip to content

NTSB investigations: Piper PA-24-250, NY

33 cases on aircraft the registry lists as Piper PA-24-250. 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 ('7102404')) 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 ('7102404'))
  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 ('7102404'))
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 ERA24LA350Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Shirley, NYThe pilot’s excessive speed during the final approach, which resulted in a collision with a fence during the subsequent aborted landing.Aug 17, 2024 · N7531P · Substantial damage NTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.Jul 27, 2011 · N7365P · Substantial damage NTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.May 9, 2011 · N5275L · 2 aircraft · Substantial damage NTSB NYC94FA075Accident · 4 fatalField investigationFinal reportCessna 152 · E. Farmingdale, NYFailure of the local tower controller to adequately control the arrival of the airplanes, and inadequate visual lookout by the Piper PA-24 pilot. A factor related to the accident was: the local controller's improper phraseology in sequencing the airplanes.Apr 9, 1994 · N757KN · 2 aircraft · Destroyed NTSB NYC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · South Bethlehem, NYThe failure of the pilot to maintain proper alignment with the runway and the inadequate snow removal.Mar 5, 1994 · N7139P · Substantial damage NTSB NYC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lyons, NYA worn out brake on the left main gear. Factors related to the accident were: the owner's decision not to repair the left brake after the right brake had a similar failure 4 hours earlier.May 26, 1990 · N7308P · Substantial damage NTSB NYC86LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Geneseo, NYThe aircraft lost power on approach to Geneseo airport. Investigation did not reveal any preimpact malfunction/failure. Conditions conducive to carburetor icing existed at the time of the accident.Sep 14, 1986 · N7215P · Substantial damage NTSB NYC83LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Millbrook, NYThe plt reported that on final apch, the acft began an unexpected descent below the intended glide path. Reportedly, full power was applied to reduce the dwscent, but the acft touched down aprx 20 ft short of the rwy on an upgrade. The acft bounced in the…Jun 24, 1983 · N6438P · Substantial damage NTSB NYC83FA107Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Coram, NYThe acft crashed shortly after declaring an 'emergency.' A witness saw the acft, but heard no eng sound prior to the crash. Examination of eng failed to reveal any discrepancies. However, when the carburetor was examined no fuel was found in the line between…May 1, 1983 · N5738P · Destroyed NTSB NYC82DA088Accident · No injuriesFinal reportPiper PA-24-250 · Farmingdale, NYThe pilot stated that a gust of wind caught the left wing of the aircraft during landing. This resulted in a hard landing and the collapse of the right main and nose gear.May 1, 1982 · N8355P · Substantial damage NTSB NYC78FHJ24Accident · Minor injuriesClosedPiper PA-24 · North Castle, NYSep 2, 1978 · N7388P · Destroyed NTSB NYC77FFA41Accident · No injuriesClosedPoper PA-24 · White Lake, NYSep 12, 1977 · N5315P · Substantial damage NTSB NYC77FFJ37Accident · No injuriesClosedPiper PA-24 · Elmira, NYJun 26, 1977 · N8154P · Substantial damage NTSB NYC75FFA24Accident · No injuriesClosedPiper PA-24 · New Paltz, NYDec 9, 1974 · N5271P · Substantial damage NTSB NYC74FHJ21Accident · Minor injuriesClosedPiper PA-24 · Cutchogue, NYJan 24, 1974 · N65ER · Destroyed NTSB NYC73FHM19Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYDec 29, 1972 · N5451P · No damage NTSB NYC73FHM15Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYNov 7, 1972 · N5500P · Substantial damage NTSB NYC72DFA48Accident · No injuriesClosedPiper PA-24 · Oneonta, NYJun 23, 1972 · N7178P · Substantial damage NTSB NYC72DFJ15Accident · No injuriesClosedPiper PA-24 · Moravia, NYSep 17, 1971 · N6514P · Substantial damage NTSB NYC71DFJ15Accident · No injuriesClosedPiper PA-24 · Weedsport, NYOct 2, 1970 · N6465P · Substantial damage NTSB NYC70F0046Accident · No injuriesClosedPiper PA-24 · White Plains, NYJun 24, 1969 · N5999P · Substantial damage NTSB NYC68D0207Accident · No injuriesClosedPiper PA-24 · White Plains, NYSep 23, 1967 · N5209P · Substantial damage NTSB NYC68D0018Accident · No injuriesClosedPiper PA-24 · Ithaca, NYMay 28, 1967 · N6960P · Substantial damage NTSB NYC67A0112Accident · No injuriesClosedPiper PA-24 · Flushing, NYFeb 10, 1967 · N8353P · Substantial damage NTSB NYC67D0019Accident · Minor injuriesClosedPiper PA24 · Spring Valley, NYJun 13, 1966 · N7139P · Substantial damage NTSB NYC67D0033Accident · No injuriesClosedPiper PA-24 · Poestenkill, NYJun 3, 1966 · N8190P · Substantial damage NTSB NYC66F0094Accident · No injuriesClosedPiper PA-24 · Utica, NYJul 12, 1965 · N6494P · Substantial damage NTSB NYC66D0049Accident · No injuriesClosedPiper PA-24 · Fishers Island, NYJun 19, 1965 · N8280P · Destroyed NTSB NYC65D0241Accident · No injuriesClosedPiper PA-24 · Montauk, NYMay 26, 1965 · N8018P · Substantial damage NTSB NYC65A0137Accident · 1 fatalClosedPiper PA-24 · West Point, NYMay 8, 1965 · N7916P · Destroyed NTSB UNK64X4117Accident · No injuriesClosedPiper PA24 · Flushing, NYSep 23, 1964 · N7451P · Substantial damage NTSB UNK64X2567Accident · No injuriesClosedPiper PA24 · Rochester, NYJun 29, 1964 · N8417P · Substantial damage NTSB UNK64X2513Accident · No injuriesClosedPiper PA24 · Cooperstown, NYJun 27, 1964 · N8018P · Substantial damage