NTSB investigations: Cessna TU206F, CA
9 cases on aircraft the registry lists as Cessna TU206F. 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
| 1973 | 1 |
|---|---|
| 1980 | 2 |
| 1982 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 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\" = '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 ('2073353'))
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 ('2073353'))
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 LAX99LA231Accident · No injuriesLimited investigationFinal reportCessna TU206F · Saline Valley, CAThe pilot's failure to verify the fuel quantity prior to departure, which led to fuel exhaustion.NTSB LAX98LA122Accident · No injuriesLimited investigationFinal reportCessna TU206F · Avalon, CAContamination of the fuel system which led to a loss of engine power. Factors were the lack of suitable terrain for the forced landing and the barbwire fence.NTSB LAX97LA313Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Yucca Valley, CAthe driver's failure to see the posted sign and yield to the landing aircraft.NTSB LAX95LA257Accident · 1 fatalLimited investigationFinal reportCessna TU206 · Danville, CAThe pilot's intentional flight into known adverse weather and failure to maintain proper altitude.NTSB LAX93FA042Accident · 2 fatalField investigationFinal reportCessna TU-206F · Clearlake, CAThe exhaust valve failing due to a complete fracture which resulted in the total lose of engine power. Factors in this accident were: 1) the terrain not being suitable for a forced landing, and 2) low ambient light which hampered the pilot's ability to see…NTSB LAX83LVG05Accident · No injuriesFinal reportCessna TU206F · Franklin, CAFinal approach was slightly high & the student plt reduced power. As the throttle was advanced from 1400 RPM the eng quit. The acft touched down approximately 300 ft short of the rwy & rolled into a fence. The fence caught the nose gear & turned the acft…NTSB LAX80DVG17Accident · No injuriesClosedCessna TU206F · Willows, CANTSB LAX80FUG19Accident · Serious injuriesClosedCessna TU206F · El Monte, CANTSB OAK73DVM28Accident · No injuriesClosedCessna U206 · S.Francisco, CA