NTSB investigations: Piper PA-22-135, NC
15 cases on aircraft the registry lists as Piper PA-22-135. 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 | 3 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1984 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2005 | 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 ('7102206'))
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 ('7102206'))
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 ATL05CA146Accident · No injuriesData collectionFinal reportPiper 22 · Archdale, NCThe pilot's failure to maintain directional control during landing roll, which resulted in a nose over.NTSB ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.NTSB ATL84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wilmington, NCWhile the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over.NTSB IAD74DKM55Accident · Serious injuriesClosedPiper PA-22 · Albemarle, NCNTSB NYC73FLJ10Accident · No injuriesClosedPiper PA-22 · Maple Hill, NCNTSB IAD71FLJ23Accident · Minor injuriesClosedPiper PA-22 · Broadway, NCNTSB IAD71DKM25Accident · Minor injuriesClosedPiper PA-22 · Bakersville, NCNTSB IAD70D0107Accident · No injuriesClosedPiper PA-22 · Vale, NCNTSB DIA68D0145Accident · No injuriesClosedPiper PA-22 · Asheville, NCNTSB DIA67F0050Accident · No injuriesClosedPiper PA-22 · Charlotte, NCNTSB MIA66D0446Accident · No injuriesClosedPiper PA-22 · Charlotte, NCNTSB UNK65X0976Accident · Minor injuriesClosedPiper PA22 · Lagrange, NCNTSB UNK65X0860Accident · No injuriesClosedPiper PA22 · Selma, NCNTSB UNK64X2106Accident · Minor injuriesClosedPiper PA-22 · Gibsonville, NC