NTSB investigations: Piper PA-24-250
17 cases on aircraft the registry lists as Piper PA-24-250, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 ATL03FA041Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Florence, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. A factors was dark night and clouds.NTSB MIA02FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Micanopy, FLThe pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.NTSB NYC00FA245Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Lexington, VAThe pilot's attempted VFR flight into instrument meteorological conditions that resulted in spatial disorientation. A factor in this accident was the pilot's inadequate preflight planning.NTSB MIA99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearwater, FLThe delay by the pilot-in-command (CFI) to take control of the airplane and inadvertent stall/mush resulting in the uncontrolled descent and impact with the runway.NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).NTSB MIA96FA115Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Lakeland, FLthe pilot's failure to maintain airspeed (Vs) while turning on approach from base to final resulting in an inadvertent stall.NTSB FTW94FA065Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Ratcliff, TXThe pilot failed to maintain control of the airplane and allowed it to exceed its design stress limits, which resulted in overload failure of the stabilators and right outboard wing section.NTSB BFO93FA189Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Akron, OHContinued flight by the pilot to an altitude that was not appropriate without supplemental oxygen, which resulted in a loss of aircraft control due to hypoxia and subsequently exceeding the design stress limits of the aircraft. Factors related to the accident…NTSB ATL93FA162Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Boone, NCThe pilot's improper preflight planning, his failure to retract the landing gear after departure, and his failure to maintain control of the aircraft. Factors in the accident were the high density altitude, and the mountainous terrain.NTSB LAX91LA304Accident · 1 fatalLimited investigationFinal reportPiper PA24-250 · Temple Bar, AZThe pilot's failure to maintain control of the aircraft during an attempted return to runway maneuver and the entry into an inadvertent stall/spin at low altitude. The exact nature of the emergency problem encountered by the pilot is undetermined.NTSB MIA91FA155Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Long Boat Key, FLAn inflight loss of control and subsequent collision with the water for unknown reasons.NTSB NYC91FA136Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Ravenna, OHFailure of the instructor pilot (CFI) to assure that adequate airspeed was maintained, after maneuvering (turning) for spacing behind another aircraft, which resulted in an inadvertent stall/mush. Factors related to the accident were: the improperly planned…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.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 CHI85LA372Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Washington, ILThe plt attempted to takeoff on the 1800 ft long grass airstrip with 3 passengers on board. A 90 deg, 12 kt x-wind was present and the OAT was 91 deg f. after liftoff, the acft settled back on the airstrip and continued off the end into a bean fld where the…NTSB CHI84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Norwalk, OHThe acft made a hard landing while on a cross-country flt. The plt stated that he encountered turbulence below 3000 ft MSL. During the he encountered wind shear which caused him to drop 40 ft onto the rwy. The acft manual states that 'in high wind conditions…NTSB LAX83LA421Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Clearlake, CADuring arrival, the plt made an apch to rwy 30 at night in calm wind conditions. He reported that on final apch, he allowed the airspeed to get low & the acft stalled and struck the ground approximately 300 feet short of the rwy. The rwy was equipped with…