Skip to content

NTSB investigations: Piper PA-22-150, VA

28 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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA26LA315Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Rural Retreat, VAThe pilot’s failure to maintain directional control during the landing roll.Aug 25, 2026 · N6157D · Substantial damage NTSB GAA17CA281Accident · No injuriesData collectionFinal reportPiper PA22 · South Boston, VAThe pilot’s failure to maintain directional control during the landing roll.May 15, 2017 · N31JP · Substantial damage NTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.Jul 24, 2005 · N3818P · Substantial damage NTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.May 13, 2000 · N6841B · Substantial damage NTSB BFO95LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · South Boston, VALoss of engine power for an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Aug 25, 1995 · N3965P · Substantial damage NTSB BFO91LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Danville, VAAn inadequate preflight inspection which resulted in water contaminated fuel. Contributing was noncompliance with an airworthiness directive.May 25, 1991 · N5931D · Substantial damage NTSB BFO91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wise, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was unsuitable terrain on the emergency landing field.Feb 2, 1991 · N7816D · Substantial damage NTSB BFO87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pungo, VAThe student made 3 full stop landings alone before the instructor boarded the acft. Another full stop landing was made and during the landing roll the instr noticed that the last half of the grass rwy was wetter than the first half. The instr elected to…Jan 21, 1987 · N7720D · Substantial damage NTSB BFO87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hillsville, VAAfter touchdown on the rwy, the plt held the nose wheel off for about 200 feet of travel by holding the control wheel back. According to him, the acft then veered to the left and he was unable to steer it with the rudder pedals. The acft went off the side of…Oct 2, 1986 · N6003D · Substantial damage NTSB ATL83LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Stafford, VAThe acft collided with a ditch during a forced landing. The plt was cruising at 3000 ft MSL when he heard a 'loud pop'. The engine started running rough and missing. The plt shut the engine down by pulling the mixture control and throttle. When he shut down…Feb 19, 1983 · N3750P · Substantial damage NTSB IAD80FID17CaseClosedPiper PA-22 · Easterville, VAApr 20, 1980 · N6170D NTSB IAD80DID13Accident · No injuriesClosedPiper PA-22 · Tye River, VAApr 4, 1980 · N6060D · Substantial damage NTSB IAD80FA013Accident · 1 fatalClosedPiper PA-23 · Locust Grove, VANov 25, 1979 · N7650D · Destroyed NTSB IAD78FID19Accident · Minor injuriesClosedPiper PA-22 · Chesterfield, VAAug 8, 1978 · N1812P · Substantial damage NTSB IAD77;ID30Accident · Minor injuriesClosedPiper PA-22 · Pungo, VASep 18, 1977 · N4323A · Destroyed NTSB IAD77FIA02Accident · No injuriesClosedPiper PA-22 · Haymarket, VAOct 25, 1976 · N6948B · Substantial damage NTSB IAD75FID02Accident · No injuriesClosedPiper PA-18 · Skippers, VAJul 22, 1974 · N2754P · Substantial damage NTSB NYC73FID09Accident · No injuriesClosedPiper PA-22 · Richmond, VANov 5, 1972 · N3546Z · Substantial damage NTSB NYC72AN151Accident · 1 fatalClosedPiper PA-22 · Winchester, VAJun 11, 1972 · N2920P · 2 aircraft · Substantial damage NTSB IAD71AI004Accident · 3 fatalClosedPiper PA-22 · Chesapeake, VAJul 5, 1970 · N1909P · Destroyed NTSB IAD70F0056Accident · Serious injuriesClosedPiper PA-22 · Hot Springs, VAAug 15, 1969 · N3832P · Destroyed NTSB DIA69F0202Accident · No injuriesClosedPiper PA-22 · Farmville, VAMay 11, 1969 · N7746D · Destroyed NTSB DIA69F0037Accident · No injuriesClosedPiper PA-22 · Earlysville, VAAug 2, 1968 · N7009B · Substantial damage NTSB DIA68F0219Accident · Minor injuriesClosedPiper PA-22 · Oak Grove, VAMay 4, 1968 · N8880D · Destroyed NTSB DIA68D0125Accident · No injuriesClosedPiper PA-22 · Boston, VAOct 6, 1967 · N2920P · Substantial damage NTSB DIA67D0028Accident · No injuriesClosedPiper PA-22 · Fredericksburg, VAFeb 5, 1967 · N7407D · Substantial damage NTSB NYC66D0589Accident · No injuriesClosedPiper PA-22 · Fredericksburg, VAMar 2, 1966 · N3630Z · Substantial damage NTSB UNK64X2816Accident · No injuriesClosedPiper PA22 · Fredericksburg, VAJul 14, 1964 · N3630Z · Substantial damage