NTSB investigations: Piper PA-18, 1985
9 cases on aircraft the registry lists as Piper PA-18. 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
| 1964 | 47 |
|---|---|
| 1965 | 31 |
| 1966 | 21 |
| 1967 | 20 |
| 1968 | 18 |
| 1969 | 14 |
| 1970 | 23 |
| 1971 | 15 |
| 1972 | 15 |
| 1973 | 11 |
| 1974 | 19 |
| 1975 | 13 |
| 1976 | 11 |
| 1977 | 10 |
| 1978 | 8 |
| 1979 | 7 |
| 1980 | 10 |
| 1981 | 7 |
| 1982 | 9 |
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 9 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 9 |
| 1991 | 7 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 6 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 6 |
| 2000 | 6 |
| 2001 | 1 |
| 2002 | 7 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 4 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802'))
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 DEN85LA248Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Deming, NMWhile practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a…NTSB ANC85LA159Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe acft crashed shortly after the plt had departed an airstrip to proceed on a hunting trip. Impact occurred in a wooded area about 1 mi from the strip. According to witnesses, the plt had made 2 low approaches over the trees before the acdnt. The acft was…NTSB NYC85LA218Accident · No injuriesLimited investigationFinal reportPiper PA-18-95 · Millinocket, METhe plt reported that he was departing from south twin lake in winds that were from 270 deg at 12 gusting 20 KTS. After the acft lifted off the water, he started a slight turn. He stated that at about that time, a gust of wind simultaneously lifted the nose &…NTSB NYC85LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18-95 · Stowe, VTDuring cruise flt, the plt heard a loud knocking coming from the eng and a decrease in oil pressure. During the landing in a fld, the landing gear collapsed and the acft ground looped. Examination of the eng disclosed that the hydraulic lifters of three of…NTSB ANC85LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Mccarthy, AKThe pilot-in-command was departing from a 600 foot long airstrip at a 3400 foot field elevation. The takeoff run was downslope and the pilot had to pull the airplane off the ground by use of the control stick and the application of full flaps, the 40 degree…NTSB MIA85LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · St.Petersburg, FLThe pilot was assigned an aircraft with a recently overhauled engine to tow a banner. He preflighted, started and ran-up the engine 3 times. Each time the engine ran rough and lost RPM on magneto checks. After each occurrence, companymaintenance personnel…NTSB NYC85LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moose River, NYThe acft collided with trees during takeoff and crashed. The plt said he encountered turbulence at about 100 ft AGL which' forced' the acft into the trees.NTSB ANC85LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Beluga, AKThe plt stated that the right ski hit something during the takeoff run & bent the right main gear/ski down & aft. He elected to land on snow covered terrain near the small village of Beluga, AK. Before coming to rest during the landing, the acft went over on…NTSB ANC85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKPlt stated, while taxiing the wind lifted the acft twice. On the second ground contact the landing gear collapsed. Plt reported winds were from 090 degrees at 10 to 18 knots.