Skip to content

NTSB investigations: Piper PA-22, MI

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

19652026

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" = 'MI' 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 ('7102202')) 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\" = 'MI' 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 ('7102202'))
  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" = 'MI' 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 ('7102202'))
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 CEN13CA185Accident · Minor injuriesData collectionFinal reportPiper PA22 · Baraga, MIThe pilot’s failure to maintain directional control during taxi.Mar 2, 2013 · N2238A · Substantial damage NTSB CHI98LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Muskegon, MIA loss of engine power due to a broken number 4 cylinder connecting rod for undetermined reasons. Contributing to this accident was the road embankment.Jul 27, 1998 · N875A · Substantial damage NTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.May 16, 1988 · N8800C · Substantial damage NTSB CHI83LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Napoleon, MIThe aircraft lost power during climb after takeoff. The pilot made a forced landing in an open field. He stated that contamentation was the cause of the power loss.Feb 7, 1983 · N4357A · Substantial damage NTSB CHI78FEM42Accident · Minor injuriesClosedPiper PA-22 · Kalamazoo, MISep 20, 1978 · N2852Z · Substantial damage NTSB CHI74FEC42Accident · Minor injuriesClosedPiper PA-22 · Cambridge Jt, MIApr 27, 1974 · N2240A · Substantial damage NTSB CHI74AC077Accident · 1 fatalClosedPiper PA-22 · Port Huron, MIMar 14, 1974 · N901A · Minor damage NTSB CHI74DEM40Accident · No injuriesClosedPiper PA-22 · Trout Lake, MIFeb 3, 1974 · N2473P · Substantial damage NTSB CHI72FEC13Accident · No injuriesClosedPiper PA-22 · Marine City, MISep 14, 1971 · N8705C · Substantial damage NTSB CHI71FBJ11Accident · Serious injuriesClosedPiper PA-22 · Kalamazoo, MIJul 23, 1970 · N2253A · Substantial damage NTSB CHI70FDW24Accident · Minor injuriesClosedPiper PA-22 · Richmond, MIJun 30, 1970 · N946A · Substantial damage NTSB CHI70DBJ17Accident · No injuriesClosedPiper PA-22 · Schoolcraft, MIMar 29, 1970 · N2747P · Substantial damage NTSB CHI70DBJ07Accident · No injuriesClosedPiper PA-22 · Lake City, MIFeb 15, 1970 · N1146C · Substantial damage NTSB CHI70F0110Accident · Minor injuriesClosedPiper PA-22 · Kalamazoo, MIAug 2, 1969 · N2194A · Substantial damage NTSB CHI70F0057Accident · No injuriesClosedPiper PA-22 · White Pigeon, MIMay 26, 1969 · N8815C · Substantial damage NTSB CHI69F0655Accident · No injuriesClosedPiper PA-22 · Pontiac, MIMay 20, 1969 · N3566A · Substantial damage NTSB CHI69D0459Accident · Minor injuriesClosedPiper PA-22 · Grand Haven, MIJan 26, 1969 · N8839C · Destroyed NTSB CHI69D0158Accident · No injuriesClosedPiper PA-22 · Pontiac, MIAug 24, 1968 · N3645A · Substantial damage NTSB CHI69F0134Accident · No injuriesClosedPiper PA-22 · Utica, MIJul 12, 1968 · N3566A · Substantial damage NTSB CHI68F0621Accident · No injuriesClosedPiper PA-22 · Greenville, MIMar 14, 1968 · N2701P · Substantial damage NTSB CHI68F0453Accident · No injuriesClosedPiper PA-22 · Kalamazoo, MINov 8, 1967 · N2147A · Substantial damage NTSB CHI68D0466Accident · Minor injuriesClosedPiper PA-22 · Gladwin, MIOct 29, 1967 · N1641A · Substantial damage NTSB CHI68D0317Accident · Minor injuriesClosedPiper PA-22 · Manistique, MIAug 31, 1967 · N940A · Substantial damage NTSB CHI68F0148Accident · Minor injuriesClosedPiper PA-22 · Belmont, MIJul 2, 1967 · N1450A · Substantial damage NTSB CHI67F0527Accident · No injuriesClosedPiper PA-22 · Kalamazoo, MIMar 2, 1967 · N3645A · Substantial damage NTSB CHI67F0382Accident · Serious injuriesClosedPiper PA-22 · Lewiston, MINov 18, 1966 · N3261Z · Substantial damage NTSB CHI67D0253Accident · No injuriesClosedPiper PA-22 · Sharon, MIOct 1, 1966 · N3330A · Substantial damage NTSB CHI67F0144Accident · No injuriesClosedPiper PA-22 · Greenville, MIAug 6, 1966 · N1450A · Substantial damage NTSB CHI66F0343Accident · No injuriesClosedPiper PA-22 · Lawrence, MIOct 5, 1965 · N834A · Substantial damage NTSB CHI66F0172Accident · No injuriesClosedPiper PA-22 · Ravenna, MIAug 3, 1965 · N181F · Substantial damage