Skip to content

NTSB investigations: Cessna 140, MT

26 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" = '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 ('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\" = '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 ('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" = '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 ('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 GAA16CA023Accident · Serious injuriesData collectionFinal reportCessna 140 · Fort Benton, MTA hard landing which resulted in a loss of directional control, main landing gear collapse, and damage to the left wing spar.Oct 20, 2015 · N76001 · Substantial damage NTSB SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.Apr 21, 2000 · N3579V · Substantial damage NTSB SEA00LA032Accident · No injuriesLimited investigationFinal reportCessna 140 · Helena, MTSeparation of the left main landing gear. Factors include inadequate preflight inspection by the pilot, and inadequate inspection at the time of annual inspection by maintenance personnel.Dec 15, 1999 · N2739N · Substantial damage NTSB DEN84LA287Accident · No injuriesLimited investigationFinal reportCessna 140 · Belgrade, MTThe plt stated that during the takeoff ground roll on the grass airstrip the engine did not seem to produce full power when 2/3 the way down the rwy. Plt applied brakes to abort the takeoff before the tailwheel was on the ground. The acft nosed over.Sep 11, 1984 · N2628N · Substantial damage NTSB DEN84LA283Accident · No injuriesLimited investigationFinal reportCessna 140 · Butte, MTThe plt taxied to rwy 11 and got out of the acft to check the wind. The rwy lights were not operating at the time. The pilot decided that rwy 11 was the most favorable rwy and the takeoff was attempted. The wind conditions at the time off the accident were…Sep 6, 1984 · N77271 · Substantial damage NTSB DEN80DTI11Accident · No injuriesClosedCessna 140 · Lost Prairie, MTJun 8, 1980 · N76657 · Substantial damage NTSB SEA80FTA04Accident · No injuriesClosedCessna 140 · Malta, MTDec 1, 1979 · N2197N · Substantial damage NTSB SEA79FTI17Accident · No injuriesClosedCessna 140 · Brady, MTJun 8, 1979 · N77318 · Substantial damage NTSB SEA77FTA24Accident · No injuriesClosedCessna 140 · Jordan, MTJun 23, 1977 · N2040N · Substantial damage NTSB SEA77FTI14Accident · Minor injuriesClosedCessna 140 · Stevensville, MTJun 1, 1977 · N76330 · Destroyed NTSB SEA77FTA12Accident · No injuriesClosedCessna 140 · Hinsdale, MTFeb 14, 1977 · N2628N · Substantial damage NTSB SEA76FTA07Accident · No injuriesClosedCessna 140 · Miles City, MTNov 2, 1975 · N2611N · Destroyed NTSB SEA75DTI26Accident · No injuriesClosedCessna 140 · Deer Lodge, MTApr 28, 1975 · N76295 · Substantial damage NTSB SEA74DTI27Accident · No injuriesClosedCessna 140 · Townsend, MTJun 9, 1974 · N76001 · Substantial damage NTSB SEA74FTA06Accident · Serious injuriesClosedCessna 140 · Ekalaka, MTAug 13, 1973 · N77002 · Substantial damage NTSB SEA72DTA12Accident · No injuriesClosedCessna 140 · Glendive, MTFeb 20, 1972 · N2040N · Substantial damage NTSB SEA72FTA11Accident · No injuriesClosedCessna 140 · Hardin, MTFeb 15, 1972 · N72261 · Substantial damage NTSB SEA71FTI33Accident · Minor injuriesClosedCessna 140 · Butte, MTMay 29, 1971 · N3079N · Substantial damage NTSB SEA69A0014Accident · 1 fatalClosedCessna 140 · Busby, MTAug 23, 1968 · N2278V · Destroyed NTSB SEA68F0199Accident · Serious injuriesClosedCessna 140 · Hardin, MTSep 25, 1967 · N76931 · Destroyed NTSB SEA68D0180Accident · No injuriesClosedCessna 140A · Worden, MTAug 10, 1967 · N3785V · Substantial damage NTSB SEA67D0120Accident · No injuriesClosedCessna 140 · Great Falls, MTSep 15, 1966 · N72308 · Substantial damage NTSB SEA66A0027Accident · 1 fatalClosedCessna 140 · Ryegate, MTOct 28, 1965 · N77103 · Destroyed NTSB SEA65F0057Accident · No injuriesClosedCessna 140 · Great Falls, MTMar 21, 1965 · N2585N · Substantial damage NTSB UNK64X3196Accident · No injuriesClosedCessna 140 · Medicine Lke, MTAug 3, 1964 · N2362V · Substantial damage NTSB UNK64X1787Accident · No injuriesClosedCessna 140 · Belgrade, MTMay 16, 1964 · N76850 · Substantial damage