NTSB investigations: Piper PA-20-135, AK
13 cases on aircraft the registry lists as Piper PA-20-135. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1970 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1998 | 1 |
| 2006 | 1 |
| 2024 | 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 ('7102010'))
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 ('7102010'))
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 ANC24LA047Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Nenana, AKThe pilot providing instruction’s delayed remedial action, resulting in a loss of control during landing roll.NTSB ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.NTSB ANC98LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mcgrath, AKThe failure of the pilot to maintain directional control during takeoff. Factors involved in the accident were a crosswind, and the trees adjacent to the takeoff area.NTSB ANC86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Two Lakes, AKThe pilot lost control of the aircraft on the initial climb. The pilot stated that after takeoff the wind shifted 180 degrees.NTSB ANC85LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-20-135 · Anchorage, AKLow time student plt lost control during attempted go-around & crashed into two parked acft. 8 to 12 kt crosswind was reported.NTSB ANC84FA056Accident · Minor injuriesField investigationFinal reportPiper PA-20 · Anchorage, AKThe acft veered during takeoff roll and left the right side of the rwy after about 200 ft of roll. The left main landinggear collapsed and separated from the acft.NTSB ANC82DA021Accident · No injuriesFinal reportPiper PA-20 · Bethel, AKThe pilot was taxiing to the tie-down area when the right ski/landing gear failed. The pilot attributed the failure to age and noted that ice landings are hard on ski equipped aircraft.NTSB ANC77DAA02Accident · No injuriesClosedPiper PA-20 · Oshetna River, AKNTSB ANC70DAG08Accident · No injuriesClosedPiper PA-20 · Glennallen, AKNTSB ANC68F0025Accident · No injuriesClosedPiper PA-20 · Mcgrath, AKNTSB ANC68F0020Accident · Serious injuriesClosedPiper PA-20 · Kenai, AKNTSB ANC67D0016Accident · No injuriesClosedPiper PA-20 · Fairbanks, AKNTSB UNK64X3292Accident · No injuriesClosedPiper PA20 · Summit, AK