Skip to content

NTSB investigations: Cessna 140, MO

33 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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 CEN16FA054Accident · 2 fatalField investigationFinal reportCessna 140 · Keytesville, MOThe non-instrument-rated pilot's decision to operate in dark night conditions with low clouds, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's use of methamphetamine, which impaired his…Dec 7, 2015 · N90123 · Substantial damage NTSB CEN09LA335Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Louis, MOThe improper installation of the wing fairing during recent maintenance, which resulted in the partial separation of the fairing shortly after takeoff.Jun 2, 2009 · N76456 · Substantial damage NTSB CHI07LA039Accident · No injuriesLimited investigationFinal reportCessna 140 · Vienna, MOThe loss of engine power during cruise flight due to fatigued crankshaft cluster gear bolts and the inadequate major overhaul of the engine that was last performed by other maintenance personnel. An additional cause was a subsequent major engine overhaul not…Dec 9, 2006 · N76379 · Substantial damage NTSB CHI98FA299Accident · 2 fatalField investigationFinal reportCessna 140 · St. Joseph, MOthe pilot not maintaining a proper final approach glide path to avoid an encounter with wake turbulence. A factor in this accident was the pilot not being able to control the airplane after its encounter with wake turbulence.Aug 4, 1998 · N2364V · Destroyed NTSB CHI97LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Fulton, MOa malfunction of the engine's carburetor that was associated with a spalled carburetor float fulcrum pin which resulted in fuel starvation.May 22, 1997 · N76122 · Substantial damage NTSB CHI92LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chillicothe, MOThe pilot's improper use of the airplanes brakes.Aug 18, 1992 · N72379 · Substantial damage NTSB CHI92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Grain Valley, MOA stall following a downwind takeoff.Apr 28, 1992 · N77205 · Substantial damage NTSB MKC89LA133Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Ceour, MOThe failure of the pilot to plan the approach and maintain alignment with the sod landing strip. The pilot's innattention to the grass strip resulted in a landing in a soft wheat field.Jun 14, 1989 · N89316 · Substantial damage NTSB MKC87LA101Accident · No injuriesLimited investigationFinal reportCessna 140 · Eldon, MOAccording to the pilot, winds were light prior to the final approach, but a gust of wind picked up the right wing and the aircraft ballooned during the flare, running out of airspeed while in a full-stall/three-point attitude. Upon impact, both main gears…Apr 8, 1987 · N2559N · Substantial damage NTSB MKC87LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Coeur, MOThe PIC was practicing landings in gusty crosswind conditions. PIC landed long, and after rolling a short distance, perceived that the wind direction had changed. The PIC stated that this new wind direction was now more of a tailwind. The PIC did not select a…Apr 1, 1987 · N89316 · Substantial damage NTSB MKC86LA186Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Festus, MOThe student plt was on his 2nd solo flt & was practicing stop & go landings. He said that during a landing, he applied brakes before the left main landing gear was on the rwy. The acft swerved to the right & the left main gear collapsed. The plt received a…Sep 6, 1986 · N89208 · Minor damage NTSB MKC82DA141Accident · Minor injuriesFinal reportCessna 140 · West Plains, MOThe pilot was practicing short field takeoffs and maneuvered to clear a 50 foot barrier. He stalled the aircraft and was unable to recover before impacting the ground, nose and right wing first.Aug 10, 1982 · N2319V · Substantial damage NTSB MKC76FCA46Accident · No injuriesClosedCessna 140 · Vandalia, MOSep 25, 1976 · N72343 · Substantial damage NTSB MKC76DCG96Accident · No injuriesClosedCessna 140 · Salisbury, MOAug 23, 1976 · N72780 · Substantial damage NTSB MKC74FCG07Accident · No injuriesClosedCessna 140 · Kansas City, MOAug 10, 1973 · N2314N · Substantial damage NTSB MKC73FCA27Accident · Minor injuriesClosedCessna 140 · Valley Park, MOMay 24, 1973 · N2835N · Destroyed NTSB MKC72DCG25Accident · No injuriesClosedCessna 140 · Independence, MOOct 4, 1971 · N76567 · Substantial damage NTSB MKC72FCG04Accident · No injuriesClosedCessna 140 · Lee'S Summit, MOJul 10, 1971 · N89384 · Substantial damage NTSB MKC71DCA23Accident · No injuriesClosedCessna 140 · Steffenville, MODec 31, 1970 · N89035 · Substantial damage NTSB MKC71DCG36Accident · No injuriesClosedCessna 140 · Versailles, MODec 13, 1970 · N90060 · Substantial damage NTSB MKC71DCG29Accident · No injuriesClosedCessna 140 · Moberly, MONov 1, 1970 · N4052N · Substantial damage NTSB MKC70AK061Accident · 1 fatalClosedCessna 140 · Waldron, MOMay 16, 1970 · N89874 · Destroyed NTSB MKC69F0298Accident · No injuriesClosedCessna 140 · Chesterfield, MODec 26, 1968 · N2459N · Substantial damage NTSB MKC68D0214Accident · Minor injuriesClosedCessna 140 · Independence, MOAug 24, 1967 · N76939 · Substantial damage NTSB MKC68D0123Accident · No injuriesClosedCessna 140 · Springfield, MOJul 15, 1967 · N72938 · Substantial damage NTSB MKC67D0092Accident · No injuriesClosedCessna 140 · Kirkville, MOJun 26, 1966 · N76387 · Substantial damage NTSB MKC66A0053Accident · 1 fatalClosedCessna 140 · Savannah, MOApr 24, 1966 · N3576V · Destroyed NTSB MKC66F0480Accident · Minor injuriesClosedCessna 140 · St Joseph, MOMar 18, 1966 · N89555 · Substantial damage NTSB MKC66F0464Accident · No injuriesClosedCessna 140 · Indeoendence, MOJan 23, 1966 · N2296V · Substantial damage NTSB MKC66F0002Accident · No injuriesClosedCessna 140 · Columbia, MOMay 17, 1965 · N2344V · Substantial damage NTSB MKC65F0122Accident · No injuriesClosedCessna 140 · Maryville, MOApr 20, 1965 · N89826 · Substantial damage NTSB MKC66D0075Accident · No injuriesClosedCessna 140 · Kirksville, MOApr 13, 1965 · N2296V · Substantial damage NTSB UNK65X0551Accident · No injuriesClosedCessna 140 · Farmington, MONov 4, 1964 · N2459N · Substantial damage