NTSB investigations: Piper PA-23-250, 1988
18 cases on aircraft the registry lists as Piper PA-23-250. 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 | 28 |
|---|---|
| 1965 | 40 |
| 1966 | 33 |
| 1967 | 41 |
| 1968 | 25 |
| 1969 | 34 |
| 1970 | 33 |
| 1971 | 27 |
| 1972 | 30 |
| 1973 | 32 |
| 1974 | 32 |
| 1975 | 20 |
| 1976 | 27 |
| 1977 | 24 |
| 1978 | 22 |
| 1979 | 29 |
| 1980 | 26 |
| 1981 | 13 |
| 1982 | 22 |
| 1983 | 17 |
| 1984 | 13 |
| 1985 | 20 |
| 1986 | 15 |
| 1987 | 15 |
| 1988 | 18 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 15 |
| 1992 | 9 |
| 1993 | 12 |
| 1994 | 15 |
| 1995 | 17 |
| 1996 | 12 |
| 1997 | 8 |
| 1998 | 8 |
| 1999 | 6 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 12 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 6 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 2 |
| 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308'))
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 BFO89FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Towson, MDAbout 6 min after takeoff, after leveling at 3500 ft, the plt rprtd he was having a probelm that he was unable to figure out. A few minutes later, he repeated the same problem & elected to divert to a nearby arpt. Witnesses rprtd the acft reversed course svrl…NTSB MIA89LA019Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Juan, PRThe pilot noted an explosion in the right wing during engine start. He stated that the aircraft had been 'topped off' prior to the flight. Residue of fuel was found in the wing outside the fuel cells after the explosion.NTSB MIA89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Tupelo, MSThe operator had applied for an on-demand/air taxi cert, but had not obtained approval. After lvl-off on a flt to carry canceled checks, the plt elected to use the remaining fuel fm the inbd tanks. He stated that soon thereafter, the left eng bgn running…NTSB MIA89WA009Accident · 1 fatalForeign investigationPiper PA-23-250 · Missing, BahamasNTSB MIA89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · La Belle, FLThe pilot while on a ferry permit flight experienced a failure of the #4 cyl of the left engine and did not attain the vyse speed and the aircraft started to descend. The pilot ditched the aircraft in a lake and it was not recovered. No records on the engines…NTSB MIA88WA273Accident · Minor injuriesForeign investigationPiper PA-23-250 · Staniel Cay, BahamasNTSB MIA88WA252Accident · 2 fatalForeign investigationPiper PA-23-250 · Gr. Harbor Cay, BahamasNTSB MIA88WA241Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNTSB NYC88LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · East Hampton, NYThe pilot reported that he had experienced a partial power loss on downwind of a VFR traffic pattern. He stated that just after entering downwind he lowered the landing gear. As the speed decreased below 132 knots he advanced the throttles. There was no…NTSB MKC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Springfield, MOWhile attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain…NTSB CHI88FA082Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Alma, MIDrg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…NTSB MKC88FA067Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Excelsior Spgs, MODuring arrival at night, after using fuel from the inboard tanks, the plt switched to the outboard fuel tanks. Shortly, thereafter, both engs lost power. The plt declared an emergency & obtained vectors to the nearest airport, but was unable to reach it.…NTSB ATL88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cleveland, OHThe plt rptd that both engines began to surge shortly after t/o during climb. The engines subsequently lost pwr completely, and the plt made a forced ldg in trees. Post-crash exam revealed that the fuel selectors were in the inbd tank positions. The lt inbd…NTSB ATL88IA096Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Elyria, OHNTSB MIA88WA101Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasNTSB ATL88FA082Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Augusta, GANTSB CHI88FA046Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Carbondale, ILShortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…NTSB NYC88LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic City, NJThe Piper PA-23-250 made an instrument approach to the airport. The pilot said he lowered the landing gear prior to touchdown, however, both propellers struck the runway. The pilot tried to make a go-around and the aircraft started to veer to the left. The…