NTSB investigations: Piper/Cub Crafters PA-18-150
12 cases on aircraft the registry lists as Piper/Cub Crafters PA-18-150. 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
| 2001 | 1 |
|---|---|
| 2002 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101843'))
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 ('7101843'))
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 CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB GAA19CA285Accident · No injuriesData collectionFinal reportPiper PA18 · Cody, WYThe student pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent loss of airplane control after overcorrecting with rudder. Contributing to the accident was the flight instructor's delayed remedial…NTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.NTSB ERA13CA353Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Eagle Bay, NYThe pilot's failure to set the engine throttle to full power during a go-around.NTSB CEN11LA632Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18-150 · Long Lake, WIThe pilot's failure to complete the prelanding checklist, which resulted in the landing gear wheels not being retracted for the water landing.NTSB WPR10CA362Accident · Minor injuriesData collectionFinal reportPiper/Cub Crafters PA-18-150 · Lucile, IDThe pilot's delayed decision to perform a go-around, which resulted in the airplane colliding with a fence during the initial climb.NTSB CEN09CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Colorado Springs, COFailure of the pilot to maintain directional control and his failure to compensate for wind conditions. Contributing to the accident were gusting winds with a wind shear warning in effect.NTSB LAX08CA171Accident · No injuriesData collectionFinal reportPiper Cub Crafters PA-18-150 · Fall RiverMills, CAThe pilot's selection of an unsuitable takeoff/landing area.NTSB ANC07CA098Accident · No injuriesData collectionFinal reportPiper/Cub Crafters PA-18 · Umiat, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an on ground encounter with terrain, and a nose over.NTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.NTSB DEN02GA039Accident · 1 fatalFinal reportPiper/Cub Crafters PA-18-150 · USAF Academy, COThe loss of control for undetermined reasons.NTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.