NTSB investigations: Piper PA-30, SC

15 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

NTSB investigations: Piper PA-30, SC per year, 1964–2026: 15 cases
1964	1
1966	2
1969	1
1970	1
1974	1
1976	1
1977	1
1978	1
1981	1
1983	1
2003	1
2005	1
2021	1
2025	1

Where

Open the map

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" = 'SC' 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\" = 'SC' 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" = 'SC' 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 ERA25LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Anderson, SCThe pilots’ overcorrection during the landing roll which resulted in a loss of directional control and runway excursion. Contributing was the flight instructor’s inability to correct the pilot’s actions because due to brakes only being installed on the…Mar 21, 2025 · N8339Y · Substantial damage NTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.Nov 5, 2021 · N8924Y · Substantial damage NTSB ATL05FA043Accident · 1 fatalField investigationFinal reportPiper PA-30 · Charleston, SCThe pilot's inadequate preflight and mismanagement of the fuel supply, which resulted in fuel exhaustion.Jan 11, 2005 · N7654Y · Substantial damage NTSB ATL04FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Spartanburg, SCThe pilot's failure to follow IFR procedures and descent below the glide path, which resulted in an inflight collision with trees during an instrument approach. A factor was the pilot's impairment due to the sedating effects of medication.Oct 27, 2003 · N7799Y · Destroyed NTSB ATL83LA098Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charleston, SCThe plt stated that the landing gear collapsed after acft had rolled aprx 1200 ft during the landing. An exam of the acft revealed that the gear retraction transmission was torn out of its fuselage bulkhead mount, the landing gear push-pull cable rod ends…Feb 6, 1983 · N1810M · Substantial damage NTSB ATL81FLG11Accident · No injuriesClosedPiper PA-30 · Hilton Head Is, SCJun 11, 1981 · N8264Y · Substantial damage NTSB MIA78FLG17Accident · Minor injuriesClosedPiper PA-30 · Landrum, SCApr 8, 1978 · N8563Y · Destroyed NTSB MIA78FA002Accident · 2 fatalClosedPiper PA-30 · Charleston, SCOct 10, 1977 · N7585Y · Destroyed NTSB MIA76FLG45Accident · Minor injuriesClosedPiper PA-30 · Summerton, SCAug 5, 1976 · N1139T · Destroyed NTSB MIA74AM053Accident · 2 fatalClosedPiper PA-30 · Charleston, SCJan 1, 1974 · N8546Y · Destroyed NTSB MIA71AM020Accident · 2 fatalClosedPiper PA-30 · Georgetown, SCAug 4, 1970 · N8047Y · Destroyed NTSB MIA69A0091Accident · 1 fatalClosedPiper PA-30 · Ocean Drive B, SCJun 17, 1969 · N8003Y · Destroyed NTSB MIA67F0373Accident · No injuriesClosedPiper PA-30 · Greenville, SCDec 19, 1966 · N8147Y · Substantial damage NTSB MIA67F0252Accident · No injuriesClosedPiper PA-30 · Columbia, SCSep 5, 1966 · N7628Y · Substantial damage NTSB UNK64X1232Accident · No injuriesClosedPiper PA30 · Johns Island, SCApr 9, 1964 · N7001Y · Substantial damage