NTSB investigations: Piper PA-22-108

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

19872026

NTSB investigations: Piper PA-22-108 per year, 1987–2026: 7 cases
1987	1
1988	2
1994	1
1997	1
1998	1
1999	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 ('7102204') 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" = 354)) 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 ('7102204')
      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\" = 354))
  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 ('7102204')
    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" = 354))
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 MIA99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Perry, GAThe maintenance personnel incorrect adjustment of the intake and exhaust valves resulting in the induction system fire and subsequent loss of engine power.Jan 6, 1999 · N4542Z · Substantial damage NTSB CHI98LA235Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Spearfish, SDthe pilots improper preflight planning, which failed to detect the fuel selector positioned on the left fuel tank, which had insufficient fuel, resulting in fuel starvation, and the loss of engine power.Jul 1, 1998 · N5181Z · Substantial damage NTSB ATL98LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Jacksonville, NCthe pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…Dec 20, 1997 · N5258Z · Substantial damage NTSB CHI94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Lebanon, INInadequate preflight preparation by the pilot-in-command. Factors were fuel system contamination and an unsuitable terrain encountered by the pilot-in-command during a forced landing.Mar 12, 1994 · N5135Z · Substantial damage NTSB ATL89LA017Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Advance, NCDuring takeoff climb eng quit then re-started. PIC turned to the north & engine quit again. PIC stalled acft & crashed into wheat field. Acft had STC for auto gas. Fuel in acft had water & rust contaminants. Fuel lines had dried. Carb had composite float. The…Oct 24, 1988 · N5361Z · Substantial damage NTSB FTW88LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Fabens, TXThe plt reported that the eng ran rough on a previous flt and he removed, cleaned, and replaced the spark plugs. He then took off and at a point seven miles from the departure arpt, the eng again began to run rough and intermittently. An emergency landing…Feb 23, 1988 · N5542Z · Substantial damage NTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…May 26, 1987 · N5448Z · Substantial damage