Skip to content

NTSB investigations: Piper PA-30, NC

24 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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA23FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Winston-Salem, NCContamination and/or misalignment of the regulator section of the right engine’s fuel servo, which resulted in excessive idle fuel flow and a total loss of engine power. Also causal was the pilot's failure to land immediately on the nearest runway at the…Nov 19, 2022 · N7295Y · Substantial damage NTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.Aug 20, 1998 · N7298Y · Substantial damage NTSB ATL98LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Hendersonville, NCThe pilot's failure to attain the proper touchdown point and improper go-around procedures resulting in collision with wires, trees, and the ground. Factors were the pilot's lack of familiarity with the airplane and the short runway.May 8, 1998 · N7312Y · Substantial damage NTSB MIA97FA049Accident · 1 fatalField investigationFinal reportPiper PA-30 · Goldsboro, NCThe pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…Dec 28, 1996 · N8220Y · Destroyed NTSB ATL95FA054Accident · 2 fatalField investigationFinal reportPiper PA-30B · Franklin, NCThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was sunglare.Feb 24, 1995 · N7972Y · Destroyed NTSB ATL92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Shallotte, NCThe deterioration of the left main fuel bladder which resulted in the premature exhaustion of the fuel supply and the loss of engine power. A factor was soft terrain.Jul 17, 1992 · N160MJ · Substantial damage NTSB ATL87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Raleigh, NCThe pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the…May 16, 1987 · N7937Y · Substantial damage NTSB ATL86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charlotte, NCPlt reported loss of power on the right eng at about 20 ft alt on takeoff. The acft veered right, the plt aborted the takeoff and touched down on the right side of rwy. The acft struck a mound of dirt and the ldg gear collapsed. The takeoff was initiated from…Jan 7, 1986 · N47KB · Substantial damage NTSB ATL84FA187Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Charlotte, NCPlt departed rwy 18L and shortly thereafter reported to the tower that he had a stuck trim. The plt was cleared to land on rwy 18R. Witnesses observed the acft descend rapidly on downwind to approx 300 to 500 ft AGL and make a steep (90 to 120 degree) right…May 29, 1984 · N7217Y · Destroyed NTSB IAD80FA031Accident · 1 fatalClosedPiper PA-30 · Charlotte, NCMar 20, 1980 · N8547Y · Destroyed NTSB IAD75DKM07Accident · No injuriesClosedPiper PA-30 · Asheville, NCJul 29, 1974 · N7910Y · Substantial damage NTSB IAD75DKM06Accident · No injuriesClosedPiper PA-30 · Charlotte, NCJul 20, 1974 · N7660Y · Substantial damage NTSB IAD74DKM48Accident · No injuriesClosedPiper PA-30 · Charlotte, NCMar 24, 1974 · N8410Y · Substantial damage NTSB IAD74DKM08Accident · No injuriesClosedPiper PA-30 · High Point, NCJul 13, 1973 · N7528Y · Substantial damage NTSB IAD73FKM33Accident · Serious injuriesClosedPiper PA-30 · Arden, NCApr 17, 1973 · N8684Y · Substantial damage NTSB NYC73DLJ04Accident · No injuriesClosedPiper PA-30 · Swansboro, NCAug 12, 1972 · N8486Y · Substantial damage NTSB IAD71AI023Accident · 1 fatalClosedPiper PA-30 · Creston, NCNov 4, 1970 · N7736Y · Destroyed NTSB DIA69F0108Accident · No injuriesClosedPiper PA-30 · Charlotte, NCDec 2, 1968 · N8391Y · Substantial damage NTSB DIA68F0051Accident · No injuriesClosedPiper PA-30 · Morganton, NCAug 12, 1967 · N8174Y · Substantial damage NTSB DIA68F0052Accident · No injuriesClosedPiper PA-30 · Greensboro, NCJul 23, 1967 · N7512Y · Substantial damage NTSB DIA68D0044Accident · No injuriesClosedPiper PA-30 · Boone, NCJul 10, 1967 · N7528Y · Substantial damage NTSB UNK65X0624Accident · No injuriesClosedPiper PA30 · Henderson, NCNov 8, 1964 · N7185Y · Substantial damage NTSB UNK64X1053Accident · No injuriesClosedPiper PA30 · Washington, NCMar 27, 1964 · N7095Y · Substantial damage NTSB UNK64X0851Accident · No injuriesClosedPiper PA30 · Wilmington, NCMar 8, 1964 · N7136Y · Substantial damage