NTSB investigations: Piper PA-18-150, 2008
9 cases on aircraft the registry lists as Piper PA-18-150, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2008 | 9 |
|---|---|
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 13 |
| 2013 | 6 |
| 2014 | 14 |
| 2015 | 4 |
| 2016 | 6 |
| 2018 | 12 |
| 2019 | 10 |
| 2020 | 4 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 2008
AND 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 year(c."eventDate") = 2008
AND 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ANC08TA107Accident · No injuriesFinal reportPiper PA-18-150 · Slana, AKThe pilot's failure to maintain directional control during an aborted takeoff.NTSB ANC08CA108AccidentData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain clearance from a tarp used as a marker at the departure end of the takeoff area.NTSB MIA08LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · N Myrtle Beach, SCThe failure of the banner tow operator to inspect banners for deterioration, resulting in a portion of a banner separating in-flight from another banner tow airplane, and colliding with the accident banner tow airplane.NTSB ANC08LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKA loss of engine power for an undetermined reason during an approach for landing, which resulted in a forced landing and collision with terrain.NTSB ANC08LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's failure to maintain directional control during the takeoff roll and liftoff, which resulted in a collision with trees and the ground.NTSB ANC08LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKA partial loss of engine power during an aborted landing for an undetermined reason, which resulted in a collision with terrain and subsequent nose over.NTSB ANC08CA070Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was a gust of wind.NTSB ANC08LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Nikolai, AKThe flight instructor's inadequate evaluation of the weather conditions. Contributing to the accident was an inadvertent stall/mush.NTSB DFW08CA059Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Sheffield, TXThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall.