NTSB investigations: Piper PA-31-310, AK
11 cases on aircraft the registry lists as Piper PA-31-310. 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
| 1974 | 2 |
|---|---|
| 1978 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2026 | 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.\"eventStateOrRegion\" = 'AK' 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 ('7103102'))
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" = 'AK' 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 ('7103102'))
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 ANC26LA009Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-31-310 · Anchorage, AKNTSB ANC05CA078Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Manokotak, AKThe pilot's failure to extend the landing gear. A contributing factor was the pilot's failure to use the checklist.NTSB ANC03LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cape Yakataga, AKThe pilot's failure to follow the prelanding checklist, which resulted in a wheels up landing when he neglected to lower the airplane's landing gear. A factor in the accident was the pilot's diverted attention associated with turbulence and a wet airstrip.NTSB ANC95FA086Accident · 4 fatalField investigationFinal reportPiper PA-31 · Valdez, AKThe pilot's failure to follow the published IFR (missed approach) procedure and assure adequate altitude/clearance from mountainous terrain.NTSB ANC94FA087Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Mccarthy, AKThe pilot's inadvertent use of the parking brake during the takeoff and not aborting the takeoff. A factor in the accident was the pilot's improper use of the airplane checklist.NTSB ANC93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Mekoryuk, AKPilot-in-command initiated VFR flight into IMC conditions. A factor in this accident was the whiteout weather conditions.NTSB ANC89LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Tok Junction, AKThe pilot's failure to lower the landing gear for landing. A factor related to the accident was his failure to use a checklist.NTSB ANC81IA047Incident · Minor injuriesClosedPiper PA-31 · Port Heiden, AKNTSB ANC78DA010Accident · No injuriesClosedPiper PA-31 · Scammon Bay, AKNTSB ANC75AA008Accident · Minor injuriesClosedPiper PA-31 · Umiat, AKNTSB ANC74AA070Accident · No injuriesClosedPiper PA-31 · Fairbanks, AK