NTSB investigations: Piper PA-20-135, 1982
3 cases on aircraft the registry lists as Piper PA-20-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 | 4 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 4 |
| 1969 | 1 |
| 1970 | 3 |
| 1972 | 2 |
| 1973 | 1 |
| 1975 | 2 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 3 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 2 |
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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102010'))
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102010'))
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 MKC83LA043Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lee'S Summit, MOThe student pilot was on a supervised solo flight in a tail wheel equipped aircraft. The instructor pilot was observing from about 300 ft from the touchdown point. He stated that the plane touched down hard, bounced and turned to the left. The right main gear…NTSB DEN82DA105Accident · No injuriesFinal reportPiper PA-20 · Near Rawlins, WYThe pilot stated that he had landed on a blacktop road, but opted to takeoff on a gravel road because of the proximity of reflector posts to the wings. He stepped off the road and estimated that he had about 800 ft for takeoff. The density altitude was about…NTSB ANC82DA021Accident · No injuriesFinal reportPiper PA-20 · Bethel, AKThe pilot was taxiing to the tie-down area when the right ski/landing gear failed. The pilot attributed the failure to age and noted that ice landings are hard on ski equipped aircraft.