NTSB investigations: Piper PA-24-260

9 cases on aircraft the registry lists as Piper PA-24-260, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Piper PA-24-260 per year, 1982–2026: 9 cases
1982	1
1989	1
1991	1
1992	1
1994	1
1997	1
1999	1
2001	1
2003	1

Where

Open the map

Latest cases

Query with SQL

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" = 350)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 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 ('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" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX03LA113Accident · No injuriesLimited investigationFinal reportPiper PA24 · Mesa, AZThe flight instructor's delayed remedial action during a go-around, which resulted in an inadvertent touchdown and hard landing. Factors associated with the accident are a momentary loss of engine power, and the inadvertent touchdown.Mar 15, 2003 · N842PS · Substantial damage NTSB LAX01LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Napa, CAThe pilot-in-command's failure to verify the fuel supply before flight, and his improper fuel management, that resulted in fuel starvation and loss of engine power during takeoff climb resulting in a forced landing and collision with ground obstacles.May 6, 2001 · N8710P · Substantial damage NTSB FTW99LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Houston, TXThe pilot's failure to maintain the proper descent rate during a forced landing, which resulted in a runway undershoot. Factors were the total loss of engine power for an undetermined reason and the dusk light conditions.Jul 2, 1999 · N5788 · Substantial damage NTSB SEA97LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sequim, WAThe pilot-in-command's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor was trees in the forced landing area.Apr 14, 1997 · N8645P · Substantial damage 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.Sep 18, 1994 · N9159P · Substantial damage NTSB FTW92LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Hot Springs, ARThe partial loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.Aug 1, 1992 · N8747P · Substantial damage NTSB ATL92LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sanford, NCThe loss of engine power due to unknown reasons.Oct 4, 1991 · N8839P · Substantial damage NTSB ANC89LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Naked Island, AKEngine failure for an unknown reason.Jun 10, 1989 · N9213P · Destroyed NTSB FTW83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · El Paso, TXWhile on a business cross country flight the fuel pressure began dropping with a subsequent drop in power. The pilot attempted to reduce manifold pressure to keep the engine running. Approximately 3-5 miles from El Paso airport the pilot landed on the desert.…Nov 9, 1982 · N8705P · Substantial damage