NTSB investigations: Piper PA-11
14 cases on aircraft the registry lists as Piper PA-11, 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 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1990 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 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 ('7101102', '7101106')
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 ('7101102', '7101106')
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 SEA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Alzada, MTThe student pilot's failure to maintain adequate flying airspeed in a turn while maneuvering close to the ground resulting in a stall condition. A contributing factor was the turbulent wind conditions.NTSB DEN99FA075Accident · 2 fatalField investigationFinal reportPiper PA-11 · Lander, WYThe pilot inadvertently stalling the airplane. Factors were his abrupt maneuvering of the airplane to avoid a powerline, and his attention being diverted.NTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB ANC90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Knik Clacier, AKA foreign object (tool) had jammed the aileron controls to the right as the pilot was maneuvering the aircraft for a low approach to a strip.NTSB ANC90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-11 · King Salmon, AKPilot-in-command's failure to maintain airplane control.NTSB DEN89LA049Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Winnett, MTThe pilot was taking off from a farm strip with a 10 kt head wind. The plt said the sun was shining at the time of the acdt but there had been snow showers in the area. He said the liftoff was normal but at about 15 to 18 ft AGL the acft stalled and crashed.…NTSB ANC89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Levelock, AKThe airplane was at approximately 250 to 300 feet above sea level, and was executing a 360 degree turn to the left when the airplane stalled and crashed in the river. The pilot reported that he has never held a FAA pilot or medical certificate.NTSB SEA87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · The Dalles, ORThe pilot was at 50 feet AGL on final approach to land at his private airstrip when he lost control. Reportedly, a gust of wind turned the aircraft 180 degrees. The aircraft descended and struck trees and the ground. Winds were reported variable at 40 to 45…NTSB ATL87LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Butler, ALThe student plt reported that a gust of wind 'caught' the airplane's left wing shortly after takeoff at about 100 ft AGL; he subsequently 'lost control' and the airplane 'went down'.NTSB MIA87FA150Accident · 1 fatalField investigationFinal reportPiper PA-11 · Hollandale, MSWitnesses stated that the acft circled a pond & dived once, then on a 2nd circling attempt, it made a short steep turn & went into a twisting dive into the pond. The passenger stated that they were flying at appx 100 to 150 ft above some fish ponds when the…NTSB NYC85FNC06Accident · Serious injuriesFinal reportPiper PA-11 · Moultonboro, NHThe 65 HP acft took off from a cove and during a turn at about 150 ft AGL the acft nosed dwn after rolling rt. The acft struck the water in a steep nose down attitude. According to witnesses, the bng was running normally during the climb and descent. No…NTSB ANC85LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Soldotna, AKThe plt stated a gust of wind forced the left wing up as the acft touched down. Fuul pwr was added to go around. The acft continued to veer to the right until it stalled and impacted the ground in a nose low attitude aprx 100 yards south of the rwy. Winds…NTSB ANC84LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Tasnuna Valley, AKThe plt stated that they had just taken off from a gravel bar when they spotted a moose. He circled the moose in a left orbit at about 65 miles per hour. During one of the orbits the 'right wing fell in a downward direction and the nose of the acft pitched…NTSB DEN82DA050Accident · Serious injuriesFinal reportPiper PA-11 · Devils Lake, NDThe pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.