NTSB investigations: Piper PA-24-250, UT
21 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2008 | 2 |
| 2019 | 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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
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" = 'UT' AND c."eventCountry" = 'USA'
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 WPR19LA239Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Wendover, UTFailure of the landing gear solenoid, which resulted in failure of the landing gear position switch, and the pilot's subsequent inability to extend the gear using the manual emergency extension system for undetermined reasons.NTSB SEA08CA152Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Vernal, UTThe pilot's failure to verify the airplane's fuel quantity during his preflight, resulting in fuel exhaustion. Contributing to the accident was the presence of a vehicle on the road where the pilot executed his forced landing.NTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.NTSB DEN05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTthe loss of engine power due to carburetor icing. Contributing factors include the weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced landing.NTSB DEN04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTfracture and subsequent total failure of the nose gear strut. A contributing factor was the pilot not being able to control the airplane.NTSB FTW02LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Provo, UTthe total loss of engine power for reasons undetermined.NTSB DEN01FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Antimony, UTthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his VFR flight into IMC, lack of instrument certification, spatial disorientation, low ceiling, and snow.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 DEN87LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monticello, UTThe plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…NTSB DEN85LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearfield, UTThe plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft…NTSB DEN79FA029Accident · 2 fatalClosedPiper PA-24 · Corinne, UTNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNTSB DEN73FTM18Accident · No injuriesClosedPiper PA-24 · Bountiful, UTNTSB DEN70D0033Accident · No injuriesClosedPiper PA-24 · Cedar City, UTNTSB DEN68A0037Accident · 3 fatalClosedPiper PA-24 · Fry Canyon, UTNTSB DEN68F0067Accident · No injuriesClosedPiper PA-24 · Salt Lake City, UTNTSB DEN67A0028Accident · 4 fatalClosedPiper PA-24 · Alton, UTNTSB DEN67D0028Accident · No injuriesClosedPiper PA-24 · Coalville, UTNTSB DEN66A0063Accident · No injuriesClosedPiper PA-24 · Hanksville, UTNTSB DEN66D0042Accident · No injuriesClosedPiper PA-24 · Panguitch, UTNTSB UNK64X2845Accident · No injuriesClosedPiper PA24 · Vernon, UT