NTSB investigations: Piper PA-24-250, 1990
14 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\") = 1990
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") = 1990
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 CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.NTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.NTSB ATL91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GATotal failure of a connecting rod cap bolt which resulted in a total loss of power.NTSB SEA90FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Salem, ORThe pilot allowed the design stress limits of the aircraft to be exceeded. Factors related to the accident concerned inadvertent flight by the pilot into known adverse weather conditions.NTSB SEA90LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA24-250 · Lagrande, ORThe pilot did not allow the airplane to attain an adequate airspeed prior to the retraction of flaps and landing gear.NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.NTSB ATL90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Concord, NCThe pilot's inadequate preflight planning and preparation, in that he did not fully consider the effects of high obstructions and a poor runway surface condition.NTSB FTW90LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24 · West Fork, ARThe catastrophic failure of the engine.NTSB CHI90LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Millington, MIInadequate planning-decision, failure to obtain lift-off airspeed, and failure to perform an aborted takeoff. Factors related to the accident are the uphill sloping runway, soft turf, high grass, and complacency.NTSB SEA90LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NVFuel exhaustion, due to the pilot's improper check of the fuel with a dipstick before takeoff, which resulted in an inadequate supply of fuel.NTSB DEN90LA148Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Broomfield, COThe failure of the pilot to extend the landing gear for landing. Contributing factors were the pilot diverting his attention from the task at hand and failure to use a checklist.NTSB BFO90LA060Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Newport News, VAFuel exhaustion caused by pilot misjudging the fuel supply. Contributing to the accident was inaccurate fuel gages.NTSB NYC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lyons, NYA worn out brake on the left main gear. Factors related to the accident were: the owner's decision not to repair the left brake after the right brake had a similar failure 4 hours earlier.NTSB DEN90FA092Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Wendover, UTThe pilot's loss of control of the airplane due to spatial disorientation. Contributing factor(s) was: the lack of surface reference while taking off over a sparsely populated area under dark night light conditions.