NTSB investigations: Piper PA-22-150
11 cases on aircraft the registry lists as Piper PA-22-150, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102210')
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\" = 351))
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 ('7102210')
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" = 351))
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 ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.NTSB BFO91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wise, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was unsuitable terrain on the emergency landing field.NTSB LAX89LA247Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Placerville, CAThe improper maintenance performed at the last overhaul which resulted in the failure of the #3 main bearing. Contributing to the accident was the lack of a suitable landing area for the emergency landing.NTSB LAX88FA251Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Compton, CAStudent pilots failure to adequately remove moisture from the fuel system during his preflight inspection which led to a loss of engine power during a critical phase of flight.NTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…NTSB FTW88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Worth, TXThe flt was cruising at 2,000 ft MSL when the eng lost pwr. The student plt changed fuel tanks and the engine regained pwr for about 20 sec then again lost pwr. During the forced landing the acft collided with a fence and nosed over. Examination of the eng by…NTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…NTSB CHI86LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, MIThe eng quit during climb out shortly after takeoff. The plt switched tanks and tried a restart with no success. The acft then experienced a nose gear collapse and nosed over during a landing roll in a field. Investigation revealed the fuel line to the…NTSB ANC84FA131Accident · No injuriesField investigationFinal reportPiper PA-22 · Delta Junction, AKThe acft was damaged in an off arpt landing after the engine lost power. The plt stated the acft was operating on automotive fuel without the required supplemental type certificate. The acft was operating without the required annual inspection and the tbo had…NTSB CHI84LA322Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Findlay, OHDuring the initial takeoff climb at an alt of aprx 1400 ft MSL the engine quit. Attempts to regain power failed. The acft nosed over during a forced landing in a corn field. Post accident investigation of the engine revealed a broken carburetor heat linkage…NTSB FTW82FQG20Accident · Serious injuriesFinal reportPiper PA-22-150 · Clovis, NMThe eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor…