NTSB investigations: Piper PA-18, 1982
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\") = 1982
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") = 1982
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 DEN83LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Camp Crook, SDPilot making low altutude turns found controls jammed and collided left wing low in descent with bales of hay. Fuselage was found to contain spent and live shotgun shells under the floor. Aileron had a firing pin from a shotgun lodged in a pulley. The pilot…NTSB LAX83LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Oceanside, CAWhile attempting a touch and go from a wheel landing the pilot lost directional control and collided with a parked aircraft and a chain fence, finally nosing over. The pilot said he did not use enough right rudder during the roll. The parked aircraft, N5515B,…NTSB ANC82FA089Accident · No injuriesField investigationFinal reportPiper PA-18 · Near Clear, AKThe plt reported that immediately after lift-off the acft began a right turn. He applied full left rudder & left aileron but the acft did not respond. It continued to turn right until it struck trees on the right side of the strip. The plt thought there was a…NTSB NYC82DA168Accident · No injuriesFinal reportPiper PA-18S · Moultonboro, NHAccording to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was…NTSB MIA82DA153Accident · Minor injuriesFinal reportPiper PA-18 · Kenneth City, FLWhile cruising the aircraft oil pressure dropped and smoke entered the cockpit, so made a forced landing in a small field. The aircraft hit a stump and nosed over. An investigation revealed a broken oil line to a pressure gauge and oil leaked on a hot exhaust…NTSB CHI82DA220Accident · Minor injuriesFinal reportPiper PA-18 · Hobart, INDuring takeoff, the engine lost power at an altitude of about 150 to 200 ft AGL. Subsequently, during a forced landing, the aircraft flew through a row of trees when the pilot tried to reach an open area that turned out to be a grave yard. The pilot believed…NTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…NTSB ANC82DAG28Accident · 1 fatalFinal reportPiper PA-18 · Kenai, AKPilot was giving passengers rides along bishop creek. He was reported as flying low and erratic. On the last flight with two passengers, the wing dipped & caught the water. The acft then cartwheeled. The plt's blood alcohol level was 196 mg%.NTSB ANC82DA023Accident · No injuriesFinal reportPiper PA-18 · Near Gulkana, AKThe pilot stated that he arrived at crosswinds lake, made a low pass and attempted to contact the wheels on the snow to determine if a landing was possible. The wheels broke through the crust on the snow and the aircraft flipped over.