NTSB investigations: Piper PA-22-150
21 cases on aircraft the registry lists as Piper PA-22-150, where the first occurrence was “Loss of engine power”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1991 | 3 |
| 1994 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 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\" = 350))
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" = 350))
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 ANC08LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Pole, AKA loss of engine power for an undetermined reason during an attempted go-around, resulting in a forced landing and a collision with snow-covered terrain. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.NTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.NTSB ANC00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Gakona, AKThe loss of engine power for an undetermined reason.NTSB MIA00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Highlands, NCTotal loss of engine power due to the obstruction (insect larva) of the left wing aft fuel system line resulting in a forced landing to non suitable terrain.NTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.NTSB NYC99FA236Accident · 2 fatalField investigationFinal reportPiper PA 22-150 · Goshen, KYA loss of engine power for undetermined reasons which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the down-sloping terrain.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB MIA97LA106Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Cumming, GAa loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.NTSB BFO95LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · South Boston, VALoss of engine power for an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.NTSB BFO91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Elkins, WVThe loss of engine power for undetermined reasons.NTSB BFO91LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Danville, VAAn inadequate preflight inspection which resulted in water contaminated fuel. Contributing was noncompliance with an airworthiness directive.NTSB LAX91LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fullerton, CAThe pilot's improper preflight inspection. Contributing to this accident was water in the fuel tank.NTSB CHI89LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lima, OHThe pilot failed to use carburetor heat during carburetor icing conditions. Contributing to the accident was the pilot's lack of total experience and the carburetor icing conditions.NTSB MKC86LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Wrightsville, ARThe PIC of the PA22 was practicing departures fm a confined field. The PIC stated that the acft engine had been operating normally, and that he had been operating fm this area for about the previous 1/2 hr. The PIC stated the eng quit on climbout fm the pvt…NTSB MKC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ashby, NEThe plt stated that he and a passenger were sightseeing when he increased the mixture to full rich, applied carb heat and reduced power for a glide across a valley. When he advanced the throttle to level off the engine did not respond. During the forced…NTSB CHI84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lake City, MIAccording to the plt, at about 30 ft AGL after takeoff the eng RPM began to decrease. The acft flew into a tree adjacent to a road near the end of the rwy. A visual inspection of the engine revealed no mechanical malfunctions. The property owner reported that…NTSB FTW84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gallup, NMThe plt reported that he was taking off from a dirt road when the eng lost power shortly after lift-off. Subsequently, the left main gear collapsed during a hard/forced landing.