Fatal NTSB investigations: Piper PA-22
46 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1965 | 3 |
| 1966 | 4 |
| 1967 | 2 |
| 1968 | 7 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 4 |
| 1972 | 4 |
| 1974 | 2 |
| 1976 | 2 |
| 1978 | 2 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 1 |
Where
Latest cases
Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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" DESCRun 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 SEA94FA174Accident · 3 fatalField investigationFinal reportPiper PA-22-135 · Leavenworth, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: high density altitude, the runway condition (with areas of soft or uneven terrain and tall grass), and obstructions (trees) near the departure end of the runway.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…NTSB DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…NTSB MKC86FA029Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Osage Beach, MOWitnesses observed N80426 lt of the final apch course for rwy 14 heading toward the arpt for landing. One witness said the acft was at 300 to 400 ft AGL when the nose of the acft rose abruptly, the lt wing went down and the acft descended to the ground. Other…NTSB ATL85FA182Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Cartersville, GAThe circumstances & purpose of the flt was not determined. According to witnesses, the owner/student plt & another psn, who was a certified mechanic & an instructor plt, took off & entered what appeared to be a closed traffic pattern for rwy 18. The traffic…NTSB FTW84FPJ01Accident · 2 fatalFinal reportPiper PA-22 · Byron, OKThe acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured.NTSB MIA83FA145Accident · 1 fatalField investigationFinal reportPiper PA-22 · Pompano Beach, FLThe surviving pax stated that about 1 mi from the rwy their alt was 1,000 ft & 'lots of speed.' The plt was cleared to land on rwy 13. The plt then reported 'we go around again...' He was advised by the tower to make left traffic. He was then observed…NTSB FTW79FA064Accident · 1 fatalClosedPiper PA-22 · Gladewater, TXNTSB ANC78FA066Accident · 2 fatalClosedPiper PA-22 · Chandalar Lake, AKNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILNTSB NYC77FA012Accident · 1 fatalClosedPiper PA-22 · Warren Center, PANTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNTSB CHI74AC092Accident · 3 fatalClosedPiper PA-22 · Oshkosh, WINTSB CHI74AC077Accident · 1 fatalClosedPiper PA-22 · Port Huron, MINTSB SEA73AS017Accident · 2 fatalClosedPiper PA-22 · Portland, ORNTSB NYC73AN058Accident · 2 fatalClosedPiper PA-22 · Candia, NHNTSB SEA72AS051Accident · 3 fatalClosedPiper PA-22 · Sunriver, ORNTSB SEA72AS040Accident · 4 fatalClosedPiper PA-22 · Ashland, ORNTSB CHI72AC052Accident · 1 fatalClosedPiper PA-22 · Evansville, INNTSB OAK72AP016Accident · 2 fatalClosedPiper PA-22 · Bodega Bay, CANTSB CHI72AC019Accident · 2 fatalClosedPiper PA-22 · Angola, INNTSB SEA71AS045Accident · 1 fatalClosedPiper PA-22 · Springfield, ORNTSB IAD71AI024Accident · 1 fatalClosedPiper PA-22 · Hamlin, WVNTSB NYC70AN136Accident · 5 fatalClosedPiper PA-32 · Saranac Lake, NYNTSB SEA70A0020Accident · 2 fatalClosedPiper PA-22 · Scappoose, ORNTSB MIA70A0036Accident · 2 fatalClosedPiper PA-22 · Missing AircraftNTSB MKC69A0050Accident · 2 fatalClosedPiper PA-22 · Oswego, KSNTSB DIA69F0115Accident · 1 fatalClosedPiper PA-22 · Franklin, NCNTSB MKC69A0012Accident · 1 fatalClosedPiper PA-22 · Gravois Mills, MONTSB MKC68A0072Accident · 2 fatalClosedPiper PA-22 · Topeka, KSNTSB CHI68A0085Accident · 1 fatalClosedPiper PA-22 · Cincinnati, OHNTSB DIA68A0036Accident · 2 fatalClosedPiper PA-22 · Kasson, WVNTSB CHI68A0076Accident · 1 fatalClosedPiper PA-22 · Nineveh, INNTSB CHI68A0068Accident · 1 fatalClosedPiper PA-22 · Cleveland, OHNTSB FTW68A0057Accident · 1 fatalClosedPiper PA-22 · Porum, OKNTSB SEA67A0064Accident · 2 fatalClosedPiper PA-22 · Rupert, IDNTSB NYC67A0061Accident · 4 fatalClosedPiper PA-22 · Maysville, WVNTSB CHI67A0045Accident · 3 fatalClosedPiper PA-22 · Knox, INNTSB MKC66A0056Accident · 1 fatalClosedPiper PA-22 · Elk City, OKNTSB CHI66A0069Accident · 2 fatalClosedPiper PA-22 · London, KYNTSB LAX66A0051Accident · 4 fatalClosedPiper PA-22 · S.Luis Obispo, CANTSB CHI65A0100Accident · 2 fatalClosedPiper PA-22 · Warren, OHNTSB SEA65A0051Accident · 1 fatalClosedPiper PA-22 · Anaconda, MTNTSB UNK65X1193Accident · 5 fatalClosedPiper PA-22 · Pelham, TNNTSB UNK65X0851Accident · 1 fatalClosedPiper PA-22 · Guinda, CANTSB UNK64X2403Accident · 3 fatalClosedPiper PA22 · Redding, CA