NTSB investigations: Piper PA-22-150, CO
30 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.
Cases per year
| 1965 | 3 |
|---|---|
| 1966 | 4 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
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.\"eventStateOrRegion\" = 'CO' 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" = 'CO' 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" 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 CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.NTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.NTSB DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.NTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.NTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.NTSB DEN99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Limon, COThe pilot's selection of the wrong runway for takeoff. Factors were a direct tailwind and high density altitude that deteriorated the airplane's climb capability, and unsuitable terrain on which to make a forced landing.NTSB DEN99FA119Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Coaldale, COThe pilot's failure to maintain control of the airplane for reasons for reasons undetermined.NTSB FTW98FA392Accident · Serious injuriesField investigationFinal reportPiper PA-20-180 · Thornton, COThe separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.NTSB FTW98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Broomfield, COthe pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.NTSB DEN91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Collins, COThe loss of directional control by the pilot in command.NTSB DEN89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rangely, COImproper planning/decision by the pilot. The high wind, gusts, the pilot's lack of recent experience, and his lack of familiarity with the aircraft's new handling characteristics were considered to be contributing factors.NTSB DEN84LA267Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Aurora, COPlt stated that following a hard landing, directional control was lost. Acft departed runway and collided with dirt berm.NTSB DEN82DA027Accident · No injuriesFinal reportPiper PA-22 · Trinidad, COThe pilot reported that the aircraft started to veer left as the tail came up during the takeoff roll. He corrected with rudder, but did not maintain directional control. As a ground loop developed, he noted there was insufficient airspeed to lift off and…NTSB DEN79FTE01Accident · No injuriesClosedPiper PA-22 · Olney Springs, CONTSB DEN77DTE83Accident · No injuriesClosedPiper PA-22 · Leadville, CONTSB DEN77FTE44Accident · Serious injuriesClosedPiper PA-22 · Englewood, CONTSB DEN75FTE76Accident · No injuriesClosedPiper PA-20 · Longmont, CONTSB DEN74DTE70Accident · No injuriesClosedPiper PA-22 · Amherst, CONTSB DEN74FTE49Accident · Minor injuriesClosedPiper PA-22 · Kiowa, CONTSB DEN73FTE74Accident · No injuriesClosedPiper PA-22 · Holly, CONTSB DEN72AD052Accident · 4 fatalClosedPiper PA-22 · Hugo, CONTSB DEN72DTE45Accident · Minor injuriesClosedPiper PA-22 · Pagosa Sprgs, CONTSB DEN69D0078Accident · No injuriesClosedPiper PA-22 · Greeley, CONTSB DEN67F0175Accident · No injuriesClosedPiper PA-22 · Greeley, CONTSB DEN67D0063Accident · Minor injuriesClosedPiper PA-22 · Conifer, CONTSB DEN66A0087Accident · 1 fatalClosedPiper PA-22 · Weston, CONTSB DEN66F0247Accident · No injuriesClosedPiper PA-22 · Boulder, CONTSB FTW66D0417Accident · No injuriesClosedPiper PA-22 · Sand Springs, CONTSB DEN65D0067Accident · No injuriesClosedPiper PA-22 · Sheridan Lake, CONTSB DEN65D0022Accident · No injuriesClosedPiper PA22 · Greely, CO