Skip to content

Fatal NTSB investigations: Piper PA-11

38 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."highestInjuryLevel" = 'Fatal' AND 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

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.\"highestInjuryLevel\" = 'Fatal'
    AND 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."highestInjuryLevel" = 'Fatal'
  AND 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

Run 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 WPR19FA173Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-11 · Copperopolis, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s impairment from consuming alcohol before the flight.Jun 16, 2019 · N209H · Destroyed NTSB ANC17FA012Accident · 2 fatalField investigationFinal reportPiper PA 11 · Aniak, AKThe pilot's intentional flight of the airplane into terrain in an act of suicide.Dec 16, 2016 · N5028H · Substantial damage NTSB CEN16FA370Accident · 2 fatalField investigationFinal reportPiper PA 11 · Arcanum, OHThe student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.Sep 14, 2016 · N4910M · Substantial damage NTSB CEN16LA310Accident · 2 fatalLimited investigationFinal reportPiper PA-11 · Indianola, IAThe pilot's inadequate preflight planning, which resulted in the airplane being operated above its maximum gross weight, degraded its climb performance, and led to an aerodynamic stall during the initial climb.Aug 5, 2016 · N4707M · Destroyed NTSB ANC10FA076Accident · 2 fatalField investigationFinal reportPiper PA-11 · Willow, AKThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall/spin and impact with the ground.Aug 25, 2010 · N78831 · Substantial damage NTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.Sep 7, 2009 · N4778M · Substantial damage 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.May 8, 1999 · N4582M · Destroyed NTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.Dec 30, 1997 · N5532H · Destroyed 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…Nov 28, 1987 · N4767H · Destroyed 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…Apr 28, 1987 · N5093H · Destroyed NTSB CHI80FA050Accident · 2 fatalClosedPiper PA-11S · Orleans, MIJul 4, 1980 · N5065H · Substantial damage NTSB ANC79FA085Accident · 2 fatalClosedPiper PA-11 · Dillingham, AKAug 23, 1979 · N4520M · Destroyed NTSB ANC78FA044Accident · 1 fatalClosedPiper PA-11 · King Salmon, AKJun 1, 1978 · N5504H · Substantial damage NTSB LAX78FA052Accident · 1 fatalClosedPiper PA-11 · Tonopah, AZMay 30, 1978 · N5086H · Destroyed NTSB FTW77FA015Accident · 2 fatalClosedPiper PA-11 · Comstock, TXNov 21, 1976 · N66A · Destroyed NTSB SEA76AS022Accident · 3 fatalClosedPiper PA-11 · Turner, MTOct 17, 1975 · N4575M · Destroyed NTSB CHI75AC045Accident · 2 fatalClosedPiper PA-11 · Brunswick, OHDec 21, 1974 · N4703M · Destroyed NTSB MKC75FCD11Accident · 1 fatalClosedPiper PA-11 · Rockwell Cty, IAAug 24, 1974 · N4858M · Substantial damage NTSB ANC75AA012Accident · 1 fatalClosedPiper PA-11 · Gulkana, AKAug 9, 1974 · N78841 · Destroyed NTSB MKC75FTG01Accident · 1 fatalClosedPiper PA-11 · Rolla, NDJul 2, 1974 · N5099H · Substantial damage NTSB MKC72AK049Accident · 1 fatalClosedPiper PA-11 · Moberly, MOFeb 20, 1972 · N4512M · Destroyed NTSB SEA71AS020Accident · 1 fatalClosedPiper PA11 · Skykomish, WASep 27, 1970 · N4899M · Destroyed NTSB CHI70F0214Accident · 1 fatalClosedPiper PA-11 · Williamston, MIJul 2, 1969 · N4713M · Destroyed NTSB SEA69A0043Accident · 2 fatalClosedPiper PA-11 · Ingomar, MTJan 26, 1969 · N4648M · Destroyed NTSB MIA69F0234Accident · 1 fatalClosedPiper PA-11 · Tifton, GAJul 19, 1968 · N4942H · Destroyed NTSB MKC68A0045Accident · 2 fatalClosedPiper PA-11 · Benkelman, NEJan 7, 1968 · N4798H · Destroyed NTSB OAK68A0038Accident · 1 fatalClosedPiper PA-11 · Dardanelle, CAOct 30, 1967 · N4557M · Destroyed NTSB SEA68A0014Accident · 2 fatalClosedPiper PA-11 · Dayton, WAAug 10, 1967 · N78736 · Destroyed NTSB MKC67A0087Accident · 1 fatalClosedPiper PA-11 · Fessenden, NDJun 26, 1967 · N5018H · Destroyed NTSB MKC67A0077Accident · 1 fatalClosedPiper PA-11 · Farragut, IAJun 5, 1967 · N4704H · Destroyed NTSB MIA67A0123Accident · 1 fatalClosedPiper PA-11 · Warrior, ALMay 21, 1967 · N4944H · Destroyed NTSB MKC67A0042Accident · 2 fatalClosedPiper PA-11 · Lexington, MOApr 28, 1967 · N5019H · Destroyed NTSB CHI67A0103Accident · 2 fatalClosedPiper PA-11 · Weidman, MIMar 18, 1967 · N1489N · Destroyed NTSB NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTDec 11, 1966 · N3697Z · 2 aircraft · Destroyed NTSB MKC67A0015Accident · 2 fatalClosedPiper PA-11 · Mullen, NEAug 25, 1966 · N4671M · Destroyed NTSB MIA66F0220Accident · 1 fatalClosedPiper PA-11 · Jackson, TNSep 7, 1965 · N5571H · Destroyed NTSB OAK65A0053Accident · 1 fatalClosedPiper PA-11 · Inverness, CAJan 28, 1965 · N5526H · Destroyed NTSB UNK64X2954Accident · 1 fatalClosedPiper PA-11 · Cottonwood, IDJul 21, 1964 · N78639 · Destroyed