NTSB investigations: Piper PA-18A-135, AK
13 cases on aircraft the registry lists as Piper PA-18A-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 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1992 | 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 ('7101822'))
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 ('7101822'))
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 ANC92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18A-135 · Paxson, AKThe pilot failed to attain & maintain takeoff airspeed. Factors to the accident were: takeoff was performed with a tailwind, and inadequate remedial action.NTSB ANC90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe main wheels (or brakes) had locked for an unknown reason.NTSB ANC88LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chandalar River, AKAfter touchdown on the gravel bar along the side of the River, the pilot lost control and the airplane nosed over on its back.NTSB ANC88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe private pilot reported that he was attempting to land at an unimproved, off-airport landing site near Delta Junction, AK. The landing area that he selected was muddier than he had anticipated, and the airplane decelerated too rapidly and nosed over,…NTSB ANC87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot elected to make an off airport landing in his ski-equipped Piper PA18 airplane. He landed the acft successfully, but the right ski attachment and left gear leg collapsed on take off from the uneven terrain. The acft was substantially…NTSB ANC84FA137Accident · No injuriesField investigationFinal reportPiper PA-18A · Mckinley, AKThe acft crashed while attemptng a takeoff from a gravel bar. The plt estimated the useable area for takeoff as 400 to 500 ft. investigation revealed that the density altitude was at least 3400 ft MSL. A test eng run after the acft was recovered, determined…NTSB ANC83LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · W. Clam Gulch, AKThe acft stalled and crashed during an approach to land in a wilderness area. According to the plt he was preoccupied with landing near a wolverine he wanted to shoot. His approach was too high so he closed the throttle put down full flaps and started a turn.…NTSB ANC80DAG65Accident · No injuriesClosedPiper PA-18A · Beluga, AKNTSB ANC76DAH32Accident · No injuriesClosedPiper PA-18 · Copper Center, AKNTSB ANC74DAG95Accident · No injuriesClosedPiper PA-18 · Eek, AKNTSB ANC68D0008Accident · Minor injuriesClosedPiper PA-18 · Dillingham, AKNTSB ANC66A0002Accident · 1 fatalClosedPiper PA-18A · Palmer, AKNTSB UNK64X3096Accident · No injuriesClosedPiper PA18A · Port Heiden, AK