Skip to content

NTSB investigations: Cessna 140, IN

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN22LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Kokomo, INThe pilot’s decision to perform the takeoff on the soft, wet, turf runway, with the tailwheel equipped airplane, which resulted in a nose-over.Feb 28, 2022 · N72831 · Substantial damage NTSB CEN16CA360Accident · No injuriesData collectionFinal reportCessna 140 · Lebanon, INPC The unseen standing water on the runway that abruptly slowed the tailwheel equipped airplane during landing resulting in a nose-over.Aug 25, 2016 · N2614N · Substantial damage NTSB CEN10CA387Accident · No injuriesData collectionFinal reportCessna 140 · Franklin, INThe pilot's improper touchdown point and excessive braking, which resulted in a nose over.Jul 10, 2010 · N72609 · Substantial damage NTSB CHI01LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · La Porte, INthe inadequate planned approach by the pilot. Contributing factors were the fuel starvation and tailwind.Jun 8, 2001 · N89320 · Substantial damage NTSB CHI89LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Terre Haute, INPilot's inability to maintain directional control during the takeoff roll. A factor in the accident was the crosswind.May 12, 1989 · N77201 · Substantial damage NTSB CHI86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Remington, INThe aircraft's engine quit at about 200 feet AGL during takeoff climb. The pilot executed a forced landing into a plowed field and the aircraft nosed over. The pilot stated that he believed the fuel selector was in the incorrect position. Examination revealed…Apr 19, 1986 · N76460 · Substantial damage NTSB CHI86LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Rochester, INUpon takeoff and after reaching an altitude of approx ten feet the right side of the cowl became unlatched and whipped up into the airstream, blocking the pilots forward view and causing some control problems. He elected to abort the takeoff and ran off the…Dec 7, 1985 · N4155N · Substantial damage NTSB CHI80DEX22Accident · Minor injuriesClosedCessna 140A · E Enterprise, INJul 7, 1980 · N3547V · Substantial damage NTSB CHI78FET34Accident · No injuriesClosedCessna 140 · Hamlet, INAug 3, 1978 · N3717V · Substantial damage NTSB CHI78FET20Accident · Minor injuriesClosedCessna 140 · Michigan City, INMay 1, 1978 · N89458 · Substantial damage NTSB CHI77BEX52Accident · No injuriesClosedCessna 140 · Anderson, INSep 25, 1977 · N76168 · Substantial damage NTSB CHI77FEX14Accident · No injuriesClosedCessna 140 · Crawfordsville, INFeb 18, 1977 · N89420 · Substantial damage NTSB CHI76FEA32Accident · No injuriesClosedCessna 140 · Cambridge City, INApr 27, 1976 · N4020N · Substantial damage NTSB CHI76FET21Accident · No injuriesClosedCessna 140 · Peru, INNov 23, 1975 · N2300N · Substantial damage NTSB CHI76DEA15Accident · No injuriesClosedCessna 140 · Reynolds, INNov 15, 1975 · N4000N · Substantial damage NTSB CHI72DEA44Accident · No injuriesClosedCessna 140 · W.Lafayette, INMay 24, 1972 · N77130 · Substantial damage NTSB CHI72DEA08Accident · No injuriesClosedCessna 140 · Lebanon, INJul 6, 1971 · N77201 · Substantial damage NTSB CHI70FBM08Accident · Serious injuriesClosedCessna 140 · Roanoke, INMar 16, 1970 · N72774 · Destroyed NTSB CHI70F0112Accident · No injuriesClosedCessna 140 · Breman, INJul 8, 1969 · N4209N · Substantial damage NTSB CHI68F0636Accident · No injuriesClosedCessna 140 · Goshen, INMar 1, 1968 · N76043 · Substantial damage NTSB CHI68F0614Accident · Serious injuriesClosedCessna 140 · Terre Haute, INFeb 8, 1968 · N76407 · Substantial damage NTSB CHI68D0348Accident · No injuriesClosedCessna 140 · Brownsburg, INSep 3, 1967 · N2848N · Substantial damage NTSB CHI67F0467Accident · No injuriesClosedCessna 140 · Elkhart, INFeb 5, 1967 · N2264V · Substantial damage NTSB CHI67F0520Accident · Minor injuriesClosedCessna 140 · Rosedale, INDec 25, 1966 · N2919N · Substantial damage NTSB CHI66D0612Accident · No injuriesClosedCessna 140 · Flora, INFeb 5, 1966 · N89361 · Substantial damage NTSB CHI66F0202Accident · No injuriesClosedCessna 140 · Mooresville, INAug 14, 1965 · N3627V · Substantial damage NTSB CHI66D0069Accident · No injuriesClosedCessna 140 · Clay City, INJun 16, 1965 · N2446N · Substantial damage NTSB CHI66F0027Accident · No injuriesClosedCessna 140 · Ramsey, INMay 29, 1965 · N76735 · Substantial damage NTSB CHI65F0046Accident · No injuriesClosedCessna 140 · Woodburn, INJan 30, 1965 · N1992V · Substantial damage NTSB UNK64X2088Accident · No injuriesClosedCessna 140 · Decatur, INJun 3, 1964 · N76537 · Substantial damage NTSB UNK64X1987Accident · No injuriesClosedCessna 140 · Libertyville, INMay 28, 1964 · N2919N · Substantial damage