Skip to content

NTSB investigations: Cessna 140, NY

32 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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.Jul 5, 2014 · N76850 · Substantial damage NTSB NYC98LA147Accident · No injuriesLimited investigationFinal reportCessna 140 · Gansevoort, NYThe pilot's decision to continue the landing attempt too far down the runway.Jul 19, 1998 · N1689V · Substantial damage NTSB NYC96LA010Accident · No injuriesLimited investigationFinal reportCessna 140 · Albion, NYthe pilot's inadequate planning/decision and compensation for wind conditions, resulting in the airplane nosing over during the taxi.Oct 15, 1995 · N72239 · Substantial damage NTSB NYC91LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · Lancaster, NYThe failure of an engine exhaust valve, which resulted in a loss of engine power and a forced landing on unsuitable terrain.Jun 30, 1991 · N89209 · Substantial damage NTSB NYC90LA185Accident · No injuriesLimited investigationFinal reportCessna 140 · Middlesex, NYThe student pilot's failure to execute a go-around. Factors which contributed to the accident was his misjudgement of speed and distance which resulted in overshooting the landing.Aug 4, 1990 · N76850 · Substantial damage NTSB NYC88LA103Accident · No injuriesLimited investigationFinal reportCessna 140 · Schroon Lake, NYDuring landing roll on a frozen lake, the left landing gear dug into a soft spot. The aircraft nosed over and was substantially damaged. In his recommendation for prevention of this acc, the plt said 'by not lndg on ice.'Mar 6, 1988 · N89431 · Substantial damage NTSB NYC83LA243Accident · No injuriesLimited investigationFinal reportCessna 140 · Fishers Island, NYThe student plt stated that he had landed on rwy 07 & was taxing along the rwy to the tiedown area when he applied brakes & the acft nosed over.Sep 15, 1983 · N1856V · Substantial damage NTSB NYC77FHJ20Accident · No injuriesClosedCessna 140 · Farmingdale, NYMay 20, 1977 · N72112 · Substantial damage NTSB NYC77FFA23Accident · No injuriesClosedCessna 140 · Potsdam, NYMay 11, 1977 · N89759 · Substantial damage NTSB NYC77DFA19Accident · No injuriesClosedCessna 140 · Monticello, NYApr 9, 1977 · N2752N · Substantial damage NTSB NYC75FFJ25Accident · No injuriesClosedCessna 140 · Corfu, NYJun 17, 1975 · N2671N · Substantial damage NTSB NYC75FFJ16Incident · No injuriesClosedCessna 140 · Orchard Park, NYNov 3, 1974 · N89624 · Minor damage NTSB NYC74FHJ24Accident · No injuriesClosedCessna 140 · White Plains, NYApr 11, 1974 · N89352 · Substantial damage NTSB NYC73FFJ11Accident · No injuriesClosedCessna 140 · Etna, NYOct 11, 1972 · N89814 · Substantial damage NTSB NYC73FFA17Accident · Minor injuriesClosedCessna 140 · Postenkill, NYSep 16, 1972 · N2897N · Substantial damage NTSB NYC73FFA13Accident · Serious injuriesClosedCessna 140 · Knox, NYSep 10, 1972 · N3054N · Substantial damage NTSB NYC70DFJ07Accident · No injuriesClosedCessna 140 · Bergen, NYFeb 1, 1970 · N76513 · Substantial damage NTSB NYC70F0215Accident · Serious injuriesClosedCessna 140 · Hammondsport, NYNov 23, 1969 · N1639V · Destroyed NTSB NYC70A0047Accident · 1 fatalClosedCessna 140 · Middleport, NYOct 26, 1969 · N2389V · Substantial damage NTSB NYC70D0084Accident · No injuriesClosedCessna 140 · Austerlitz, NYAug 9, 1969 · N76833 · Substantial damage NTSB NYC69D0389Accident · No injuriesClosedCessna 140 · Cicero, NYMar 18, 1969 · N76853 · Substantial damage NTSB NYC69F0270Accident · No injuriesClosedCessna 140 · Camillus, NYNov 23, 1968 · N76051 · Substantial damage NTSB NYC68F0473Accident · No injuriesClosedCessna 140 · Ithaca, NYApr 22, 1968 · N2897N · Substantial damage NTSB NYC68D0377Accident · No injuriesClosedCessna 140 · Middletown, NYJan 20, 1968 · N89123 · Substantial damage NTSB NYC68D0101Accident · No injuriesClosedCessna 140 · Hopewell Jctn, NYJul 29, 1967 · N72319 · Substantial damage NTSB NYC67D0651Accident · No injuriesClosedCessna 140 · Poughkeepsie, NYApr 29, 1967 · N76833 · Substantial damage NTSB NYC67D0295Accident · No injuriesClosedCessna 140 · Lindenhurst, NYSep 28, 1966 · N89262 · Substantial damage NTSB NYC67D0285Accident · No injuriesClosedCessna 140 · Spring Valley, NYAug 28, 1966 · N4022N · Substantial damage NTSB NYC67F0113Accident · No injuriesClosedCessna 140 · Ilion, NYJul 15, 1966 · N1931N · Substantial damage NTSB NYC66D0699Accident · No injuriesClosedCessna 140 · Inlet, NYMay 20, 1966 · N72954 · Substantial damage NTSB NYC66D0666Accident · No injuriesClosedCessna 140 · Montgomery, NYMay 4, 1966 · N1866V · Substantial damage NTSB NYC66F0102Accident · No injuriesClosedCessna 140 · Cambridge, NYJun 6, 1965 · N76065 · 2 aircraft · Substantial damage