NTSB investigations: Piper PA-18-150
32 cases on aircraft the registry lists as Piper PA-18-150, where the first occurrence was “On ground/water encounter with terrain/water”. 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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 2 |
| 2007 | 2 |
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 ('7101828', '7104221', '7102835')
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\" = 320))
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 ('7101828', '7104221', '7102835')
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" = 320))
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 SEA08CA018Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot's failure to maintain clearance from a ditch while taxiing. Contributing factors were the pilot's inadequate visual lookout and the ditch.NTSB ANC08CA008Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe pilot's selection of an unsuitable landing area which resulted in an on ground encounter with terrain, and a nose over.NTSB ANC05TA126Accident · No injuriesFinal reportPiper PA-18-150 · Cold Foot, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing down during the landing roll. A factor associated with the accident was the rough and uneven terrain.NTSB ANC05LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain control of the airplane, which resulted in a nose over during the landing roll. A factor contributing to the accident was uneven terrain.NTSB ANC05LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrrain during the landing roll. Factors contributing to the accident were a rough/rutted and snow-covered airstrip surface, and an inadvertent ground…NTSB ANC04LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Paxson, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a rock and subsequent main landing gear collapse during the landing roll. A factor contributing to the accident was rough, uneven terrain.NTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.NTSB ANC03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a nose over. A factor contributing to the accident was the soft sand of the sandbar.NTSB ANC03CA080Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over.NTSB ANC03TA072Accident · No injuriesFinal reportPiper PA-18-160 · Anchorage, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an encounter with high brush.NTSB ANC03LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Kenai, AKThe pilot's failure to compensate for gusting wind conditions during the landing flare, which resulted in the airplane encountering brush, and nosing over. Factors contributing to the accident were high brush, and gusting winds.NTSB ANC03LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an encounter with soft snow, and subsequent nose over during the landing roll. A factor contributing to the accident was the soft, snow-covered terrain.NTSB ANC03LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain aircraft control which resulted in a nose over. A factor contributing to the accident was standing puddles of water on the frozen lake.NTSB ANC02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Copper Center, AKThe pilot's selection of unsuitable terrain for landing, resulting in a nose-over during the landing roll. A factor contributing to the accident was rough/uneven terrain.NTSB ANC02TA036Accident · No injuriesFinal reportPiper PA-18 · Holy Cross, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was the presence of high vegetation (willows) along the right side of the landing area.NTSB ANC00LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll. A factor associated with the accident was the presence of tall brush alongside the runway.NTSB ANC00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were soft, snow covered terrain.NTSB ANC99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Seward, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft sand.NTSB FTW99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palacios, TXThe pilot's failure to maintain clearance with terrain. A factor was the high vegetation.NTSB ANC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cordova, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was grass covered rocks.NTSB ANC98LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were snow covered terrain, and a hidden obstruction.NTSB ANC96LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor in the accident was the soft terrain.NTSB SEA96LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ephrata, WAfailure of the pilot to maintain proper alignment with the landing area (driveway) during the landing. Factors relating to the accident were: the selection of an unsuitable area for landing, the reported turbulence during landing, and an encounter with a rock…NTSB ANC96LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's selection of unsuitable terrain for landing. Soft sandy terrain was a related factor.NTSB ANC95LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKFailure of the pilot to maintain proper alignment with the intended takeoff area during the takeoff roll. Factors relating to the accident were: pilot fatigue and the proximity of rocks/boulders to the takeoff area.NTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.NTSB ANC95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Juneau, AKThe pilot's selection of unsuitable terrain for the attempted takeoff.NTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.NTSB ANC89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Trading Bay, AKSelection of unsuitable terrain (landing area) by the pilot. Contributing factors were: improper information provided by other personnel and a hidden obstruction (log) in tall vegetation (grass).NTSB DEN89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Medicine Lake, MTSelection of unsuitable terrain by the pilot, resulting in a collision with snowdrifts during landing ground run.NTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…NTSB CHI84LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sauk Rapids, MNThe plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over.