NTSB investigations: Piper PA-24-250, 1999
13 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\") = 1999
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") = 1999
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 SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.NTSB FTW00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oklahoma City, OKThe failure of the pilot to follow the landing checklist and verify that the landing gear was down and locked, which resulted in a wheels up landing. A factor was the failure of the landing gear locking mechanism for an undetermined reason.NTSB SEA00LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bozeman, MTThe pilot-in-command's (CFI) failure to take remedial action. Factors include the private pilot letting the airspeed get too low.NTSB DEN00LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · La Junta, COThe pilot-in-command's failure to maintain a proper altitude during final approach to landing, and his misjudgment of altitude clearances. Factors were the sudden windshift, downdraft and turbulent weather conditions, the dark night, and the pilot's lack of…NTSB MIA99LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · St. Petersburg, FLthe pilots improper use of the hand brake during the landing roll out and his failure to maintain directional control, which resulted in the airplane exiting the runway and incurring substantial damage.NTSB MIA99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Naples, FLThe pilot's failure to perform manual gear extension procedures with a suspected unsafe landing gear indication which resulted in a collapse of the main landing gear on landing rollout. A factor in the accident was the pilot's lack of total experience in kind…NTSB NYC99LA189Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Greencastle, PAThe pilot's misjudgement of speed and distance during the approach and his failure to perform a go around.NTSB CHI99FA223Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Fertile, MNthe inadvertent stall. Factors relating to this accident were the instructor pilot maneuvering the airplane at very low altitude and the trees.NTSB SEA99LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Plentywood, MTThe pilot's failure to ensure that the landing gear were properly down and locked for landing.NTSB ATL99LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Southern Pines, NCA failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.NTSB MIA99LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Everglades City, FLThe failure of the PIC to maintain directional control on takeoff roll following a loss of power brought about by fuel starvation due to the PIC's failure to verify the proper setting of the fuel selector valve, and the subsequent collision with trees during…NTSB FTW99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Denton, TXThe hard landing as a result of the pilot's failure to maintain the proper descent rate during the landing flare.NTSB ATL99LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Colbert, GAInadequate planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.