NTSB investigations: Piper PA-24, 1983
6 cases on aircraft the registry lists as Piper PA-24. 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
| 1962 | 1 |
|---|---|
| 1964 | 34 |
| 1965 | 36 |
| 1966 | 48 |
| 1967 | 31 |
| 1968 | 25 |
| 1969 | 25 |
| 1970 | 13 |
| 1971 | 17 |
| 1972 | 15 |
| 1973 | 13 |
| 1974 | 15 |
| 1975 | 11 |
| 1976 | 6 |
| 1977 | 13 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 5 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 7 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2006 | 1 |
| 2007 | 2 |
| 2009 | 2 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 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 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 ('7102402'))
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 ('7102402'))
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 ATL84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Clemson, SCThe pilot failed to lower the landing gear stating that he was distracted by an acft on the ground & diverted his attention from the landing checklist.NTSB ATL84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Montgomery, ALAccording to the plt he had an unsafe gear indication while in the traffic pattern. He alerted the tower to the problem and made a low pass over the runway. He was informed by tower personnel that the gear looked down and normal. During the landing the plt…NTSB NYC83AA208Accident · 4 fatalFinal reportPiper PA-24-180 · Pomona, NJDuring his wx briefing, the plt was advised of an area of rain showers & scattered thunderstorms along his route of flt, as well as flt precautions for occasional moderate turbulence below 8000 ft which was forcast. He departed norfolk at 1500. At about 1630,…NTSB DEN83FA123Accident · 1 fatalField investigationFinal reportPiper 24-180 · Horse Creek, WYThe acft crashed in rolling terrain minus about 6 ft of its left wing. This portion of wing was found about 339 ft east of the main wreckage. Exam revealed evidence that the outboard portion of the wing separated in an upward and aft direction indicative of…NTSB CHI83LA188Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Platteville, WIDuring arrival, the plt entered the traffic pattern to land on rwy 27 in x-wind conditions. The rwy was 2200 ft long & was wet from light rain. After making 2 go-arounds, a landing was made on the 3rd apch. The plt reported that the braking was poor to nil.…NTSB ATL83FA117Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Hendersonville, NCAfter reporting level at 7,000 ft in rain, the plt reported that altitude could not be maintained due to a power loss. He stated that '...we're down to about fourteen inches and we just broke out and I got the lights.' At 1849, after a discussion with ATC…