NTSB investigations: Piper PA-24-250, 1988
15 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\") = 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 ('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") = 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 ('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 DEN89FA045Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elephant Butte, NMDuring a return flight from having maintenance performed on the acft the plt executed a low pass by his home which was located on a point of land overlooking Elephant Butte reservoir, NM. During the maneuver while in a steep turn the left wing struck the…NTSB DEN89LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COThe student plt was practicing a touch and go landing. During a turn to final, the plt heard an acft report final for a straight in. He said he became distracted and failed to extend the landing gear. The acft landed with the gear up and slid 500 feet, coming…NTSB MKC89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jacksonville, ARDuring a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.…NTSB MIA89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile in cruise flt near an arpt, the prop separated. Plt was given vectors to arpt & entered pattern for lndg. Downwind leg was extended due to strong tailwind. Strong headwind on final caused acft to land short. During landing roll acft collided with two…NTSB ATL89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Mill, SCTwo days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…NTSB BFO89LA011Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Port Royal, VAThe plt received a wx briefing which forecast IFR after 1800 EST. He departed dca in light drizzle conditions. Arpx 35 NM from dca, radar service was terminated and the plt attempted to contact ATC to no avail. He reported that near the brook VOR the VOR…NTSB CHI89LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Indianapolis, INShortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive…NTSB ATL89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monroeville, ALAccording to the plt, he had requested the acft be fully svcd with fuel before takeoff; however, he did not visually check the fuel. He rprtd that after takeoff, he had flown about 50 min when he noted the rgt tank, which he was using, indcd empty. He said he…NTSB LAX88FA319Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Springville, CAPilot used poor judgement in executing the second low pass and failed to follow normal v.f.r. go-around procedures. Contributing to this accident was the pilot's failure to maintain flying speed during the rapid pitch-up maneuver.NTSB LAX88LA267Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chico, CADuring a cross country flight, the pilot noted a loss of oil pressure. Shortly after, the pilot heard a loud bang and the engine lost power. A forced landing was made short of the airport where the airplane collided with the terrain during the landing roll.…NTSB CHI88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mattoon, ILUpon return from a local aerial photography flight, the pilot failed to ensure that the aircraft landing gear was extended, down and locked. When the aircraft touched down, the gear was only extended approximately 10%; it collapsed fully when it contacted the…NTSB NYC88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blairstown, NJThe flight was on final for runway 7 following another airplane, when the pilot's attention was drawn to a glider maneuvering in the area. He yielded left to maintain a comfortable distance from the glider and failed to observe an antenna tower in his path.…NTSB NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…NTSB BFO88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Rock Camp, WVDuring cruise flight in IMC the engine stopped when the plt turned the carb heat to check for carb ice. He was unable to restart the engine. He descended into VMC and tried a forced landing in an open field. The acft struck a tree short of the field. The plt…NTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.