NTSB investigations: Piper PA-22-108
709 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.
Cases, newest first
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.\"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."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" 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 ATL85FA020Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Vicksburg, MSDuring preflt, plt detected water in fuel sample. After takeoff, the engine began to run roughly and on crosswind leg lost power completely. Plt stated that on approach to forced landing, he intentionally struck a tree with the left wing to slow the acft.…NTSB MKC84FA285Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Wilmot, ARWitnesses stated, acft was seen circling over farmland and during the third circle it descended toward a brick house. The acft was seen to pull-up at which time it contacted the top of a sycamore tree in a left bank. The acft continued an additional 230 ft…NTSB CHI84LA333Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Bloomington, ILPlt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to…NTSB NYC84LA120Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Lawrence, MAThe plt reported that the acft ballooned on landing, & on the 2nd touchdown, it veered left towards a snowbank. He maneuvered to avoid the snowbank, but the nose wheel collapsed in soft mud.NTSB ATL84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Edgewater, MDA student plt started to fly the acft, but as she was moving on the rwy, she detected a misfiring of the eng that she reported as a popping sound. Therefore, she returned to the ramp area & shut down the eng. Her husband agreed to fly with her around the…NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB NYC83LA230Accident · No injuriesLimited investigationFinal reportPiper PA-22 · West Bloomfield, NYReportedly, the plt was returning to the departure arpt to land when the eng lost power. Subsequently, the acft was damaged during a forced landing in a corn field. An exam of the eng revealed excessive carbon in the exhaust stack. Also, the primer was found…NTSB SEA83FYA02Accident · 1 fatalFinal reportPiper PA-22-108 · Nr Jackpot, NVPrior to the accident, the acft was observed maneuvering in the vicinity. Subsequently, the acft collided with the ground while it was being flown under a 40 ft power line. Both of the occupants had student plt certificates that had expired. One of the…NTSB LAX83LA352Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Mammoth Lakes, CAThe acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the…NTSB FTW83LA248Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Breaux Bridge, LAThe acft nosed over during landing on a wet soft private grass strip. During landing the nose gear dug in and the acft nosed over. The plt stated that he needed more experience in judging grass strip conditions.NTSB SEA82DA056Accident · No injuriesFinal reportPiper PA-22-108 · Snohomish, WAThe pilot stated that he kept his speed up and landed farther down the runway than usual due to other traffic. After touchdown he found that the brakes had failed so he attempted to slow down the aircraft by swerving back and forth and finally turning off on…NTSB MIA82DA121Accident · No injuriesFinal reportPiper PA-22-108 · Tampa, FLWhile circling over the area where the pilot resided, a complete loss of power occurred. During the emergency landing the pilot stalled the aircraft while attempting to avoid a collision with an autombile. Both the aircraft and the automobile were…NTSB LAX82FA036Accident · 1 fatalField investigationFinal reportPiper PA-22 · Black Canyon Ci, AZThe wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.NTSB MIA82FLD07Accident · Minor injuriesClosedPiper PA-22 · Zephyrhills, FLNTSB NYC82DFJ05Accident · No injuriesClosedPiper PA-22 · Fulton, NJNTSB NYC81DNA22Accident · No injuriesClosedPiper PA-22 · Mansfield, MANTSB CHI81FEM27Accident · Minor injuriesClosedPiper PA-22 · Alma, MINTSB LAX81FA052Accident · 2 fatalClosedPiper PA-22 · Grand Canyon, AZNTSB CHI81FER15Accident · No injuriesClosedPiper PA-22 · Turtle Lake, WINTSB FTW80DRA47Accident · Minor injuriesClosedPiper PA-22 · La Porte, TXNTSB CHI80FEI33Accident · No injuriesClosedPiper PA-22 · Painesville, OHNTSB LAX80FA056Accident · 2 fatalClosedPiper PA-22 · Oxnard, CANTSB LAX80FUM11Accident · Minor injuriesClosedPiper PA-22 · Ocotillo Well, CANTSB SEA80DYP13Accident · No injuriesClosedPiper PA-22 · Colville, WANTSB MKC80DER11Accident · No injuriesClosedPiper PA-22 · Middle River, MNNTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MINTSB IAD80FKM01Accident · Serious injuriesClosedPiper PA-22 · Charlotte, NCNTSB IAD79DKM01Accident · No injuriesClosedPiper PA-22 · Port Royal, VANTSB NYC79FFA11Accident · Minor injuriesClosedPiper PA-22 · Albany, NYNTSB FTW79FRA04Accident · Serious injuriesClosedPiper PA-22 · Houston, TXNTSB IAD78FID22Accident · Minor injuriesClosedPiper PA-22 · Danville, VANTSB MKC78DCG49Accident · Minor injuriesClosedPiper PA-22 · Severance, KSNTSB CHI78DEX22Accident · Minor injuriesClosedPiper PA-22 · Richmond, INNTSB CHI78FEC34Accident · Minor injuriesClosedPiper PA-22 · Fraser, MINTSB FTW78FPM13Accident · No injuriesClosedPiper PA-22 · Tulsa, OKNTSB NYC78FA056Accident · 2 fatalClosedPiper PA-22 · Northampton, PANTSB CHI78FEI15Accident · No injuriesClosedPiper PA-22 · Toronto, OHNTSB NYC78FNA09Accident · No injuriesClosedPiper PA-22 · Westerly, RINTSB CHI78FEI13Accident · No injuriesClosedPiper PA-22 · Medina, OHNTSB MKC78DCA12Accident · No injuriesClosedPiper PA-22 · Chesterfield, MONTSB ANC78DAG20Accident · No injuriesClosedPiper PA-22 · Talkeenta, AKNTSB FTW78FPJ08Accident · Minor injuriesClosedPiper PA-22 · Victory, OKNTSB LAX77FA071Accident · 1 fatalClosedPiper PA-22 · Malibu, CANTSB DEN77DQD23Accident · Minor injuriesClosedPiper PA-22 · Silver City, NMNTSB MIA77FKG52Accident · No injuriesClosedPiper PA-25 · Sylvania, GANTSB FTW77FPG34Accident · Minor injuriesClosedPiper PA-22 · N.Little Rock, ARNTSB FTW77FPJ08Accident · No injuriesClosedPiper PA-22 · Duncan, OKNTSB NYC77FFJ13Accident · No injuriesClosedPiper PA-22 · Jamestown, NYNTSB SEA77DYK05Accident · No injuriesClosedPiper PA-22 · Denmark, ORNTSB CHI77FA025Accident · 2 fatalClosedPiper PA-22 · Romeoville, IL