NTSB investigations: Cessna TU206G, CA
15 cases on aircraft the registry lists as Cessna TU206G. 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
| 1978 | 2 |
|---|---|
| 1979 | 1 |
| 1980 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 2 |
| 1996 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2020 | 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.\"eventStateOrRegion\" = 'CA' 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 ('2073357'))
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" = 'CA' 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 ('2073357'))
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 WPR21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Twentynine Palms, CAThe pilot’s decision to takeoff with a known mechanical engine anomaly, and the failure of the No. 2-cylinder exhaust valve, which resulted in a total loss of engine power during the initial climb and subsequent impact with terrain.NTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.NTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.NTSB LAX07LA179Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Napa, CAFailure of the number 5 connecting rod due to oil starvation.NTSB LAX97LA078Accident · No injuriesLimited investigationFinal reportCessna TU206G · Mammoth Lakes, CAThe loss of power for undetermined reasons, and the pilot's inappropriate use of flaps and his failure to maintain an adequate airspeed during the subsequent landing attempt.NTSB LAX88LA250Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Palo Alto, CADuring a local flight, the pilot noted that the oil pressure was low. En route to the airport, the engine quit. A forced landing was made on a road where during the landing the airplane collided with telephone wires and subsequently the terrain. Inspection of…NTSB LAX88LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Coarsegold, CAWhile at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.NTSB LAX85LA331Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Taohoma, CAOn July 27, 1985 a float equipped Cessna TU206G landed on choppy water, nosed over and sank at the seaplane base in lake tahoe, CA. The pilot and 1 passenger were not injured. Witnesses reported that time water conditions were moderate chop with waves 2 to 5…NTSB LAX84LA209Accident · No injuriesLimited investigationFinal reportCessna TU-206G · Auburn, CAThe plt came in for her 3rd landing and after flaring high'cut'the throttle and said she hoped for a'soft'landing with trim back and 40 degrees of flaps. A plt on the ground near the rwy said his attention was drawn to the acft because of a large increase in…NTSB LAX84LA077Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Riverside, CAThe plt of a Cessna TU206F, N7320Z, stated that he advised other traffic of his position & intentions on the UNICOM freq as he entered a straight-in apch to rwy 24. At about the same time, the plt of a pitts special S-1, N20JK, had returned from a local flt &…NTSB LAX80FA117Accident · 2 fatalClosedCessna TU206G · Carlsbad, CANTSB LAX80FUD09Accident · No injuriesClosedCessna T206 · Los Angeles, CANTSB LAX79DA071Accident · No injuriesClosedCessna TP206C · San Jose, CANTSB OAK79DXQ08Accident · No injuriesClosedCessna 206 · Mammoth Lakes, CANTSB LAX79FA009Accident · 2 fatalClosedCessna TU206G · Chula Vista, CA