NTSB investigations: Piper PA-23, 1984
4 cases on aircraft the registry lists as Piper PA-23. 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 | 24 |
|---|---|
| 1965 | 24 |
| 1966 | 24 |
| 1967 | 21 |
| 1968 | 16 |
| 1969 | 14 |
| 1970 | 15 |
| 1971 | 20 |
| 1972 | 16 |
| 1973 | 16 |
| 1974 | 19 |
| 1975 | 8 |
| 1976 | 12 |
| 1977 | 5 |
| 1978 | 5 |
| 1979 | 11 |
| 1980 | 7 |
| 1981 | 8 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102302'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102302'))
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 CHI84LA408Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Defiance, OHDuring initial takeoff climb at alt of 300 ft AGL, 9 1/4 inches of rt engine prop blade separated. Forced landing was make in field during which time the rt wing contacted a tree. Metallurgical examination revealed progressive fatigue over 75% of the…NTSB NYC84LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23 · No. Andover, MAThe acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…NTSB DEN84FA148Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Parker, COAccording to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…NTSB NYC84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Lawrence, MAAs the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the…