NTSB investigations: Piper PA-18-150, 2015
7 cases on aircraft the registry lists as Piper PA-18-150, where the sequence of events included Nose over/nose down. 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 | 3 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 5 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 3 |
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\") = 2015
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\" = '096' 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") = 2015
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" = '096' 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 GAA16CA004Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's excessive brake application during landing, which resulted in a nose-over.NTSB GAA15CA254Accident · No injuriesData collectionFinal reportPiper PA 18-150 · LaBelle, FLThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over and impact with terrain.NTSB ANC15CA054Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's inadequate compensation for wind conditions, and improper recovery from a bounced landing resulting in a loss of control and collision with terrain.NTSB WPR15CA207Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Carlsbad, CAThe pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.NTSB ANC15CA039Accident · No injuriesData collectionFinal reportPiper PA 18-150 · McCarthy, AKThe pilot's excessive use of wheel brakes during landing, resulting in a nose over.NTSB ANC15CA028Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Seward, AKThe pilot's excessive braking during landing, which resulted in a nose over.NTSB ANC15CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Anchorage, AKThe pilot's excessive use of brakes to maintain directional control, which resulted in a nose over.