NTSB investigations: Piper PA-20, 1983
3 cases on aircraft the registry lists as Piper PA-20, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 6 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 7 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ATL84LA012Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Moncks Corner, SCThe plt reported that he landed on rwy 5 with a wind from the north northwest at 8 to 15 KTS. During the landing, he encountered a gust of wind, the acft veered, and subsequently, the right main gear failed.NTSB MKC84LA001Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cedar Rapids, IAThe plt reported that when he landed on rwy 13, the wind was from 170 deg at 10 gusting to 20 KTS. He said that about 30 ft beyond the touchdown point, a gust of wind picked up the right wing & the acft swerved to the right. Subsequently, the left main gear…NTSB CHI83LA320Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mason, MIThe student & instructor plt (CFI) were practicing landings in the student's acft, which was equipped with brakes only on the left side. Reportedly, the student flared high during a landing & the CFI added power to recover. After touchdown, the roll-out was…