NTSB investigations: Piper PA-11
209 cases on aircraft the registry lists as Piper PA-11. 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, newest first
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'))
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'))
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 LAX88FA061Accident · 2 fatalField investigationFinal reportPiper PA-11 · San Marcos, CAThe 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…NTSB DEN87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Longmont, COThe plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over.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 NYC87LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Andover, NJThe pilot lost directional control during landing roll. As the aircraft drifted left of the runway, power was added for a go-around but the aircraft was left of the rwy. The left wing strut hit the wing of a Cessna 150 in an attempt to avoid colliding with…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 MKC87LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Meade, KSAfter takeoff, the engine started losing power. During the turn toward a landing area, the airplane stalled, hit the ground to the right of the runway and flipped forward to the inverted position. A partial tear down inspection revealed that the intake valve…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 ANC87LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Nenana, AKThe pilot lost control on takeoff, stalled and crashed on a frozen lake. During the interview with the pilot, he stated that the engine quit on initial climbout; he believed he did not pre-heat the engine long enough before takeoff. At the time of the…NTSB NYC86FNC02Accident · Serious injuriesFinal reportPiper PA-11 · Brewer, METhe plt had been using auto gas in this acft, however, he experienced water contamination problems and discontinued its use. He then found himself at an arpt needing fuel. The arpt only had auto gas available so the plt refueled the acft with auto gas. While…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 CHI85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-11-494 · Alliance, OHThe acft approach was high and fast. The landing was made with 500-600 ft of runway remaining. The acft brakes were not sufficient to stop on the runway. The pilot added power and veered left off the end of the runway to avoid a heavily traveled road, the…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 MIA85LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Parkland, FLThe plt stated that as he approached the airstrip he flew his pattern low. As he turned base the wind caught the left wing shoving the acft down. He jammed the throttle forward but the acft crashed.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 DEN83LA187Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Wagner, SDThe plt reported that the eng began loosing power as he approached his destination. He elected to make an emergency landing on a road to investigate the problem. He stated that he made a stalled landing that caused the tailwheel to unlock & allowed the acft…NTSB ANC83LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Kasilof, AKThe acft collided with trees and crashed during takeoff. The plt stated he made several attempts to get airborne in bothdirections from the strip and when he finally got airborne he struck a tree and crashed. The plt statements varied during several…NTSB NYC82DA207Accident · No injuriesFinal reportPiper PA-11 · Utica, NYThe throttle would not close during landing. The pilot tried brakes and then elevator as the aircraft nosed over. There was no indication of trying to stop the engine by other means (switch, mixture, etc).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.NTSB CHI82DER03Accident · No injuriesClosedPiper PA-11 · Duluth, MNNTSB ANC81DAG17Accident · Serious injuriesClosedPiper PA-11 · Kenai, AKNTSB DEN80DTK22Accident · No injuriesClosedPiper PA-11 · Olsonville, SDNTSB FTW80DPG43Accident · No injuriesClosedPiper PA-11 · Hazen, ARNTSB CHI80FA050Accident · 2 fatalClosedPiper PA-11S · Orleans, MINTSB ANC80DAG16Accident · No injuriesClosedPiper PA-11 · Montague Is, AKNTSB ANC79FA085Accident · 2 fatalClosedPiper PA-11 · Dillingham, AKNTSB ANC79DAA28Accident · Minor injuriesClosedPiper PA-11 · Fairbanks, AKNTSB NYC79FFA24Accident · No injuriesClosedPiper PA-11 · Alplaus, NYNTSB CHI79FET08Accident · No injuriesClosedPiper PA-11 · Michigan City, INNTSB ANC79DAG09Accident · Minor injuriesClosedPiper PA-11 · Kenai, AKNTSB ANC78FA044Accident · 1 fatalClosedPiper PA-11 · King Salmon, AKNTSB LAX78FA052Accident · 1 fatalClosedPiper PA-11 · Tonopah, AZNTSB MKC78FCD25Accident · Serious injuriesClosedPiper PA-11 · Terril, IANTSB ANC78DAG27Accident · Serious injuriesClosedPiper PA-11 · Kasilof, AKNTSB DEN77FQA25Accident · Minor injuriesClosedPiper PA-11 · Los Lunas, NMNTSB ANC77DAG33Accident · No injuriesClosedPiper PA-11 · Alexander Ck, AKNTSB MIA77DLA12Accident · No injuriesClosedPiper PA-11 · Perry, FLNTSB MKC77FTK04Accident · No injuriesClosedPiper PA-11 · Lake Preston, SDNTSB FTW77FA015Accident · 2 fatalClosedPiper PA-11 · Comstock, TXNTSB NYC76FNC67Accident · No injuriesClosedPiper PA-11 · Cushing, MENTSB ANC76DAH36Accident · No injuriesClosedPiper PA-11 · Peter'S Creek, AKNTSB ANC76DAH18Accident · Minor injuriesClosedPiper PA-11 · Cape Seniavin, AKNTSB SEA76FTA16Accident · No injuriesClosedPiper PA-11 · Ashland, MTNTSB ANC76DAG76Accident · Serious injuriesClosedPiper PA-11 · Dillingham, AKNTSB FTW76DRG27Accident · No injuriesClosedPiper PA-11 · Chapman Ranch, TXNTSB SEA76AS022Accident · 3 fatalClosedPiper PA-11 · Turner, MTNTSB SEA75FTA20Accident · No injuriesClosedPiper PA-11 · Nashua, MTNTSB CHI75AC045Accident · 2 fatalClosedPiper PA-11 · Brunswick, OHNTSB FTW75ORG71Accident · No injuriesClosedPiper PA-30 · Zihuathnejo, MexicoNTSB MKC75FCD11Accident · 1 fatalClosedPiper PA-11 · Rockwell Cty, IANTSB ANC75DAG22Accident · No injuriesClosedPiper PA-11 · King Salmon, AK