NTSB investigations: Piper PA-18-150, 2014
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
| 2008 | 4 |
|---|---|
| 2009 | 6 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 7 |
| 2013 | 7 |
| 2014 | 8 |
| 2015 | 6 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 11 |
| 2019 | 9 |
| 2020 | 6 |
| 2021 | 7 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 2 |
| 2025 | 5 |
| 2026 | 2 |
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\") = 2014
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 year(c."eventDate") = 2014
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 ANC14CA084Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cantwell, AKThe pilot's loss of directional control during takeoff from an off-airport site, which resulted in a collision with terrain.NTSB ANC14CA063Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilots excessive use of the airplanes brakes during the landing roll, which resulted in a nose over. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.NTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.NTSB WPR14CA289Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll.NTSB ANC14CA053Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Prudhoe Bay, AKThe pilot's failure to maintain directional control during landing and attempted go-around, resulting in contact with terrain and a ground loop.NTSB ERA14CA211Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Woodbine, NJThe flight instructor's delayed reaction to the loss of directional control, which resulted in a ground loop.NTSB ERA14CA188Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Bethel, METhe pilot's failure to maintain control of the airplane while taxiing after landing during gusty wind conditions.NTSB ERA14CA140Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Mayaguez, PRThe pilot's loss of directional control of the airplane during landing, which resulted in a runway excursion.