NTSB investigations: Cessna U206G
10 cases on aircraft the registry lists as Cessna U206G, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2007 | 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 ('2073356', '2073315', '2073314')
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\" = 250))
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 ('2073356', '2073315', '2073314')
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" = 250))
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 ANC07CA050Accident · Minor injuriesData collectionFinal reportCessna 206 · Seldovia, AKThe pilot's inadequate compensation for wind conditions during the final landing approach, which resulted in an in-flight collision with trees. A factor associated with the accident was turbulence.NTSB LAX95GA334Accident · 2 fatalFinal reportCessna U206G · Dos Palos, CAthe pilot-in-command's failure to assure that adequate airspeed was maintained.NTSB ANC92LA057Accident · No injuriesLimited investigationFinal reportCessna U206G · Kotzebue, AKThe pilot's failure to remove all the frost from the airplane and exceeding the gross weight limit of the airplane.NTSB ANC91LA131Accident · No injuriesLimited investigationFinal reportCessna 206 · Funnel Lake, AKThe pilot's failure to attain proper airspeed. Contributing to the accident was the high wind encountered during takeoff and the terrain.NTSB ANC89LA141Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot allowed the aircraft to lift-off prematurely, then inadvertently enter a stall/mush. The gusty/crosswind conditions were contributing factors.NTSB SEA89LA035Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Sekiu, WAPilot attempted a landing in adverse weather conditions, rather than postpone the business trip and return to origin or other safe area. Contributing to the accident were turbulence and gusty winds along with the self induced pressure to make the business flt.NTSB NYC89LA009Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Rutland, VTThe accident sequence was observed by two pilots who were awaiting takeoff at the approach end of the rwy in use. One of the pilots reported that the plt of the acdt acft advised him that the acdt acft had encountered ice during the flight. The acdt acft was…NTSB SEA87FA180Accident · 1 fatalField investigationFinal reportCessna U206G II · Yakutat, AKAcft was observed to depart from controlled flight while in a steep left turn at slow speed and low altitude, impacting on a river sand bar. Fire ensued, demolishing acft. Following heavy rains, river rose and acft not recovered.NTSB ANC85LA066Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Kodiak, AKAcft made low alt steep 180 deg turn, stalled & spun into water. Acft had just taken off & was to spot flsh for three fishing vessels.NTSB ANC85LA030Accident · No injuriesLimited investigationFinal reportCessna U206 · Point Hope, AKThe acft crashed during takeoff while on a schedule air taxi flt. The plt & 5 passengers escaped serious injury. Investigation revealed the takeoff was attempted with suface winds reported as quartering directly across the takeoff rwy from 30 to more than 40…