NTSB investigations: Cessna 140, 1987
12 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.
Cases per year
| 1964 | 108 |
|---|---|
| 1965 | 106 |
| 1966 | 80 |
| 1967 | 95 |
| 1968 | 74 |
| 1969 | 66 |
| 1970 | 50 |
| 1971 | 44 |
| 1972 | 55 |
| 1973 | 40 |
| 1974 | 46 |
| 1975 | 31 |
| 1976 | 23 |
| 1977 | 32 |
| 1978 | 24 |
| 1979 | 18 |
| 1980 | 14 |
| 1981 | 21 |
| 1982 | 15 |
| 1983 | 23 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 16 |
| 1987 | 12 |
| 1988 | 8 |
| 1989 | 11 |
| 1990 | 11 |
| 1991 | 16 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 18 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 11 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 7 |
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 7 |
| 2012 | 1 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 9 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 9 |
| 2022 | 9 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 8 |
| 2026 | 5 |
Where
Latest cases
Query with SQL
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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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" DESCRun 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 FTW88FA024Accident · Serious injuriesField investigationFinal reportCessna 140 · Bryan, TXThe student plt took off at ngt with a passenger aboard. After takeoff, he remained in a left traffic pattern & made a low apch. Witnesses rprtd the plt then entered a rgt pattern, but the acft was lower & slower than normal as it was turning on the 2nd apch…NTSB NYC88LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · New Milford, CTThe flight en route was uneventful; however, during the landing at New Milford, CT, the aircraft's propeller struck the surface of the runway & the plane nosed over. The plt stated that he applied the brakes too harshly.NTSB DEN87LA244Accident · No injuriesLimited investigationFinal reportCessna 140 · San Ysidro, NMThe plt and pax were on a LCL sightseeing flt. The plt stated that he had been flying low and slow at a nose high attitude. The engine began to overheat and did not cool off and the pilot executed a precautionary landing on a dirt road. The acft ballooned and…NTSB ATL87LA263Accident · No injuriesLimited investigationFinal reportCessna 140 · Jesup, GADuring initial takeoff the aircraft's engine lost power and the aircraft collided with the ground. Investigation revealed the carburetor inlet filter was 50 percent plugged with rusty material and two tablespoons of rusty water remained in the carburetor…NTSB LAX87LA323Accident · No injuriesLimited investigationFinal reportCessna 140 · Gorman, CAA Cessna 140 nosed over during the landing roll after a precautionary landing to a paved access road. The plt indicated that the oil pressure and oil temp began to drop for unknown reasons while in cruise flt. The plt stated he was unable to determine the…NTSB ATL87LA183Accident · No injuriesLimited investigationFinal reportCessna 140 · Falmouth, KYThe pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the…NTSB MKC87LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Ankeny, IAWhile practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to…NTSB DEN87LA137Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Sawyer, NDThe commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private…NTSB FTW87LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Waco, TXThe pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged.NTSB MKC87LA101Accident · No injuriesLimited investigationFinal reportCessna 140 · Eldon, MOAccording to the pilot, winds were light prior to the final approach, but a gust of wind picked up the right wing and the aircraft ballooned during the flare, running out of airspeed while in a full-stall/three-point attitude. Upon impact, both main gears…NTSB MKC87LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Coeur, MOThe PIC was practicing landings in gusty crosswind conditions. PIC landed long, and after rolling a short distance, perceived that the wind direction had changed. The PIC stated that this new wind direction was now more of a tailwind. The PIC did not select a…NTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.