Skip to content

NTSB investigations: Piper PA-24-250, AR

24 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

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."eventStateOrRegion" = 'AR' 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

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\" = 'AR' 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" = 'AR' 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

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 CEN25LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Bentonville, ARThe pilots’ mismanagement of the available fuel, which resulted in a loss of engine power due to fuel starvation.Jan 16, 2025 · N6799P · Substantial damage NTSB DEN08CA144Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Pine Bluff, ARLanding gear collapse for reasons undetermined.Aug 13, 2008 · N6265P · Destroyed NTSB FTW97LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ward, ARThe loss of engine power resulting from fuel starvation due to the pilot's mismanagement of available fuel. A factor was the lack of suitable terrain for a forced landing.May 26, 1997 · N7967P · Substantial damage NTSB FTW90LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24 · West Fork, ARThe catastrophic failure of the engine.Jul 23, 1990 · N7202P · Substantial damage NTSB MKC89FA110Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Winslow, ARThe pilot flying into adverse weather conditions which resulted in the in-flight separation of a portion of the right wing. Contributing to the accident was the pilot's lack of total experience.May 15, 1989 · N8199P · Destroyed NTSB MKC89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jacksonville, ARDuring a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.…Dec 10, 1988 · N8356P · Substantial damage NTSB FTW82DA037Accident · Serious injuriesFinal reportPiper PA-24-250 · Lonoke, ARThe pilot stated that the engine failed at 2000 ft as he was descending for an approach. He switched the fuel selector from the right tank to the left tank, turned on the boost pump, and pumped the throttle but the engine failed to start. The aircraft landed…Jan 5, 1982 · N5304P · Substantial damage NTSB FTW80FA126Accident · 4 fatalClosedPiper PA-24 · Hot Springs, ARSep 29, 1980 · N7839P · Destroyed NTSB FTW78DPG82Accident · No injuriesClosedPiper PA-24 · Clarksville, ARAug 28, 1978 · N7338P · Substantial damage NTSB FTW78FPG05Accident · No injuriesClosedPiper PA-24 · Booneville, ARNov 5, 1977 · N5581P · Substantial damage NTSB FTW77FPG60Accident · No injuriesClosedPiper PA-24 · Russellville, ARJul 2, 1977 · N7757P · Substantial damage NTSB FTW76AF067Accident · 1 fatalClosedPiper PA-24 · Mena, ARFeb 20, 1976 · N6396P · Destroyed NTSB FTW76FPG26Accident · No injuriesClosedPiper PA-24 · Guy, ARSep 23, 1975 · N6514P · Substantial damage NTSB FTW70F0288Accident · No injuriesClosedPiper PA-24 · Little Rock, ARNov 2, 1969 · N7994P · Substantial damage NTSB FTW68F0432Accident · No injuriesClosedPiper PA-24 · Hindsville, ARDec 2, 1967 · N8091P · Substantial damage NTSB FTW67D0105Accident · No injuriesClosedPiper PA-24 · Keo, ARJul 21, 1966 · N6048P · Substantial damage NTSB FTW66F0561Accident · No injuriesClosedPiper PA-24 · Manila, ARMar 19, 1966 · N7901P · Substantial damage NTSB FTW66D0560Accident · No injuriesClosedPiper PA-24 · Mena, ARMar 17, 1966 · N7153P · Substantial damage NTSB FTW66D0503Accident · No injuriesClosedPiper PA-24 · Fordyce, ARFeb 3, 1966 · N8024P · Substantial damage NTSB FTW66A0014Accident · 1 fatalClosedPiper PA-24 · Mcalmont, ARAug 9, 1965 · N6643P · Destroyed NTSB UNK65X1254Accident · No injuriesClosedPiper PA24 · Little Rock, ARJan 8, 1965 · N6125P · Substantial damage NTSB UNK64X2732Accident · No injuriesClosedPiper PA24 · Lake Village, ARJul 9, 1964 · N8312P · Substantial damage NTSB UNK64X2459Accident · No injuriesClosedPiper PA24 · Heber Spgs, ARJun 24, 1964 · N5547P · Substantial damage NTSB UNK64X0345Accident · Minor injuriesClosedPiper PA24 · Pine Bluff, ARJan 25, 1964 · N7989P · Substantial damage