Skip to content

NTSB investigations: Piper PA-32-300, AZ

25 cases on aircraft the registry lists as Piper PA-32-300. 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

19672026

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" = 'AZ' 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 ('7103212')) 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\" = 'AZ' 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 ('7103212'))
  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" = 'AZ' 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 ('7103212'))
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 WPR25LA030Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Prescott Valley, AZSeparation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder…Oct 31, 2024 · N154DC · Substantial damage NTSB ANC24LA030Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during takeoff in gusting wind conditions, which resulted in collision with an object.Apr 12, 2024 · N4011R · Substantial damage NTSB LAX95LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Buckeye, AZa loss of engine power for undetermined reasons.Feb 1, 1995 · N8950N · Substantial damage NTSB LAX95FA262Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Flagstaff, AZthe pilot's intentional flight into known adverse weather conditions, his misjudged evaluation of the weather, and his inexperience in actual instrument flying.Nov 18, 1994 · N4108R · Destroyed NTSB LAX89FA014Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Sedona, AZTotal failure of the magneto's impulse coupling which resulted in a shearing of the crankshaft's idler gear teeth and the crankshaft dowel pin.Oct 16, 1988 · N4113R · Destroyed NTSB LAX83FA260Accident · 2 fatalField investigationFinal reportPiper PA-32 300C · Buckeye, AZThe acft collided with a utility pole about 36 ft AGL less than a mile north of a private dirt airstrip. The acft had departed scottsdale municipal arpt at about 0045. The accident occurred at about 0200 aproximately 4 miles west of Buckeye,AZ. A witness…Jun 1, 1983 · N8926N · Destroyed NTSB LAX83FUJ04Accident · 1 fatalFinal reportPiper PA-32-300 · Douglas, AZThe plt was observed to crash shortly after takeoff. Witnesses stated it had been snowing off & on. The plt's blood alcohol level was 228 mg%.Dec 2, 1982 · N55118 · Destroyed NTSB LAX79FUJ43Accident · Serious injuriesClosedPiper PA-32 · Morman Lake, AZFeb 5, 1979 · N4100W · Destroyed NTSB LAX79FA019Accident · 2 fatalClosedPiper PA-32 · Sun City, AZDec 24, 1978 · N4008R · Destroyed NTSB LAX79DUJ07Accident · No injuriesClosedPiper PA-32 · Sun City, AZOct 22, 1978 · N4167W · Substantial damage NTSB LAX78FUK06Accident · No injuriesClosedPiper PA-32 · Yuma, AZSep 20, 1978 · N55679 · Substantial damage NTSB LAX78DUJ17Accident · No injuriesClosedPiper PA-32 · Holbrook, AZNov 28, 1977 · N8629N · Substantial damage NTSB LAX76FUJ83Accident · No injuriesClosedPiper PA-32 · Tubac, AZJun 8, 1976 · N8987N · Substantial damage NTSB LAX76AL033Accident · 2 fatalClosedPiper PA-32 · Coolidge, AZNov 5, 1975 · N43475 · Destroyed NTSB LAX76AL026Accident · 2 fatalClosedPiper PA-32 · Tucson, AZOct 15, 1975 · N15876 · Destroyed NTSB LAX75DUJ62Accident · No injuriesClosedPiper PA-32 · Tucson, AZMar 24, 1975 · N9AZ · Substantial damage NTSB LAX74DUJ71Accident · No injuriesClosedPiper PA-32 · Page, AZJun 15, 1974 · N4296R · Substantial damage NTSB LAX74FUJ11Accident · Serious injuriesClosedPiper PA-32 · Grnd Canyon, AZAug 5, 1973 · N4291R · Substantial damage NTSB LAX72FUJ40Accident · Minor injuriesClosedPiper PA-32 · Nogales, AZSep 2, 1971 · N4080W · Substantial damage NTSB LAX70AL061Accident · 6 fatalClosedPiper PA-32 · Colrado Cty, AZMar 26, 1970 · N4121R · Destroyed NTSB LAX70AL058Accident · 5 fatalClosedPiper PA-32 · Pima, AZMar 13, 1970 · N4244R · Destroyed NTSB LAX70DUJ08Accident · No injuriesClosedPiper PA-32 · Pima, AZFeb 2, 1970 · N4293R · Substantial damage NTSB LAX70D0203Accident · No injuriesClosedPiper PA-32 · Flagstaff, AZNov 7, 1969 · N4071R · Substantial damage NTSB LAX68D0075Accident · No injuriesClosedPiper PA-32 · Grand Canyon, AZJul 11, 1967 · N4100W · Substantial damage NTSB LAX67F0323Accident · No injuriesClosedPiper PA-32 · Somerton, AZMar 23, 1967 · N4018W · Substantial damage