NTSB investigations: Piper PA-18-105 SPECIAL, AK
20 cases on aircraft the registry lists as Piper PA-18-105 SPECIAL. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2021 | 2 |
| 2022 | 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 ('7101808'))
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 ('7101808'))
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 ANC24LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Big Lake, AKThe pilot’s failure to maintain clearance from an obstacle during takeoff.NTSB CEN22LA417Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Delta Junction, AKThe pilot’s decision to depart during high, gusty wind conditions which resulted sink and subsequent impact with terrain.NTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.NTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.NTSB GAA16CA210Accident · Minor injuriesData collectionFinal reportPiper PA18S · Talkeetna, AKThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose over.NTSB ANC14CA029Accident · No injuriesData collectionFinal reportPiper PA 18-105 Special · Anchorage, AKThe pilot's loss of control of the airplane during landing roll on a rough, grass airstrip in gusting wind.NTSB ANC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palmer, AKThe pilot's selection of an unsuitable takeoff area, and his failure to achieve takeoff speed which resulted in an on ground collision with a ditch. Contributing factors were soft and snow-covered terrain, and a ditch.NTSB ANC00LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Slana, AKThe pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.NTSB ANC90LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Falls Creek, AKPilot-in-command's failure to maintain aircraft control.NTSB ANC89LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Port Moller, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's self induced pressure and the adverse weather conditions.NTSB ANC87FA095Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Sheep Mountain, AKThe pilot and his two passengers took off in a two place Piper PA-18 from a glacier after doing repair work on an aircraft that had crashed there earlier. Weather conditions were deteriorating as they approached their destination airstrip located in a nearby…NTSB ANC86LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big River, AKThe pilot attempted a touch and go landing to evaluate a questionable landing area. The area was too soft for a touch and go. The acft became mired in mod and nosed over.NTSB ANC82FAG30Accident · 2 fatalFinal reportPiper PA-18 · Near Dillingham, AKThe acft impacted a side of a mountain Near horseshoe pass at an elevation of 250 ft above sea level. The accident occurred during the hours of daylight with VMC prevailing.NTSB ANC76FAG51Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC74DAG79Accident · No injuriesClosedPiper PA-18 · Talkeetna, AKNTSB ANC70A0039Accident · 2 fatalClosedPiper PA-18 · Palmer, AKNTSB ANC69F0005Accident · No injuriesClosedPiper PA-18 · Juneau, AKNTSB ANC67F0060Accident · No injuriesClosedPiper PA-18 · Juneau, AKNTSB ANC67F0027Accident · No injuriesClosedPiper PA-18 · Soldotna, AKNTSB ANC66F0038Accident · No injuriesClosedPiper PA-18 · Mcgrath, AK