NTSB investigations: Piper PA-18A 150
16 cases on aircraft the registry lists as Piper PA-18A 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 | 1 |
|---|---|
| 2011 | 3 |
| 2012 | 3 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 2 |
| 2019 | 1 |
| 2023 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101837')
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101837')
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 ANC24LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Denali, AKFailure to maintain clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB WPR23LA158Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Garrison, MOThe pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.NTSB GAA20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Gerlach, NVThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.NTSB GAA16CA262Accident · No injuriesData collectionFinal reportPiper PA 18A · Westminster, MDThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with terrain.NTSB ANC15CA022Accident · Serious injuriesData collectionFinal reportPiper PA 18A 150 · Nondalton, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.NTSB ANC14LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s inadvertent application of excessive brake pressure during landing on a rough surface, which resulted in a nose-over.NTSB WPR14CA228Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Leeds, UTThe pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.NTSB ANC14CA023Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Kenai, AKThe pilot's loss of directional control during takeoff, resulting in a collision with terrain and ground loop.NTSB ANC12CA091Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Talkeetna, AKThe pilot's decision to land on a short, wet, off-airport landing site, which resulted in a runway excursion.NTSB ANC12CA062Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Illiamna, AKThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of control.NTSB ANC12CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s selection of unsuitable terrain for taxi.NTSB ANC11CA064Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Cordova, AKThe pilot's failure to maintain sufficient airspeed during approach, resulting in an aerodynamic stall, and collision with terrain.NTSB ERA11LA200Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Hollywood, FLA total loss of engine power for undetermined reasons.NTSB ANC11CA020Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Beluga Lake, AKThe pilot's decision to land on unsuitable terrain, resulting in the airplane nosing over.NTSB ANC08FA079Accident · 1 fatalField investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain directional control while landing in a gusty crosswind.