NTSB investigations: Piper PA-18-150, 1988
14 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
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\") = 1988
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") = 1988
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 DEN89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground…NTSB ANC89LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Huslia, AKThe private pilot and his adult male passenger were both severely burned when the pilot's Piper PA-18 crashed and burned following a low altitude stall and impact with trees. The pilot's wife stated that her husband told her that he was showing his passenger…NTSB ANC88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe commercial pilot attempted to takeoff from a rough and soft off-airport site in rural Alaska. During the takeoff roll, the airplane's main landing gear encountered an exceptionally soft spot, causing the airplane to nose over. The pilot stated that the…NTSB ANC88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe private pilot was attempting to land at a remote beach site to join a pilot friend who had landed there earlier in his own airplane. The pilot on the beach had placed a sleeping bag and other items in a hole on the beach to mark it as a landing hazard.…NTSB ANC88LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe private pilot and his passenger were uninjured when their Piper PA-18 (super cub) ground-looped while landing at Anchorage international airport, Anchorage, AK. The pilot stated that the right main landing gear tire 'grabbed' when it touched the paved…NTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…NTSB ANC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shismaref, AKThe pilot stated he decided to land on the beach due to weather. After touchdown on the beach the main landing gear dropped into an area of soft sand; the aircraft then went over on its back.NTSB ATL88LA172Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mocksville, NCThe floatplane student pilot lost control of the aircraft during a practice glassy water take off. The floatplane instructor did not take control soon enough and the aircraft stalled and struck the water.NTSB ANC88FA052Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Larson Bay, AKA float equipped Piper PA-18-150 and float equipped Cessna 185F, were involved in a midair collision at an altitude of approximately 800 feet MSL over Larson Bay, AK. At the time of the midair collision both aircraft were being used as fish spotters for…NTSB ANC88FA045Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot-in-command was a certificated airframe and powerplant mechanic who was working on the airplane. The owner stated that the mechanic was not authorized to fly the airplane. The pilot's brother stated he had just disembarked from the airplane after a…NTSB ANC88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe private pilot-in-command of the Piper PA-18 lost control of the airplane while attempting to takeoff from a section of snow covered river ice.NTSB LAX88LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Shandon, CADuring the initial climb, at approximately 20 feet AGL, a gust of wind forced the aircraft off course, resulting in a collision with a shed near the private dirt strip. The pilot reported that there were no mechanical failures or malfunctions with the…NTSB DEN88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Peyton, CONTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…