NTSB investigations: Piper PA-22-150
15 cases on aircraft the registry lists as Piper PA-22-150, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 1 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2007 | 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\" = 130))
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" = 130))
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 DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.NTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.NTSB ANC00LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKA malfunctioning main landing gear brake, which precipitated a ground-loop.NTSB FTW96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · El Paso, TXloss of directional control due to the failure of the tailwheel lock. A factor was the crosswind.NTSB CHI91LA217Accident · No injuriesLimited investigationFinal reportPiper PA22/20 · Stevens Point, WIThe improper installation of the flight control system rudder control rod (rudder cable bellcrank torque tube) by maintenance personnel. A factor contributing to this accident was the inoperative tailwheel steering.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 CHI88LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Muncie, INWhen the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move…NTSB DEN86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cedar City, UTThe plt stated that while in cruise flt, a loud noise was heard followed by air entering the cockpit. The plt said he initially reduced pwr, not knowing what the problem was. According to the plt, when no visual problem with the aircraft was found, he added…NTSB SEA85FA181Accident · 2 fatalField investigationFinal reportPiper PA-22 · Ketchum, IDStudent pilot on cross country flt, route thru mountain pass and mountains. Attempted emergency landing on highway. During approach and while turning toward selected landing site, plt inadvertantly set full nose down trim with half flaps. As acft completed…NTSB SEA84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Davenport, WADuring the landing roll the brakes were applied with no effect. The acft went off the end of the rwy into a ditch and nosed over. Examination of the acft showed the brake system low on fluid and the master cylinder diaphragm ruptured.NTSB MKC84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Derby, KSThe plt was pacticing landings & stopped after each touchdown. After aprx the 5th landing, the brakes failed to operate & the acft continued off the end of the rwy. Before stopping, the nose gear went in a ditch & collapsed, and the acft nosed over. The plt…NTSB DEN83LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Ennis, MTDuring a night flight, oil began spreading over the windshield & heavy smoke came in the cockpit through the cabin heater. The plt opened the cabin windows, reduced power & turned back toward the arpt. The oil pressure dropped to 5 PSI & the plt descended to…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 FTW83LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ramon, NMThe flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After…NTSB NYC82DA102Accident · Minor injuriesFinal reportPiper PA-22-150 · Seneca Falls, NYWhile trying to roll out of a left turn on downwind the pilot experienced a jammed rudder control. Full aileron control was not available because of the aileron-rudder interconnect system and a considerable buffet was induced during an attempt to level the…