NTSB investigations: Cessna 140
11 cases on aircraft the registry lists as Cessna 140, where the first occurrence was “In flight collision with object”. 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 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1998 | 2 |
| 2001 | 1 |
| 2003 | 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\" = 220))
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" = 220))
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 CHI03LA282Accident · 1 fatalLimited investigationFinal reportCessna 140 · Edwardsburg, MIThe pilot not maintaining altitude/clearance from the power line during his low level cruise. Factors were the power transmission line, the lake, and low altitude flight.NTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.NTSB DEN02LA008Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Nephi, UTThe pilot's failure to maintain clearance with the transmission wires while maneuvering. A contributing factor was the low altitude flight performed by the pilot.NTSB NYC98LA192Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Watertown, CTWas the pilot's misjudged altitude of the airplane prior to performing a stall, and which resulted in the main landing gear contacting a rock wall.NTSB NYC98LA147Accident · No injuriesLimited investigationFinal reportCessna 140 · Gansevoort, NYThe pilot's decision to continue the landing attempt too far down the runway.NTSB ATL94LA067Accident · 1 fatalLimited investigationFinal reportCessna 140 · Celina, TNThe pilot's failure to maintain a proper altitude, and his failure to maintain clearance from the transmission wire.NTSB CHI90LA242Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Blissfield, MIThe pilot's inadequate visual lookout which resulted in a collision with a utility wire.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 ATL85FA140Accident · 2 fatalField investigationFinal reportCessna 140 · Hawesville, KYThe acft collided with and sunk into the Ohio river following a wing separation after contacting the lowest wire in a set of 3 power lines which spanned the river. Two other wires were located above the set of 3 power lines. Witnesses on and near the river…NTSB SEA82DA078Accident · Minor injuriesFinal reportCessna 140 · Buena Vista, ORThe pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose…NTSB FTW82DA063Accident · No injuriesFinal reportCessna 140 · Krotz Springs, LADuring the power recovery from a simulated forced landing to a railroad right-of-way the aircraft struck four strands of telephone wire which ran perpendicular to the tracks. The aircraft was landed at a nearby airport where post-flight inspection revealed…