NTSB investigations: Piper PA-28-235
26 cases on aircraft the registry lists as Piper PA-28-235, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
| 1984 | 1 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
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 ('7102810')
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\" = 353))
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 ('7102810')
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" = 353))
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 FTW03LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bryson, TXthe pilot's inadequate inflight planning and decision which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane and dark night conditions were contributing factors.NTSB LAX03LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Van Nuys, CAfuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB NYC02LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PAThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.NTSB LAX01LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Carson City, NVThe pilot's incorrect setting of the fuel selector valve during the prelanding checklist to a position between usable tanks, resulting in fuel starvation.NTSB LAX01LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Flagstaff, AZThe loss of engine power during cruise flight for undetermined reasons that resulted in a forced landing in rough terrain.NTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.NTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.NTSB LAX95LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Gilbert, AZThe pilot's fuel system mismanagement and improper emergency procedure. The pilot's misjudging the flare was a factor.NTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.NTSB ANC94LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKFuel starvation from water and/or ice crystals in the fuel system. A factor in the accident was the improper preflight of the fuel sumps by the pilot-in-command.NTSB CHI93LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bloom, KSimproper refueling by a person or persons unknown. A factor was deteriorated fuel.NTSB FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB FTW90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Granbury, TXFuel starvation due to the pilot's disregard for the position of the fuel tank selector.NTSB BFO90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Tappahannock, VAFailure of fixed base operator (FBO) personnel to assure that the fuel tank was free of water, and failure of the pilot to insure that the aircraft was properly preflighted. Soft/marshy terrain in the emergency landing area was a related factor.NTSB ATL89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Somerset, OHThe pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.NTSB LAX89LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Long Beach, CAThe pilot's failure to select the proper fuel tank for an adequate fuel supply for the takoeff.NTSB LAX88LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Lower Lake, CAThe pilot departed NOVAT0, CA with the fuel selector in the right tip tank position. She did not switch the selector to the main tank position. Four miles from Lower Lake, CA the engine lost all power. After the accident, only the right tip tank was found…NTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…NTSB LAX87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · San Luis Obispo, CAAfter take-off, the pilot was flying a downwind departure when the engine quit. The pilot was unable to return to the runway and collided with the terrain a half mile from the airport. Inspection of the engine at the time of the accident found that the main…NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…NTSB SEA84LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Touchet, WAThe acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…NTSB LAX84FA118Accident · No injuriesField investigationFinal reportPiper PA28-235 · Irwindale, CAAccording to the flt instr the eng lost pwr after the stu had completd varous turning maneuvers. He stated that the fuel sel was in the left main position and estimated that there were 18 gals in that tank, 25 gals in the right tank,5 gals in the left tip…NTSB DEN82DA167Accident · Serious injuriesFinal reportPiper PA-28-235 · Englewood, COThe engine quit on downwind and the pilot attempted to land downwind on the runway but crashed off the airport. The fuelselector was found on an auxiliary tank. According to the pilot and other operators of the aircraft, only about three gallons of fuel are…NTSB ANC82DAG35Accident · Minor injuriesFinal reportPiper PA-28-140 · Wasilla, AKPilot had opportunity to refuel and did not. On one flight before accident he successfully made a forced landing due to fuel starvation. He figured he had enough fuel for one more flight. During this flight engine quit and the pilot landed in a ditch…