Skip to content

NTSB investigations: Piper PA-22-150, ID

20 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'ID' 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

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\" = 'ID' 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" = 'ID' 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

Run 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 WPR24LA147Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Emmett, IDThe pilot’s loss of directional control during landing roll due to a loose tailwheel leaf spring assembly.May 12, 2024 · N3915P · Substantial damage NTSB WPR22LA118Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Bonners Ferry, IDThe pilot’s improper landing flare, and bounced landing, which resulted in a ground loop and runway excursion.Mar 8, 2022 · N6755B · Substantial damage NTSB WPR13CA192Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Moose Creek Ranger Station, IDThe pilot's use of excessive braking after landing with a tailwind and after an extended touchdown to avoid deer on the runway.Apr 9, 2013 · N3505P · Substantial damage NTSB WPR09FA379Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Saint Charles, IDThe pilot’s failure to maintain terrain clearance while maneuvering.Aug 7, 2009 · N6905B · Destroyed NTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.Jul 24, 1994 · N51AR · Substantial damage NTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.Jun 3, 1994 · N2926Z · Substantial damage 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…Jul 29, 1985 · N4445A · Destroyed NTSB SEA84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Shoshone, IDThe plt attempted takeoff from a wet alfalfa field. High vegetation and soft terrain prevented proper acceleration to lift off speed. The nosewheel struck an embankment and the aircraft nosed over.Aug 25, 1984 · N7249D · Substantial damage NTSB SEA79FA026Accident · 3 fatalClosedPiper PA-22 · Spencer, IDMar 16, 1979 · N4740A · Destroyed NTSB SEA77FYA20Accident · Serious injuriesClosedPiper PA-22 · American Falls, IDJun 4, 1977 · N8002D · Substantial damage NTSB SEA7KFYA50Accident · Serious injuriesClosedPiper PA-22 · Blackfoot, IDJun 11, 1975 · N2602P · Substantial damage NTSB SEA76DYA46Accident · Minor injuriesClosedPiper PA-22 · Burley, IDJun 2, 1975 · N3413Z · Substantial damage NTSB SEA74DYA38Accident · No injuriesClosedPiper PA-22 · Oakley, IDJun 20, 1974 · N6729B · Substantial damage NTSB SEA74DYA18Accident · No injuriesClosedPiper PA-22 · Bone, IDDec 29, 1973 · N8002D · Substantial damage NTSB SEA72AS003Accident · 2 fatalClosedPiper PA-22 · Mountain Home, IDJul 27, 1971 · N6924B · Destroyed NTSB SEA71DXM23Accident · No injuriesClosedPiper PA-22 · Ketchum, IDJan 25, 1971 · N7415D · Substantial damage NTSB SEA71DXM20Accident · No injuriesClosedPiper PA-22 · Fairfield, IDJan 11, 1971 · N3550P · Substantial damage NTSB SEA70D0120Accident · No injuriesClosedPiper PA-22 · Burley, IDDec 10, 1969 · N6729B · Substantial damage NTSB SEA66F0072Accident · No injuriesClosedPiper PA-22 · Nampa, IDAug 8, 1965 · N6753B · Substantial damage NTSB UNK64X0435Accident · No injuriesClosedPiper PA-22 · Mountain Home, IDFeb 2, 1964 · N3708P · Substantial damage