NTSB investigations: Cessna 140, NE
25 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 2 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1991 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 2007 | 1 |
| 2018 | 1 |
| 2022 | 1 |
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 c.\"eventStateOrRegion\" = 'NE' 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" = 'NE' 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" 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 ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…NTSB GAA18CA495Accident · No injuriesData collectionFinal reportCessna 140 · Hayes Center, NEThe pilot's failure to maintain directional control during landing.NTSB CHI07CA274Accident · No injuriesData collectionFinal reportCessna 140 · Grant, NEThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.NTSB CHI98LA272Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Falls City, NEthe main landing gear leg fracturing and separating from the portion mounted to the fuselage for undetermined reasons.NTSB CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.NTSB CHI92LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbury, NEThe pilot's improper use of the brakes. An associated factor is the pilot's lack of total experience in the type airplane.NTSB CHI91LA066Accident · No injuriesLimited investigationFinal reportCessna 140 · So. Sioux City, NEDirectional control not maintained by the pilot-in-command. Factors related to the accident were a snow covered runway and a lack of recent experience.NTSB MKC83LA070Accident · No injuriesLimited investigationFinal reportCessna 140 · Scottsbluff, NEThe aircraft made a hard landing while landing at Scottsbluff NE during a pleasure flight. The aircraft was landing on runway 30 with the wind from 350 degrees at 8 KTS. A witness said the aircraft bounced 2 times before groundlooping off the left side of the…NTSB MKC83LA034Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, NERight landing gear collapsed during landing. A hole was found drilled through strut. The hole was not shown on parts catalog.NTSB MKC78FA043Accident · 2 fatalClosedCessna 140 · Wolbach, NENTSB MKC77DCJ39Accident · No injuriesClosedCessna 140 · Kimball, NENTSB MKC76FCJ45Accident · Serious injuriesClosedCessna 140 · Elgin, NENTSB MKC76DCJ44Accident · No injuriesClosedCessna 140 · York, NENTSB MKC74DCJ47Accident · No injuriesClosedCessna 140 · Papillion, NENTSB MKC74DCJ33Accident · No injuriesClosedCessna 140 · Gordon, NENTSB MKC73FCJ02Accident · Minor injuriesClosedCessna 140 · North Platte, NENTSB MKC72DCJ48Accident · No injuriesClosedCessna 140 · Lincoln, NENTSB MKC71DCJ50Accident · No injuriesClosedCessna 140 · Omaha, NENTSB MKC71FCJ16Accident · No injuriesClosedCessna 140 · Lincoln, NENTSB MKC69F0354Accident · No injuriesClosedCessna 140 · Grand Island, NENTSB MKC69F0147Accident · No injuriesClosedCessna 140 · Thedford, NENTSB MKC67D0610Accident · No injuriesClosedCessna 140 · Norfolk, NENTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NENTSB MKC66F0117Accident · No injuriesClosedCessna 140 · Omaha, NENTSB UNK64X1139Accident · No injuriesClosedCessna 140 · Ord, NE