NTSB investigations: Piper PA-22-160
13 cases on aircraft the registry lists as Piper PA-22-160, 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 3 |
| 1995 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 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\" = 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 ('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" = 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 DEN06LA007Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · New Century, KSloss of engine power due to the pilot's improper use of carbuetor heat and his improper inflight planning/decision. Contributing factors were the inadequate supervision of the student by the flight instructor, conditions conducive to carburetor ice, dark…NTSB LAX04LA109Accident · No injuriesLimited investigationFinal reportPiper PA 22-160 · Carefree, AZThe pilot's inadequate fuel management by his failure to switch the fuel tank selector position, which resulted in fuel starvation, a loss of engine power.NTSB ANC01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Skwentna, AKA loss of engine power due to an undetermined reason.NTSB CHI97LA286Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Shields, KSa loss of engine power from undetermined reasons.NTSB LAX95LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Payson, AZa loss of power for undetermined reasons.NTSB LAX93LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Florence, AZThe pilot's poorly planned approach; his failure to attain the proper touch down point; and, delay in executing a go-around. Contributing to this accident was the partial loss of power for undetermined reasons.NTSB ANC92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Alsworth, AKThe improper maneuver that unported the low fuel tank. The unsuitable terrain at the site of forced landing was a factor.NTSB ANC92LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Cinnibar, AKThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB ATL90LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Greensboro, NCThe loss of engine power for undetermined reasons.NTSB MIA89FA174Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · St. Augustine, FLThe pilot failed to maintain airspeed during the turn to return to the airport, resulting in the loss of control. Contributing to the accident was his continued takeoff with intermittent engine power.NTSB ATL87LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Toronto, OHThe plt reported that the engine quit completely after takeoff at about 50-75 ft AGL without any warning. The plt attempted to land back on the rwy and the acft overran the rwy end. Examination of the acft after the accident revealed no malfunctions, defects,…NTSB DEN85LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Rocky Ford, COAccording to the plt, at 150 to 200 ft AGL the acft was unable to continue the climb or maintain alt. During the forced landing rollout in a corn field the acft nosed over and came to rest inverted. Engine disassembly revealed no mechanical malfunctions. The…NTSB NYC82DA186Accident · No injuriesFinal reportPiper PA-22-160 · Barnstead, NHThe pilot stated he lost power during takeoff and landed in trees off the end of the runway.