Skip to content

NTSB investigations: Piper PA-28-140, MT

29 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" = 'MT' 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\" = 'MT' 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" = 'MT' 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 WPR22LA301Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Laurel, MTThe loss of climb performance due to undetermined reasons.Aug 11, 2022 · N5780F · Substantial damage NTSB WPR20LA278Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Harlowton, MTThe pilot’s failure to follow the appropriate takeoff procedures, which resulted in a collision with terrain.Aug 14, 2020 · N317LB · Substantial damage NTSB WPR15LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Helena, MTLoss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any evidence of an anomaly that would have precluded normal operation.Jan 20, 2015 · N4666R · Substantial damage NTSB WPR12CA209Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sula, MTThe pilot's inability to maintain clearance from terrain while operating in a downdraft over mountainous terrain.Jun 8, 2012 · N2839T · Substantial damage NTSB SEA05LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Superior, MTA loss of engine power due to the pilot's inadequate planning/decision and improper fuel management, which resulted in fuel starvation. A contributing factor was the berm.Feb 9, 2005 · N6399W · Substantial damage NTSB SEA00LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miles City, MTA loss of engine power for undetermined reasons.Sep 27, 2000 · N4686R · Substantial damage NTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.May 20, 1997 · N32142 · Substantial damage NTSB SEA92LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Monarch, MTThe pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…May 29, 1992 · N6434R · Destroyed NTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.Apr 8, 1990 · N5628U · Substantial damage NTSB DEN89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Livingston, MTThe poor judgement displayed by the pilot when he maneuvered the airplane at extremely low altitude over mountainous terrain. During the flight the pilot misjudged the pull-up required and struck trees.May 7, 1989 · N7296J · Substantial damage NTSB DEN89LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Chinook, MTThe student plt was flying cross country, solo, to take a private plt checkride. He said he became lost and flew until the fuel was exhausted. He selected a snow covered field and landed. At touchdown, the nose gear dug in and the acft nosed over.Nov 16, 1988 · N28EF · Substantial damage NTSB DEN82FTI10Accident · Serious injuriesFinal reportPiper PA-28-140 · Near Bozeman, MTThe pilot was on an early morning flight over mountainous terrain at 8500 feet. While inbound to his destination, he encountered an area of restricted visibility with snow. As he started a right turn to correct to his desired course, his passenger alerted him…Jan 11, 1982 · N7273J · Destroyed NTSB SEA80DTI03Accident · No injuriesClosedPiper PA-28 · Missoula, MTJan 18, 1980 · N38313 · Substantial damage NTSB SEA78FTI23Accident · Serious injuriesClosedPiper PA-28 · Augusta, MTJul 14, 1978 · N9875W · Destroyed NTSB SEA78FTI13Accident · No injuriesClosedPiper PA-28 · Kalispell, MTMay 8, 1978 · N16447 · Substantial damage NTSB SEA77FTA26Accident · No injuriesClosedPiper PA-28 · Billings, MTJul 4, 1977 · N9875W · Substantial damage NTSB SEA77FA038Accident · 3 fatalClosedPiper PA-28 · Lavina, MTJun 4, 1977 · N1176H · Destroyed NTSB SEA76AS064Accident · 1 fatalClosedPiper PA-28 · Butte, MTJul 25, 1976 · N6825W · Destroyed NTSB SEA75DTI25Accident · No injuriesClosedPiper PA-28 · Kalispell, MTMar 21, 1975 · N2698T · Substantial damage NTSB SEA74FTA02Accident · No injuriesClosedPiper PA-28 · Flaxville, MTJul 15, 1973 · N7360J · Substantial damage NTSB SEA71DTI32Accident · No injuriesClosedPiper PA-28 · Belgrade, MTMay 27, 1971 · N6357R · Substantial damage NTSB SEA71DDG17Accident · No injuriesClosedPiper PA-28 · Livingston, MTOct 31, 1970 · N7164R · Substantial damage NTSB SEA67D0276Accident · Minor injuriesClosedPiper PA-28 · Stevensville, MTApr 9, 1967 · N6152W · Substantial damage NTSB SEA67A0051Accident · 2 fatalClosedPiper PA-28 · Acton, MTMar 18, 1967 · N6789W · Destroyed NTSB SEA67D0186Accident · No injuriesClosedPiper PA-28 · Billings, MTOct 17, 1966 · N6991W · Substantial damage NTSB SEA66D0271Accident · No injuriesClosedPiper PA28 · Ut Bank, MTMay 6, 1966 · N6434W · Substantial damage NTSB SEA66D0247Accident · No injuriesClosedPiper PA-28 · Great Falls, MTMar 28, 1966 · N6304W · Substantial damage NTSB UNK65X1143Accident · No injuriesClosedPiper PA28 · Great Falls, MTDec 26, 1964 · N6304W · Substantial damage NTSB UNK65X0738Accident · No injuriesClosedPiper PA28 · Great Falls, MTNov 16, 1964 · N6304W · Substantial damage