NTSB investigations: Piper PA-22
5 cases on aircraft the registry lists as Piper PA-22, where the first occurrence was “In flight collision with terrain/water”. 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 |
|---|---|
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 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 ('7102202')
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\" = 230))
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 ('7102202')
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" = 230))
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 SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.NTSB FTW97LA337Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Saratoga, WYThe pilot's failure to consult airplane performance data based upon the weather conditions that prevailed. Factors were terrain induced turbulence and high density altitude.NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.NTSB CHI96LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Crawfordsville, INThe pilot's premature raising of the flaps and the low airspeed.NTSB FTW82FQA24Accident · Serious injuriesFinal reportPiper PA-22 · Lake Arthur, NMThe pilot and one passenger were on a flight to pick up spare parts. The passenger recalled that while en route, the pilot remarked, "oh, I can't resist" and started to descend, then made a pass at about 50 ft over a field hand. The field hand, a mexican…