NTSB investigations: Piper PA-24-250, 1987
16 cases on aircraft the registry lists as Piper PA-24-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 | 152 |
|---|---|
| 1965 | 130 |
| 1966 | 124 |
| 1967 | 137 |
| 1968 | 63 |
| 1969 | 60 |
| 1970 | 52 |
| 1971 | 55 |
| 1972 | 54 |
| 1973 | 43 |
| 1974 | 41 |
| 1975 | 36 |
| 1976 | 34 |
| 1977 | 43 |
| 1978 | 27 |
| 1979 | 24 |
| 1980 | 25 |
| 1981 | 16 |
| 1982 | 19 |
| 1983 | 13 |
| 1984 | 11 |
| 1985 | 19 |
| 1986 | 8 |
| 1987 | 16 |
| 1988 | 15 |
| 1989 | 14 |
| 1990 | 14 |
| 1991 | 15 |
| 1992 | 4 |
| 1993 | 12 |
| 1994 | 15 |
| 1995 | 8 |
| 1996 | 13 |
| 1997 | 14 |
| 1998 | 3 |
| 1999 | 13 |
| 2000 | 7 |
| 2001 | 13 |
| 2002 | 10 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 6 |
| 2006 | 8 |
| 2007 | 8 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 4 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 5 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 10 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 8 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 8 |
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 ('7102404'))
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 ('7102404'))
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 ATL88FA040Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Lewisburg, KYThe pilot experienced a loss of engine power at 5500 feet. He was not able to start the engine after completing an emergency procedure. The pilot established an approach to a landing area, and stalled the aircraft on short final. The aircraft moved about 30…NTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…NTSB LAX88FA028Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Buttonwillow, CAA Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…NTSB MKC87LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Osage Beach, MOWhile performing as PIC during a biennial flt review, the CFI requested that the owner perform a short fld lndg using full flaps in cross wind conditions. The acft struck the terrain 50 feet short of the rwy and bounced onto the approach end of it. The CFI…NTSB FTW87LA193Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Midland, TXThe right main landing gear collapsed during the landing roll resulting in the loss of directional control. The acft sustained substantial damage to the right wing assembly and the right main landing gear assembly. The acft was being moved to Midland airpark…NTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…NTSB ATL87LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · St Marys, GAAfter returning fm a local ngt flt, the acft was lndd gear up when the lndg gear did not extend. The acft bgn burning after it came to rest. It was extensively damaged by fire & the cause of the gear malfunction was not determined. Local police, who responded…NTSB FTW87FA161Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · El Paso, TXEscaping hot exhaust gas from the broken exhaust manifold melted the sealant from several areas of the firewall where hoses, wires, etc., pass through to the cocipit area. Heavy black smoke produced by smoldering wire insulation, fire shield material, etc.,…NTSB MIA87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kissimmee, FLThe plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative.NTSB DEN87LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monticello, UTThe plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…NTSB ATL87LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Pinehurst, NCThe pilot called approach control and reported he was out of fuel and didn't think he was going to make the airport. He had landed at an airport enroute but had not refueled. He stated that he started descending when he got within ten miles of the airport. He…NTSB LAX87LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Catalina, CAJust after takeoff, the plt stated that he heard a loud bang. The acft began to vibrate severely with the engine developing partial power. The acft would not climb and the plt was able to maintain 100 fpm descent. Unable to return to the arpt, the plt ditched…NTSB LAX87FA149Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Jamestown, CADuring the night cross country flt, the accident acft, in company with 2 others, was trying to land at the dest airport in hilly terrain. As the 3 acft approached the airport they encountered bkn to ovrcst conditions of about 400 ft AGL and vis of 2 mi in…NTSB MIA87LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Meridian, MSThe pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and…NTSB MIA87LA104Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Navarre, FLShortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…NTSB MKC87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kimball, NEThe PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted…