Skip to content

NTSB investigations: Cessna U206A, AK

16 cases on aircraft the registry lists as Cessna U206A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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 ('2073316')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2073316'))
  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 ('2073316'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC18TA070Accident · Serious injuriesFinal reportCessna U206 · Willow, AKThe pilot receiving instruction's failure to maintain control during a night landing pattern crosswind turn due to spatial disorientation and the flight instructor's inadequate supervision and delayed remedial action, which resulted in impact with terrain.Sep 9, 2018 · N8070Z · Substantial damage NTSB GAA16CA455Accident · No injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall and a hard landing.Aug 17, 2016 · N8076Z · Substantial damage NTSB ANC13CA052Accident · No injuriesData collectionFinal reportCessna U206A · Fairbanks, AKThe pilot’s inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over.May 31, 2013 · N4571K · Substantial damage NTSB ANC93LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Willow, AKThe abrupt aircraft handling by the pilot in command. Factors were the collapse of the nose gear and the soft, snow covered terrain.Feb 28, 1993 · N8076Z · Substantial damage NTSB ANC92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Fort Yukon, AKFatigue failure of an engine cylinder precipitated by the pilot-in-command intentionally exceeding the engine performance ratings in order to sustain flight in the grossly overweight condition. A factor contributing to the accident was the high grass. A…Sep 2, 1992 · N8070Z · Substantial damage NTSB ANC92LA146Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKProper touchdown point was not attained by the pilot. Factors related to the accident were: the tailwind and the improper approach procedure used by the pilot, an inadequate background check of pilot in hiring by company/mgmt, inadequate training and check of…Aug 26, 1992 · N711FY · Substantial damage NTSB ANC88LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Chugiak, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to exit the left side of the runway into an open ditch. The aircraft traveled approximately 1000 feet of the runway.Jun 2, 1988 · N4571K · Substantial damage NTSB ANC76FAH78Accident · No injuriesClosedCessna U206 · Egegik, AKSep 28, 1976 · N206TK · Substantial damage NTSB ANC76AA122Accident · No injuriesClosedCessna U206 · Anchorage, AKAug 11, 1976 · N8067Z · Substantial damage NTSB ANC76AA110Accident · No injuriesClosedCessna 206 · Kenai, AKJul 12, 1976 · N8091Z · Substantial damage NTSB ANC75DAG01Accident · No injuriesClosedCessna U206 · Paimuit, AKJul 5, 1974 · N4849F · Destroyed NTSB ANC70AA059Accident · No injuriesClosedCessna U206 · Juneau, AKFeb 5, 1970 · N4840F · Substantial damage NTSB ANC70A0046Accident · No injuriesClosedCessna 206 · Cordova, AKDec 7, 1969 · N4802F · Destroyed NTSB ANC68A0007Accident · No injuriesClosedCessna U206 · Kenai, AKAug 9, 1967 · N4802F · Substantial damage NTSB ANC67F0094Accident · No injuriesClosedCessna U206A · Kenai, AKDec 16, 1966 · N4802F · Substantial damage NTSB ANC67D0015Accident · No injuriesClosedCessna 206 · Mckinley Prk, AKAug 6, 1966 · N4847F · Substantial damage