Skip to content

NTSB investigations: Piper PA-22-150, MO

38 cases on aircraft the registry lists as Piper PA-22-150. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('7102210')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102210'))
  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 ('7102210'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.Nov 28, 2002 · N4901S · Substantial damage NTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.Apr 14, 2001 · N3021Z · Substantial damage NTSB CHI91LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Springfield, MOThe pilot's poor evaluation of high wind conditions and the subsequent inability to compensate for the winds. Related to the accident was the gusty crosswind conditions.Feb 28, 1991 · N3658P · Substantial damage NTSB MKC89LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · St. Clair, MOThe pilot's inability to establish a positive rate of climb due to the misjudged weight and balance calculations.Aug 14, 1989 · N7136B · Substantial damage NTSB MKC88LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Freeburg, MOWhile attempting to land on a farm pasture that the plt had previously walked over to check, the aircraft nose wheel collapsed, followed by a nose over. The aircraft landed nose low with no flaps and dug into the grass runway.Aug 26, 1988 · N3171Z · Substantial damage NTSB MKC82DA167Accident · Minor injuriesFinal reportPiper PA-22-150 · Higginsville, MOWhile attempting a power-off landing at a private airstrip, the pilot added power for a go-around. The engine sputtered, lost power and the pilot made a forced landing in a terraced area. The nose gear collapsed and the aircraft nosed over. Water was found in…Aug 31, 1982 · N6914D · Substantial damage NTSB MKC81FCG24Accident · No injuriesClosedPiper PA-22 · Bethany, MOMar 15, 1981 · N4786A · Substantial damage NTSB MKC81FCG15Accident · No injuriesClosedPiper PA-22 · Independence, MONov 15, 1980 · N2637P · Substantial damage NTSB MKC79FCG08Accident · Serious injuriesClosedPiper PA-22 · Ozark, MOOct 21, 1978 · N9675D · Substantial damage NTSB MKC77FA030Accident · 4 fatalClosedPiper PA-22 · Bunker, MOJul 15, 1977 · N2928P · Destroyed NTSB MKC76DCG03Accident · Minor injuriesClosedPiper PA-22 · Camdenton, MOJul 6, 1975 · N3523Z · Substantial damage NTSB MKC74AK050Accident · 1 fatalClosedPiper PA-22 · Maitland, MOFeb 16, 1974 · N7133D · Destroyed NTSB MKC73DCG28Accident · No injuriesClosedPiper PA-22 · Osceola, MOFeb 10, 1973 · N3301Z · Substantial damage NTSB MKC72DCA13Accident · No injuriesClosedPiper PA-22 · Vichy, MONov 6, 1971 · N2827P · Substantial damage NTSB MKC72IK006Incident · No injuriesClosedLockheed T-33 · R.Gebaur Afb, MOJul 18, 1971 · AF 70751 · 2 aircraft · Minor damage NTSB MKC71DCG55Accident · No injuriesClosedPiper PA-22 · Platte City, MOApr 6, 1971 · N1846P · Substantial damage NTSB MKC71DCA24Accident · No injuriesClosedPiper PA-22 · Mexico, MOJan 25, 1971 · N7220D · Substantial damage NTSB MKC70DCG25Accident · Minor injuriesClosedPiper PA-22 · Kirksville, MOMay 3, 1970 · N2974P · Substantial damage NTSB MKC70DCG15Accident · No injuriesClosedPiper PA-22 · Bethany, MOMar 16, 1970 · N3538Z · Substantial damage NTSB MKC67F0561Accident · Minor injuriesClosedPiper PA-22 · Higginsville, MOApr 18, 1967 · N2566P · Substantial damage NTSB MKC67D0346Accident · No injuriesClosedPiper PA-22 · Independence, MONov 20, 1966 · N7159D · Substantial damage NTSB MKC67F0103Accident · No injuriesClosedPiper PA-22 · Cuba, MOJul 18, 1966 · N9303D · Substantial damage NTSB MKC66F0499Accident · No injuriesClosedPiper PA-22 · Columbia, MOFeb 26, 1966 · N7804D · Substantial damage NTSB MKC66F0333Accident · No injuriesClosedPiper PA-22 · Cape Girardeau, MONov 11, 1965 · N3968P · Substantial damage NTSB MKC66D0357Accident · No injuriesClosedPiper PA-22 · Centerville, MONov 8, 1965 · N2663P · Substantial damage NTSB MKC66F0231Accident · No injuriesClosedPiper PA-22 · Bigelow, MOSep 13, 1965 · N7033D · Substantial damage NTSB MKC66D0128Accident · Minor injuriesClosedPiper PA-22 · Hallsville, MOJul 10, 1965 · N2811P · Substantial damage NTSB MKC65A0075Accident · 2 fatalClosedPiper PA-22 · 6n Camdenton, MOJun 13, 1965 · N2428P · Destroyed NTSB MKC65F0146Accident · No injuriesClosedPiper PA-22 · Kansas City, MOApr 17, 1965 · N1626P · Substantial damage NTSB MKC65F0089Accident · Minor injuriesClosedPiper PA-22 · Rogersville, MOFeb 20, 1965 · N6833B · Substantial damage NTSB UNK65X0411Accident · 2 fatalClosedPiper PA-22 · Westplains, MOOct 24, 1964 · N7548D · Destroyed NTSB UNK64X4171Accident · 2 fatalClosedPiper PA-22 · Fisk, MOSep 26, 1964 · N7820D · Destroyed NTSB UNK64X3427Accident · No injuriesClosedPiper PA22 · Independence, MOAug 16, 1964 · N3524Z · Substantial damage NTSB UNK64X2779Accident · 1 fatalClosedPiper PA22 · Springfield, MOJul 12, 1964 · N2948Z · Destroyed NTSB UNK64X2639Accident · No injuriesClosedPiper PA22 · Eldon, MOJul 4, 1964 · N2468P · Substantial damage NTSB UNK64X2468Accident · No injuriesClosedPiper PA22 · Climax Springs, MOJun 24, 1964 · N2759P · Substantial damage NTSB UNK64X1103Accident · Serious injuriesClosedPiper PA22 · Bowling Green, MOMar 29, 1964 · N3533P · Destroyed NTSB UNK64X0418Accident · Minor injuriesClosedPiper PA-22 · St Charles Co, MOFeb 1, 1964 · N5961D · Substantial damage