NTSB investigations: Piper PA-31-310
11 cases on aircraft the registry lists as Piper PA-31-310, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 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 ('7103102')
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\" = 353))
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 ('7103102')
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" = 353))
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 CHI05CA181Accident · Minor injuriesData collectionFinal reportPiper PA-31-310 · Lake Huron, MIThe fuel exhaustion during cruise flight, the inadequate in-flight planning/decision by the pilot, and the unsuitable terrain encountered by the pilot during the forced landing.NTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.NTSB IAD01LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-310 · Uniontown, OHFuel exhaustion due to the pilot's failure to perform fuel calculations. A factor was the inboard fuel tank probes not being within the manufacturer's resistance limits, which resulted in inaccurate fuel gauges.NTSB ATL98FA059Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Southport, NCThe pilot's failure to follow the preflight checklist, which resulted in a loss of engine power due to fuel starvation. Contributing to the significance of the accident was the pilot's failure to maintain control of the aircraft following the loss of engine…NTSB MIA96LA234Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Wassau Island, GAthe pilot's inadequate preflight and planning which resulted in fuel exhaustion.NTSB LAX91LA343Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Byron, CAThe pilot's failure to refuel the airplane and his misjudging the distance to the runway.NTSB SEA91FA025Accident · Serious injuriesField investigationFinal reportPiper PA31 · Enumclaw, WAFuel exhaustion due to inadequate preflight planning and preparations, and poor inflight planning and decisions. The pilot elected to fly into known adverse weather conditions, and did not calculate fuel consumption for the planned flight.NTSB ATL89FA066Accident · 1 fatalField investigationFinal reportPiper PA-31 · Springfield, OHFuel exhaustion precipatated by the inadequate fuel consumption calculations performed by the pilot, pressure from the company president to not carry excess fuel and improper in-flight planning/decisions by the pilot by not refueling enroute before fuel was…NTSB FTW89FA007Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Edinburg, TXAcft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's…NTSB CHI83IA360Incident · No injuriesIncident investigationFinal reportPiper PA31-310 · Mount Vernon, OHOn final approach both engines failed. The pilot elected to land intentional gear up short of therunway. Less than 1 pint of fuel was found on board.NTSB ATL82DA284Accident · No injuriesFinal reportPiper PA-31 · London, KYThe aircraft was on a flight from palm beach, FL to London, KY. Five miles short of runway 23 at London, both engines quit and the aircraft made a forced landing. Post crash examination revealed less than one gallon of fuel on board.