NTSB investigations: Piper PA-22-160
14 cases on aircraft the registry lists as Piper PA-22-160, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 2 |
|---|---|
| 1986 | 1 |
| 1989 | 4 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 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 ('7102214')
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\" = 353))
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 ('7102214')
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" = 353))
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 MIA01LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Daytona Beach, FLa total loss of engine power due to the pilot's improper procedures by not placing the fuel selector on the tank with the most fuel, after a reported restricted movement of the flight controls for undetermined reasons, which resulted in fuel starvation and a…NTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.NTSB DEN00LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COThe pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.NTSB LAX98LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Clarksburg, CAA total loss of engine power for undetermined non-mechanical reasons. A contributing factor in the landing nose-over was the presence of the soft terrain.NTSB CHI95LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Rock Falls, ILthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's poor preflight planning/preparation.NTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB FTW92LA217Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Farmington, NMTotal loss of engine power due to carburetor ice and the pilot's delayed use of carburetor heat. A factor was unsuitable terrain.NTSB CHI90LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Barron, WIImproper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.NTSB LAX89LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · El Cajon, CAThe inadequate maintenance of the airplane & inadequate preflight inspection which resulted in the undetection of contaminated fuel.NTSB NYC89LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Gettysburg, PAThe pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion.NTSB FTW89LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Henryetta, OKThe loss of engine power from fuel starvation due to inadequate inflight planning/decision.NTSB FTW86LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Abbeville, LAThe pvt plt took off on a pleasure flt with 1 pax on board. Drg the initial climb, the eng lost power at about 300 ft AGL. The plt then turned downwind & subsequently made a forced landing in a sugar cane field adjacent to the arpt. Drg the landing, the acft…NTSB NYC82DA227Accident · Minor injuriesFinal reportPiper PA-22-160 · Marlboro, NJThe aircraft lost power after takeoff. While the pilot was attempted to land, the left wing of the aircraft collided with trees and the plane crashed. The fuel was found to have been exhausted.NTSB ATL82DA166Accident · Minor injuriesFinal reportPiper 22-160 · Lynchburg, VAThe pilot took off from newport news, VA on a VFR flight to south boston, VA. Later at dusk, he contacted the roanoke fss and asked for an "accurate fix" of his position. At that time, the pilot indicated that he was low on fuel. Fss personnel reported that…