Skip to content

NTSB investigations: Piper PA-22-108, TX

22 cases on aircraft the registry lists as Piper PA-22-108. 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" = 'TX' 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 ('7102204')) 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\" = 'TX' 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 ('7102204'))
  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" = 'TX' 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 ('7102204'))
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 CEN16LA394Accident · Serious injuriesLimited investigationFinal reportPiper PA 22-108 · Pearland, TXA partial loss of engine power during takeoff for reasons that could not be determined based on the available information following a thorough postaccident examination.Sep 24, 2016 · N4920Z · Substantial damage NTSB CEN16FA087Accident · 1 fatalField investigationFinal reportPiper PA 22-108 · Garden City, TXThe pilot's failure to maintain clearance with terrain during a low altitude flight.Jan 14, 2016 · N4751Z · Destroyed NTSB CEN11CA217Accident · Minor injuriesData collectionFinal reportPiper PA-22-108 · Lockhart, TXThe pilot's failure to maintain clearance from trees.Mar 7, 2011 · N4571Z · Substantial damage NTSB FTW93FA158Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Weatherford, TXTotal loss of engine power with cause undetermined. A factor was the lack of suitable terrain.May 17, 1993 · N4924Z · 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 FTW87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Terrel, TXThe pilot attempted a go-around due to cross winds and experienced an engine failure due to fuel starvation when the mixture control vibrated out to the shutoff position. The pilot attempted several times to restart the engine, but was unsuccessful prior to…Jan 29, 1987 · N4862Z · Substantial damage NTSB FTW80DRA47Accident · Minor injuriesClosedPiper PA-22 · La Porte, TXAug 31, 1980 · N4774Z · Substantial damage NTSB FTW79FRA04Accident · Serious injuriesClosedPiper PA-22 · Houston, TXNov 28, 1978 · N4687Z · Substantial damage NTSB FTW77DQD06Accident · No injuriesClosedPiper PA-22 · Pecos, TXJan 17, 1977 · N4508Z · Substantial damage NTSB FTW75DQG39Accident · No injuriesClosedPiper PA-22 · Dalhart, TXJan 3, 1975 · N4689Z · Substantial damage NTSB FTW72DPD08Accident · No injuriesClosedPiper PA-22 · Ft.Worth, TXSep 3, 1971 · N5673Z · Substantial damage NTSB FTW69F0390Accident · No injuriesClosedPiper PA-22 · Lubbock, TXFeb 15, 1969 · N4615Z · Substantial damage NTSB FTW68F0443Accident · Minor injuriesClosedPiper PA-22 · Baytown, TXJan 30, 1968 · N5744Z · Substantial damage NTSB FTW68F0115Accident · No injuriesClosedPiper PA-22 · Texas City, TXJul 15, 1967 · N5501Z · Substantial damage NTSB FTW6MF0154Accident · No injuriesClosedPiper PA-22 · Dallas, TXJul 26, 1966 · N4541Z · Substantial damage NTSB FTW66D0443Accident · No injuriesClosedPiper PA-22 · Johnson City, TXDec 5, 1965 · N5111Z · Substantial damage NTSB FTW66F0327Accident · No injuriesClosedPiper PA22 · Grand Prairie, TXOct 14, 1965 · N4958Z · No damage NTSB FTW66F0171Accident · Minor injuriesClosedPiper PA-22 · Houston, TXJul 28, 1965 · N4760Z · Substantial damage NTSB FTW66F0094Accident · No injuriesClosedPiper PA-22 · Friendswood, TXJun 8, 1965 · N2929T · Substantial damage NTSB UNK65X1293Accident · No injuriesClosedPiper PA22 · Rockwall, TXJan 15, 1965 · N4644Z · Substantial damage NTSB UNK64X3416Accident · No injuriesClosedPiper PA22 · Corpus Christ, TXAug 16, 1964 · N5756Z · Substantial damage NTSB UNK64X1484Accident · Minor injuriesClosedPiper PA22 · Texas City, TXApr 27, 1964 · N5282Z · Destroyed