Skip to content

NTSB investigations: Cessna 140, OK

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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN20CA350Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Olustee, OKThe pilot's decision to attempt a takeoff from the middle of the runway in shifting wind conditions, which resulted in an aborted takeoff and runway excursion.Aug 18, 2020 · N2207N · Substantial damage NTSB CEN13CA189Accident · No injuriesData collectionFinal reportCessna 140 · El Reno, OKThe pilot's failure to maintain control during takeoff. Contributing to the accident was the check pilot's delayed remedial action.Mar 11, 2013 · N90047 · Substantial damage NTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportCessna 140 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.Aug 1, 2004 · N2632N · 2 aircraft · Substantial damage NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.Apr 26, 2000 · N76176 · Substantial damage NTSB FTW98LA159Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Norman, OKThe pilot's improper compensation for wind conditions, which resulted in a loss of directional control and collision with a ditch. A contributing factor was the high crosswind.Mar 25, 1998 · N2044N · Substantial damage NTSB FTW89LA003Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Fairfax, OKThe plt reported that the engine locked and he made a forced landing in a muddy, plowed field. The airplane landed hard and the plt received a fracture to the skull just above his right eye. During engine teardown, the head from the exhaust valve on the…Oct 11, 1988 · N11191 · Substantial damage NTSB FTW81DPJ40Accident · No injuriesClosedCessna 140 · Thomas, OKSep 19, 1981 · N76915 · Substantial damage NTSB FTW74AF087Accident · 2 fatalClosedCessna 140 · Sand Springs, OKMay 27, 1974 · N76819 · Destroyed NTSB FTW73FPJ13Accident · No injuriesClosedCessna 140 · Goldsby, OKMar 28, 1973 · N3548V · Substantial damage NTSB FTW72DPJ45Accident · No injuriesClosedCessna 140 · Woodward, OKJun 25, 1972 · N76568 · Substantial damage NTSB FTW72DPJ39Accident · No injuriesClosedCessna 140 · Yukon, OKMay 2, 1972 · N2875N · Substantial damage NTSB FTW72DPJ28Accident · No injuriesClosedCessna 140 · Boise City, OKJan 7, 1972 · N2397V · Substantial damage NTSB FTW70F0331Accident · No injuriesClosedCessna 140 · Sand Springs, OKDec 17, 1969 · N89240 · Substantial damage NTSB FTW70D0190Accident · No injuriesClosedCessna 140 · Enid, OKAug 31, 1969 · N2020N · Substantial damage NTSB FTW69D0422Accident · No injuriesClosedCessna 140 · Weatherford, OKApr 3, 1969 · N77053 · Substantial damage NTSB FTW69D0210Accident · No injuriesClosedCessna 140 · Perkins, OKSep 20, 1968 · N1699V · Substantial damage NTSB FTW69F0187Accident · No injuriesClosedCessna 140 · Afton, OKSep 13, 1968 · N72438 · Substantial damage NTSB FTW68F0422Accident · No injuriesClosedCessna 140 · Ponca City, OKJan 21, 1968 · N72750 · Substantial damage NTSB FTW68D0093Accident · No injuriesClosedCessna 140 · Carrier, OKJul 13, 1967 · N72510 · Substantial damage NTSB FTW68D0091Accident · No injuriesClosedCessna 140 · Blackwell, OKJul 11, 1967 · N72750 · Substantial damage NTSB FTW67F0645Accident · No injuriesClosedCessna 140 · Okla.City, OKJun 3, 1967 · N77053 · Substantial damage NTSB FTW67F0571Accident · No injuriesClosedCessna 140 · Tulsa, OKMay 8, 1967 · N4274N · Substantial damage NTSB FTW67F0481Accident · Serious injuriesClosedCessna 140 · Marlow, OKMar 3, 1967 · N90045 · Substantial damage NTSB FTW66F0307Accident · Minor injuriesClosedCessna 140 · Tulsa, OKSep 4, 1965 · N76029 · Substantial damage NTSB FTW66D0149Accident · Minor injuriesClosedCessna 140 · Cashion, OKJul 15, 1965 · N72688 · Substantial damage NTSB FTW65F0023Accident · Minor injuriesClosedCessna 140 · Tulsa, OKApr 14, 1965 · N1794V · Substantial damage NTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKSep 9, 1964 · N2228V · Substantial damage NTSB UNK64X1603Accident · No injuriesClosedCessna 140A · Frederick, OKMay 3, 1964 · N72385 · Substantial damage