Fatal NTSB investigations: Piper PA-24-260, TX
8 cases on aircraft the registry lists as Piper PA-24-260. 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
| 1969 | 1 |
|---|---|
| 1972 | 1 |
| 1982 | 2 |
| 1988 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2015 | 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 ('7102406'))
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 ('7102406'))
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 CEN15FA232Accident · 4 fatalField investigationFinal reportPiper PA 24-260 · Spring Branch, TXThe pilot's failure to maintain control during takeoff due to his impairment from marijuana. Contributing to the accident was the pilot’s impaired decision to fly after using a disqualifying drug.NTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.NTSB FTW94FA300Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Tennesse Colony, TXThe pilot's failure to maintain airspeed and the resultant inadvertent stall/spin. A factor was the loss of engine power for undetermined reasons.NTSB FTW88FA085Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Henrietta, TXThe plt was given a pre-flt wx briefing by a fss briefer. He rcvd a full & thorough briefing, except the briefer did not have an opnl wx radar set available. The plt was adzd of a line of thunderstorms (tstms) to the southwest, moving east at 20 KTS. He was…NTSB FTW82FA382Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Paris, TXThe PA-24 had departed rwy 17 at cox field & was climbing at the time of the collision. The plt had reported his intended departure on UNICOM. The AA5B had reported 5 mi sw of the arpt descending through 5,000 ft. for landing. The head-on collision occurred…NTSB FTW82FRG26Accident · 2 fatalFinal reportPiper PA-24-260 · Kingsville, TXOn 3/17/82 a wx briefer advised the pilot all of Texas would be under instrument meteorological conditons on the morningof 3/18/82. There was no record of a flt plan filed by the pilot of N8988P and the departure time from Kingsville could not be determined.…NTSB FTW73AF014Accident · 7 fatalClosedPiper PA-24 · Goldthwaite, TXNTSB FTW70A0038Accident · 5 fatalClosedPiper PA-24 · Bellevue, TX