Skip to content

NTSB investigations: Piper PA-24-250, ID

18 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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.Dec 17, 2018 · N6283P · Substantial damage NTSB SEA05LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Challis, IDThe installation of an improper oil gasket by maintenance personnel, which resulted in a loss of engine oil and subsequent loss of engine power during the emergency descent.Aug 13, 2005 · N6677P · Substantial damage NTSB SEA97FA070Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Boise, IDthe accumulation of airframe ice on the aircraft, and the pilot's delayed remedial action after intentionally flying into forecast adverse weather conditions. The adverse weather (icing) conditions were related factors.Mar 7, 1997 · N7583P · Destroyed NTSB SEA96LA151Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Stanley, IDthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The crosswind was a related factor.Jul 10, 1996 · N5352P · Substantial damage NTSB SEA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Paris, IDthe pilot forgot to extend the landing gear before landing. Factors relating to the accident were: an interuption of the pilot's habit pattern, when he circled to provide time for another airplane to takeoff as he entered the traffic pattern; and his failure…Jul 2, 1996 · N5246P · Substantial damage NTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.Jul 27, 1994 · N6824P · Substantial damage NTSB SEA91LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Arco, IDWater in the fuel tank and the inability of the pilot to flare for landing after maneuvering to avoid transmission lines in his flight path during the forced landing.Sep 19, 1991 · N7985P · Substantial damage NTSB SEA85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mccall, IDThe acft was damaged during a forced landing in a fld following fuel exhaustion. The plt reported he departed yellow pine, ID, with the fuel gages indicating 1/2. Upon reaching an alt of 10,000 ft, the eng quit due to fuel exhaustion. The right fuel tank was…Jul 5, 1985 · N5829P · Substantial damage NTSB SEA75DYA24Accident · Minor injuriesClosedPiper PA-24 · Arco, IDNov 27, 1974 · N7985P · Substantial damage NTSB SEA68D0183Accident · No injuriesClosedPiper PA-24 · Burley, IDOct 19, 1967 · N5109P · Substantial damage NTSB SEA68D0117Accident · No injuriesClosedPiper PA-24 · Rockland, IDJul 3, 1967 · N7535P · Substantial damage NTSB SEA67D0066Accident · Minor injuriesClosedPiper PA-24 · Challis, IDJul 24, 1966 · N7870P · Substantial damage NTSB SEA67D0058Accident · Minor injuriesClosedPiper PA-24 · Montpelier, IDJun 21, 1966 · N7093P · Substantial damage NTSB SEA66D0263Accident · Minor injuriesClosedPiper PA-22 · Union, IDMay 1, 1966 · N5830P · Substantial damage NTSB SEA66F0175Accident · Minor injuriesClosedPiper PA-24 · Idaho Falls, IDNov 30, 1965 · N7163P · Substantial damage NTSB SEA66F0049Accident · No injuriesClosedPiper PA-24 · Boise, IDJul 16, 1965 · N5811P · Substantial damage NTSB SEA65D0011Accident · No injuriesClosedPiper PA24 · Challis, IDFeb 2, 1965 · N9003T · Substantial damage NTSB UNK64X2152Accident · Minor injuriesClosedPiper PA24 · Boise, IDJun 6, 1964 · N5109P · Destroyed