NTSB investigations: Cessna U206F
9 cases on aircraft the registry lists as Cessna U206F, 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2004 | 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 ('2073333', '207333A')
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 ('2073333', '207333A')
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 ANC05LA015Accident · No injuriesLimited investigationFinal reportCessna U206F · Bethel, AKThe pilot's inadequate evaluation of the weather conditions, and his inadequate compensation for the wind conditions, which resulted in a loss of control and subsequent nose over during taxi from landing. A factor contributing to the accident was a tailwind.NTSB ATL99LA065Accident · No injuriesLimited investigationFinal reportCessna 206 · Fayetteville, NCThe pilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB SEA98LA157Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot-in-command's not lowering flaps prior to takeoff and overload of the nose landing gear. Contributing factors were high density altitude conditions and high brush.NTSB ANC94LA034Accident · No injuriesLimited investigationFinal reportCessna 206 · New Koliganek, AKThe pilot's failure to maintain control of the airplane. Factors in the accident were the strong crosswinds and the icy/snow covered taxi surface.NTSB NYC90LA160Accident · 1 fatalLimited investigationFinal reportCessna U206F · Augusta, MEImproper planning/decision by the pilot, and his failure to compensate for wind conditions. The unfavorable wind conditions and rough water were related factors.NTSB CHI89LA102Accident · No injuriesLimited investigationFinal reportCessna 206 · Flushing, MIPilot's inadequate aircraft control during the aborted takeoff attempt, and the aircraft's resultant collision with trees. The wet runway was a factor in the lack of normal braking action.NTSB ANC88LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Cantwell, AKThe air-taxi pilot stated that he attempted to takeoff from a private, dirt runway that was dry in the middle and muddy towards the edges. During the takeoff roll, the airplane's left main gear tire encountered the soft, muddy area and turned abruptly towards…NTSB ANC87LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Pt. Mackenzie, AKThe pilot stated that during the takeoff roll on the beach the aircraft struck a sand bar causing the aircraft to nose over on the beach.NTSB DEN85LA201Accident · No injuriesLimited investigationFinal reportCessna U206 · Greystone, COThe plt lost control of the acft during an attempted takeoff from a 7000 ft gravel road. The takeoff was being made to the north-northeast and the plt reported winds were from 180 degs at 10 KTS gusting to 15 KTS. The acft veered left, contacted a tree and…