NTSB investigations: Piper PA-24-260
8 cases on aircraft the registry lists as Piper PA-24-260, 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
| 1986 | 1 |
|---|---|
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2006 | 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 ('7102406')
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 ('7102406')
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 CHI07FA041Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Bucyrus, OHThe inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…NTSB FTW00FA035Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · New Orleans, LAthe pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.NTSB SEA97FA044Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Winston, MTPilot incapacitation due to hypoxia. Failure of the pilot to use available oxygen is a factor.NTSB FTW94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Roswell, NMThe loss of control due to clear air turbulence.NTSB NYC93LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's inadequate preflight preparation by failing to properly set the stabilator trim tab.NTSB SEA92FA147Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Woods Cross, UTPilot factor in that he failed to attain and maintain sufficient flying speed. Factors to the accident were: cylinder over temperature, improper use of the mixture and procedures/directives were not followed.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 NYC86FA214Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Ft. Dix, NJThe acft was headed sw on victor sixteen inbound to coyle VOR when the plt reported the loss of gyro instruments. The acft was at 6000 ft and in 'solid IFR weather.' The plt elected not to declare emergency and land when asked if he wanted to do so by ATC.…