NTSB investigations: Cessna 140, GA
33 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 4 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 4 |
| 1977 | 4 |
| 1978 | 1 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2017 | 1 |
| 2025 | 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\" = 'GA' 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" = 'GA' 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 ERA26LA020Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Canon, GAThe pilot’s inadvertent application of brakes during the landing roll, which resulted in a noseover.NTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.NTSB MIA99LA169Accident · No injuriesLimited investigationFinal reportCessna 140 · Woodstock, GAa total loss of engine power due to fuel starvation because of contaminated fuel, resulting in a forced landing and subsequent impact with a tree.NTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.NTSB ATL92LA175Accident · No injuriesLimited investigationFinal reportCessna 140 · Blairsville, GAA complete loss of engine power which resulted from two stuck exhaust valves.NTSB ATL89FA167Accident · Serious injuriesField investigationFinal reportCessna 140 · Conyers, GACarburetor ice and the pilot's improper use of carburetor heat. Carburetor icing condition was a related factor.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 ATL84LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Wadley, GAThe plt stated that he landed too fast on the grass strip, & when he attempted to turn off the rwy onto a taxiway, the acft groundlooped.NTSB ATL82DA050Accident · No injuriesFinal reportCessna 140 · Statesboro, GADuring the second landing of a supervised solo flight, a gust of wind picked up the right wing and the left wing struck the ground. The student pilot applied power while initiating corrective action. However, the plane ground looped and flipped over on its…NTSB ATL81DKG34Accident · Minor injuriesClosedCessna 140 · Dahlonega, GANTSB NYC81FKG02Accident · Minor injuriesClosedCessna 140 · Stockbridge, GANTSB ATL80FLA01Accident · No injuriesClosedCessna 140 · St Marys, GANTSB MIA79FKG05Accident · No injuriesClosedCessna 140 · Sugar Valley, GANTSB MIA78FKG03Accident · Serious injuriesClosedCessna 140 · Calhoun, GANTSB MIA78DKG02Accident · No injuriesClosedCessna 140 · Tifton, GANTSB MIA77DKG80Accident · No injuriesClosedCessna 140 · Blairsville, GANTSB MIA77FKG20Accident · Minor injuriesClosedCessna 140 · Whitesburg, GANTSB MIA74FKG46Accident · Minor injuriesClosedCessna 140 · Savannah, GANTSB MIA74FKG26Accident · Minor injuriesClosedCessna 140 · Stockbridge, GANTSB MIA74DKG11Accident · No injuriesClosedCessna 140 · Thomaston, GANTSB MIA73DKG80Accident · No injuriesClosedCessna 140 · Marietta, GANTSB MIA73DKG13Accident · No injuriesClosedCessna 140 · Claxton, GANTSB MIA71DKG68Accident · No injuriesClosedCessna 140 · Jonesboro, GANTSB MIA70FKG48Accident · Serious injuriesClosedCessna 140 · Soperton, GANTSB MIA70D0313Accident · No injuriesClosedCessna 140 · Crawford, GANTSB MIA70D0249Accident · Serious injuriesClosedCessna 140 · Cleveland, GANTSB MIA69F0491Accident · Minor injuriesClosedCessna 140 · Temple, GANTSB MIA69D0433Accident · No injuriesClosedCessna 140 · Jefferson, GANTSB MIA69D0089Accident · No injuriesClosedCessna 140 · Irwinville, GANTSB MIA68F0505Accident · No injuriesClosedCessna 140 · Douglasville, GANTSB MIA68F0136Accident · No injuriesClosedCessna 140 · Dawson, GANTSB MIA67D0047Accident · No injuriesClosedCessna 140 · Blairsville, GANTSB UNK64X3931Accident · 1 fatalClosedCessna 140 · Darien, GA