NTSB investigations: Piper PA-24-250, 1986
8 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\") = 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 ('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") = 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 ('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 DEN87FA046Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Leyba, NMThe plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased…NTSB MKC87LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Seward, NEThe plt reports that he was landing on his private grass strip which is 1600 x 60 ft. he said the grass on the edges was thicker then that in the middle. During landing roll the acft drifted to the lt and the lt wing collided with milo growing along the lt…NTSB NYC86LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Geneseo, NYThe aircraft lost power on approach to Geneseo airport. Investigation did not reveal any preimpact malfunction/failure. Conditions conducive to carburetor icing existed at the time of the accident.NTSB MIA86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was…NTSB CHI86FA194Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Oshkosh, WIThe aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at…NTSB ATL86LA177Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Chester, OHDrg flt, the eng lost power & the plt was unable to maintain alt. He made a forced landing on a road, but drg the lndg roll, the acft collided with a road sign. A post crash exam of the eng revealed the #6 cylinder had separated aprx 4' above the cylinder…NTSB SEA86LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fallon, NVWhile on final apch to the arpt, the acft's eng ceased operating due to fuel exhaustion. The acft was damaged during a hard forced landing on a baseball fld.NTSB DEN86FA098Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Truth&Consequen, NMThe plt took off on a night IFR flt after being briefed on adverse wx which included severe turbulence and moderate mixed icing conditions. The acft was not equipped for flt in icing conditions. Radio and radar contact with the flt was lost in the vicinity of…