Skip to content

NTSB investigations: Piper PA-30, OK

17 cases on aircraft the registry lists as Piper PA-30. 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

19652026

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" = 'OK' 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 ('7103002')) 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\" = 'OK' 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 ('7103002'))
  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" = 'OK' 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 ('7103002'))
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 CEN26LA248Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Tulsa, OKOn July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was…Jul 9, 2026 · N8154Y · Substantial damage NTSB CEN22FA145Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Pond Creek, OKThe pilot’s loss of control of the airplane, resulting in an in-flight breakup.Mar 17, 2022 · N8357Y · Destroyed NTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.Nov 5, 2004 · N7415Y · Substantial damage NTSB FTW99FA222Accident · 1 fatalField investigationFinal reportPiper PA30 · Holdenville, OKthe pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.Aug 16, 1999 · N7178Y · Destroyed NTSB FTW99LA154Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Mcalester, OKThe pilot inadvertently stalling the airplane while attempting to avoid power lines. Factors were the loss of power on both the left and right engines as a result of water contamination in the fuel system, the pilot's inadequate preflight procedures, and the…May 28, 1999 · N7991Y · Substantial damage NTSB FTW89LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Bristow, OKThe pilot's improper fuel management and failure of the inflight restart attempt.Jun 6, 1989 · N7959Y · Substantial damage NTSB FTW84FA126Accident · 1 fatalField investigationFinal reportPiper PA-30B · Hugo, OKAccording to witnesses, the acft was having some kind of problem after takeoff. It entered a nose high attitude, went to the right & crashed. An exam revealed that it had impacted in a nose down attitude. The landing gear was found in a down & locked…Feb 6, 1984 · N1VE · Destroyed NTSB FTW78FA006Accident · 2 fatalClosedPiper PA-30 · Wetumka, OKOct 23, 1977 · N7623Y · Destroyed NTSB FTW74FPM06Accident · No injuriesClosedPiper PA-30 · Tulsa, OKAug 31, 1973 · N8328Y · Substantial damage NTSB FTW71FPJ43Accident · No injuriesClosedPiper PA-30 · Oklahoma Cty, OKMay 24, 1971 · N8396Y · Substantial damage NTSB FTW71AF002Accident · 3 fatalClosedPiper PA-30 · Davenport, OKJul 11, 1970 · N8516Y · Destroyed NTSB FTW70D0178Accident · No injuriesClosedPiper PA-30 · Texhoma, OKAug 20, 1969 · N7065Y · Substantial damage NTSB FTW68A0072Accident · No injuriesClosedPiper PA-30 · Enid, OKJan 17, 1968 · N7407Y · Substantial damage NTSB FTW68D0340Accident · No injuriesClosedPiper PA-30 · Okla.City, OKNov 27, 1967 · N7519Y · Substantial damage NTSB FTW68F0033Accident · Serious injuriesClosedPiper PA-30 · Sand Springs, OKAug 11, 1966 · N7218Y · Destroyed NTSB FTW66D0416Accident · No injuriesClosedPiper PA-30 · Tulsa, OKOct 10, 1965 · N7746Y · Substantial damage NTSB FTW65F0026Accident · No injuriesClosedPiper PA-30 · Oklahoma City, OKApr 18, 1965 · N7670Y · Substantial damage