Skip to content

NTSB investigations: Cessna 140, WI

31 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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CEN26LA193Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rice Lake, WIThe pilot’s failure to maintain directional control during landing.May 20, 2026 · N2307V · Substantial damage NTSB CEN26LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Antigo, WIThe pilot receiving instruction’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed remedial action.Feb 16, 2026 · N2221V · Substantial damage NTSB CEN24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Hayward, WIThe pilot’s loss of control during landing rollout.Feb 2, 2024 · N1887V · Substantial damage NTSB CEN20CA194Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Appleton, WIThe pilot's loss of control while landing a tailwheel airplane.May 26, 2020 · N90023 · Substantial damage NTSB CEN11LA448Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Burlington, WIThe improper installation of the fuel selector indicator handle, which resulted in a total loss of engine power due to fuel starvation.Jun 29, 2011 · N2332V · Substantial damage NTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.May 9, 2008 · N89307 · Substantial damage NTSB CHI03LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Sullivan, WIThe pilot's inadequate compensation for wind conditions resulting in a loss of directional control. A factor contributing to the accident was the crosswind.Jul 13, 2003 · N2180V · Substantial damage NTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.Jun 9, 1992 · N2776N · Substantial damage NTSB CHI91LA177Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Depere, WIThe pilot's failure to correct a mushed stall during liftoff. A factor in the accident was the pilot's failure to compensate for wind conditions.May 31, 1991 · N4090N · Destroyed NTSB CHI83LA074Accident · No injuriesLimited investigationFinal reportCessna 140 · Springbrook, WIThe acft collided with a four ft snowbank at the rwy threshold during landing. This was a dual instructional flt with the student in the right seat. The CFI had made no landings in this make and model of acft in the previous 90 days. The pilot stated that due…Jan 1, 1983 · N89399 · Substantial damage NTSB CHI82DA201Accident · No injuriesFinal reportCessna 140 · Stevens Point, WIDuring arrival, the pilot entered traffic for runway 21. The wind was from 180 degrees at 15 gusting to 35 KTS. The pilot stated that while on final approach, he slipped the plane to the right to land on the grass, but went beyond the smooth grass. After…Jun 6, 1982 · N3103N · Substantial damage NTSB CHI82DEP12Accident · No injuriesClosedCessna 140 · Hayward, WINov 27, 1981 · N3174N · Substantial damage NTSB CHI79FA054Accident · 2 fatalClosedCessna 140 · Springbrook, WIJul 1, 1979 · N1972J · Destroyed NTSB CHI77DEP05Accident · Minor injuriesClosedCessna 140 · Brookfield, WINov 20, 1976 · N2168V · Substantial damage NTSB CHI76DEP21Accident · No injuriesClosedCessna 140 · Kenosha, WIJan 18, 1976 · N701F · Substantial damage NTSB CHI75DEP56Accident · No injuriesClosedCessna 140 · Reedsville, WIMay 21, 1975 · N1893V · Destroyed NTSB CHI75DEP14Accident · No injuriesClosedCessna 140 · Shawano, WIAug 2, 1974 · N77253 · Substantial damage NTSB CHI70FDJ27Accident · No injuriesClosedCessna 140 · Lyndon Stn, WIJun 27, 1970 · N89231 · Substantial damage NTSB CHI70D0298Accident · No injuriesClosedCessna 140 · Chilton, WIAug 24, 1969 · N1999V · Substantial damage NTSB CHI68D0523Accident · No injuriesClosedCessna 140 · Fitchburg, WIDec 24, 1967 · N1914N · Substantial damage NTSB CHI68D0411Accident · No injuriesClosedCessna 140 · Norwalk, WIOct 21, 1967 · N89033 · Substantial damage NTSB CHI68D0075Accident · No injuriesClosedCessna 140 · Rockland, WIJun 25, 1967 · N89943 · Substantial damage NTSB CHI67D0185Accident · No injuriesClosedCessna 140 · Pewaukee, WIAug 29, 1966 · N76708 · Substantial damage NTSB CHI67D0029Accident · No injuriesClosedCessna 140 · Madison, WIJun 10, 1966 · N72919 · Substantial damage NTSB CHI66F0666Accident · No injuriesClosedCessna 140 · Milwaukee, WIApr 16, 1966 · N89523 · Substantial damage NTSB CHI66D0165Accident · No injuriesClosedCessna 140 · Milwaukee, WIJul 10, 1965 · N89657 · Substantial damage NTSB UNK65X0242Accident · No injuriesClosedCessna 140 · Palmyra, WIOct 11, 1964 · N2050V · Destroyed NTSB UNK64X3423Accident · Minor injuriesClosedCessna 140 · Waukesea, WIAug 16, 1964 · N89345 · Destroyed NTSB UNK64X3195Accident · No injuriesClosedCessna 140 · Janesville, WIAug 3, 1964 · N2084V · Substantial damage NTSB UNK64X1028Accident · No injuriesClosedCessna 140 · Lake Tomahawk, WIMar 24, 1964 · N2907N · Substantial damage NTSB UNK64X0947Accident · No injuriesClosedCessna 140 · Watertown, WIMar 15, 1964 · N4118N · Substantial damage