Fatal NTSB investigations: Piper PA-24-250, TX
22 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 | 4 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 2 |
| 1977 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.NTSB CEN20FA023Accident · 3 fatalClass 3 · FieldFinal reportPiper PA24 · San Antonio, TXThe loss of engine power for reason that could not be determined. Contributing to the accident was the pilot’s failure to maintain aircraft control while maneuvering to landing which resulted in an inadvertent stall/spin with insufficient altitude to recover.NTSB CEN15FA287Accident · 2 fatalField investigationFinal reportPiper PA 24-250 · Quinlan, TXThe pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…NTSB CEN12FA164Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Albany, TXThe loss of flight instrumentation due to a failed vacuum pump while flying a night without a discernable horizon, which resulted in the pilot's spatial disorientation and an in-flight loss of control and impact with terrain. Contributing was the continued…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 FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.NTSB FTW80FA063Accident · 2 fatalClosedPiper PA-24 · Texarkana, TXNTSB FTW79FA050Accident · 4 fatalClosedPiper PA-24 · Dallas, TXNTSB FTW78FA017Accident · 3 fatalClosedPiper PA-24 · Kerrville, TXNTSB FTW77FA072Accident · 3 fatalClosedPiper PA-24 · Canyon, TXNTSB FTW73AF025Accident · 3 fatalClosedPiper PA-24 · Quemado, TXNTSB FTW72AF068Accident · 3 fatalClosedPiper PA-24 · Seminole, TXNTSB FTW69A0071Accident · 3 fatalClosedPiper PA-24 · Wolfe City, TXNTSB FTW68A0087Accident · 2 fatalClosedPiper PA-24 · Austin, TXNTSB FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXNTSB FTW68A0063Accident · 1 fatalClosedPiper PA-24 · Manvel, TXNTSB FTW67A0057Accident · 1 fatalClosedPiper PA-24 · Sanderson, TXNTSB FTW66A0079Accident · 2 fatalClosedPiper PA-24 · Brownwood, TXNTSB UNK64X2113Accident · 3 fatalClosedPiper PA24 · Mason, TXNTSB UNK64X1045Accident · 2 fatalClosedPiper PA24 · Mentone, TXNTSB UNK64X0549Accident · 2 fatalClosedPiper PA-24 · Emory, TXNTSB UNK64X0507Accident · 1 fatalClosedPiper PA24 · Dallas, TX