NTSB investigations: Piper PA-22-135
7 cases on aircraft the registry lists as Piper PA-22-135, where the first occurrence was “Loss of control - in flight”. 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2004 | 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 ('7102206')
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\" = 250))
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 ('7102206')
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" = 250))
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 ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.NTSB NYC99FA181Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Palatine, NYThe pilot was impaired by an illegal drug, and entered an inadvertent stall/spin.NTSB SEA91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Laramie, WYThe pilot's failure to maintain an airspeed above the stall speed for the aircraft. Contributing to the accident was the high density altitude.NTSB ATL89FA144Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Augusta, GAFailure of the pilot to maintain adequate airspeed, while making a steep turn after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.NTSB ANC89LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Healy Lake, AKAfter waiting for more favorable wind conditions, the student pilot and his passenger attempted a departure from a dirt strip surrounded by trees. The non-rated passenger stated that 'after becoming airborne and climbing slightly above the treetops, it felt…NTSB ANC87LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Iowa Ridge, AKThe pilot was awakened in the night at his hunting camp by strong winds estimated at 70 - 80 mph. His airplane came loose at its tie-down and he elected to try and fly it to a safer location. Shortly after take off he lost control of the airplane and crashed.…NTSB ANC85LA143Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Mccarthy, AKThe plt stated that while executing a 180 deg right turn the acft drifted 50 ft to the east of rwy 19 where it struck a row of trees. The acft continued in a steep descending turn. The acft stalled and crashed into a wooded area.