NTSB investigations: Cessna U206D, AK
8 cases on aircraft the registry lists as Cessna U206D. 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
| 1977 | 2 |
|---|---|
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 2007 | 1 |
| 2012 | 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 ('2073342'))
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 ('2073342'))
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 ANC12LA093Accident · No injuriesLimited investigationFinal reportCessna U206D · Nikolai, AKThe total loss of engine power for reasons that could not be determined because the engine was not made available for examination.NTSB ANC07FA051Accident · Serious injuriesField investigationFinal reportCessna 206 · Homer, AKA loss of engine power due to fuel starvation from the pilot's improper fuel selector positioning, and her failure to maintain adequate airspeed to preclude a stall. Contributing to the accident was an inadvertent stall.NTSB ANC84LA152Accident · No injuriesLimited investigationFinal reportCessna 206 · Nondalton, AKThe acft landed short of the rwy. The wind was from 280 degrees at 12 KTS gusting to 25 KTS. The plt reported that he was caught in a downdraft and full power did not slow the rate of descent.NTSB ANC81FA075Accident · 5 fatalClosedCessna U206 · Moose Pass, AKNTSB ANC80FA075Accident · Minor injuriesClosedCessna U206 · Kenai, AKNTSB ANC78DAG66Accident · Minor injuriesClosedCessna 206 · Icy Bay, AKNTSB ANC77DA070Accident · No injuriesClosedCessna 206E · Tatitlek, AKNTSB ANC77DA037Accident · No injuriesClosedCessna U206D · Flat, AK