NTSB investigations: Piper PA-18-150, 2023
15 cases on aircraft the registry lists as Piper 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
| 1963 | 1 |
|---|---|
| 1964 | 35 |
| 1965 | 37 |
| 1966 | 43 |
| 1967 | 47 |
| 1968 | 47 |
| 1969 | 42 |
| 1970 | 36 |
| 1971 | 37 |
| 1972 | 29 |
| 1973 | 36 |
| 1974 | 35 |
| 1975 | 42 |
| 1976 | 50 |
| 1977 | 59 |
| 1978 | 41 |
| 1979 | 46 |
| 1980 | 45 |
| 1981 | 36 |
| 1982 | 28 |
| 1983 | 27 |
| 1984 | 33 |
| 1985 | 18 |
| 1986 | 31 |
| 1987 | 35 |
| 1988 | 14 |
| 1989 | 32 |
| 1990 | 23 |
| 1991 | 19 |
| 1992 | 21 |
| 1993 | 27 |
| 1994 | 26 |
| 1995 | 30 |
| 1996 | 18 |
| 1997 | 28 |
| 1998 | 28 |
| 1999 | 24 |
| 2000 | 23 |
| 2001 | 13 |
| 2002 | 17 |
| 2003 | 30 |
| 2004 | 26 |
| 2005 | 15 |
| 2006 | 13 |
| 2007 | 19 |
| 2008 | 17 |
| 2009 | 19 |
| 2010 | 19 |
| 2011 | 21 |
| 2012 | 25 |
| 2013 | 12 |
| 2014 | 21 |
| 2015 | 18 |
| 2016 | 15 |
| 2017 | 6 |
| 2018 | 19 |
| 2019 | 19 |
| 2020 | 13 |
| 2021 | 14 |
| 2022 | 14 |
| 2023 | 15 |
| 2024 | 13 |
| 2025 | 17 |
| 2026 | 8 |
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 year(c.\"eventDate\") = 2023
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'))
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") = 2023
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'))
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 ANC24FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Anchor Point, AKAn impact to the left wing, at an undetermined time, for reasons that could not be determined, which partially separated the left wing and rendered the airplane uncontrollable.NTSB ERA24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Tompkinsville, KYThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a hard landing.NTSB ANC24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe instructor pilot’s delayed action and over application of brakes which resulted in a nose-over.NTSB ANC23LA084Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB ANC23LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s failure to maintain directional control during after encountering a wind gust during landing that resulted in an impact with terrain.NTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…NTSB ANC23LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McCarthy, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB ANC23LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Tyonek, AKThe pilot’s encounter with windshear during the initial climb, which resulted in a loss of control.NTSB ANC23FA061Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Skwentna, AKAn impact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.NTSB ANC23LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's excessive braking during landing on a sand bar, which resulted in a nose over.NTSB CEN23LA210Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St. Anthony, NDThe pilot’s failure to maintain clearance from terrain while maneuvering at low attitude.NTSB ANC23LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a water loop and impact with terrain.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 ANC23LA018Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-180 · Glennallen, AKThe pilot’s failure to maintain airspeed during a drag maneuver, which resulted in an overrun and subsequent impact with terrain.NTSB ANC23LA011Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain directional control during landing in flat light conditions, resulting in the airplane to nose over.