NTSB investigations: Cessna U206E, AK
13 cases on aircraft the registry lists as Cessna U206E. 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
| 1972 | 1 |
|---|---|
| 1976 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2005 | 2 |
| 2011 | 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\" = 'AK' 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 ('2073350'))
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" = 'AK' 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 ('2073350'))
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 ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…NTSB ANC05LA125Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Skwentna, AKThe pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.NTSB ANC05CA059Accident · No injuriesData collectionFinal reportCessna U206E · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose down, and structural damage to the wing. A factor contributing to the accident was the soft sand.NTSB ANC97LA138Accident · Serious injuriesLimited investigationFinal reportCessna U206E · Mcgrath, AKthe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear and a nose over. Factors associated with the accident were: the pilot's failure to follow procedures and directives by neglecting to…NTSB ANC93LA009Accident · No injuriesLimited investigationFinal reportCessna 206 · Slate Creek, AKThe icy condition of the runway and the discontinued snow removal.NTSB ANC87FA146Accident · 2 fatalField investigationFinal reportCessna U206E · Harding Glacier, AKThe private pilot and his non-pilot adult male passenger were flying from modesto, CA, to soldotna, AK, for a hunting trip. The pilot, who had approximately 164 hours total flight time at the time of the accident, and who had no prior flying experience in…NTSB ANC86LA121Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe pilot stated that during the landing rollout on the gravel bar he lost control of the aircraft causing the plane to nose over on its back.NTSB ANC79DAG59Accident · No injuriesClosedCessna U206 · Palmer, AKNTSB ANC79DA062Accident · No injuriesClosedCessna U206 · Emmonak, AKNTSB ANC78FA013Accident · Serious injuriesClosedCessna 206 · Brevig Mission, AKNTSB ANC77DA006Accident · Serious injuriesClosedCessna 206 · Tuntutuliak, AKNTSB ANC76DAG83Accident · No injuriesClosedCessna 206 · Kenai, AKNTSB ANC73AA012Accident · 1 fatalClosedCessna U206 · Juneau, AK