NTSB investigations: Piper PA-22-150, AR
21 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
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2008 | 1 |
| 2022 | 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\" = 'AR' 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" = 'AR' 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 CEN22LA121Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Furlow, ARA loss of engine power for undetermined reasons.NTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.NTSB FTW00LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Calico Rock, ARthe pilot's inability to maintain airplane control during the landing roll due to the airplane hydroplaning on the wet runway.NTSB FTW98LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Searcy, ARThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the certified flight instructor's inadequate supervision.NTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.NTSB FTW92LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Walnut Ridge, ARThe inadvertent ground loop. A factor was the pilots total lack of experience in type airplane.NTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.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 MKC86LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Wrightsville, ARThe PIC of the PA22 was practicing departures fm a confined field. The PIC stated that the acft engine had been operating normally, and that he had been operating fm this area for about the previous 1/2 hr. The PIC stated the eng quit on climbout fm the pvt…NTSB MKC84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russellville, ARAfter landing, the plt taxied to the tie-down area. While turning into a tiedown postion, the right main gear hit a tire, surrounding a tie-down stake, & the acft nosed over.NTSB FTW81DPG12Accident · Serious injuriesClosedPiper PA-22 · Rogers, ARNTSB FTW75DPG85Accident · No injuriesClosedPiper PA-22 · Van Buren, ARNTSB FTW73FPG49Accident · Minor injuriesClosedPiper PA-22 · Pocahontas, ARNTSB FTW73FPG09Accident · Minor injuriesClosedPiper PA-22 · Arkansas City, ARNTSB FTW71FPG21Accident · No injuriesClosedPiper PA-22 · N Little Rock, ARNTSB FTW69F0239Accident · Minor injuriesClosedPiper PA-22 · Roe, ARNTSB FTW68D0138Accident · No injuriesClosedPiper PA-22 · Wilmot, ARNTSB FTW66D0424Accident · No injuriesClosedPiper PA-22 · Waldo, ARNTSB FTW66F0135Accident · Minor injuriesClosedPiper PA-22 · Mena, ARNTSB UNK64X1483Accident · No injuriesClosedPiper PA22 · Bentonville, ARNTSB UNK64X1321Accident · No injuriesClosedPiper PA22 · Seyppel, AR