NTSB investigations: Piper PA-22-150, MN
36 cases on aircraft the registry lists as Piper PA-22-150. 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
| 1964 | 3 |
|---|---|
| 1965 | 2 |
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2008 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2019 | 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\" = 'MN' 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 ('7102210'))
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" = 'MN' 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 ('7102210'))
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 CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB CEN14LA028Accident · 1 fatalLimited investigationFinal reportPiper PA 22-150 · Princeton, MNThe pilot's loss of airplane control during takeoff.NTSB CEN11CA236Accident · No injuriesData collectionFinal reportPiper PA-22-150 · South St. Paul, MNThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB CHI08CA167Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Wadena, MNThe pilot's failure to maintain control of the tail wheel airplane during the landing roll. A factor associated with the accident was the pilot's lack of recent experience in tail wheel airplanes.NTSB CHI96LA355Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jordan, MNthe pilot's failure to maintain directional control during the landing roll.NTSB CHI93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · South St. Paul, MNThe pilot's inadequate compensation for the existing crosswind condition. The crosswind was a factor.NTSB CHI91LA191Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Eagle Bend, MNThe pilot in command's failure to attain proper alignment with the runway. Factors contributing to this accident were an unreliable airspeed indicator and the pilot's decision to operate with this known deficiency.NTSB MKC90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ely, MNImproper planning/decision by the pilot. A factor related to the accident was: the strong/gusty crosswind condition.NTSB MKC89FA201Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · St. Charles, MNThe pilot's failure to maintain a positive rate of climb during a night takeoff. Contributing factor(s) was: an out-of-c.g airplane, takeoff with only one magneto operating; and the limited vision of the pilot.NTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…NTSB CHI88DER13Accident · No injuriesFinal reportPiper PA-22-150 · Cohasset, MNFailure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach.NTSB CHI86FER09Accident · 1 fatalFinal reportPiper PA-22-150 · Lino Lakes, MNThis aircraft was overloaded on takeoff with extra fuel, camping equipment, a passenger, an outboard motor, tools and the like. In addition the center of gravity was probably out of safe limits. An additional factor affecting takeoff and turn performance was…NTSB CHI85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rush City, MNThe plt reported that he was taking off on rwy 33 with the wind from 280 deg a 18 gusting 25 KTS. After becoming airborne, the acft weathervaned into the wind. It then traveled to the left of the rwy where it settled back to the ground. Subsequently, the acft…NTSB CHI83LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Alexandria, MNThe pilot decided to make a precautionary landing after he heard a noise or bang which he thought was the muffler. The pilot made a decision to land on a runway which had an unfavorable wind. Control was lost when a gust of wind raised the left wing. The…NTSB CHI83LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sandstone, MNThe pilot reported that soon after touchdown, the aircraft began to veer to the left and attempts to correct the situation failed. Subsequently, the aircraft impacted a snowbank and was damaged.NTSB CHI82DER02Accident · No injuriesClosedPiper PA-22 · Austin, MNNTSB MKC79DER32Accident · No injuriesClosedPiper PA-22 · Hutchinson, MNNTSB MKC79DER16Accident · Minor injuriesClosedPiper PA-22 · Bricelyn, MNNTSB MKC79DER08Accident · No injuriesClosedPiper PA-22 · Sleepy Eye, MNNTSB MKC79FER75Accident · Minor injuriesClosedPiper PA-22 · Jasper, MNNTSB MKC77DER83Accident · No injuriesClosedPiper PA-22 · Brandon, MNNTSB MKC76FER86Accident · Minor injuriesClosedPiper PA-22 · St Cloud, MNNTSB MKC76DER53Accident · No injuriesClosedPiper PA-22 · Gaylord, MNNTSB MKC75DER32Accident · No injuriesClosedPiper PA-22 · Marshall, MNNTSB MKC73FER65Accident · Minor injuriesClosedPiper PA-22 · Wadena, MNNTSB MKC73AK021Accident · 4 fatalClosedPiper PA-22 · Princeton, MNNTSB MKC71FDD15Accident · No injuriesClosedPiper PA-22 · Fergus Falls, MNNTSB MKC70DDM10Accident · No injuriesClosedPiper PA-22 · Rosemount, MNNTSB MKC68A0013Accident · 1 fatalClosedPiper PA-22 · Lake Benton, MNNTSB MKC68F0447Accident · No injuriesClosedPiper J3C-65 · Fergus Falls, MNNTSB MKC67D0439Accident · No injuriesClosedPiper PA-22 · Buffalo, MNNTSB MKC66F0098Accident · No injuriesClosedPiper PA-22 · Fairbault, MNNTSB MKC65F0042Accident · No injuriesClosedPiper PA-22 · Bagley, MNNTSB UNK65X1141Accident · No injuriesClosedPiper PA22 · Silver Lake, MNNTSB UNK65X1072Accident · No injuriesClosedPiper PA22 · St Cloud, MNNTSB UNK64X2641Accident · No injuriesClosedPiper PA22 · Faribault, MN