NTSB investigations: Cessna 140A
10 cases on aircraft the registry lists as Cessna 140A, 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 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071604')
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 ('2071604')
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 CHI03LA157Accident · No injuriesLimited investigationFinal reportCessna 140A · Grinnell, IAThe pilot's inadvertent ground loop. Factors contributing to the accident were the wind gusts and crosswind conditions.NTSB CHI97LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Allegan, MIthe pilot's failure to maintain directional control during landing.NTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.NTSB CHI92LA200Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Grain Valley, MOThe pilot's excessive application of wheel brakes after touchdown.NTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.NTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.NTSB MIA88LA145Accident · No injuriesLimited investigationFinal reportCessna 140A · Lakeland, FLWhile on a personal flt during the landing roll after the plt applied the brakes, the acft nosed over & came to rest inverted. He stated that the left brake locked up & after the acft was removed from the rwy, he disassembled each brake assy in an effort to…NTSB CHI85LA203Accident · No injuriesLimited investigationFinal reportCessna 140A · Owosso, MIThe plt-in-command allowed the passenger in the right seat, a rated plt, to land the acft. This plt lost directional control during the landing roll & the acft ground looped. During the second ground loop the right main landing gear axle separated from the…NTSB SEA85LA006Accident · No injuriesLimited investigationFinal reportCessna 140A · Las Vegas, NVAccording to the plt he was unable to raise the tail of the acft during the takeoff and directional control could not be maintained. The plt made a hard landing in the acft on the day before the the accident. Investigators did not any flight control…NTSB LAX83LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Wickenburg, AZThe pilot stated the aircraft touched the runway then ballooned during a wheels-first landing. After the pilot decided to execute a go-around and the aircraft became airborne, it became apparent that the aircraft could not clear rising terrain. The pilot cut…