NTSB investigations: Piper PA-18
19 cases on aircraft the registry lists as Piper PA-18, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 MIA95GA178Accident · 2 fatalFinal reportPiper L-21A · Lorida, FLThe pilot's failure to maintain airspeed while his attention was diverted.NTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).NTSB CHI94LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Terre Haute, INthe pilot-in-command's inadvertant stall of the airplane. A factor associated with the accident was the elevator trim position.NTSB ANC93LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon Flat, AKThe pilot in commands misjudgment of aerodynamic maneuvering parameters (inflight decision making), and his inadvertant stall/spin entry at low altitude.NTSB ANC92LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Nome, AKThe pilot inadvertently stalled the airplane. Contributing to the accident was inadequate altitude.NTSB ANC91LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThat the pilot inadvertently stall/spun the airplane to the ground. Contributing to the accident was the pilot's failure to adequately remove the ice/frost from the wings before starting the takeoff.NTSB ANC91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eureka, AKThe pilot-in-command's failure to maintain airspeed and directional control of the airplane during the initial climb.NTSB ANC90LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe pilot-in-command's failure to maintain aircraft control.NTSB ATL90FA153Accident · 2 fatalField investigationFinal reportPiper PA-18 · Southport, NCThe entry into a flat spin which precluded recovery by the pilot. The reason for the spin becoming flat could not be determined.NTSB ANC90LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot-in-command's failure to maintain flying speed during the go-around.NTSB ANC88DAG05Accident · 2 fatalFinal reportPiper PA-18A · Mcgrath, AKThe airplane crashed approximately 94 miles east of the city of Mcgrath, Alaska. The pilot and passenger were fatally injured and the Piper PA-18 airplane was substantially damaged. The airplane impacted ground in a near vertical attitude near the end of a…NTSB MKC87FA051Accident · 1 fatalField investigationFinal reportPiper PA-18 · Venango, NEA witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost…NTSB ANC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe pilot stated he encountered freezing rain and due to the build-up on the aircraft, he stalled and crashed in an open area next to the airport.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 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 DEN84FA278Accident · 2 fatalField investigationFinal reportPiper PA-18 · Meadow Lake, NMAccording to witnesses, the plt make a x-wind apch for a landing from west to east in winds that were from the south at 10 to 12 mph. Reportedly the acft touched down with the right wing high, then the plt applied power & initiated a go-around at about…NTSB SEA83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grass Valley, ORThe aircraft stalled while the pilot was attempting to land downwind on an uphill Grass strip. The wind was estimated at 15 gusting to 20 KTS. The pilot stated that on his approach, he was to the left of the center of the landing strip. He attempted to…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 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…