NTSB investigations: Piper PA-22-108, MO
18 cases on aircraft the registry lists as Piper PA-22-108. 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 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 1 |
| 1971 | 1 |
| 1977 | 1 |
| 1994 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2014 | 1 |
| 2016 | 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\" = 'MO' 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 ('7102204'))
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" = 'MO' 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 ('7102204'))
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 CEN17LA062Accident · No injuriesLimited investigationFinal reportPiper PA22 · Piedmont, MOThe pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines.NTSB CEN14LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Forsyth, MOThe pilot's improper flight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.NTSB CHI07LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Ava, MOThe failure of the aileron cable eye splice during cruise flight. Contributing to the accident were improper installation and service of the crimped cable sleeve, which rendered the airplane uncontrollable.NTSB CHI95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Mt. Vernon, MOthe pilot's inadequate visual lookout. A factor associated with the accident is the fence post.NTSB MKC78DCA12Accident · No injuriesClosedPiper PA-22 · Chesterfield, MONTSB MKC72DCG19Accident · No injuriesClosedPiper PA-22 · Brookfield, MONTSB MKC69F0438Accident · Serious injuriesClosedPiper PA-22 · Richland, MONTSB MKC69F0114Accident · Serious injuriesClosedPiper PA-22 · St Charles, MONTSB MKC69D0057Accident · No injuriesClosedPiper PA-22 · St.Charles, MONTSB MKC68D0426Accident · No injuriesClosedPiper PA-22 · Fayette, MONTSB MKC68F0313Accident · No injuriesClosedPiper PA-22 · St.Charles, MONTSB CHI67F0102Accident · Serious injuriesClosedPiper PA-22 · Fruitland, MONTSB MKC66F0439Accident · Serious injuriesClosedPiper PA-22 · Kansas City, MONTSB MKC66F0291Accident · Minor injuriesClosedPiper PA-22 · Trenton, MONTSB UNK64X3824Accident · No injuriesClosedPiper PA22 · West Plains, MONTSB UNK64X3461Accident · No injuriesClosedPiper PA22 · Chillicothe, MONTSB UNK64X2321Accident · Serious injuriesClosedPiper PA-22 · St Louis, MO