NTSB investigations: Piper PA-23-250, 1986
15 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\") = 1986
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") = 1986
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 MIA87LA026Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLWhile being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated…NTSB CHI87DEE02Accident · No injuriesFinal reportPiper PA-23-250 · Crestwood, ILThe aircraft was flown without authorization from the owner by unknown person(s). Upon landing, directional control was lost. The aircraft skidded off the runway into an aircraft tie-down area and collided with a parked aircraft.NTSB ATL86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Montgomery, ALDuring initial climb phase of an experimental flt from mgm, AL, the plt rpted that the left engine had failed and an attempt was made to feather the prop. The plt radioed dannelly tower that the acft was returning to the arpt. Then the plt rpted that the…NTSB DEN86LA239Accident · No injuriesLimited investigationFinal reportPiper PA-23E-250 · Grand Forks, NDThe acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear…NTSB ATL86LA224Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Wadsworth, OHDuring the landing roll on rwy 02, the pilot lost directional control and the acft veered off the right side of the runway. The reported winds were 290 degrees at 8 knots. The wreckage examination failed to disclose any malfunction or failure. The acft brake…NTSB MIA86LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft.Lauderdale, FLFlt experienced loss of power in the left engine shortly after takeoff due to corrosion blocking the main jet in the fuel control unit. The pilot feathered the engine and returned for a landing. While on short final he remembered he would have to manually…NTSB MKC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Norfolk, NEA fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…NTSB BFO86LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Mt. Holly, VAThe nose gear was sheared off when the acft contacted a ditch during an overrun landing. Upon arriving at the pvt airstrip the plt circled the rwy and decided it was suitable for landing. Touchdown was made 400 ft down the rwy and normal deceleration was…NTSB FTW86LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Rio Hondo, TXThe right eng failed during cruise flt and the plt was unsuccessful in his attempt to restart the eng. The acft was unable to maintain alt and impacted the ground resulting in substantial damage to the acft. Although there was no evidence of any…NTSB LAX86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mesa, AZThe pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading.NTSB LAX86FA167Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Mesa, AZWhile on the fourth leg of an IFR business flight from stow, Ohio to santa paula, California, the airplane experienced fuel exhaustion and crashed about 1 1/2 miles northeast of falcon field (ffz), Mesa, Arizona. The flight was being conducted under the…NTSB MIA86FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Osteen, FLBefore the flt, the plt & pax were observed drinking alcoholic beverages on the way to the arpt. After much difficulty taxiing to the rwy, the flt was cleared for takeoff after entering the active rwy without clearance. After taking off, the acft was seen…NTSB MIA86LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Pierce, FLThe plt stated that while switching tanks, his fuel selector froze up & both eng's failed. Upon landing, the acft struck a tree severing a wing. The NTSB form 6120.1 that was sent to the plt was returned, it stated that the addressee moved & left no address.…NTSB LAX86LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Francisco, CAOn feb 9, 1986 at 1717 PST a Piper PA-23, N5300Y, ditched approximately 460 NM sw of sfo, CA. The flt originated from hnl, HI. In flt fuel leak was discovered after 7 hrs of flight. Fuel vapors were seen contrailing off both wings. The plt attempted to…NTSB ATL86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Rural Retreat, VAPilot said first adf approach terminated by missed approach due to oscillating directional needle. On second approach acft broke out of clouds with trees in front of acft. It impacted a cloud obscured ridge 3.5 miles southeast of airport on a southerly…