NTSB investigations: Piper PA-24-250
26 cases on aircraft the registry lists as Piper PA-24-250, where the first occurrence was “Loss of engine power”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 3 |
| 2007 | 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\" = 350))
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" = 350))
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 LAX07LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Winslow, AZLoss of engine power for undetermined reasons.NTSB DFW05LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Granbury, TXThe loss of engine power due to fuel starvation. Contributing factors were the pilot's inadequate preflight planning/preparation, and the lack of suitable terrain for the forced landing.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 CHI04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Overland Park, KSThe pilot's inadequate fuel calculations and the pilot's improper in-flight decision which resulted in fuel exhaustion. Contributing factors were the trees and the night conditions.NTSB ATL04LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Troy, ALThe certified flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation resulting in a forced landing, in-flight collision with trees and ground.NTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.NTSB MIA02LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hernando, MSThe pilot's operation of the airplane with known deficiencies ( contaminated fuel system) which resulted in fuel starvation, a forced landing to a cotton field, and damage to the airplane during the landing.NTSB FTW02LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Provo, UTthe total loss of engine power for reasons undetermined.NTSB MIA02LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Evans, GAThe pilot's improper fuel management and failure switch to the other fuel tank which had fuel available prior to the engine ceasing to operate, which resulted in fuel starvation and damage to the airplane during an off-airport landing.NTSB MIA02LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAThe pilot’s attempted operation of the aircraft with known deficiencies in the engine ignition system resulting in failure of the engine due to ignition system failure and damage to the airplane during the subsequent forced landing.NTSB LAX01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Petaluma, CAFailure of non-airframe and powerplant mechanic/certificated owners to properly install a new mixture cable that became entangled in the nose landing gear during its extension for landing, resulting in a loss of engine power.NTSB FTW00LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · College Station, TXThe loss of engine power due to fuel system contamination. A factor was the lack of suitable terrain for the forced landing.NTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.NTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.NTSB LAX97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAa loss of engine power for undetermined reasons.NTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.NTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.NTSB BFO94LA107Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Forest Hill, MDThe loss of engine power during for undetermined reasons.NTSB ATL94LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kinston, NCA loss of engine power due to a partial blockage of the induction air system by a foreign object (silicon baffling material).NTSB BFO93LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caribou, MELoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB BFO88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Rock Camp, WVDuring cruise flight in IMC the engine stopped when the plt turned the carb heat to check for carb ice. He was unable to restart the engine. He descended into VMC and tried a forced landing in an open field. The acft struck a tree short of the field. The plt…NTSB NYC86LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Geneseo, NYThe aircraft lost power on approach to Geneseo airport. Investigation did not reveal any preimpact malfunction/failure. Conditions conducive to carburetor icing existed at the time of the accident.NTSB LAX85LA303Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Maria, CAThe pilot reported to the tower, while on base leg, that he was out of fuel. He then landed short and contacted a fence and a tree on the landing roll. The pilot stated that the aircraft contained 45 gallons of fuel when he departed and that he had flown for…NTSB LAX83LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · El Cajon, CAShortly after takeoff, at an altitude of aprx 300 ft AGL, the eng lost power. The plt turned & landed wheels-up on an unimproved grass area on the southwest corner of the arpt. An exam of the eng & fuel systems revealed no evidence of a preimpact/mechanical…NTSB LAX82DA198Accident · No injuriesFinal reportPiper PA-24-250 · Apple Valley, CADuring a flight from saint george, ut to imperial, GA, the pilot encountered fog as he approached el cajon pass, south of Apple Valley, CA. He attempted to go under the fog but was unable. He reversed course and headed back toward Apple Valley. As he was…NTSB CHI82FEG02Accident · Serious injuriesFinal reportPiper PA-24-250 · Pleasant Hill, OHWhile enroute, the pilot elected to climb over the weather rather than fly through it. At about 12,000 ft MSL over the weather, he encountered an engine problem. He initiated emergency procedures and informed dayton approach control of his problem. Unable to…