Skip to content

NTSB investigations: Cessna 140, OH

33 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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CEN10CA174Accident · No injuriesData collectionFinal reportCessna 140 · Malta, OHThe pilot's decision to take off in conditions that exceeded the climb capability of the airplane.Mar 23, 2010 · N2082N · Substantial damage NTSB NYC00LA194Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, OHThe pilot's improper decision to abort the takeoff. A factor in this accident was the dark night conditions.Jul 9, 2000 · N3583V · Substantial damage NTSB NYC99LA201Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Zanesville, OHThe pilot's failure to maintain directional control.Aug 15, 1999 · N89775 · Substantial damage NTSB NYC98LA083Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Milford Center, OHthe pilot's excessive application of brakes during an aborted takeoff roll.Mar 27, 1998 · N1998N · Substantial damage NTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.Jun 23, 1994 · N3627V · Destroyed NTSB NYC92LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Wauseon, OHThe pilot improperly used the brakes, resulting in the airplane nosing over.Jun 15, 1992 · N76009 · Substantial damage NTSB CHI83LA119Accident · No injuriesLimited investigationFinal reportCessna 140 · Elyria, OHThe acft veered off the left side of rwy 27 and nosed over during landing. This was the student pilots second supervisedsolo and his third landing to a full stop. The weather was VMC with the wind from 360 degrees at 4 KTS.Feb 22, 1983 · N72296 · Substantial damage NTSB CHI81FEK02Accident · No injuriesClosedCessna 140 · Sunbury, OHOct 20, 1980 · N76731 · Substantial damage NTSB CHI75FEI58Accident · No injuriesClosedCessna 140 · Youngstown, OHJun 19, 1975 · N4229N · Substantial damage NTSB CHI74DEI47Accident · No injuriesClosedCessna 140 · Wellington, OHMay 20, 1974 · N1932V · Substantial damage NTSB CHI74FEG20Accident · No injuriesClosedCessna 140 · Dayton, OHMar 28, 1974 · N72331 · Substantial damage NTSB CHI74DEI01Accident · No injuriesClosedCessna 140 · Canton, OHJul 3, 1973 · N89784 · Substantial damage NTSB CHI73FEG28Accident · Serious injuriesClosedCessna 140 · Union, OHJun 10, 1973 · N76126 · Destroyed NTSB CHI73DEK27Accident · No injuriesClosedCessna 140 · Spring Mtn, OHJun 9, 1973 · N89205 · Substantial damage NTSB CHI73AC042Accident · 1 fatalClosedCessna 140 · Gilmore, OHOct 18, 1972 · N89593 · Destroyed NTSB CHI72FEG10Accident · No injuriesClosedCessna 140 · Greenville, OHAug 30, 1971 · N89163 · Substantial damage NTSB CHI71DGD09Accident · Serious injuriesClosedCessna 140 · Brecksville, OHJul 26, 1970 · N2107N · Substantial damage NTSB CHI70FGG20Accident · No injuriesClosedCessna 140 · Chesterville, OHMay 22, 1970 · N3631V · Substantial damage NTSB CHI70DGG08Accident · No injuriesClosedCessna 140 · Lancaster, OHFeb 18, 1970 · N2421V · Substantial damage NTSB CHI70F0248Accident · No injuriesClosedCessna 140 · Columbus, OHSep 14, 1969 · N4255N · Substantial damage NTSB CHI70F0128Accident · Minor injuriesClosedCessna 140 · Findlay, OHJul 19, 1969 · N4064N · Destroyed NTSB CHI69F0349Accident · No injuriesClosedCessna 140 · Elyria, OHNov 13, 1968 · N4268N · Substantial damage NTSB CHI69F0283Accident · No injuriesClosedCessna 140 · Marysville, OHSep 29, 1968 · N76083 · Substantial damage NTSB CHI69D0329Accident · No injuriesClosedCessna 140 · Painesville, OHSep 20, 1968 · N72489 · Substantial damage NTSB CHI69F0062Accident · Minor injuriesClosedCessna 140 · Hamilton, OHJul 2, 1968 · N90156 · Destroyed NTSB CHI68F0187Accident · No injuriesClosedCessna 140 · Columbus, OHAug 12, 1967 · N4116N · Substantial damage NTSB CHI67D0427Accident · No injuriesClosedCessna 140 · Cleveland, OHDec 17, 1966 · N2424V · Substantial damage NTSB CHI66D0403Accident · No injuriesClosedCessna 140 · Cleveland, OHNov 7, 1965 · N1998V · Substantial damage NTSB CHI65F0205Accident · No injuriesClosedCessna 140 · Chesapeake, OHJun 6, 1965 · N1693V · Substantial damage NTSB CHI65F0186Accident · No injuriesClosedCessna 140 · Cincinnati, OHMay 21, 1965 · N89026 · Substantial damage NTSB CHI65D0061Accident · No injuriesClosedCessna 140 · Newark, OHApr 6, 1965 · N72782 · Substantial damage NTSB UNK64X2622Accident · No injuriesClosedCessna 140 · Uhrichsville, OHJul 3, 1964 · N77002 · Substantial damage NTSB UNK64X2580Accident · No injuriesClosedCessna 140 · Akron, OHJun 30, 1964 · N76919 · Substantial damage