NTSB investigations: Piper PA-22-160, NC
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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 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 ('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" = '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 ('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 ATL93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Greensboro, NCThe improper flare by the pilot which resulted in a hard landing and ground loop of the aircraft. A factor in the accident was the crosswind at the time of the landing.NTSB ATL90LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Greensboro, NCThe loss of engine power for undetermined reasons.NTSB ATL89LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · China Grove, NCPilot's loss of control during the final approach in that he failed to establish a proper glidepath. The airplane landed short of the runway. During the attempted go-around his improper use of rudder and aileron, following the application of full power,…NTSB IAD76DKM31Accident · No injuriesClosedPiper PA-22 · Whitsett, NCNTSB IAD76AKM06Accident · No injuriesClosedPiper PA-22 · Ashville, NCNTSB IAD75DKM04Accident · Minor injuriesClosedPiper PA-22 · Monroe, NCNTSB IAD71FIJ18Accident · No injuriesClosedPiper PA-22 · Kinston, NCNTSB IAD70D0071Accident · No injuriesClosedPiper PA-22 · Indian Trail, NCNTSB DIA67D0010Accident · No injuriesClosedPiper PA-22 · Aurora, NCNTSB MIA66F0512Accident · No injuriesClosedPiper PA-22 · Franklinton, NCNTSB UNK64X3788Accident · No injuriesClosedPiper PA22 · Southport, NC