NTSB investigations: Cessna 140
26 cases on aircraft the registry lists as Cessna 140, where the first occurrence was “Loss of engine power”. 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
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 4 |
| 1996 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 DFW06LA007Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Big Flat, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB ANC05LA053Accident · No injuriesLimited investigationFinal reportCessna 140 · Denali Park, AKThe loss of engine power during takeoff and cruise flight for an undetermined reason, which resulted in an emergency descent/landing, and collision with trees.NTSB FTW04LA096Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Portland, TXThe pilots failure to maintain airspeed resulting in an inadvertant stall while executing a forced landing. A factor was the loss of engine power for undetermined reasons.NTSB CHI01LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · La Porte, INthe inadequate planned approach by the pilot. Contributing factors were the fuel starvation and tailwind.NTSB NYC00LA219Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Post Mills, VTwas the pilot's improper fuel management which resulted in power loss due to fuel starvation.NTSB ATL98LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB MIA96LA178Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reason(s) during a go-around, which result in the aircraft being unable to climb above trees at the departure end of the runway.NTSB ATL96LA097Accident · No injuriesLimited investigationFinal reportCessna 140 · Jacksboro, TNloss of engine power for undetermined reason(s), which resutled in a forced landing and subsequent in-flight collision with trees and the terrain.NTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.NTSB BFO94LA158Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Ravenswood, WVThe poorly planned approach which resulted in unporting of fuel from the left fuel tank and loss of engine power due to fuel starvation.NTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.NTSB LAX94LA094Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Warner Springs, CAa loss of engine power for undetermined reasons.NTSB CHI94LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Frankenmuth, MIImproper use of the mixture control by the pilot. Factors related to the accident were: the similarity of shape, size, and color of the mixture and carburetor heat controls and the terrain condition (with crop) in the emergency landing area.NTSB SEA93LA063Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Salem, ORA complete loss of power for undetermined reasons. Factors include unsuitable terrain, and trees surrounding the forced landing site.NTSB MIA93FA051Accident · Serious injuriesField investigationFinal reportCessna 140 · Niceville, FLA loss of engine power for undetermined reasons over terrain that was not suitable for the subsequent forced landing.NTSB SEA92LA217Accident · No injuriesLimited investigationFinal reportCessna 140 · Moab, UTThe loss of engine power due to fuel exhaustion resulting from inaccurate fuel consumption calculations by the pilot. A factor relating to the accident was the terrain condition (ditch) in the landing area.NTSB ATL92LA175Accident · No injuriesLimited investigationFinal reportCessna 140 · Blairsville, GAA complete loss of engine power which resulted from two stuck exhaust valves.NTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.NTSB LAX91LA294Accident · No injuriesLimited investigationFinal reportCessna 140 · Montague, CAThe failure of an exhaust valve in the engine.NTSB BFO89LA051Accident · No injuriesLimited investigationFinal reportCessna 140 · Bridgeport, WVThe loss of engine power because of fuel starvation. Fuel starvation occurred because of unporting of fuel from the tank outlet when the aircraft was in a slip attitude shortly before the power loss. A contributing factor is inadequate information in the…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 DEN84LA287Accident · No injuriesLimited investigationFinal reportCessna 140 · Belgrade, MTThe plt stated that during the takeoff ground roll on the grass airstrip the engine did not seem to produce full power when 2/3 the way down the rwy. Plt applied brakes to abort the takeoff before the tailwheel was on the ground. The acft nosed over.NTSB SEA83FA058Accident · 1 fatalField investigationFinal reportCessna 140 · Moses Lake, WAThe flight originated at the pilots private farm strip. The pilot stated that during the flight the engine 'sputtered and died'. During a power off landing attempt the passenger grabbed the controls according to the pilot. The pilot said he fought for control…NTSB NYC83LA051Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Sussex, NJAircraft lost power after takeoff at 200 feet and pilot made a turn back towards airport for landing. Engine did not respond to pilots remedial actions. A landing was made in soft grassy terrain on the airport. During landing the right main gear separated and…NTSB FTW82DA050Accident · No injuriesFinal reportCessna 140 · Bald Knob, ARAn estimate two hours of fuel was observed in the aircraft during the preflight inspection. About 24 minutes after takeoff, the engine lost power during takeoff from a touch and go landing. The power loss occurred at about 100 to 150 ft AGL. The instructor…NTSB SEA82DA018Accident · No injuriesFinal reportCessna 140 · Spokane, WAAfter an annual inspection, the pilot made a thorough ground check and taxied out for a test flight. During takeoff, the engine lost power at about 50 ft AGL. The pilot landed on the runway overrun in about 9 inches of crusted snow and the plane nosed over.…