Skip to content

NTSB investigations: Piper PA-24-250, IN

31 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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN26LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.Mar 21, 2026 · N7548P · Substantial damage NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.Dec 13, 2018 · N6785P · Destroyed NTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.Mar 21, 2018 · N6785P · Substantial damage NTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…Mar 26, 2016 · N8154P · Substantial damage NTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…Apr 19, 2010 · N5425P · Destroyed NTSB CHI90DET01Accident · No injuriesFinal reportPiper PA-24-250 · Decatur, INThe pilot's misjudgement of the fuel supply, inaccurate fuel consumption calculations, and his improper in-flight planning/decision, which resulted in fuel exhaustion. The lack of suitable terrain for an emergency landing was a related factor.Nov 23, 1989 · N5483P · Substantial damage NTSB CHI89LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Indianapolis, INShortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive…Oct 21, 1988 · N7733P · Substantial damage NTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.Jan 5, 1988 · N6487P · Destroyed NTSB CHI82DA240Accident · No injuriesFinal reportPiper PA-24-250 · Lafayette, INDuring arrival, the pilot was unable to extend the gear by using the normal (electrical) system or the manual emergency handle. After repeated attempts to correct the malfunction, he elected to land with the gear up.Jul 7, 1982 · N8103P · Substantial damage NTSB CHI78FEX14Accident · No injuriesClosedPiper PA-24 · Greenwood, INApr 24, 1978 · N7429P · Substantial damage NTSB CHI78FA005Accident · 4 fatalClosedBeech P35 · Francesville, INOct 30, 1977 · N1555S · 2 aircraft · Destroyed NTSB CHI75FET03Accident · No injuriesClosedPiper PA-24 · Valparaiso, INJul 3, 1974 · N7652P · Substantial damage NTSB CHI73FEA28Accident · No injuriesClosedPiper PA-24 · Jeffersonvlle, INMar 21, 1973 · N8263P · Substantial damage NTSB CHI73AC012Accident · 3 fatalClosedPiper PA-24 · Nappanee, INAug 7, 1972 · N6378P · Destroyed NTSB CHI73AC004Accident · 4 fatalClosedPiper PA-24 · Kewanna, INJul 15, 1972 · N5491P · Destroyed NTSB CHI70F0324Accident · No injuriesClosedPiper PA-24 · Mccordsville, INOct 29, 1969 · N5302P · Substantial damage NTSB CHI70F0249Accident · No injuriesClosedPiper PA-24 · Putnamville, INSep 27, 1969 · N7570P · Substantial damage NTSB CHI69D0576Accident · No injuriesClosedPiper PA-24 · Greenwood, INApr 13, 1969 · N7167P · Substantial damage NTSB CHI69F0307Accident · No injuriesClosedPiper PA-24 · Muncie, INOct 5, 1968 · N8001P · Substantial damage NTSB CHI67A0136Accident · 3 fatalClosedPiper PA-24 · Madison, INJun 21, 1967 · N7895P · Destroyed NTSB CHI67A0124Accident · 4 fatalClosedPiper PA-24 · Covington, INMay 13, 1967 · N6536P · Destroyed NTSB CHI67D0516Accident · No injuriesClosedPiper PA-24 · Bethlehem, INMar 4, 1967 · N5688P · Substantial damage NTSB CHI67A0032Accident · 3 fatalClosedPiper PA-24 · Fort Wayne, INSep 1, 1966 · N8115P · Destroyed NTSB CHI67F0140Accident · No injuriesClosedPiper PA-24 · Culver, INJul 26, 1966 · N8451P · Substantial damage NTSB CHI66A0083Accident · 3 fatalClosedPiper PA-24 · Seymour, INApr 5, 1966 · N7300P · Destroyed NTSB CHI66F0501Accident · No injuriesClosedPiper PA-24 · Wabash, INDec 26, 1965 · N5242P · Substantial damage NTSB CHI66D0504Accident · No injuriesClosedPiper PA-24 · Indianapolis, INDec 18, 1965 · N8451P · Substantial damage NTSB CHI66F0116Accident · No injuriesClosedPiper PA-24 · Ft Wayne, INJul 26, 1965 · N6019P · Substantial damage NTSB UNK65X1058Accident · Serious injuriesClosedPiper PA24 · Indianapolis, INDec 19, 1964 · N8451P · No damage NTSB UNK65X0765Accident · No injuriesClosedPiper PA24 · Michigan City, INNov 20, 1964 · N6033P · Substantial damage NTSB UNK64X0571Accident · No injuriesClosedPiper PA24 · Gary, INFeb 15, 1964 · N7614P · Substantial damage