Skip to content

NTSB investigations: Cessna 140, IL

42 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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN21LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Greenville, ILThe pilot’s failure to maintain directional control during taxi which resulted in a ground loop.Aug 13, 2021 · N77365 · Substantial damage NTSB CEN11LA595Accident · No injuriesLimited investigationFinal reportCessna 140 · Monmouth, ILThe pilot's loss of airplane control during the landing roll.Aug 25, 2011 · N72688 · Substantial damage NTSB CHI08CA087Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe left wing skin "fabric patch" separated from the wing ribs and spars for an undetermined reason.Feb 23, 2008 · N3527V · Substantial damage NTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.Sep 5, 1993 · N89467 · Substantial damage NTSB CHI84LA085Accident · No injuriesLimited investigationFinal reportCessna 140 · Huntley, ILThe student plt allowed the acft to drift left during takeoff in spite of verbal instructions by the CFI to correct the situation. The acft continued toward a snowbank and the CFI did not take corrective action on the controls in time to avoid a collision…Jan 15, 1984 · N76310 · Substantial damage NTSB CHI83LA095Accident · No injuriesLimited investigationFinal reportCessna 140 · Richview, ILThe acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no…Jan 29, 1983 · N2377V · Substantial damage NTSB CHI79FEE09Accident · Minor injuriesClosedCessna 140 · Waukegan, ILNov 11, 1978 · N701F · Substantial damage NTSB CHI78DEV26Accident · Minor injuriesClosedCessna 140 · Trivoli, ILApr 9, 1978 · N4158N · Substantial damage NTSB CHI77FEV02Accident · No injuriesClosedCessna 140 · Peoria, ILOct 17, 1976 · N72498 · Substantial damage NTSB CHI76FEV24Accident · No injuriesClosedCessna 140 · Minonk, ILJan 4, 1976 · N3618V · Substantial damage NTSB CHI76DEV10Accident · No injuriesClosedCessna 140 · Quincy, ILAug 21, 1975 · N1627V · Substantial damage NTSB CHI75FEE54Accident · No injuriesClosedCessna 140 · Monee, ILMar 21, 1975 · N2036N · Substantial damage NTSB CHI74AEV27Accident · Serious injuriesClosedCessna 140 · Hull, ILNov 5, 1973 · N72391 · Substantial damage NTSB CHI74AEV01Accident · No injuriesClosedCessna 140 · Metamora, ILJul 7, 1973 · N2123N · Substantial damage NTSB CHI73FEE01Accident · No injuriesClosedCessna 140 · Harvard, ILJul 4, 1972 · N89325 · Substantial damage NTSB CHI72FEE60Accident · No injuriesClosedCessna 140 · Wheeling, ILMar 10, 1972 · N3552V · Substantial damage NTSB CHI71DEE86Accident · No injuriesClosedCessna 140 · Earlville, ILJun 11, 1971 · N76644 · Substantial damage NTSB CHI71AC045Accident · 1 fatalClosedCessna 140 · Vergennes, ILDec 19, 1970 · N2035N · Substantial damage NTSB CHI70F0205Accident · No injuriesClosedCessna 140 · Mt.Vernon, ILAug 5, 1969 · N2010N · Substantial damage NTSB CHI70F0078Accident · Minor injuriesClosedCessna 140 · Jacksonville, ILJun 2, 1969 · N274 · Destroyed NTSB CHI70D0073Accident · Minor injuriesClosedCessna 140 · Paris, ILMay 23, 1969 · N2293N · Substantial damage NTSB CHI69F0049Accident · No injuriesClosedCessna 140 · Columbia, ILMay 8, 1968 · N2776N · Substantial damage NTSB CHI68F0367Accident · No injuriesClosedCessna 140 · Mt.Sterling, ILSep 21, 1967 · N89883 · Substantial damage NTSB CHI68D0313Accident · No injuriesClosedCessna 140 · Dekalb, ILSep 16, 1967 · N2905N · Substantial damage NTSB CHI68F0233Accident · Minor injuriesClosedCessna 140 · Bunker Hill, ILAug 13, 1967 · N89480 · Substantial damage NTSB CHI68F0152Accident · No injuriesClosedCessna 140 · Bartonville, ILJul 20, 1967 · N89912 · Substantial damage NTSB CHI68F0126Accident · Minor injuriesClosedCessna 140 · Roselle, ILJun 6, 1967 · N241V · Destroyed NTSB CHI67D0589Accident · No injuriesClosedCessna 140 · Spring Bay, ILAug 24, 1966 · N1965N · Substantial damage NTSB CHI66F0730Accident · No injuriesClosedCessna 140 · Springfield, ILApr 3, 1966 · N77365 · Substantial damage NTSB CHI66F0580Accident · No injuriesClosedCessna 140 · Sycamore, ILFeb 4, 1966 · N81093 · Substantial damage NTSB CHI66F0209Accident · No injuriesClosedCessna 140 · Trivoli, ILAug 17, 1965 · N4158N · Substantial damage NTSB CHI66F0061Accident · No injuriesClosedCessna 140 · East Moline, ILJun 12, 1965 · N1891V · Substantial damage NTSB CHI66F0206Accident · No injuriesClosedCessna 140 · Joliet, ILJun 9, 1965 · N2353V · Substantial damage NTSB CHI65D0048Accident · No injuriesClosedCessna 140 · Sugar Grove, ILFeb 14, 1965 · N76095 · Substantial damage NTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · Destroyed NTSB UNK64X3918Accident · No injuriesClosedCessna 140 · Chicago, ILSep 11, 1964 · N89049 · Substantial damage NTSB UNK64X3727Accident · No injuriesClosedCessna 140 · Northbrook, ILSep 1, 1964 · N89918 · Substantial damage NTSB UNK64X2652Accident · No injuriesClosedCessna 140 · Marissa, ILJul 5, 1964 · N89838 · Substantial damage NTSB UNK64X1709Accident · No injuriesClosedCessna 140 · Atwood, ILMay 10, 1964 · N76501 · Substantial damage NTSB UNK64X1699Accident · Minor injuriesClosedCessna 140 · Glenwood, ILMay 10, 1964 · N89671 · Substantial damage NTSB UNK64X1687Accident · No injuriesClosedCessna 140 · Hamilton, ILMay 9, 1964 · N1621V · Substantial damage NTSB UNK64X0312Accident · No injuriesClosedCessna 140 · Huey, ILJan 21, 1964 · N76421 · Substantial damage