NTSB investigations: Cessna 140
81 cases on aircraft the registry lists as Cessna 140, where the first occurrence was “Loss of control - on ground/water”. 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 | 7 |
| 1984 | 5 |
| 1986 | 6 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 2 |
| 2006 | 3 |
| 2007 | 3 |
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\" = 260))
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" = 260))
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 DFW07CA195Accident · No injuriesData collectionFinal reportCessna 140 · Lubbock, TXThe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the flight instructor's delay in taking remedial action.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 LAX07CA252Accident · No injuriesData collectionFinal reportCessna 140 · Olympia, WAThe pilot's failure to maintain directional control during landing.NTSB LAX07LA081Accident · No injuriesLimited investigationFinal reportCessna 140 · Van Nuys, CAFailure of the pilot under instruction to maintain directional control of the airplane and the flight instructor's inadequate supervision.NTSB DEN06CA106Accident · No injuriesData collectionFinal reportCessna 140 · Cunningham, KSthe pilot's failure to maintain directional control during the aborted takeoff. A contributing factor was the mud.NTSB ATL06CA056Accident · No injuriesData collectionFinal reportCessna 140 · Pageland, SCThe pilot's failure to maintain directional control during a crosswind landing resulting in the airplane veering to the right, colliding with a runway light, and subsequent nose over.NTSB ANC03CA081Accident · No injuriesData collectionFinal reportCessna 140 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane and excessive application of the airplane brakes during the landing roll that resulted in the airplane nosing over.NTSB CHI03LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Sullivan, WIThe pilot's inadequate compensation for wind conditions resulting in a loss of directional control. A factor contributing to the accident was the crosswind.NTSB CHI02LA225Accident · No injuriesLimited investigationFinal reportCessna 140 · Cook, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB FTW02LA126Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Powderly, TXthe pilot's failure to maintain directional control during the takeoff roll, which resulted in an encounter with muddy terrain and a nose over. Contributing factors to the accident were the crosswind and muddy terrain.NTSB LAX01LA260Accident · No injuriesLimited investigationFinal reportCessna 140 · San Luis Obispo, CAThe pilot's failure to maintain directional control during landing that resulted in dragging the wing and nosing over.NTSB CHI01LA210Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe pilot failed to maintain directional control of the airplane during the landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing and his lack of experience in the make and model of the accident airplane.NTSB FTW01LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Fort Worth, TXthe inadvertent ground loop during the landing roll. A contributing factor was the gusty crosswind.NTSB LAX01LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · San Jose, CAThe failure of the pilot to maintain directional control during landing.NTSB LAX01LA044Accident · No injuriesLimited investigationFinal reportCessna 140 · Sacramento, CAThe pilot's failure to maintain directional control on landing rollout.NTSB NYC00LA168Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Turner, METhe pilot's failure to maintain directional control after landing. A factor in this accident was the high grass along the runway edge which disguised an embankment.NTSB LAX00LA228Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Hayfork, CAThe failure of the pilot under instruction to maintain directional control during the landing roll and the inadequate supervision of the flight instructor, which resulted in a collision with a runway light, overload failure of the wheel axle, and the airplane…NTSB SEA00LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Creswell, ORThe pilot's failure to maintain directional control. Factors include a drainage ditch and a crosswind.NTSB FTW00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Weir, TXThe delayed aborted takeoff by the pilot. Factors were the pilot's intentional ground loop/swerve and the tail wind.NTSB SEA00LA029Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Port Townsend, WACompensation for wind conditions was inadequate. Gusting wind conditions were a factor.NTSB NYC99LA201Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Zanesville, OHThe pilot's failure to maintain directional control.NTSB NYC99LA166Accident · No injuriesLimited investigationFinal reportCessna 140 · Beckley, WVThe pilot's loss of aircraft control during the landing roll, which resulted in an inadvertent ground loop.NTSB ANC99LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Sitka, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and the pilot's lack of total experience in the type of airplane.NTSB ANC99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot misjudged his altitude and airspeed, and his failure to maintain directional control of the airplane. Factors in the accident were a wet grass runway, and the pilot's excessive application of the brakes.NTSB DEN99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMThe pilot's excessive use of rudder while attempting to correct for loss of directional control. Factors were the pilot's loss of directional control, and his lack of experience in the type of airplane.NTSB NYC98LA084Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, NJThe pilot in commands improper recovery from a bounced landing.NTSB LAX98LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Goodyear, AZThe inadvertent brake activation by the student pilot while practicing touch-and-go landings.NTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.NTSB LAX97LA273Accident · No injuriesLimited investigationFinal reportCessna 140 · Pacoima, CAThe pilot's failure to maintain directional control of the aircraft during landing.NTSB LAX97LA223Accident · No injuriesLimited investigationFinal reportCessna 140 · Columbia, CAthe student pilot's failure to maintain directional control of the aircraft during a bounced landing recovery.NTSB ATL96LA072Accident · No injuriesLimited investigationFinal reportCessna 140 · Elkin, NCfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB CHI96LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · Ulysses, KSFailure of the pilot to maintain directional control of the airplane during the takeoff roll, and his improper use of brakes and elevator control, while aborting the takeoff. A factor relating to the accident was the gusty wind condition.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.NTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.NTSB SEA94LA161Accident · No injuriesLimited investigationFinal reportCessna 140 · Kent, WAInadequate compensation for wind conditions. A factor to the accident was wind gust.NTSB LAX94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ramona, CAa failure of the pilot to maintain directional control of the airplane. A lack of total experience in tailwheel type airplanes was a factor in the accident.NTSB FTW94LA148Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Lancaster, TXThe pilot's failure to use tie downs and proper assistance during the hand propping engine start.NTSB BFO94LA072Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Clarion, PAThe pilot's failure to maintain directional control which resulted in an overrun of the runway and collision with a berm.NTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.NTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB ANC93LA104Accident · No injuriesLimited investigationFinal reportCessna 140 · Juneau, AKThe pilot's failure to maintain directional control. A factor to the accident was the pilot's lack of total experience.NTSB ANC93LA073Accident · No injuriesLimited investigationFinal reportCessna 140 · Dillingham, AKThe pilot in command's failure to maintain proper runway alignment.NTSB CHI93LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Warren, MNThe pilot's inadequate compensation for variable wind conditions during landing. The crosswind was a factor.NTSB LAX92LA364Accident · No injuriesLimited investigationFinal reportCessna 140 · Reedley, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll and his excessive use of the brakes.NTSB CHI92LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Minneapolis, MNRemedial action was not performed by the CFI. A factor related to the accident was directional control was not maintained by the student pilot.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 FTW91LA152Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ward, ARThe pilot's failure to maintain directional control.NTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.