Skip to content

NTSB investigations: Piper PA-24-250, KS

30 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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 GAA15CA178Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Newton, KSThe failure of the right main landing gear down-lock micro switch, which resulted in a landing gear collapse during landing, and the pilot/owner's unfamiliarity with the emergency landing gear extension procedure. Contributing to the accident was the flight…Jul 4, 2015 · N7985P · Substantial damage NTSB DEN06CA101Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Olathe, KSthe pilot's failure to extend the landing gear prior to landing.Jul 16, 2006 · N6955P · Destroyed 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.Apr 6, 2004 · N5844P · Substantial damage NTSB CHI03LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chanute, KSThe pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…Sep 22, 2003 · N122CC · Substantial damage NTSB CHI01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Manhattan, KSthe inadequate soft field takeoff procedure by the pilot and his failure to abort the takeoff. Factors were the high grass on the runway, the pilots disregard for the runway conditions, his lack of total experience in the aircraft, the trees, and the pilots…Oct 14, 2000 · N6107P · Destroyed NTSB CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.Nov 11, 1990 · N6981P · Substantial damage NTSB MKC89FA156Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Medicine Lodge, KSThe pilot misjudged clearance above a house (residence) that he was buzzing and allowed the aircraft to collide with the attached antenna.Jul 9, 1989 · N5379P · Destroyed NTSB MKC85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Weskan, KSThe plt rptd a high eng oil temperature & low oil pressure while maneuvering over a siesmic operation site in west Kansas. The acft was substantially damaged when it contacted a ditch during a forced landing. Post accident inspection failed to disclose any…Aug 31, 1985 · N6903P · Substantial damage NTSB MKC84LA113Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Osage City, KSDuring an aborted takeoff, executed due to an inoperative airspeed indicator, the acft swerved off the left side of the rwy across a ditch, damaging the left wing & main landing gear. A clogged pilot tube was the cause of the airspeed indication of zero mph.…Mar 31, 1984 · N6293P · Substantial damage NTSB MKC82DCQ03Accident · No injuriesClosedPiper PA-24 · Wichita, KSNov 6, 1981 · N6243P · Substantial damage NTSB MKC78FCQ29Accident · No injuriesClosedPiper PA-24 · Wichita, KSJun 22, 1978 · N6549P · Substantial damage NTSB MKC77FCG21Accident · No injuriesClosedPiper PA-24 · Osawatomie, KSApr 27, 1977 · N5454P · Substantial damage NTSB MKC75DCQ41Accident · No injuriesClosedPiper PA-24 · Emporia, KSApr 5, 1975 · N5915P · Substantial damage NTSB MKC74AK045Accident · 1 fatalClosedPiper PA-24 · Lawrence, KSFeb 2, 1974 · N5323P · Destroyed NTSB MKC74FCQ17Accident · No injuriesClosedPiper PA-24 · Larned, KSNov 19, 1973 · N8131P · Substantial damage NTSB MKC71DCG47Accident · No injuriesClosedPiper PA-24 · Olathe, KSMar 14, 1971 · N6424P · Substantial damage NTSB MKC69D0139Accident · No injuriesClosedPiper PA-24 · Winfield, KSSep 11, 1968 · N8381P · Substantial damage NTSB MKC67A0082Accident · No injuriesClosedPiper PA-24 · Wichita, KSJun 16, 1967 · N6424P · Substantial damage NTSB MKC67F0544Accident · No injuriesClosedPiper PA-24 · Kansas City, KSApr 14, 1967 · N6439P · Substantial damage NTSB MKC67D0450Accident · No injuriesClosedPiper PA-24 · Olathe, KSFeb 18, 1967 · N8437P · Substantial damage NTSB MKC67D0316Accident · No injuriesClosedPiper PA-24 · Topeka, KSNov 13, 1966 · N8031P · Substantial damage NTSB MKC67D0188Accident · No injuriesClosedPiper PA-24 · Wichita, KSJun 25, 1966 · N7392P · Substantial damage NTSB MKC66F0569Accident · No injuriesClosedPiper PA-24 · Emporia, KSApr 13, 1966 · N8031P · Substantial damage NTSB MKC66F0262Accident · No injuriesClosedPiper PA-24 · Wichita, KSSep 25, 1965 · N6839P · Substantial damage NTSB UNK64X3345Accident · No injuriesClosedPiper PA24 · Fall River, KSAug 12, 1964 · N7797P · Substantial damage NTSB UNK64X1740Accident · No injuriesClosedPiper PA24 · Manhattan, KSMay 12, 1964 · N6544P · Substantial damage NTSB UNK64X1249Accident · No injuriesClosedPiper PA24 · Topeka, KSApr 10, 1964 · N5495P · Substantial damage NTSB UNK64X1043Accident · No injuriesClosedPiper PA24 · Iola, KSMar 26, 1964 · N5449P · Substantial damage NTSB UNK64X0862Accident · Minor injuriesClosedPiper PA24 · Clearwater, KSMar 9, 1964 · N7161P · Destroyed NTSB UNK64X0153Accident · No injuriesClosedPiper PA24 · Wichita, KSJan 4, 1964 · N7161P · Substantial damage