NTSB investigations: Piper PA-22-150, 1997

10 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

19642026
NTSB investigations: Piper PA-22-150, 1997 per year, 1964–2026: 1,313 cases
1964114
1965108
196696
196778
196869
196955
197052
197147
197235
197332
197421
197527
197640
197733
197831
197928
198019
198117
198212
198320
198415
198512
198620
198714
198817
198918
199012
199118
199215
19938
199411
19957
199610
199710
199810
19999
20009
200110
20025
20036
20045
200511
20067
20077
20087
20097
20107
20116
20128
20133
20143
20152
20162
20178
20184
201912
20207
20215
20229
20234
20248
20255
20266

Latest 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 year(c.\"eventDate\") = 1997
    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.

NTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.Nov 22, 1997 · N7528D · Substantial damageNTSB FTW98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Broomfield, COthe pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.Nov 7, 1997 · N9607D · Substantial damageNTSB CHI97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Castlewood, SDThe pilot's failure to maintain adequate clearance from the trees.Sep 1, 1997 · N2743P · Substantial damageNTSB ANC97LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Fairbanks, AKThe pilot's initiation of an abrupt, evasive maneuver, and his failure to maintain directional control of the airplane. Factors in the accident were an undetermined object crossing the runway and the passenger's rudder control interference during the evasive…Jul 15, 1997 · N4520A · Substantial damageNTSB ANC97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hoonah, AKThe pilot's failure to maintain directional control while landing.Jun 22, 1997 · N7025B · Substantial damageNTSB SEA97LA108Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · The Dalles, ORThe pilot-in-command misjudged his altitude and distance from the runway while landing.May 10, 1997 · N1707P · Substantial damageNTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.Apr 26, 1997 · N3126Z · DestroyedNTSB MIA97LA106Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Cumming, GAa loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.Mar 30, 1997 · N3201Z · Substantial damageNTSB LAX97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Madera, CAThe pilot's failure to maintain adequate clearance from obstructions and his inadequate visual outlook.Feb 9, 1997 · N1900F · DestroyedNTSB ANC97LA025Accident · 3 fatalLimited investigationFinal reportPiper PA-22 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent failure to maintain control of the airplane. Factors associated with the accident are the pilot's inadequate weather evaluation, his becoming lost/disoriented, and…Feb 1, 1997 · N7235D · Destroyed