Skip to content

NTSB investigations: Piper PA-30, GA

33 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

19662026

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA23FA274Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Claxton, GAThe flight crew’s improper fuel management, which resulted in the airplane’s right engine being starved of fuel and its subsequent total loss of power.Jun 25, 2023 · N7240Y · Substantial damage NTSB ERA23LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Milan, GAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.Oct 4, 2022 · N7494Y · Substantial damage NTSB ERA16LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Dublin, GAThe pilot’s inadvertent retraction of the landing gear during the landing roll following a landing approach in gusting wind conditions.Jan 18, 2016 · N68X · Substantial damage NTSB ERA10LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Douglas, GAA loss of engine power during takeoff due to fuel contamination. Contributing to the accident was the pilot's inadequate preflight inspection and inadequate maintenance of the fuel system.Aug 23, 2010 · N8734Y · Substantial damage NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.Sep 18, 2008 · N7195Y · Substantial damage NTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.Feb 19, 2008 · N8202Y · Substantial damage NTSB ATL02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-30-30 · Winder, GAThe pilot's failure to maintain directional control during landing roll which resulted in the subsequent collision with an airport sign and the collapse of the main landing gear. the pilot's improper recovery from a bounced landing was a contributing factor.Sep 7, 2002 · N7817Y · Substantial damage NTSB ATL97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Cartersville, GAthe flight instructor's (CFI's) inadequate supervision by failing to ensure that directional control of the aircraft was maintained, during a simulated engine failure. The student pilot's delay in performing the appropriate single-engine emergency procedure…Nov 11, 1996 · N7392Y · Substantial damage NTSB ATL84FA118Accident · No injuriesField investigationFinal reportPiper PA 31-350 · Atlanta, GAThe aircrews of a Piper PA-31, N62849, & a Piper PA-30, N7047Y, proceeded to taxi at dawn from a cargo ramp to rwy 26. Their taxi route was down a parallel taxiway. The PA-31 plt stopped at a glide slope hold line which was located near the end of the…Mar 7, 1984 · N62849 · 2 aircraft · Substantial damage NTSB ATL83FA189Accident · No injuriesField investigationFinal reportPiper PA-30 · Atlanta, GAAccording to the plt, he extended the gear, got a safe gear down indication & made an approach with the flaps retracted. The gear warning was not heard. The plt stated that after the acft rolled about 1500 ft after touchdown, and with all 3 gear on the…May 17, 1983 · N8450Y · Substantial damage NTSB ATL80FLA10Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 28, 1980 · N8353Y · Substantial damage NTSB MIA80FKG22Accident · No injuriesClosedPiper PA-30 · Gainesville, GAMar 16, 1980 · N7858Y · Substantial damage NTSB MIA79DKG45Accident · No injuriesClosedPiper PA-30 · Jefferson, GAMay 30, 1979 · N7555Y · Substantial damage NTSB MIA79FKG37Accident · Serious injuriesClosedPiper PA-30B · Ball Ground, GAMay 11, 1979 · N8152Y · Destroyed NTSB MIA79FA034Accident · 1 fatalClosedPiper PA-30 · Lafayette, GADec 31, 1978 · N7031Y · Destroyed NTSB MIA78FA103Accident · 3 fatalClosedPiper PA-30 · Albany, GAJul 10, 1978 · N41AC · Destroyed NTSB MIA78FA048Accident · 2 fatalClosedPiper PA-30 · Waco, GAMar 2, 1978 · N7428Y · Destroyed NTSB MIA75FKG67Accident · No injuriesClosedPiper PA-30 · Patterson, GAApr 14, 1975 · N7873Y · Substantial damage NTSB MIA75AM040Accident · 2 fatalClosedPiper PA-30 · Atlanta, GADec 30, 1974 · N7007Y · Destroyed NTSB MIA74AM095Accident · Serious injuriesClosedPiper PA-30 · Atlanta, GAMay 20, 1974 · N8723Y · Substantial damage NTSB MIA74FKG55Accident · No injuriesClosedPiper PA-30 · Atlanta, GAMar 5, 1974 · N99EJ · Substantial damage NTSB MIA74FKG23Accident · No injuriesClosedPiper PA-30 · Sylvania, GASep 2, 1973 · N7902Y · Substantial damage NTSB MIA74FKG20Accident · No injuriesClosedPiper PA-30 · Jesup, GAAug 12, 1973 · N7695Y · Substantial damage NTSB MIA71AM063Accident · Minor injuriesClosedPiper PA-30 · Atlanta, GAJan 30, 1971 · N7632Y · Substantial damage NTSB MIA71FKG18Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 8, 1970 · N8326Y · Substantial damage NTSB MIA70F0295Accident · No injuriesClosedPiper PA-30 · Columbus, GAJul 23, 1969 · N8719Y · Substantial damage NTSB MIA70F0212Accident · No injuriesClosedPiper PA-30 · Chamblee, GAJul 6, 1969 · N7376Y · Substantial damage NTSB MIA69F0431Accident · No injuriesClosedPiper PA-30 · Sandy Springs, GAFeb 19, 1969 · N7553Y · Destroyed NTSB MIA68A0108Accident · 2 fatalClosedPiper PA-30 · Statesboro, GAJun 17, 1968 · N7603Y · Destroyed NTSB MIA68F0309Accident · No injuriesClosedPiper PA-30 · Chamblee, GANov 4, 1967 · N7553Y · Substantial damage NTSB MIA68F0327Accident · No injuriesClosedPiper PA-30 · Chamblee, GAOct 30, 1967 · N7615Y · Substantial damage NTSB MIA67F0356Accident · No injuriesClosedPiper PA-30 · Jonesboro, GAJan 24, 1967 · N7030Y · Substantial damage NTSB MIA67D0196Accident · No injuriesClosedPiper PA-30 · Milledgeville, GASep 20, 1966 · N8123Y · Substantial damage