NTSB investigations: Piper PA-22-150
22 cases on aircraft the registry lists as Piper PA-22-150, where the sequence of events included Nose over/nose down. 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
| 2008 | 2 |
|---|---|
| 2010 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ANC24LA104Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Dillingham, AKThe pilot’s failure to maintain directional control while taxiing in gusting wind conditions.NTSB CEN24LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Dalhart, TXThe total loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat in meteorological conditions conducive to the formation of carburetor icing.NTSB ANC23LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Anchorage, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.NTSB ANC23LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Wasilla, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over after the main landing gear wheels broke through deep snow on the snow-covered runway.NTSB ANC22LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Kasilof, AKThe pilot’s decision to land on an unmaintained runway surface, which resulted in a loss of control and nose over.NTSB ANC21LA093Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Chandalar Shelf, AKA separation of the rudder cable from the rudder pedal due to the connecting bolt detaching for undetermined reasons, which resulted in a loss of directional control.NTSB ANC21LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Willow, AKThe pilots over application of the brakes while landing on a wet grass runway, which resulted in a loss of control and nose-over.NTSB ANC20CA087Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Lake Louise, AKThe pilot’s decision to takeoff in shifting winds from a remote unimproved gravel bar, which resulted in a failure to attain an airspeed suitable for flight and a loss of control.NTSB GAA19CA114Accident · No injuriesData collectionFinal reportPiper PA22 · Anchorage, AKThe student pilot's overcorrection with rudder during the landing and her subsequent failure to maintain directional control, which resulted in a runway excursion, impact with a snowbank, and a nose-over.NTSB ANC19LA011Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Anchorage, AKA loss of engine power due to oil starvation as the result of a loose B-nut fitting on the engine oil cooler, resulting in a forced landing to a soft, snow-covered surface, and a subsequent nose over.NTSB GAA17CA281Accident · No injuriesData collectionFinal reportPiper PA22 · South Boston, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA199Accident · No injuriesData collectionFinal reportPiper PA 22 · Scappoose, ORThe student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.NTSB GAA17CA159Accident · No injuriesData collectionFinal reportPiper PA22 · Big Lake, AKThe contamination of snow and ice on the left main landing gear and brake, which prevented the wheel from rolling during touchdown and resulted in a nose-over.NTSB CEN16LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Houghton Lake Heights, MIThe pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.NTSB WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA192Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Moose Creek Ranger Station, IDThe pilot's use of excessive braking after landing with a tailwind and after an extended touchdown to avoid deer on the runway.NTSB CEN12CA207Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Crowley, LAThe student pilot's improper landing flare, which resulted in a nose-over.NTSB WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.NTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.NTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.NTSB LAX08CA278Accident · No injuriesData collectionFinal reportPiper PA-22 · St. Paul, ORThe pilot's misjudged altitude, speed, and subsequent failure to attain the proper touchdown point while landing.