NTSB investigations: Piper PA-30, KS

15 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

19642026

NTSB investigations: Piper PA-30, KS per year, 1964–2026: 15 cases
1964	1
1966	1
1969	1
1970	2
1971	1
1972	1
1974	1
1977	1
1985	1
1986	1
1987	1
2002	1
2007	1
2017	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."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 ('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\" = '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 ('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" = '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 ('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 CEN17FA297Accident · 2 fatalField investigationFinal reportPiper PA30 · Topeka, KSThe failure of the pilot and flight instructor to maintain aircraft control while maneuvering in the traffic pattern.Aug 1, 2017 · N22HW · Destroyed NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.Aug 31, 2007 · N22HW · Substantial damage NTSB CHI02LA219Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Abilene, KSThe pilot failed to achieve clearance over the trees and wires. Factors associated with the accident were the pilot failed to use all available runway, a downwind takeoff was performed, the tailwind, trees, and wires.Jul 29, 2002 · N90TC · Substantial damage NTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…Nov 8, 1987 · N7277Y · Substantial damage NTSB MKC86LA149Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Arkansas City, KSThe certified flight instructor stated that his intentions for this flight were to simulate an engine power loss during the early stages of the takeoff roll and have the student perform a rejected takeoff procedure. According to the c.f.I., at approximately…Jul 13, 1986 · N7259Y · Substantial damage NTSB MKC85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manhattan, KSThe plt said he put the landing gear selector switch to the down position and thought that he observed a green, down andlocked indicator light; however, the acft landed with the gear retracted. Examination of the acft after the accident revealed that the…Jun 23, 1985 · N7012Y · Substantial damage NTSB MKC77FCQ43Accident · No injuriesClosedPiper PA-30 · Wichita, KSJun 24, 1977 · N8695Y · Substantial damage NTSB MKC75FCQ04Accident · Serious injuriesClosedPiper PA-30 · Newton, KSJul 17, 1974 · N7432Y · Substantial damage NTSB MKC73AK012Accident · 4 fatalClosedPiper PA-30 · Overbrook, KSAug 3, 1972 · N8245Y · Destroyed NTSB MKC72DCQ17Accident · No injuriesClosedPiper PA-30 · Mankato, KSAug 7, 1971 · N7065Y · Substantial damage NTSB MKC71AK005Accident · 2 fatalClosedPiper PA-30 · St John, KSAug 4, 1970 · N7525Y · Destroyed NTSB MKC70AK039Accident · Minor injuriesClosedPiper PA-30 · Wichita, KSJan 15, 1970 · N8648Y · Substantial damage NTSB MKC70A0010Accident · No injuriesClosedPiper PA-30 · Topeka, KSSep 12, 1969 · N8701Y · Substantial damage NTSB MKC66D0579Accident · No injuriesClosedPiper PA-30 · Lawrence, KSMay 26, 1966 · N7898Y · Substantial damage NTSB UNK64X0176Accident · No injuriesClosedPiper PA30 · Lacrosse, KSJan 6, 1964 · N7121Y · Substantial damage