NTSB investigations: Piper PA-23-250, 1987
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\") = 1987
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") = 1987
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 MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.NTSB MIA88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Miami, FLPlt stated that shortly after starting the left engine he heard an explosion and saw flame spreading from the accessory area of the left engine toward the left wing tip and the cabin. He shut down the engine by turning off the magnetos and he and his…NTSB FTW88LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Brownsville, TXDuring initial climb into IFR conditions, the non-multiengine, non-instrument rated mexican certificated private pilot diverted his attention from flying the aircraft to adjust the mixture control on the left engine. The aircraft impacted the ground and…NTSB MIA88FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · St. ThomasAfter departure, aprx 3 miles west of the arpt at St. Thomas, the plt reported to the tower that the flt was returning to land due to a loss of power from the left eng. He secured it, returned to land, & on short final, positioned the landing gear selector…NTSB MIA88FA001Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Everglades City, FLThe non-instrument rated plt attempted a VFR flt over the Everglades during the hrs of darkness. The acft crashed into a swampy area at a high rate of speed while in a 90 degree left bank. The acft disintegrated on impact. A convective SIGMET was issued about…NTSB FTW87LA200Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mc Allen, TXThe right main landing gear collapsed for unknown reasons as the aircraft was taxiing for takeoff. The pilot has not responded to requests to complete an accident report form. According to airman records, the pilot did not have a multiengine rating.NTSB FTW87FA184Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Imperial, TXAfter takeoff, the plt elected to fly low over a reservoir. He stated that as he began a pass, not FAR from the water's edge, the acft enctrd a sink. He said he ' . . . Checked power, all ok, plane just seemed to lose all lift . . .' Subsequently, the acft…NTSB NYC87LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Sandy Creek, NYThe pilot of the PA-23-250 attempted a takeoff on a 2200 ft long private airstrip with a grass runway. Witnesses reported the aircraft was airborne further down the runway than normal. The aircraft did not clear the trees on the departure end of the runway.…NTSB MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…NTSB NYC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Portland, METhe pilot of the PA-23 was attempting an NDB approach into the Portland, ME. Int'l jetport. The wx was rpt'd as moderate turbulence and moderate or greater icing, the icing level was rpt'd from the surface to 16000 ft. prior to this NDB approach the pilot had…NTSB NYC87LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Nantucket, MAThe Piper PA-23-250 attempted a go-around after crossing the threshold and observing the runway lights were not on during a night instrument approach. The pilot reported that he added full power and retracted the wing flaps. The procedure in the Piper manual…NTSB BFO87LA028Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Dover, DEThe rockwell was in level flight at 2800 ft and the Piper was climbing when midair collision occurred. Neither acft was operating under ATC. Neither plt saw the otr acft before the collision occurred. The bottom of the rockwell cabin and the left tiptank of…NTSB LAX87LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Chandler, AZWhile clbg fm a go-arnd at abt 400' AGL, the instructor (CFI) shut dwn the l eng by closing the mixture & the student (pvt plt) feathered the left prop. The CFI then moved the prop ctl out of the feather psn, but the prop rmnd feathered. The CFI was unable to…NTSB FTW87LA075Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · George West, TXAircraft collided with power lines during forced landing due to fuel exhaustion. Owner has not responded to letters. Warrant was issued for arrest of person thought to be pilot. Aircraft had traces of marijuana on board.NTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…