Skip to content

NTSB investigations: Piper PA-28-140, ID

35 cases on aircraft the registry lists as Piper PA-28-140. 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" = 'ID' 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 ('7102802')) 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\" = 'ID' 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 ('7102802'))
  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" = 'ID' 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 ('7102802'))
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 WPR23LA242Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe premature retraction of the flaps by the student pilot, while just above the airplane’s stall speed. Contributing to the accident was the flight instructor’s inadequate supervision and failure to regain aircraft control from the student pilot.Jun 27, 2023 · N730SC · Substantial damage NTSB WPR22LA030Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.Oct 28, 2021 · N1671J · Substantial damage NTSB GAA17CA157Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Weiser, IDThe student pilot’s failure to maintain directional control and to maintain clearance from a snow berm during the aborted landing.Feb 25, 2017 · N4404T · Substantial damage NTSB WPR13CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Coolin, IDThe pilot’s failure to maintain an adequate glide path, which led to a runway excursion and collision with objects.Jun 16, 2013 · N199 · Substantial damage NTSB SEA07LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, IDThe pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.Nov 14, 2006 · N2390T · Substantial damage NTSB SEA05CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McCammon, IDA loss of engine power due to the pilot's inadequate in-flight decision/planning by failing to refuel while en route, resulting in fuel exhaustion. Factors contributing to the accident included the trees and fence.Apr 15, 2005 · N8715E · Substantial damage NTSB SEA03LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Homedale, IDLoss of engine power during descent due to a failed cylinder head.Sep 3, 2003 · N15367 · Substantial damage NTSB SEA03LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orofino, IDThe pilot's misjudgment of speed and distance resulting in a loss of airspeed, stall and undershoot of runway.Apr 19, 2003 · N6268W · Substantial damage NTSB SEA02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include high density altitude, variable winds, and a ditch near the point where the aircraft departed the side of the runway.Aug 28, 2002 · N5781F · Substantial damage NTSB SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.Mar 13, 1999 · N9578W · Substantial damage NTSB SEA91FA170Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Driggs, IDThe pilot's poor inflight decision and his improper compensation for wind. Factors were rising, mountainous terrain; high, gusty winds; and a high density altitude.Jul 14, 1991 · N501FL · Destroyed NTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.Jul 19, 1990 · N5011T · Substantial damage NTSB SEA89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Fork, IDThe pilot flew the aircraft into a box canyon at dawn. The aircraft was unable to outclimb rising terrain. The aircraft impacted heavily wooded terrain at a slow airspeed at 8,000 feet MSL about 50 yards short of the crest.Oct 1, 1988 · N7548R · Destroyed NTSB SEA86LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Preston, IDThe jackson county sheriff reported that the pilot was attempting to take off from a farmer's field and failed to clear a dike. Subsequently, the acft cartwheeled into a county landfill and was damaged.Aug 10, 1986 · N5576F · Substantial damage NTSB SEA84LA079Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Idaho Falls, IDThe student plt was on a solo x-country flt & had refueled at twin Falls, ID. When she took off, both fuel tanks were full. While descending thru about 6000 ft, near the destination arpt, the eng sputtered & quit running. The student enriched the mixture,…Apr 4, 1984 · N1436X · Substantial damage NTSB SEA82DYA04Accident · No injuriesClosedPiper PA-28 · Majic Rsrvoir, IDDec 9, 1981 · N7267F · Substantial damage NTSB SEA77FYA21Accident · No injuriesClosedPiper PA-28 · Nampa, IDJun 5, 1977 · N8410R · Substantial damage NTSB SEA77FYA14Accident · No injuriesClosedPiper PA-28 · Emmett, IDMar 20, 1977 · N4388X · Substantial damage NTSB LAX74DYA29Accident · Serious injuriesClosedPiper PA-28 · Twin Falls, IDApr 19, 1974 · N7063R · Minor damage NTSB SEA74AS036Accident · 1 fatalClosedPiper PA-28 · Caldwell, IDMar 10, 1974 · N6290W · Destroyed NTSB SEA74AS014Accident · 4 fatalClosedPiper PA-28 · Idaho Cty, IDSep 9, 1973 · N1742T · Destroyed NTSB SEA72AS054Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDJun 17, 1972 · N8775N · Substantial damage NTSB SEA71FYA35Accident · Serious injuriesClosedPiper PA-28 · Boise, IDJun 13, 1971 · N6786W · Substantial damage NTSB SEA71DXM26Accident · No injuriesClosedPiper PA-28 · Burley, IDFeb 28, 1971 · N7063R · Substantial damage NTSB SEA71AS034Accident · 3 fatalClosedPiper PA-28 · Rogerson, IDJan 10, 1971 · N95124 · Destroyed NTSB SEA70DXM14Accident · No injuriesClosedPiper PA-28 · Oxford, IDMay 15, 1970 · N5787F · Substantial damage NTSB SEA70D0104Accident · No injuriesClosedPiper PA-28 · Lewiston, IDOct 10, 1969 · N7098R · Substantial damage NTSB SEA69A0025Accident · 3 fatalClosedPiper PA-28 · Cataldo, IDOct 22, 1968 · N1740J · Destroyed NTSB SEA69D0066Accident · No injuriesClosedPiper PA-28 · Montpelier, IDAug 12, 1968 · N6043W · Substantial damage NTSB SEA68D0236Accident · No injuriesClosedPiper PA-28 · Arco, IDJan 23, 1968 · N9747W · Substantial damage NTSB SEA68D0186Accident · No injuriesClosedPiper PA-28 · Picabo, IDNov 2, 1967 · N6655W · Substantial damage NTSB SEA68D0113Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDAug 1, 1967 · N7049R · Substantial damage NTSB SEA67D0310Accident · Minor injuriesClosedPiper PA-28 · Horsebend, IDApr 24, 1967 · N7512R · Substantial damage NTSB SEA67D0269Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDApr 1, 1967 · N7049R · Substantial damage NTSB UNK64X4099Accident · No injuriesClosedPiper PA28 · Montpelier, IDSep 22, 1964 · N6043W · Substantial damage