NTSB investigations: Piper PA-18-150, CO
8 cases on aircraft the registry lists as Piper PA-18-150, where the sequence of events included Loss of control on ground. 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
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2025 | 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 c.\"eventStateOrRegion\" = 'CO' 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 ('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\" = '230' 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."eventStateOrRegion" = 'CO' 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 ('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" = '230' 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 CEN25LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Meeker, COThe student pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN23LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Brush, COThe pilot’s failure to maintain directional control during the landing roll with strong gusty surface winds.NTSB GAA19CA572Accident · No injuriesData collectionFinal reportPiper PA18 · Boulder, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA19CA045Accident · No injuriesData collectionFinal reportPiper PA18 · Denver, COThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions.NTSB CEN16LA348Accident · No injuriesLimited investigationFinal reportPiper PA 18-180 · Colorado Springs, COThe pilot's failure to maintain directional control after encountering a wind gust during the landing roll, which resulted in a ground loop.NTSB GAA15CA011Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Boulder, COThe pilot's loss of directional control during a bounced landing, which resulted in a runway excursion.NTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.NTSB CEN10CA473Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Watkins, COThe pilot's failure to maintain aircraft control during the landing, resulting in a ground-loop.