NTSB investigations: Piper PA-22-160, VA
11 cases on aircraft the registry lists as Piper PA-22-160. 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 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1982 | 1 |
| 1990 | 1 |
| 2016 | 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\" = 'VA' 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 ('7102214'))
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" = 'VA' 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 ('7102214'))
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 ERA16CA239Accident · Serious injuriesData collectionFinal reportPiper PA 22-160 · Harrisonburg, VAThe pilot's loss of directional control during takeoff in gusting crosswind conditions.NTSB BFO90LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lovingston, VAPilot failure to climb out of ground effect because of inadequate airspeed. Factor was unfavorable wind at takeoff.NTSB ATL82DA166Accident · Minor injuriesFinal reportPiper 22-160 · Lynchburg, VAThe pilot took off from newport news, VA on a VFR flight to south boston, VA. Later at dusk, he contacted the roanoke fss and asked for an "accurate fix" of his position. At that time, the pilot indicated that he was low on fuel. Fss personnel reported that…NTSB IAD77DID25Accident · Minor injuriesClosedPiper PA22 · Blackstone, VANTSB IAD77FIJ02Accident · Serious injuriesClosedPiper PA-22 · Woodlawn, VANTSB IAD76AI063Accident · 1 fatalClosedPiper PA-22 · Sperryville, VANTSB IAD74FID38Accident · No injuriesClosedPiper PA-22 · Forest, VANTSB IAD74FIA04Accident · No injuriesClosedPiper PA-22 · Harrisonburg, VANTSB NYC72FID06Accident · Serious injuriesClosedPiper PA-22 · Montvale, VANTSB IAD71DIA06Accident · No injuriesClosedPiper PA-22 · Woodbridge, VANTSB UNK65X1359Accident · Minor injuriesClosedPiper PA22 · Urbana, VA