NTSB investigations: Piper PA-11, MT
17 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 per year
| 1965 | 2 |
|---|---|
| 1968 | 3 |
| 1969 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1988 | 2 |
| 2003 | 1 |
| 2006 | 1 |
| 2013 | 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.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA'
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" 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 WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.NTSB SEA06CA144Accident · No injuriesData collectionFinal reportPiper PA-11 · Turner, MTThe passenger's inadvertent activation of the airplane's brakes during the landing roll, resulting in the pilot's loss of control and subsequent nose over. A factor was the pilot's inadequate preflight planning/preparation by not briefing the passenger about…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 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 DEN89LA046Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Hammond, MTThe plt, who was a veterinarian, landed his acft in rough, cultivated farm fld at a ranch in order to conduct business. Upon completion of his business, the plt selected a smoother area in the same field for takeoff. The area was smoother but was shorter and…NTSB SEA76FTA16Accident · No injuriesClosedPiper PA-11 · Ashland, MTNTSB SEA76AS022Accident · 3 fatalClosedPiper PA-11 · Turner, MTNTSB SEA75FTA20Accident · No injuriesClosedPiper PA-11 · Nashua, MTNTSB SEA75FTA06Accident · Serious injuriesClosedPiper PA-11 · Hammond, MTNTSB SEA71DTA24Accident · No injuriesClosedPiper PA-11 · Alzada, MTNTSB SEA71FDA17Accident · No injuriesClosedPiper PA-11 · Alzada, MTNTSB SEA69A0043Accident · 2 fatalClosedPiper PA-11 · Ingomar, MTNTSB SEA69D0029Accident · No injuriesClosedPiper PA-11 · Fairview, MTNTSB SEA69F0003Accident · No injuriesClosedPiper PA-11 · Zurich, MTNTSB SEA68D0313Accident · Minor injuriesClosedPiper PA-11 · Wolf Point, MTNTSB SEA66D0178Accident · No injuriesClosedPiper PA-11 · Lambert, MTNTSB SEA65D0016Accident · No injuriesClosedPiper PA-11 · Decker, MT