Skip to content

NTSB investigations: Piper PA-30, PA

28 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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · Destroyed NTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.Feb 16, 2014 · N931JS · Substantial damage NTSB ERA14FA077Accident · 2 fatalField investigationFinal reportPiper PA-30 · Biglerville, PAThe noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.Dec 26, 2013 · N8372Y · Destroyed NTSB NYC91FA112Accident · 1 fatalField investigationFinal reportPiper PA-30 · Hollidaysburg, PAThe pilot's loss of control for undetermined reasons.Apr 13, 1991 · N8073Y · Destroyed NTSB NYC83LA010Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe pilot stated that while practicing touch-and-go landings he encountered turbulence during a touchdown. When he aborted the takeoff segment the aircraft departed the runway and the landing gear collapsed.Oct 17, 1982 · N7518Y · Substantial damage NTSB NYC82DA229Accident · No injuriesFinal reportPiper PA-30F · Dubois, PAThe pilot stated that shortly after takeoff the radio master circuit breaker tripped. He repositioned the switch but it tripped again. As the flight returned to the airport the landing gear and flap trim failed to respond. The pilot confirmed a complete loss…Sep 20, 1982 · N330CP · Substantial damage NTSB NYC80FGM12Accident · No injuriesClosedPiper PA-30 · Waynesburg, PAMar 3, 1980 · N7315Y · Substantial damage NTSB NYC74AN092Accident · 2 fatalClosedPiper PA-30 · Champion, PAApr 19, 1974 · N7296Y · Destroyed NTSB NYC73FGM15Accident · No injuriesClosedPiper PA-30 · Conemaugh, PAJan 3, 1973 · N153MC · Substantial damage NTSB NYC73FHD17Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAOct 18, 1972 · N8662Y · Substantial damage NTSB NYC72FGT11Accident · Serious injuriesClosedPiper PA-30 · Lock Haven, PAJun 18, 1972 · N8829Y · Destroyed NTSB NYC71DHG09Accident · No injuriesClosedPiper PA-30 · Hershey, PAJan 23, 1971 · N8685Y · Substantial damage NTSB NYC70IN119Incident · No injuriesClosedPiper PA-30 · State College, PAMay 14, 1970 · N8742Y · Minor damage NTSB NYC70A0031Accident · 4 fatalClosedPiper PA-30 · Port Royal, PASep 4, 1969 · N7005Y · Destroyed NTSB NYC70A0028Accident · 3 fatalClosedPiper PA-30 · Bradford, PAAug 30, 1969 · N8391Y · Destroyed NTSB NYC69F0363Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAMar 3, 1969 · N8609Y · Substantial damage NTSB NYC69D0287Accident · No injuriesClosedPiper PA-30 · Toughkenamon, PAJan 4, 1969 · N8126Y · Substantial damage NTSB NYC69A0007Accident · 1 fatalClosedPiper PA-30 · Lock Haven, PAJul 9, 1968 · N8572Y · Destroyed NTSB NYC69F0007Accident · No injuriesClosedPiper PA-30 · Reading, PAJun 15, 1968 · N7569Y · Substantial damage NTSB NYC68F0049Accident · No injuriesClosedPiper PA-30 · Selinsgrove, PAJun 28, 1967 · N7412Y · Substantial damage NTSB NYC67F0583Accident · No injuriesClosedPiper PA-30 · Allentown, PAApr 10, 1967 · N7110Y · Substantial damage NTSB NYC67A0076Accident · No injuriesClosedPiper PA-30 · New Cumberland, PANov 7, 1966 · N7507Y · Substantial damage NTSB NYC67F0326Accident · No injuriesClosedPiper PA-30 · Morrisville, PAOct 25, 1966 · N7907Y · Destroyed NTSB NYC67D0158Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAJul 25, 1966 · N7626Y · Substantial damage NTSB NYC66F0478Accident · No injuriesClosedPiper PA-28 · Friedens, PAJan 21, 1966 · N4567R · 2 aircraft · Substantial damage NTSB UNK65X1271Accident · No injuriesClosedPiper PA30 · Reading, PAJan 11, 1965 · N7178Y · Substantial damage NTSB UNK65X0119Accident · No injuriesClosedPiper PA30 · Reading, PAOct 3, 1964 · N7178Y · Substantial damage NTSB UNK64X0876Accident · No injuriesClosedPiper PA30 · Montoursville, PAMar 10, 1964 · N7005Y · Substantial damage