NTSB investigations: Piper PA-22-150
28 cases on aircraft the registry lists as Piper PA-22-150, 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 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 ('7102210')
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 ('7102210')
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 FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.NTSB SEA03LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Garryowen, MTThe pilot in command's allowing the aircraft to inadvertently enter into a stall condition at low altitude while maneuvering. A contributing factor was the pilot's intentional low altitude maneuvering.NTSB SEA01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lewistown, MTPilot's failure to maintain directional control of the aircraft while landing.NTSB CHI00FA184Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Quincy, ILThe pilots failure to maintain control of the aircraft and his continued flight into adverse weather. Factors were the fog, and the crops.NTSB DEN99FA120Accident · 4 fatalField investigationFinal reportPiper PA-22-150 · Roy, UTThe pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.NTSB DEN99FA119Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Coaldale, COThe pilot's failure to maintain control of the airplane for reasons for reasons undetermined.NTSB MIA96LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Quincy, FLThe pilot's inadequate compensation for wind conditions, while beginning a flare to land, which resulted in a loss of aircraft control and collision with the ground.NTSB SEA95LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Rice, WAThe pilot's failure to maintain the proper climb rate. A factor was trees in the flight path.NTSB CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.NTSB LAX93LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Reno, NVThe pilot's poorly planned approach, inadequate compensation for the existing winds, and failure to maintain airspeed. Contributing to this accident was the pilot's lack of total expereince and inadvertent stall.NTSB ATL92LA170Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisburg, NCThe passenger's inadvertent interference with the flight controls.NTSB LAX92LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Oxnard, CAThe pilot's failure to maintain control of the airplane during takeoff as a result of his alcoholic impairment of efficiency and judgement. A factor in the accident was the dark night.NTSB SEA91LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Dayton, WYSevere down drafts. Factors to the accident were: terrain clearance was not maintained, and a poor weather evaluation, by the pilot.NTSB NYC91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAImproper use of the flight controls by the pilot which resulted in an inadvertent stall on takeoff with insufficient altitude for recovery. Factors related to the accident was the failure of the pilot to properly set the elevator trim prior to takeoff and the…NTSB NYC91LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Nayville, NYFailure of the pilot to attain adequate airspeed to climb, which resulted in a stall/mush. The trees were a related factor.NTSB ANC90LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Caribou Creek, AKThe pilot's failure to adequately compensate for the existing wind conditions.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 MKC89LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · St. Clair, MOThe pilot's inability to establish a positive rate of climb due to the misjudged weight and balance calculations.NTSB SEA89FA126Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Elgin, ORFailure of the pilot to obtain/maintain adequate airspeed during takeoff/initial climb, which resulted in a stall. Factors related to the accident were: quartering tailwind, high density altitude, and the pilot's lack of recent experience in the aircraft.NTSB NYC89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Uxbridge, MAImproper maneuvering shortly after takeoff from a private grass strip of marginal length for the caliber of acft being operated. A wind change added to the already exacting conditions.NTSB NYC89FA062Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Limington, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the adverse wind conditions, lack of pilot experience in the type of aircraft, and the lack of shoulder harness/upper body…NTSB DEN89LA015Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Edgewood, NMThe acft had just been overhauled & a new prop (hartzell model 7636D-4) had been installed in place of the old prop. The plt rprtd that after takeoff, the acft failed to climb, although he was using full power. He said he headed for lower terrain & circled…NTSB ANC86LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · King Salmon, AKThe plt stated that after lift off the acft stalled. He then lost directional control and the acft contacted a ditch.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 DEN86LA085Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Estelline, SDAccording to the student plt, during the landing roll on a public road, the acft he was piloting encountered a crosswind which tipped the left wing up. The student plt indicated the acft nosed over onto its back. The plt had purchased the acft aprx 1 hr prior…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 CHI84FA042Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Easton Township, MIThe acft crashed aprx 3 mi from the departure arpt. According to witnesses, it was flying at aprx 200 ft AGL when the right wing dipped & then the acft went nearly straight into the ground. An inspection of the airframe & flt control sys revealed no evidence…