Skip to content

NTSB investigations: Cessna 140, VA

24 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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA26LA079Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 140 · Ceres, VAThe pilot’s failure to recognize and mitigate carburetor icing, which resulted in a partial loss of engine power and forced landing.Dec 27, 2025 · N89884 · Substantial damage NTSB ERA26LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Suffolk, VAThe pilot’s failure to maintain control of the airplane during landing, which resulted in a nose over.Nov 6, 2025 · N1860V · Substantial damage NTSB ERA14CA412Accident · No injuriesData collectionFinal reportCessna 140 · Luray, VAA loss of control and subsequent runway excursion while attempting to avoid a collision with a deer on takeoff.Aug 25, 2014 · N436DC · Substantial damage NTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.Sep 5, 2009 · N3656V · 2 aircraft · Minor damage NTSB IAD04CA002Accident · No injuriesData collectionFinal reportCessna 140 · Ridegway, VAThe pilot's improper pre-flight planning, which resulted in an engine failure due to fuel exhaustion.Oct 7, 2003 · N2370N · Substantial damage NTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.May 9, 2003 · N72942 · Substantial damage NTSB IAD97LA013Accident · No injuriesLimited investigationFinal reportCessna 140 · Wakefield, VAuncommanded operation of the parking brake, due to a missing tension spring, which resulted in locked brakes and subsequent nose over of the airplane during landing.Oct 26, 1996 · N83N · Substantial damage NTSB BFO88LA021Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Orange, VAAccording to the plt, during the landing roll the acft drifted to the right and before he could take corrective action the acft ground looped. He had 3 hrs of total time in this make/model acft. The plt rptd he was late applying corrective rudder forces. He…Feb 17, 1988 · N2300N · Substantial damage NTSB BFO85LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Chesapeake, VAThe student plt was making a takeoff from rwy 20 with an estimated 10 kt right x-wind. After about 800 ft of ground run, the acft lifted off at aprx 65 mph. At an alt of about 30 ft, the acft began to settle in a left drift as it flew abeam trees on the right…May 6, 1985 · N2034V · Substantial damage NTSB ATL84LA180Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisonburg, VAThe acft's left main landing gear strut failed during a landg. A mechanic, who examined the acft, stated that the strut had a previously existing crack prior to the accident. The strut failed at a hole where the step was attached.May 19, 1984 · N72115 · Substantial damage NTSB IAD80DID16Accident · No injuriesClosedCessna 140 · Chesapeake, VAApr 19, 1980 · N1885V · Substantial damage NTSB IAD79FA087Accident · No injuriesClosedCessna 140 · Luray, VASep 20, 1979 · N89327 · Substantial damage NTSB IAD77DID22Accident · No injuriesClosedCessna 140 · Leedsville, VAJun 24, 1977 · N72595 · Substantial damage NTSB IAD76FID05Accident · Minor injuriesClosedCessna 140 · Bassett, VAAug 17, 1975 · N2522N · Substantial damage NTSB DIA69D0189Accident · No injuriesClosedCessna 140 · Baileys Xroads, VAMay 14, 1969 · N89711 · Substantial damage NTSB DIA68D0221Accident · No injuriesClosedCessna 140 · Woodbridge, VAMay 8, 1968 · N73019 · Substantial damage NTSB DIA68F0152Accident · No injuriesClosedCessna 140 · Fredericksburg, VAJan 20, 1968 · N89535 · Substantial damage NTSB DIA68A0004Accident · Serious injuriesClosedCessna 140 · Baileys Crsrds, VAJul 27, 1967 · N76124 · Substantial damage NTSB NYC66F0249Accident · Minor injuriesClosedCessna 140 · Victoria, VAAug 28, 1965 · N89491 · Substantial damage NTSB NYC65F0101Accident · Serious injuriesClosedCessna 140 · Troutville, VAMar 6, 1965 · N76467 · Substantial damage NTSB UNK65X1393Accident · No injuriesClosedCessna 140 · Winchester, VAFeb 4, 1965 · N76511 · Substantial damage NTSB UNK65X1256Accident · No injuriesClosedCessna 140 · Orange, VAJan 9, 1965 · N76841 · Substantial damage NTSB UNK64X3537Accident · No injuriesClosedCessna 140 · Bridgewater, VAAug 22, 1964 · N72134 · Substantial damage NTSB UNK64X2103Accident · No injuriesClosedCessna 140 · Hillsboro, VAJun 4, 1964 · N2298V · Substantial damage