Skip to content

NTSB investigations: Cessna 140, AR

18 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

19652026

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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN13LA454Accident · No injuriesLimited investigationFinal reportCessna 140 · Jonesboro, ARThe pilot's improper flare and recovery from a bounced landing and his delay in performing an aborted landing.Jul 31, 2013 · N2745N · Substantial damage NTSB DFW06LA007Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Big Flat, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.Oct 16, 2005 · N72901 · Substantial damage NTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.Aug 10, 2003 · N72971 · Substantial damage NTSB FTW91LA152Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ward, ARThe pilot's failure to maintain directional control.Aug 23, 1991 · N2559N · Substantial damage NTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…Jun 1, 1986 · N89247 · 2 aircraft · Destroyed NTSB MKC86LA038Accident · No injuriesLimited investigationFinal reportCessna 140 · Coy, ARThe pilot reports that the engine of N3587V was run at idle for an extended time before the takeoff was attempted. After several minutes, the engine died. It was restarted and the takeoff was commenced immediately. According to the pilot, the engine was…Dec 21, 1985 · N3587V · Substantial damage NTSB FTW82DA050Accident · No injuriesFinal reportCessna 140 · Bald Knob, ARAn estimate two hours of fuel was observed in the aircraft during the preflight inspection. About 24 minutes after takeoff, the engine lost power during takeoff from a touch and go landing. The power loss occurred at about 100 to 150 ft AGL. The instructor…Jan 30, 1982 · N3041N · Substantial damage NTSB FTW77DPG29Accident · No injuriesClosedCessna 140 · Marion, ARApr 28, 1977 · N76713 · Substantial damage NTSB FTW74FPG47Accident · No injuriesClosedCessna 140 · Dalark, ARFeb 19, 1974 · N89792 · Substantial damage NTSB FTW72FPG19Accident · No injuriesClosedCessna 140 · N Little Rock, ARAug 6, 1971 · N2025V · Substantial damage NTSB FTW70DPG32Accident · No injuriesClosedCessna 140 · Springdale, ARJun 8, 1970 · N89846 · Substantial damage NTSB FTW70FRG04Accident · No injuriesClosedCessna 140 · Springdale, ARJan 15, 1970 · N89846 · Substantial damage NTSB FTW70F0278Accident · Minor injuriesClosedCessna 140 · Pineville, ARSep 30, 1969 · N90017 · Substantial damage NTSB FTW69D0238Accident · No injuriesClosedCessna 140 · Van Buren, ARSep 18, 1968 · N89173 · Substantial damage NTSB FTW68D0581Accident · No injuriesClosedCessna 140 · Clinton, ARMay 4, 1968 · N89323 · Substantial damage NTSB FTW67F0191Accident · No injuriesClosedCessna 140 · Brinkley, ARAug 30, 1966 · N1408U · Substantial damage NTSB FTW67F0167Accident · Serious injuriesClosedCessna 140 · Jonesboro, ARJul 24, 1966 · N3192N · Destroyed NTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARAug 3, 1965 · N89234 · Substantial damage