NTSB investigations: Piper PA-22-135

7 cases on aircraft the registry lists as Piper PA-22-135, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19842026

NTSB investigations: Piper PA-22-135 per year, 1984–2026: 7 cases
1984	3
1988	1
1990	1
1993	1
1998	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102206') 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" = 353)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102206')
      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\" = 353))
  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 ('7102206')
    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" = 353))
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 FTW98LA305Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · San Angelo, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.Jul 9, 1998 · N1279C · Substantial damage NTSB CHI93LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Kewanee, ILThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the pilot's inadvertent stall/mush during the forced landing.Jun 6, 1993 · N8236C · Substantial damage NTSB NYC90LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Franklin Center, PALoss of engine power for an undetermined reason and the failure of the pilot to maintain airspeed during a forced landing which restuled in an inadvertent stall.Jun 17, 1990 · N3393A · Substantial damage NTSB MKC89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Salisbury, MOThe pilot said shortly after takeoff the engine lost power. He attempted to land on a plowed field, and after rolling about fifty yards on the rough, soft terrain, the aircraft nosed over. Post accident investigation revealed the engine lost power due to fuel…Nov 22, 1988 · N8927C · Substantial damage NTSB LAX84LA477Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Byron, CADuring takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board.Sep 1, 1984 · N77G · Substantial damage NTSB NYC84LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Canton, PAThe pilot performed a runup prior to departure. He used one notch of flaps and approximately 800 feet of runway to break ground. During the climbout at approximately 200 ft the engine 'started skipping then quit.' The pilot was unable to restore power before…Jul 26, 1984 · N3777A · Substantial damage NTSB ANC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Big Delta, AKThe plt switched the tank selector while cruising in flt and the engine quit. He said he then primed the engine and tried to start it, but failed. A forced landing was made & the acft nosed over. After the accident, the acft was righted, the tank selector was…Jun 6, 1984 · N8510C · Substantial damage