Skip to content

NTSB investigations: Piper PA-22-150, IN

31 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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN12LA332Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Greenfield, INA partial loss of engine power for undetermined reasons during takeoff.May 26, 2012 · N9815D · Substantial damage NTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.Aug 15, 2004 · N4303A · Substantial damage NTSB CHI00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Salem, INthe inadequate compensation for the wind conditions and the failure of the pilot to maintain directional control. A factor to the accident was the crosswind condition.Jun 3, 2000 · N1686P · Substantial damage NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.Feb 24, 1996 · N6939B · Substantial damage NTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.Mar 27, 1993 · N3439Z · Substantial damage NTSB CHI88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Marion, INThe pilot became disoriented during flight and made an unscheduled stop in a corn field to ask for directions to his destination airport. During taxi for takeoff from the field, the pilot failed to maintain adequate visual lookout, and struck a manhole cover…Jun 8, 1988 · N3737P · Substantial damage NTSB CHI88LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Muncie, INWhen the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move…Mar 27, 1988 · N7725D · Substantial damage NTSB CHI87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Belleville, INThe aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…Sep 20, 1987 · N7108B · Substantial damage NTSB CHI82DEX02Accident · No injuriesClosedPiper PA-22 · Anderson, INDec 5, 1981 · N1785P · Substantial damage NTSB CHI79FET22Accident · No injuriesClosedPiper PA-22 · Elkhart, INApr 14, 1979 · N2340P · Substantial damage NTSB CHI76FEA23Accident · No injuriesClosedPiper PA-22 · Nashville, INJan 31, 1976 · N7821D · Destroyed NTSB CHI76FEA16Accident · No injuriesClosedPiper PA-22 · Indianapolis, INNov 28, 1975 · N4440A · Substantial damage NTSB CHI75DEA24Accident · Serious injuriesClosedPiper PA-22 · Muncie, INJun 24, 1975 · N7636D · Substantial damage NTSB CHI75FEA08Accident · No injuriesClosedPiper PA-22 · Indianapolis, INAug 15, 1974 · N7730D · Destroyed NTSB UNK74X0102Accident · 1 fatalClosedPiper PA-22 · Wilkinson, INFeb 23, 1974 · N3642Z · Destroyed NTSB CHI73DEA16Accident · No injuriesClosedPiper PA-22 · New Point, INSep 30, 1972 · N6085D · Substantial damage NTSB CHI72FEA41Accident · No injuriesClosedPiper PA-22 · Muncie, INMay 9, 1972 · N7220D · Substantial damage NTSB CHI71FBA17Accident · Serious injuriesClosedPiper PA-22 · Corydon, INNov 29, 1970 · N6712B · Destroyed NTSB CHI71FBA02Accident · Serious injuriesClosedPiper PA-22 · Crawfordsvlle, INJul 5, 1970 · N6043D · Substantial damage NTSB CHI70D0289Accident · No injuriesClosedPiper PA-22 · Loogootee, INSep 14, 1969 · N3276Z · Substantial damage NTSB CHI69F0560Accident · No injuriesClosedPiper PA-22 · Galveston, INMar 23, 1969 · N6177D · Substantial damage NTSB CHI69A0038Accident · 1 fatalClosedPiper PA-22 · Hobart, INOct 7, 1968 · N6113D · Destroyed NTSB CHI68D0682Accident · No injuriesClosedPiper PA-22 · Monon, INApr 6, 1968 · N7028B · Substantial damage NTSB CHI68D0619Accident · No injuriesClosedPiper PA-22 · Muncie, INMar 1, 1968 · N7109B · Substantial damage NTSB CHI68F0328Accident · No injuriesClosedPiper PA-22 · Wabash, INSep 24, 1967 · N6999B · Substantial damage NTSB CHI68D0485Accident · No injuriesClosedPiper PA-22 · Greenwood, INSep 23, 1967 · N3656P · Substantial damage NTSB CHI68F0336Accident · Serious injuriesClosedPiper PA-22 · Greenfield, INSep 10, 1967 · N3740P · 2 aircraft · Substantial damage NTSB CHI67D0519Accident · No injuriesClosedPiper PA-22 · Muncie, INMar 1, 1967 · N7047B · Substantial damage NTSB CHI66A0089Accident · 1 fatalClosedPiper PA-22 · Morocco, INMay 12, 1966 · N3208Z · Destroyed NTSB CHI66F0154Accident · No injuriesClosedPiper PA-22 · Indianapolis, INAug 7, 1965 · N9636D · Substantial damage NTSB UNK64X2902Accident · No injuriesClosedPiper PA-22 · Madison, INJul 18, 1964 · N7040B · Substantial damage