Skip to content

NTSB investigations: Cessna 140, IA

28 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" = 'IA' 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\" = 'IA' 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" = 'IA' 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 CHI04LA004Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Waterloo, IAThe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain control of the airplane while landing. A factor associated with the accident was the strong, gusty wind condition.Oct 3, 2003 · N72701 · Substantial damage NTSB CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.Oct 27, 1992 · N4213N · Substantial damage NTSB MKC89LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Audubon, IAThe failure of the pilot to maintain control of the airplane. Contributing to the accident were the crosswind conditions.Jan 9, 1989 · N89867 · Substantial damage NTSB MKC87LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Ankeny, IAWhile practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to…Jun 8, 1987 · N1990N · Substantial damage NTSB MKC83LA101Accident · No injuriesLimited investigationFinal reportCessna C-140 · Mt. Pleasant, IAThe pilot stated he did not make a visual check of his fuel supply prior to flight. After a 45 minute solo flight he landed at a private strip and picked up a passenger. The right fuel tank was selected and the guage was indicating in the lower red 1/4 red,…Apr 30, 1983 · N77090 · Substantial damage NTSB MKC79DCD11Accident · No injuriesClosedCessna 140 · Lamotte, IAFeb 11, 1979 · N89902 · Substantial damage NTSB MKC78DCD15Accident · No injuriesClosedCessna 140 · Shenandoah, IAJan 28, 1978 · N72750 · Substantial damage NTSB MKC78FCD06Accident · No injuriesClosedCessna 140 · Ankeny, IAOct 19, 1977 · N2419V · Substantial damage NTSB MKC76DCD57Accident · No injuriesClosedCessna 170B · Salix, IAJul 18, 1976 · N1856C · Substantial damage NTSB MKC76AK066Accident · 1 fatalClosedCessna 140 · Lake Mills, IAJul 10, 1976 · N89103 · Destroyed NTSB MKC76FCD22Accident · No injuriesClosedCessna 140 · Des Moines, IADec 6, 1975 · N2465V · Substantial damage NTSB MKC74FCD36Accident · Minor injuriesClosedCessna 140 · Logan, IAMay 28, 1974 · N89184 · Destroyed NTSB MKC74DCD30Accident · No injuriesClosedCessna 140 · Chariton, IAMay 5, 1974 · N76973 · Destroyed NTSB MKC73DCD06Accident · No injuriesClosedCessna 140 · Toledo, IAJul 23, 1972 · N1859V · Substantial damage NTSB MKC72DCD46Accident · No injuriesClosedCessna 140 · Chillicothe, IANov 7, 1971 · N1621V · Substantial damage NTSB MKC72DCD43Accident · Minor injuriesClosedCessna 140 · Mapleton, IANov 6, 1971 · N89093 · Substantial damage NTSB MKC71DCD78Accident · Serious injuriesClosedCessna 140 · Lamoni, IAApr 26, 1971 · N89355 · Destroyed NTSB MKC70F0303Accident · No injuriesClosedCessna 140 · Newton, IADec 19, 1969 · N72363 · Substantial damage NTSB MKC70A0014Accident · 2 fatalClosedCessna 140 · Hartley, IAOct 1, 1969 · N1984V · Destroyed NTSB MKC69D0359Accident · No injuriesClosedCessna 140 · Emmetsburg, IAMar 7, 1969 · N2320V · Substantial damage NTSB MKC69F0138Accident · Serious injuriesClosedCessna 140 · Lowden, IASep 4, 1968 · N3708V · Substantial damage NTSB MKC67D0297Accident · No injuriesClosedCessna 140 · Moorhead, IANov 12, 1966 · N76487 · Substantial damage NTSB MKC67D0155Accident · No injuriesClosedCessna 140 · La Porte Cty, IAAug 10, 1966 · N1999N · Substantial damage NTSB MKC67F0015Accident · No injuriesClosedCessna 140 · Des Moines, IAJun 21, 1966 · N3621V · Substantial damage NTSB MKC67D0014Accident · No injuriesClosedCessna 140 · Corning, IAJun 11, 1966 · N76644 · Substantial damage NTSB MKC65D0046Accident · No injuriesClosedCessna 140 · Davenport, IAMar 6, 1965 · N2733N · Substantial damage NTSB UNK64X4183Accident · No injuriesClosedCessna 140 · Ames, IASep 27, 1964 · N77075 · Destroyed NTSB UNK64X1905Accident · No injuriesClosedCessna 140 · Marion, IAMay 23, 1964 · N81030 · Substantial damage