NTSB investigations: Piper PA-22, NC
15 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 |
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2020 | 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\" = 'NC' 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" = 'NC' 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 ERA20CA251Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 22 · Fuquay Varina, NCThe pilot's failure to attain a proper approach speed, which resulted in an overrun of the wet grass runway.NTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.NTSB ATL98LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Bern, NCThe failure of the inner cable of the carburetor heat cable assembly that prevented the application of carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB ATL94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22\20 · Kill Devil Hill, NCThe pilot's failure to adequately compensate for the crosswind condition during a landing rollout.NTSB IAD77FKM11Accident · Serious injuriesClosedPiper PA-22 · Kernersville, NCNTSB IAD76DKM27Accident · No injuriesClosedPiper PA-22 · Whitsett, NCNTSB IAD74DKM45Accident · No injuriesClosedPiper PA-22 · High Point, NCNTSB IAD74DLJ14Accident · No injuriesClosedPiper PA-22 · Burlington, NCNTSB IAD71FLJ22Accident · No injuriesClosedPiper PA-22 · Apex, NCNTSB IAD71DKM26Accident · No injuriesClosedPiper PA-22 · Statesville, NCNTSB IAD70D0055Accident · No injuriesClosedPiper PA-22 · Advance, NCNTSB DIA69F0115Accident · 1 fatalClosedPiper PA-22 · Franklin, NCNTSB MIA66F0546Accident · No injuriesClosedPiper PA-22 · Trinity, NCNTSB MIA65F0020Accident · No injuriesClosedPiper PA-22 · Whitsett, NCNTSB UNK64X3066Accident · No injuriesClosedPiper PA22 · Liberty, NC