NTSB investigations: Piper PA-22, GA
9 cases on aircraft the registry lists as Piper PA-22. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1985 | 1 |
| 1998 | 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\" = 'GA' 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 ('7102202'))
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" = 'GA' 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 ('7102202'))
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 ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.NTSB ATL85FA182Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Cartersville, GAThe circumstances & purpose of the flt was not determined. According to witnesses, the owner/student plt & another psn, who was a certified mechanic & an instructor plt, took off & entered what appeared to be a closed traffic pattern for rwy 18. The traffic…NTSB MIA76DKG22Accident · Minor injuriesClosedPiper PA-22 · Claxton, GANTSB MIA73FKG56Accident · Serious injuriesClosedPiper PA-22 · Peachtree City, GANTSB MIA72FKG55Accident · Minor injuriesClosedPiper PA-22 · Wrens, GANTSB MIA70FKG26Accident · No injuriesClosedPiper PA-22 · Jonesboro, GANTSB MIA68F0367Accident · No injuriesClosedPiper PA-22 · Moultrie, GANTSB MIA66D0219Accident · Minor injuriesClosedPiper PA-22 · Savannah, GANTSB UNK64X1097Accident · Minor injuriesClosedPiper PA22 · Cecil, GA