NTSB investigations: Piper PA-30
14 cases on aircraft the registry lists as Piper PA-30, where the first occurrence was “Airframe/component/system failure/malfunction”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.NTSB ATL00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Key West, FLA landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.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.NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…NTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.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.NTSB FTW91FA033Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oppella, ARThe pilot's failure to maintain a proper climb rate following loss of his visual references and allowing himself to become diverted during the takeoff. Factors in the accident were interrupted instrument lighting and the dark night conditions.NTSB MIA88LA113Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jupiter, FLThe plt stated that he had completed a ldg away from his home base without the gear down & locked lights being illuminated. He stated that he had assumed the lights were 'burned out'. Upon departure, he retracted the gear & flew to his home airport. Upon…NTSB LAX87LA013Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Oceanside, CADuring a x-country flt, the plt stated, that just south of los angeles international arpt, the acft's right engine was running rough. At the same time pwr in the left engine began decreasing, then the prop automatically feathered. The plt attempted a re-start…NTSB MIA85LA060Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jacksonville, FLElectrical malfunctions caused the loss of air to ground communications and acft navigational equipment. The plt became lost about 70 mi east of Jacksonville, FL. With the help of another acft the plt located the arpt and radio communications were temporarily…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…NTSB CHI84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indianapolis, INAfter takeoff from dyersburg the gear would not fully retract. The plt attempted to lower the gear manually but it was stuck in the transient position. The plt then diverted to Indianapolis & landed with the gear in the transient position. Investigation…NTSB CHI82FA211Accident · No injuriesField investigationFinal reportPiper PA-30 · Vandalia, OHDuring descent at 215 mph the acft entered violent buffeting. Recovery was initiated by reducing power & the acft landed without any further incident. Examination revealed the horizontal stabilator was permanently bent downward on both sides. The acft was…