Skip to content

NTSB investigations: Cessna 140, OR

32 cases on aircraft the registry lists as Cessna 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" = 'OR' 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 ('2071602', '2071603')) 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\" = 'OR' 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 ('2071602', '2071603'))
  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" = 'OR' 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 ('2071602', '2071603'))
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 WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.Apr 26, 2023 · N140D · Substantial damage NTSB WPR21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Fields, ORThe pilot’s failure to maintain directional control during landingMay 29, 2021 · N89257 · Substantial damage NTSB WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.Jun 12, 2019 · N73053 · Substantial damage NTSB WPR16LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Independence, ORThe failure of the left main landing gear wheel axle due to a fatigue crack.Feb 13, 2016 · N3625V · Substantial damage NTSB WPR15LA155Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Crescent Lake, ORThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inability to restart the engine for reasons that could not be determined because postaccident examination…May 1, 2015 · N2514N · Substantial damage NTSB SEA00LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Creswell, ORThe pilot's failure to maintain directional control. Factors include a drainage ditch and a crosswind.Apr 4, 2000 · N76777 · Substantial damage NTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.Aug 13, 1997 · N76233 · Substantial damage NTSB SEA93LA063Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Salem, ORA complete loss of power for undetermined reasons. Factors include unsuitable terrain, and trees surrounding the forced landing site.Feb 5, 1993 · N2019N · Substantial damage NTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.Sep 11, 1991 · N76006 · Substantial damage NTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.Feb 12, 1987 · N72166 · Substantial damage NTSB SEA86LA036Accident · No injuriesLimited investigationFinal reportCessna 140 · Ione, ORThe pilot attempted to fly his newly purchased aircraft a distance of 3 miles from one local airstrip to another for the purpose of hangaring it. A ceiling of 500 feet overcast with 5 miles visibility fog and freezing rain were present. The windscreen iced up…Jan 5, 1986 · N1920V · Substantial damage NTSB SEA82DA078Accident · Minor injuriesFinal reportCessna 140 · Buena Vista, ORThe pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose…May 23, 1982 · N73056 · Substantial damage NTSB SEA81DYK15Accident · Minor injuriesClosedCessna 140 · Ashland, ORAug 24, 1981 · N2626N · Destroyed NTSB SEA81DYM23Accident · No injuriesClosedCessna 140 · Pendleton, ORApr 30, 1981 · N2143V · Substantial damage NTSB SEA80FYK11Accident · No injuriesClosedCessna 140 · Creswell, ORAug 3, 1980 · N3691V · Substantial damage NTSB SEA77DYM50Accident · No injuriesClosedCessna 140 · Rufus, ORJul 28, 1977 · N89388 · Destroyed NTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORDec 1, 1973 · N76006 · Substantial damage NTSB SEA74DYC21Accident · No injuriesClosedCessna 140 · Astoria, OROct 8, 1973 · N3086N · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB SEA73FYC30Accident · Serious injuriesClosedCessna 140 · Sisters, ORMay 28, 1973 · N2051N · Destroyed NTSB SEA72DYI20Accident · Minor injuriesClosedCessna 140 · Bend, ORApr 29, 1972 · N73079 · Substantial damage NTSB SEA71DWA33Accident · No injuriesClosedCessna 140 · Tigard, ORApr 1, 1971 · N76294 · Substantial damage NTSB SEA70D0123Accident · No injuriesClosedCessna 140 · Roseburg, ORSep 2, 1969 · N76445 · Substantial damage NTSB SEA70A0010Accident · 1 fatalClosedCessna 140 · Newport, ORAug 14, 1969 · N2225N · Destroyed NTSB SEA69D0160Accident · No injuriesClosedCessna 140 · Mulino, ORSep 27, 1968 · N2497N · Substantial damage NTSB SEA68D0271Accident · No injuriesClosedCessna 140 · Beaver Creek, ORMar 3, 1968 · N76167 · Substantial damage NTSB SEA67F0007Accident · No injuriesClosedCessna 140 · Medford, ORApr 27, 1966 · N2172V · Substantial damage NTSB SEA66D0292Accident · No injuriesClosedCessna 140 · Paisley, ORApr 15, 1966 · N3713V · Substantial damage NTSB SEA66D0186Accident · No injuriesClosedCessna 140 · Beaverton, ORDec 4, 1965 · N3701V · Substantial damage NTSB SEA65F0025Accident · No injuriesClosedCessna 140 · Lebanon, ORMar 27, 1965 · N2593N · Substantial damage NTSB UNK65X0151Accident · Serious injuriesClosedCessna 140 · Beaverton, OROct 4, 1964 · N2291N · Substantial damage NTSB UNK64X1279Accident · No injuriesClosedCessna 140A · Burns, ORApr 12, 1964 · N5309C · Substantial damage