Skip to content

NTSB investigations: Piper PA-24-250, WA

19 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

19652026

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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 WPR22LA213Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Auburn, WAA total loss of engine power due to fuel starvation.Jun 12, 2022 · N7482P · Substantial damage NTSB WPR11FA367Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Camas, WAThe pilot's failure to maintain control of the airplane while maneuvering in the traffic pattern.Aug 3, 2011 · N6297P · Substantial damage NTSB WPR11LA340Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lopez, WAA partial loss of engine power due to a cracked engine case near the rear cylinder.Jul 17, 2011 · N5532P · Substantial damage NTSB SEA06LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Auburn, WAThe failure of the landing gear's normal retraction/extension assembly due to an overload condition.Aug 19, 2006 · N6249P · Substantial damage NTSB SEA06CA018Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Tacoma, WAThe collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…Nov 3, 2005 · N1959P · Substantial damage NTSB SEA01LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fragaria, WAThe pilot's failure to maintain adequate directional control. Contributing factors were the embankment and the deer.Jul 7, 2001 · N7994P · Substantial damage NTSB SEA96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Camas, WAFailure of the pilot to ensure that the landing gear was extended before landing.Jan 3, 1996 · N6297P · Substantial damage NTSB SEA91FA076Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Chehalis, WAA loss of engine power due to an improper overhaul.Mar 28, 1991 · N6044P · Destroyed NTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.Nov 19, 1989 · N8289P · Destroyed NTSB SEA81FA028Accident · Minor injuriesClosedPiper PA-24 · Port Orchard, WAApr 15, 1981 · N5976P · Substantial damage NTSB SEA81FYE15Accident · No injuriesClosedPiper PA-24 · Olympia, WAJan 10, 1981 · N6651P · Substantial damage NTSB SEA77FYP25Accident · No injuriesClosedPiper PA-24 · Spokane, WAMay 22, 1977 · N6487P · Substantial damage NTSB SEA76AS032Accident · 4 fatalClosedPiper PA-24 · Palmer, WADec 26, 1975 · N7288P · Destroyed NTSB SEA76DYG14Accident · No injuriesClosedPiper PA-24 · Richland, WASep 14, 1975 · N5829P · Substantial damage NTSB SEA74DYG43Accident · No injuriesClosedPiper PA-24 · Othello, WAMay 31, 1974 · N7722P · Substantial damage NTSB SEA74FYE03Accident · No injuriesClosedPiper PA-24 · Renton, WAJul 13, 1973 · N5976P · Substantial damage NTSB SEA68A0043Accident · No injuriesClosedPiper PA-24 · Seattle, WADec 10, 1967 · N6091P · Substantial damage NTSB SEA68F0212Accident · No injuriesClosedPiper PA-24 · Ocean Shores, WANov 4, 1967 · N6116P · 2 aircraft · Substantial damage NTSB SEA66F0003Accident · No injuriesClosedPiper PA-24 · Seatte, WAMay 30, 1965 · N6678P · Substantial damage