NTSB investigations: Piper PA-22-160, KS
11 cases on aircraft the registry lists as Piper PA-22-160. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1997 | 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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102214'))
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."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102214'))
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 CHI97LA286Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Shields, KSa loss of engine power from undetermined reasons.NTSB CHI93LA323Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Ellis, KSthe pilot's inadequate preflight planning and preparation. Factors in the accident are the pilot's premature liftoff, his failure to keep the airplane properly aligned during the initial climb, and the high density altitude.NTSB MKC89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Ft Leavenworth, KSThe student pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing to the accident was the student's lack of total experience.NTSB MKC72DCQ43Accident · Minor injuriesClosedPiper PA-22 · Lakin, KSNTSB MKC71FCQ14Accident · No injuriesClosedPiper PA-22 · Dighton, KSNTSB MKC70DCQ22Accident · No injuriesClosedPiper PA-22 · Bird City, KSNTSB MKC69D0217Accident · No injuriesClosedPiper PA-22 · Salina, KSNTSB MKC68D0294Accident · No injuriesClosedPiper PA-22 · Tribune, KSNTSB MKC67D0268Accident · No injuriesClosedPiper PA-22 · Larned, KSNTSB UNK64X3875Accident · No injuriesClosedPiper PA-22 · Liberal, KS