Fatal NTSB investigations: Piper PA-14

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

Fatal NTSB investigations: Piper PA-14 per year, 1964–2026: 14 cases
1964	1
1965	1
1966	1
1970	1
1972	1
1977	1
1979	1
1982	2
1983	1
1985	1
1993	1
2005	1
2020	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101402')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101402'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101402'))
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 WPR20LA270Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA 14 · Susanville, CAThe pilot’s decision to conduct a steep departure at a high-density altitude and the exceedance of the airplane’s critical angle of attack during a climb, which resulted in an accelerated stall and subsequent loss of control. Contributing to the accident was…Aug 15, 2020 · N91449 · Substantial damage NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.Aug 27, 2005 · N5104H · Destroyed NTSB ANC93FA045Accident · 1 fatalField investigationFinal reportPiper PA-14 · Rainey Pass, AKThe pilot-in-command's attempt to fly VFR in IMC conditions. Factors were the mountainous terrain and whiteout conditions.Mar 20, 1993 · N5153H · Substantial damage NTSB SEA85FA100Accident · 1 fatalField investigationFinal reportPiper PA-14 · Bliss, IDThe acft was observed by witnesses to climb out at a steep angle & slow airspeed after the 3rd touch & go before performing a wingover like maneuver & crashing in the x-wind turn. The pax reported the plt executing a steep left turn before the acft began a…Apr 28, 1985 · N5122H · Destroyed NTSB MKC83FA216Accident · 1 fatalField investigationFinal reportPiper PA-14 · Trenton, MOThe acft had just received extensive maintenance at buffalo, MO, which included internal & external recovering & an STC modification. During arrival at Trenton, MO, the acft was observed on a short final apch. At a position of aprx 200 ft short of the rwy &…Sep 10, 1983 · N372T · Substantial damage NTSB LAX83FA061Accident · 4 fatalField investigationFinal reportPiper PA-14 · Santa Ysabel, CANarrative will follow.Dec 25, 1982 · N4230H · Destroyed NTSB ANC82DAG33Accident · 1 fatalFinal reportPiper PA-14 · Talkeetna, AKThe pilot step taxied the float plane to the north end of neil lake in preparation for a south takeoff. Approaching the north shore, a left step turn was initiated to postion the aircraft to the south for a takeoff. During the turn, while still on a northerly…Jun 24, 1982 · N5173H · Destroyed NTSB ANC79FA083Accident · 2 fatalClosedPiper PA-14 · Anchorage, AKAug 23, 1979 · N4252H · Destroyed NTSB ANC77FA060Accident · 2 fatalClosedPiper PA-14 · Wasilla, AKJul 17, 1977 · N5115H · Destroyed NTSB ANC72AA040Accident · 2 fatalClosedPiper PA-14 · Fairbanks, AKMar 15, 1972 · N4271H · Destroyed NTSB SEA71AS023Accident · 2 fatalClosedPiper PA-14 · Carlyle, MTOct 30, 1970 · N4266H · Destroyed NTSB ANC67F0005Accident · 1 fatalClosedPiper PA-14 · Fairbanks, AKJun 25, 1966 · N5163H · Destroyed NTSB DEN66A0002Accident · 1 fatalClosedPiper PA-14 · Jamestown, NDJul 2, 1965 · N4298H · Destroyed NTSB UNK64X3932Accident · 1 fatalClosedPiper PA-14 · Tyone Lodge, AKSep 12, 1964 · N5140H · Destroyed