Skip to content

NTSB investigations: Piper PA-22, TX

29 cases on aircraft the registry lists as Piper PA-22. 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 ('7102202')) 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 ('7102202'))
  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 ('7102202'))
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 FTW03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Big Spring, TXthe failure of both pilots to maintain visual separation with each other. Factors were the Cessna pilot's inability to listen to or make radio transmissions and the Piper pilot's nonstandard traffic pattern.Oct 29, 2002 · N1456A · 2 aircraft · Substantial damage NTSB FTW89FA171Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Elgin, TXThe pilot's inadvertent closure (deactivation) of the mixture control, which resulted in a loss of engine power, and his failure to maintain sufficient airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the gusty wind, and…Sep 22, 1989 · N4329A · Destroyed NTSB FTW89LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Austin, TXThe failure of the aircraft brake system. Factors include high tail wind.Jun 10, 1989 · N655A · Substantial damage NTSB FTW85LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Brownwood, TXA witness who is a pilot and an A&P mechanic, stated that he heard the engine on N2259A sputtering as if it was running out of fuel as it passed over his house. The witness continued to state that shortly after the aircraft passed, the pilot of N2259A called…Nov 25, 1984 · N2259A · Substantial damage NTSB FTW83LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Lajitas, TXThe student plt was on a supervised cross-country flight flt. After arriving at an en route airport, he landed on runway 22 with an estimated crosswind from 310 deg at 10 gusting 20 KTS. After decelerating to taxi speed on the runway, a gust of wind was…Feb 27, 1983 · N816A · Substantial damage NTSB FTW80DQG38Accident · No injuriesClosedPiper PA-22 · Odessa, TXSep 3, 1980 · N3538A · Substantial damage NTSB FTW79FA064Accident · 1 fatalClosedPiper PA-22 · Gladewater, TXMar 17, 1979 · N936A · Destroyed NTSB FTW78DRA24Accident · Minor injuriesClosedPiper PA-22 · Hardin, TXMay 27, 1978 · N1748A · Substantial damage NTSB FTW78DQD18Accident · No injuriesClosedPiper PA-22 · Alpine, TXApr 13, 1978 · N676A · Substantial damage NTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNov 6, 1976 · N1336Q · 2 aircraft · Destroyed NTSB FTW72FRA39Accident · Minor injuriesClosedPiper PA-22 · Houston, TXFeb 27, 1972 · N8295C · Substantial damage NTSB FTW72FRA12Accident · No injuriesClosedPiper PA-22 · Cypress, TXOct 5, 1971 · N685A · Substantial damage NTSB FTW71FRH17Accident · No injuriesClosedPiper PA-22 · Corpus Chrsti, TXApr 27, 1971 · N2457A · Substantial damage NTSB FTW71FRA42Accident · Minor injuriesClosedPiper PA-22 · Dayton, TXMar 22, 1971 · N945A · Substantial damage NTSB FTW71DQG54Accident · No injuriesClosedPiper PA-22 · Ozona, TXFeb 12, 1971 · N1128C · Substantial damage NTSB FTW70FBG07Accident · Minor injuriesClosedPiper PA-22 · Port Lavaca, TXJan 17, 1970 · N8611C · Substantial damage NTSB FTW69F0433Accident · No injuriesClosedPiper PA-22 · Bay City, TXMar 13, 1969 · N3409A · Substantial damage NTSB FTW69D0265Accident · No injuriesClosedPiper PA-22 · Abilene, TXOct 28, 1968 · N961A · Substantial damage NTSB FTW68D0524Accident · No injuriesClosedPiper PA-22 · Levelland, TXMar 27, 1968 · N1452A · Substantial damage NTSB FTW67F0246Accident · Serious injuriesClosedPiper PA-22 · Muenster, TXOct 11, 1966 · N1401A · Substantial damage NTSB FTW67F0039Accident · No injuriesClosedPiper PA22 · Austin, TXJun 21, 1966 · N4329A · Substantial damage NTSB FTW67D0038Accident · No injuriesClosedPiper PA22 · Houston, TXJun 12, 1966 · N659A · Substantial damage NTSB FTW66D0492Accident · No injuriesClosedPiper PA-22 · Sunray, TXJan 26, 1966 · N3564A · Substantial damage NTSB FTW66F0456Accident · No injuriesClosedPiper PA-22 · Bandera, TXNov 22, 1965 · N2828P · Substantial damage NTSB FTW66F0284Accident · No injuriesClosedPiper PA-22 · Euless, TXAug 28, 1965 · N666A · Substantial damage NTSB FTW66F0215Accident · No injuriesClosedPiper PA-22 · Big Lake, TXAug 1, 1965 · N8740C · Substantial damage NTSB FTW66F0074Accident · Minor injuriesClosedPiper PA-22 · Breckenridge, TXMay 20, 1965 · N1401A · Substantial damage NTSB FTW66F0068Accident · No injuriesClosedPiper PA-22 · Morse, TXFeb 26, 1965 · N9237D · Substantial damage NTSB UNK64X3072Accident · No injuriesClosedPiper PA22 · Dinmitt, TXJul 27, 1964 · N8830C · Substantial damage