NTSB investigations: Piper PA-18-150, 1993
27 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\") = 1993
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") = 1993
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 ANC94LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot-in-command not maintaining the proper clearance from the terrain during the approach.NTSB LAX94FA065Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Payson, AZImproper in-flight planning/decision by the pilot, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: pilot impairment from improper use of prescription drugs (not approved for…NTSB ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.NTSB ANC94LA012Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Haines, AKFatigue failure in a weld on the right main landing gear oleo strut tubing.NTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.NTSB ANC93LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Rocky River, AKThe pilot misjudging his altitude on final approach.NTSB ANC93LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot failed to adequately compensate for the wind conditions. A factor was the unfavorable wind.NTSB ANC93LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prudhoe Bay, AKFluid fuel contamination as a result of the pilot-in-commands improper preflight planning/preparation.NTSB ANC93LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mosquito River, AKThe pilot's failure to maintain a proper altitude during the low pass. A factor was the rough/uneven terrain.NTSB ANC93LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Squirrel River, AKThe pilot improperly compensated for the wind conditions.NTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.NTSB ANC93LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Happy Valley, AKThe pilot's improper preflight planning/decision, and his failure to maintain directional control of the airplane. A factor was the rough/uneven terrain.NTSB ANC93LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Little Delta Rv, AKThe pilot's failure to maintain control of the airplane during the takeoff climb. Factor was the gusty winds.NTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.NTSB ANC93LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper planning/decision, while on an approach to land behind another airplane.NTSB DEN93LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, COThe pilot's failure to maintain directional control.NTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.NTSB ANC93LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Uganik River, AKPilot in commands failure to compensate adequately for shifting wind conditions and his selection of unsuitable terrain on which to land. A factor in the accident was the rough uneven terrain landing strip.NTSB ANC93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot in command selected unsuitable terrain on which to land on. A factor in the accident was the rough/uneven, soft terrain.NTSB FTW93TA#07Accident · No injuriesFinal reportPiper PA-18-150 · Del Rio, TXNTSB MIA93LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pensacola, FLThe pilot-in-command's inadequate compensation for wind conditions and delayed remedical action.NTSB ANC93LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot in command's inadvertent ground loop.NTSB LAX93LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Vacaville, CAthe pilot's failure to maintain directional control after encountering strong and gusty cross winds during the landing flare.NTSB FTW93TA#04Accident · No injuriesFinal reportPiper PA-18-150 · Godley, TXNTSB ANC93FA054Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kashwitna, AKThe pilot in command not maintaining control of the airplane and his inadequate preflight preparation for high mountain terrain big game operations. Factors contributing to the accident were: the high terrain condition and the lack of total experience in the…NTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.