NTSB investigations: Piper PA-22-150, NE
20 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 | 4 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1993 | 1 |
| 2010 | 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\" = 'NE' 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" = 'NE' 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 CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.NTSB MKC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ashby, NEThe plt stated that he and a passenger were sightseeing when he increased the mixture to full rich, applied carb heat and reduced power for a glide across a valley. When he advanced the throttle to level off the engine did not respond. During the forced…NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…NTSB MKC80FCJ10Accident · No injuriesClosedPiper PA-22 · Lincoln, NENTSB MKC77DCJ15Accident · No injuriesClosedPiper PA-22 · Whitman, NENTSB MKC73DCJ15Accident · No injuriesClosedPiper PA-22 · Ravenna, NENTSB MKC72FCJ36Accident · Minor injuriesClosedPiper PA-22 · Nehawka, NENTSB MKC71FCJ25Accident · Serious injuriesClosedPiper PA-22 · Atkinson, NENTSB MKC71DCJ17Accident · No injuriesClosedPiper PA-22 · Humphrey, NENTSB MKC70D0028Accident · Minor injuriesClosedPiper PA-22 · Madrid, NENTSB MKC69D0352Accident · No injuriesClosedPiper PA-22 · Auburn, NENTSB MKC68F0509Accident · No injuriesClosedPiper PA-22 · Franklin, NENTSB MKC68D0171Accident · No injuriesClosedPiper PA-22 · Wahoo, NENTSB MKC68F0102Accident · No injuriesClosedPiper PA-22 · Newman Grove, NENTSB MKC66F0515Accident · No injuriesClosedPiper PA-22 · Oshkosh, NENTSB UNK65X0986Accident · No injuriesClosedPiper PA22 · Wayne, NENTSB UNK65X0601Accident · No injuriesClosedPiper PA22 · Hastings, NENTSB UNK64X2795Accident · No injuriesClosedPiper PA12 · Gordon, NENTSB UNK64X2308Accident · 1 fatalClosedPiper PA22 · Grant, NE