Skip to content

NTSB investigations: Cessna 140, MI

51 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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CEN25LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Mason, MIThe pilot’s failure to maintain aircraft control during landing rollout that resulted in a nose over and an impact with the runway.Nov 25, 2024 · N76061 · Substantial damage NTSB CHI03LA282Accident · 1 fatalLimited investigationFinal reportCessna 140 · Edwardsburg, MIThe pilot not maintaining altitude/clearance from the power line during his low level cruise. Factors were the power transmission line, the lake, and low altitude flight.Aug 24, 2003 · N140GS · Substantial damage NTSB CHI03LA191Accident · No injuriesLimited investigationFinal reportCessna 140 · Ludington, MIThe maintenance personnel's improper installation of the landing gear axle, which resulted in the separation of the axle from the landing gear.Jul 2, 2003 · N89360 · Substantial damage NTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.Sep 13, 1995 · N76919 · Substantial damage NTSB CHI95LA291Accident · 1 fatalLimited investigationFinal reportCessna 140 · Mio, MIthe pilot's impairment of judgement and performance which led to performing a low altitude maneuver with insufficient altitude for recovery. A factor was the tailwind.Aug 21, 1995 · N76429 · Destroyed NTSB CHI94LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Frankenmuth, MIImproper use of the mixture control by the pilot. Factors related to the accident were: the similarity of shape, size, and color of the mixture and carburetor heat controls and the terrain condition (with crop) in the emergency landing area.Oct 24, 1993 · N73003 · Substantial damage NTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.Aug 1, 1991 · N76535 · Substantial damage NTSB CHI90LA242Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Blissfield, MIThe pilot's inadequate visual lookout which resulted in a collision with a utility wire.Aug 25, 1990 · N2239V · Substantial damage NTSB CHI89LA093Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, MIThe pilot's poor judgement, poor aircraft handling, and the resultant hard touchdown.May 17, 1989 · N4240N · Destroyed NTSB CHI84LA002Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Hastings, MIThe instructor plt (CFI) knew that the acft was getting low on fuel, but he wanted the student to make one more takeoff & landing. When the acft was climbing thru about 200 ft after takeoff, the eng began losing power. The CFI assumed control of the acft &…Oct 1, 1983 · N76639 · Substantial damage NTSB CHI80DEC05Accident · No injuriesClosedCessna 140 · Romeo, MIDec 3, 1979 · N1788N · Substantial damage NTSB CHI78FEM11Accident · No injuriesClosedCessna 140 · Atwood, MIMar 1, 1978 · N2102N · Substantial damage NTSB CHI78FEC05Accident · No injuriesClosedCessna 140 · W.Bloomfield, MINov 3, 1977 · N2229N · Substantial damage NTSB CHI75FEC60Accident · No injuriesClosedCessna 140 · Grosse Isle, MIJun 23, 1975 · N1970V · Substantial damage NTSB CHI75FEC49Accident · Serious injuriesClosedCessna 140 · Tecumseh, MIMay 25, 1975 · N2459V · Destroyed NTSB CHI75FEC41Accident · Serious injuriesClosedCessna 140 · Mason, MIMar 19, 1975 · N76264 · Substantial damage NTSB CHI73DEM69Accident · Minor injuriesClosedCessna 140 · Sanford, MIMay 30, 1973 · N76013 · Substantial damage NTSB CHI73DEM42Accident · Minor injuriesClosedCessna 140 · Levering, MIJan 20, 1973 · N76836 · Substantial damage NTSB CHI73FEC21Accident · Serious injuriesClosedCessna 140 · Plymouth, MIJan 7, 1973 · N2177V · Destroyed NTSB CHI72FEC03Accident · No injuriesClosedCessna 140 · Pontiac, MIAug 21, 1971 · N76130 · Substantial damage NTSB CHI71FBJ70Accident · No injuriesClosedCessna 140 · Fulton, MIApr 22, 1971 · N77073 · Substantial damage NTSB CHI71DDW24Accident · No injuriesClosedCessna 140 · Fraser, MINov 14, 1970 · N2893N · Substantial damage NTSB CHI70DDW19Accident · No injuriesClosedCessna 140 · Adrian, MIMay 27, 1970 · N76071 · Substantial damage NTSB CHI70FDW13Accident · Minor injuriesClosedCessna 140 · Port Huron, MIMay 17, 1970 · N2060N · Substantial damage NTSB CHI70F0323Accident · No injuriesClosedCessna 140 · Flint, MIOct 24, 1969 · N89119 · Substantial damage NTSB CHI70D0294Accident · No injuriesClosedCessna 140 · St Ignace, MIOct 10, 1969 · N3591V · Substantial damage NTSB CHI70F0232Accident · Minor injuriesClosedCessna 140 · Traverse Cty, MISep 13, 1969 · N2727N · Substantial damage NTSB CHI70F0127Accident · No injuriesClosedCessna 140 · Romeo, MIJun 25, 1969 · N72631 · Substantial damage NTSB CHI69D0555Incident · No injuriesClosedCessna 140 · St.Ignace, MIMar 23, 1969 · N3591V · Minor damage NTSB CHI69F0228Accident · No injuriesClosedCessna 140 · Kawkawlin, MISep 17, 1968 · N77353 · Substantial damage NTSB CHI69D0225Accident · No injuriesClosedCessna 140 · Lawton, MIAug 18, 1968 · N89458 · Substantial damage NTSB CHI69F0163Accident · No injuriesClosedCessna 140 · Milan, MIAug 11, 1968 · N77130 · Substantial damage NTSB CHI69F0153Accident · Minor injuriesClosedCessna 140 · Conklin, MIAug 5, 1968 · N76925 · Substantial damage NTSB CHI68D0662Accident · No injuriesClosedCessna 140 · Manton, MIMar 30, 1968 · N2239V · Substantial damage NTSB CHI68D0153Accident · No injuriesClosedCessna 140 · Lake Orion, MIJul 12, 1967 · N89252 · Substantial damage NTSB CHI67D0432Accident · No injuriesClosedCessna 140 · Three Rivers, MIDec 11, 1966 · N89673 · Substantial damage NTSB CHI67D0202Accident · No injuriesClosedCessna 140 · Napoleon, MISep 18, 1966 · N89822 · Substantial damage NTSB CHI67F0093Accident · 1 fatalClosedCessna 140 · Freaser, MIJul 22, 1966 · N2378N · Destroyed NTSB CHI66D0663Accident · No injuriesClosedCessna 140 · Ann Arbor, MIMar 27, 1966 · N4147N · Substantial damage NTSB CHI66D0537Accident · No injuriesClosedCessna 140 · Petersburg, MIFeb 5, 1966 · N2473V · Substantial damage NTSB CHI66F0408Accident · No injuriesClosedCessna 140 · Houghton, MIOct 29, 1965 · N72856 · Substantial damage NTSB CHI66A0042Accident · 2 fatalClosedCessna 140 · Ralph, MIOct 24, 1965 · N72146 · Destroyed NTSB CHI66D0136Accident · Minor injuriesClosedCessna 140 · Plymouth, MIAug 5, 1965 · N72873 · Destroyed NTSB CHI65F0177Accident · No injuriesClosedCessna 140 · Pontiac, MIMay 1, 1965 · N76943 · Substantial damage NTSB CHI65F0115Accident · No injuriesClosedCessna 140 · Hastings, MIMar 28, 1965 · N89480 · Substantial damage NTSB UNK65X0329Accident · No injuriesClosedCessna 140 · Houghton, MIOct 18, 1964 · N72856 · Substantial damage NTSB UNK64X3659Accident · No injuriesClosedCessna 140 · Birmingham, MIAug 29, 1964 · N2981N · Substantial damage NTSB UNK64X3029Accident · Minor injuriesClosedCessna 140 · Schoolcraft, MIJul 25, 1964 · N3626V · Destroyed NTSB UNK64X1955Accident · No injuriesClosedCessna 140 · Clare, MIMay 25, 1964 · N72856 · Substantial damage NTSB UNK64X1558Accident · No injuriesClosedCessna 140 · Watervliet, MIMay 2, 1964 · N76276 · Substantial damage