NTSB investigations: Cessna 140, SC
13 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 3 |
| 1975 | 1 |
| 1977 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2013 | 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\" = 'SC' 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" = 'SC' 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 ERA13CA208Accident · No injuriesData collectionFinal reportCessna 140 · Lancaster, SCThe pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.NTSB ERA11CA097Accident · No injuriesData collectionFinal reportCessna 140 · Winnsboro, SCThe excessive brake inputs by both pilots during the landing roll resulting in the airplane nosing over.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 ATL92FA040Accident · 2 fatalField investigationFinal reportCessna 140 · Columbia, SCThe pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…NTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…NTSB MIA77FLG23Accident · Serious injuriesClosedCessna 140 · Isle Of Palms, SCNTSB MIA75DLG25Accident · Minor injuriesClosedCessna 140 · Manning, SCNTSB MIA73DLG30Accident · No injuriesClosedCessna 140 · N Myrtle Beach, SCNTSB NYC73ANO61Accident · 1 fatalClosedCessna 140 · Gaffney, SCNTSB MIA72DLG32Accident · Minor injuriesClosedCessna 140 · Laurens, SCNTSB MIA70D0106Accident · Minor injuriesClosedCessna 140 · Walterboro, SCNTSB MIA68D0517Accident · Minor injuriesClosedCessna 140 · Charleston, SCNTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SC