NTSB investigations: Piper PA-22-108, VA
15 cases on aircraft the registry lists as Piper PA-22-108. 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 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2006 | 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 ('7102204'))
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 ('7102204'))
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 NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.NTSB NYC02LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Roanoke, VAThe failure of the pilot ensure the proper position of the fuel selector which resulted in fuel starvation. Factors were the improper placement of the fuel selector valve tank index, and the improper in-flight decision of the pilot to change tanks in…NTSB NYC99LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Manassas, VAThe pilot's failure to recover from a sideslip maneuver, and flare the airplane before touchdown.NTSB NYC99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Isle Of Wight, VAThe improper visual inspection of overhauled engine components by maintenance personnel.NTSB IAD79DKM01Accident · No injuriesClosedPiper PA-22 · Port Royal, VANTSB IAD78FID22Accident · Minor injuriesClosedPiper PA-22 · Danville, VANTSB IAD75FID17Accident · Serious injuriesClosedPiper PA-22 · Cape Charles, VANTSB IAD73DID21Accident · No injuriesClosedPiper PA-22 · Chesapeake, VANTSB IAD71DID22Accident · No injuriesClosedPiper PA-22 · Monterey, VANTSB DIA69D0169Accident · Minor injuriesClosedPiper PA-22 · Bowers Hill, VANTSB DIA69A0006Accident · 2 fatalClosedPiper PA-22 · Chesapeake, VANTSB NYC66F0395Accident · No injuriesClosedPiper PA-24 · Lunenburg, VANTSB NYC66F0216Accident · No injuriesClosedPiper PA-22 · West Point, VANTSB UNK65X0394Accident · No injuriesClosedPiper PA22 · Roanoke, VANTSB UNK64X0593Accident · 1 fatalClosedPiper PA22 · Sandston, VA