NTSB investigations: Cessna 140, 1986
16 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
Open the mapLatest 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\") = 1986
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") = 1986
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 MIA86LA247Accident · No injuriesLimited investigationFinal reportCessna 140 · Jacksonville, FLThe accident occurred while practicing takeoffs and landings in a grass area adjacent to the asphalt runway. The aircraft contacted soft mud during the landing roll and nosed over.NTSB MKC86LA186Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Festus, MOThe student plt was on his 2nd solo flt & was practicing stop & go landings. He said that during a landing, he applied brakes before the left main landing gear was on the rwy. The acft swerved to the right & the left main gear collapsed. The plt received a…NTSB LAX86LA310Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Oroville, CAA Cessna 140 nosed over in a ditch after aborting a takeoff. The plt indicated he was practicing stop and go landings. During the last landing the right brake was inadvertently applied and the acft veered to the right off the rwy. The plt initiated a…NTSB DEN86FA207Accident · Serious injuriesField investigationFinal reportCessna 140 · Taos, NMN76541 took off on rwy 04 on a high density altitude day. The acft was seen climbing with the nose high near the departure end of the rwy. The acft just cleared some electrical lines near the end of the rwy and then was observed to descend down to a height…NTSB LAX86LA298Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZA Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right…NTSB LAX86LA256Accident · No injuriesLimited investigationFinal reportCessna 140 · Pacoima, CAThe plt lost control of the acft during landing. A witness stated that when the acft was about one-fourth of the way down the rwy, it began porpoising and then flipped over on its back.NTSB NYC86LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Meriden, CTDirectional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing 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…NTSB ANC86LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Bradley Ski, AKThe pilot stated that after touchdown he lost control of the aircraft causing the plane to nose over on its back. At the time of the accident the wind was less than six knots.NTSB DEN86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Riverton, WYThe plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…NTSB CHI86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Remington, INThe aircraft's engine quit at about 200 feet AGL during takeoff climb. The pilot executed a forced landing into a plowed field and the aircraft nosed over. The pilot stated that he believed the fuel selector was in the incorrect position. Examination revealed…NTSB LAX86LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe purpose of the dual instructional flight was for the instructor pilot to check out a private pilot in the conventional gear Cessna 140 aircraft. After a series of uneventful full stop & touch & go landings, the student was directed to land. The CFI & a…NTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.NTSB LAX86LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Rio Linda, CAOn March 20, 1986, a Cessna 140 nosed over in mud after running off runway 17. VMC prevailed at the time. The aircraft was substantially damaged and the pilot and his passenger were not injured. The pilot stated he was too fast on his approach and ran off the…NTSB LAX86LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Rancho Murieta, CAOn February 8, 1986 at 1530 PST a Cessna 140 landed hard and nosed over on the runway. VMC prevailed at the time. The pilot indicated that on landing he flared too high and landed hard. His feet slipped on the pedals and inadvertently applied the brakes which…NTSB SEA86LA036Accident · No injuriesLimited investigationFinal reportCessna 140 · Ione, ORThe pilot attempted to fly his newly purchased aircraft a distance of 3 miles from one local airstrip to another for the purpose of hangaring it. A ceiling of 500 feet overcast with 5 miles visibility fog and freezing rain were present. The windscreen iced up…