Skip to content

NTSB investigations: Piper PA-22-150, IL

41 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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CHI08CA038Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plato Center, ILThe excessive airspeed used by the pilot which resulted in an overrun, impact with a ditch and subsequent nose over. The ditch was a factor.Nov 9, 2007 · N2813Z · Substantial damage NTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.Nov 2, 2005 · N9664D · Destroyed NTSB CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.Jun 16, 2001 · N3526Z · Substantial damage NTSB CHI00FA184Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Quincy, ILThe pilots failure to maintain control of the aircraft and his continued flight into adverse weather. Factors were the fog, and the crops.Jul 6, 2000 · N1783P · Destroyed NTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.Mar 15, 1994 · N3263Z · Substantial damage NTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…Apr 4, 1989 · N2944P · Substantial damage NTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…Mar 18, 1988 · N2758P · Substantial damage NTSB CHI83LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Romeoville, ILThe pilot flew over the airport at night, saw the runway lights and entered the traffic pattern for landing. On final approach, he saw a rotating beacon and thought an aircraft was holding short of the runway. As he continued on final, he saw that the beacon…Oct 2, 1982 · N4434A · Substantial damage NTSB CHI78FEV44Accident · No injuriesClosedPiper PA-22 · Galatia, ILSep 15, 1977 · N9623D · Substantial damage NTSB CHI77FCA04Accident · Serious injuriesClosedPiper PA-22 · Columbia, ILJun 18, 1977 · N7125B · Substantial damage NTSB CHI76FEE80Accident · No injuriesClosedPiper PA-22 · Grays Lake, ILSep 29, 1976 · N2758P · Substantial damage NTSB CHI76FEV38Accident · No injuriesClosedPiper PA-22 · Mansfield, ILMay 9, 1976 · N2965Z · Substantial damage NTSB CHI76DEE12Accident · No injuriesClosedPiper PA-22 · Chenoa, ILAug 13, 1975 · N2844P · Substantial damage NTSB CHI76FEV07Accident · Minor injuriesClosedPiper PA-22 · Havana, ILAug 3, 1975 · N4525A · Substantial damage NTSB CHI74FEE18Accident · Minor injuriesClosedPiper PA-22 · Glenwood, ILSep 10, 1973 · N5725D · Substantial damage NTSB CHI73DEV28Accident · No injuriesClosedPiper PA-22 · Galesburg, ILMay 16, 1973 · N3152Z · Substantial damage NTSB CHI73FEE29Accident · Minor injuriesClosedPiper PA-22 · Barrington, ILNov 5, 1972 · N5751D · Substantial damage NTSB CHI71AC013Accident · 1 fatalClosedPiper PA-22 · Xenia, ILAug 12, 1970 · N2627P · 2 aircraft · Destroyed NTSB CHI70F0247Accident · Serious injuriesClosedPiper PA-22 · Decatur, ILAug 31, 1969 · N1745P · Substantial damage NTSB CHI70D0143Accident · No injuriesClosedPiper PA-22 · Peotone, ILJun 28, 1969 · N6746B · Substantial damage NTSB CHI70F0179Accident · Minor injuriesClosedPiper PA-22 · Urbana, ILJun 12, 1969 · N7048B · Substantial damage NTSB CHI69D0608Accident · No injuriesClosedPiper PA-22 · Midlothian, ILMar 23, 1969 · N3413Z · Substantial damage NTSB CHI69D0071Accident · No injuriesClosedPiper PA-22 · Richton Park, ILJun 30, 1968 · N3827P · Substantial damage NTSB CHI68A0093Accident · 1 fatalClosedPiper PA-22 · Trivoli, ILApr 20, 1968 · N7101D · Destroyed NTSB CHI68D0678Accident · No injuriesClosedPiper PA-22 · Midlothian, ILApr 14, 1968 · N2710P · Substantial damage NTSB CHI68F0654Accident · No injuriesClosedPiper PA-22 · Urbana, ILFeb 28, 1968 · N3725P · Substantial damage NTSB CHI68D0272Accident · Minor injuriesClosedPiper PA-22 · Grayslake, ILJul 17, 1967 · N7336D · Substantial damage NTSB CHI68D0483Accident · Minor injuriesClosedPiper PA-22 · Carman, ILJun 4, 1967 · N3525P · Substantial damage NTSB CHI68D0036Accident · No injuriesClosedPiper PA-22 · Grayslake, ILMay 7, 1967 · N2330P · Substantial damage NTSB CHI68D0037Accident · No injuriesClosedPiper PA-22 · Rockford, ILMay 1, 1967 · N7438D · Substantial damage NTSB CHI66F0733Accident · No injuriesClosedPiper PA-22 · Rockford, ILMay 9, 1966 · N7613D · Substantial damage NTSB CHI66F0600Accident · No injuriesClosedPiper PA-22 · Naperville, ILJan 29, 1966 · N4785A · Substantial damage NTSB CHI66A0063Accident · 5 fatalClosedPiper PA-22 · Rockton, ILJan 23, 1966 · N2712P · 2 aircraft · Destroyed NTSB CHI66F0307Accident · No injuriesClosedPiper PA-22 · Lombard, ILAug 28, 1965 · N4957E · Substantial damage NTSB CHI66F0229Accident · No injuriesClosedPiper PA-22 · Hinckley, ILAug 12, 1965 · N6023D · Substantial damage NTSB CHI65D0188Accident · No injuriesClosedPiper PA-22 · Benton, ILMay 16, 1965 · N3309Z · Substantial damage NTSB CHI65D0155Accident · No injuriesClosedPiper PA-22 · Streator, ILApr 13, 1965 · N2941Z · Substantial damage NTSB UNK64X1810Accident · No injuriesClosedPiper PA22 · Lombard, ILMay 17, 1964 · N2751P · Substantial damage NTSB UNK64X1724Accident · No injuriesClosedPiper PA22 · Lombard, ILMay 11, 1964 · N2900P · Substantial damage NTSB UNK64X1315Accident · No injuriesClosedPiper PA22 · Sterling, ILApr 14, 1964 · N3016Z · Destroyed NTSB UNK64X0953Accident · No injuriesClosedPiper PA22 · Chicago, ILMar 16, 1964 · N3664Z · Substantial damage