Fatal NTSB investigations: Cessna U206
14 cases on aircraft the registry lists as Cessna U206. 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1991 | 2 |
| 1994 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073306'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073306'))
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 ANC95FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 206 · Kenai, AKUndetermined.NTSB MIA91WA176Accident · 6 fatalForeign investigationCessna U206 · Missing, BahamasNTSB DEN91FA042Accident · 4 fatalField investigationFinal reportCessna U206 · Yampa, COInadvertent accelerated stall by the pilot in command while attempting a turn in close proximity to terrain. A factor was the high altitude.NTSB ANC86FA032Accident · 1 fatalField investigationFinal reportCessna 206 · Anchorage, AKThe pilot was using the aircraft to commute on a weekly basis between his residence in Anchorage and to the king salmon area. The pilot received several preflight and inflight weather briefings. During the briefings the flight service station stated that VFR…NTSB ANC81FA081Accident · 3 fatalClosedCessna 180 · Naknek, AKNTSB ANC81FA007Accident · 1 fatalClosedCessna U206 · Missing AircraftNTSB DEN78FA044Accident · 1 fatalClosedCessna U206 · Erie, CONTSB NYC78FA011Accident · 1 fatalClosedCessna 206 · Taunton, MANTSB MIA75AM077Accident · 2 fatalClosedCessna 206 · Union Springs, ALNTSB IAD74AI029Accident · 1 fatalClosedCessna U206C · Hayesville, NCNTSB ANC74AA02CAccident · 1 fatalClosedCessna 206 · Togiak, AKNTSB ANC72AA031Accident · 1 fatalClosedCessna U206 · Wainwright, AKNTSB NYC70A0012Accident · 1 fatalClosedCessna 206 · Springfield, VTNTSB SEA69A0037Accident · 1 fatalClosedCessna TU206A · Troutdale, OR