NTSB investigations: Piper PA-18-150, 2011
21 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\") = 2011
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") = 2011
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 WPR12CA028Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.NTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.NTSB ERA12CA015Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Elizabethton, TNThe failure of the pilot to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB ANC11CA115Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe student pilot's hard landing in a gusting wind.NTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.NTSB ANC11FA093Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot inadvertently switched off the engine magnetos during short final approach, which resulted in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches in the cabin.NTSB ANC11CA092Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's continued visual flight into instrument meteorological conditions.NTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.NTSB ANC11CA086Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Beluga Lake, AKThe pilot's decision to takeoff with an unfavorable wind which resulted in a loss of directional control, and collision with terrain.NTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.NTSB WPR11FA390Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Forsyth, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.NTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.NTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.NTSB ANC11CA047Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's loss of directional control while landing in a crosswind.NTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC11CA021Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken Lake, AKThe pilot's failure to maintain adequate clearance from terrain.NTSB WPR11LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Twin Falls, IDThe pilot’s failure to compensate for the wind, which resulted in the airplane being blown over after completion of the landing roll.NTSB WPR11TA087Accident · No injuriesFinal reportPiper PA-18-180 · Shoshoni, WYA total loss of engine power for undetermined reasons.