NTSB investigations: Piper PA-22-150
24 cases on aircraft the registry lists as Piper PA-22-150, where the first occurrence was “In flight collision with object”. 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.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 4 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2007 | 2 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102210')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102210')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.NTSB ANC07CA101Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cooper Landing, AKThe pilot's failure to maintain altitude/clearance from objects, which resulted in an in-flight collision with trees during takeoff/initial climb. A factor contributing to the accident was the pilot's decision to takeoff into known adverse weather.NTSB SEA01LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Sunriver, ORThe pilot's failure to maintain clearance from trees during initial climb. Trees were a factor.NTSB LAX99FA301Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Strathmore, CAThe failure of the pilot to maintain an adequate terrain and obstacle clearance altitude, which resulted in a collision with power transmission wires.NTSB MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.NTSB CHI97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Castlewood, SDThe pilot's failure to maintain adequate clearance from the trees.NTSB LAX97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Madera, CAThe pilot's failure to maintain adequate clearance from obstructions and his inadequate visual outlook.NTSB BFO93LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Mayville, NYThe pilot's failure to select the proper runway for takeoff, and his failure to maintain clearance with terrain. A factor related to the accident was a prevailing tailwind.NTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.NTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.NTSB ANC91LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Beluga, AKThe pilot's failure to use proper takeoff procedures. Contributing to the accident was the tailwind, and the rising terrain.NTSB MKC90LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Eldora, IAImproper planning/decision by the pilot, and his failure to maintain clearance from obstructions during the approach to land. Factors related to the accident were: the aircraft's low fuel level, darkness, the pilot's selection of the wrong airport/runway, the…NTSB CHI88DER13Accident · No injuriesFinal reportPiper PA-22-150 · Cohasset, MNFailure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach.NTSB SEA88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Hawthorne, NVDuring a go-around due to the pilot having difficulty landing with a gusting crosswind, the aircraft struck a barbed wire fence with the main landing gear and a fence post with the left horizontal stabilizer. The aircraft then crossed a road and came to rest…NTSB NYC88FA131Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Thomasville, PADue to the pilot's improper preflight planning, he attempted to takeoff with his aircraft weight above the maximum gross weight in a high unfavorable 90 degree crosswind, failed to maintain directional control, and collided with trees.NTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…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…NTSB FTW87DRD12Accident · Serious injuriesFinal reportPiper PA-22-150 · Mansfield, LAThe airport was 324 feet above sea level. The OAT was 96 degrees f. the airplane, with the pilot and two passengers, lifted off the rwy but would not climb. A witness stated the engine sounded normal but the nose was very high. The airplane impacted trees and…NTSB MKC87FA165Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Batesville, ARThe airplane was at maximum gross weight at takeoff. The field elevation was 613 feet and the density altitude was 3300 feet. There were two runways available. Runway 25 was 6002 feet long and had a slight headwind from the southwest. Runway 35 was 3320 feet…NTSB FTW86LQG10Accident · No injuriesFinal reportPiper PA-22-150 · Skellytown, TXThe pilot stated that his take off roll was longer than expected. Reaching the end of the runway, he rotated & the acft left the ground, but it did not establish a good rate of climb. Subsequently, the acft collided with a pole & crashed. The takeoff was…NTSB ATL84FLT02Accident · Serious injuriesFinal reportPiper PA-22-150 · Memphis, TNThe acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop…NTSB ATL83LA156Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Liberty, NCThe acft collided with trees during takeoff climb and crashed to the ground in a nose low attitude. The 4 occupants received only minor injuries. This was the beginning of a 10 minute night flight in dark overcast conditions. The pilot lowered the acft nose…NTSB ATL82DA177Accident · Minor injuriesFinal reportPiper PA-22-150 · Hixson, TNThe pilot elected to takeoff on a dark night without runway lights. He stated that the runway lights were not available at the time since the operator was out of town. According to the pilot and other witnesses, at least part of the airport environment was…NTSB CHI82DA167Accident · No injuriesFinal reportPiper PA-22-150 · Harrison, MIDuring takeoff the pilot failed to clear a chain link fence. The aircraft collided with a ditch and the left main landing gear collapsed.