Final NTSB investigations: Cessna TU206E
10 cases on aircraft the registry lists as Cessna TU206E. 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
| 1976 | 2 |
|---|---|
| 1977 | 1 |
| 1978 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2008 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073352'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073352'))
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 LAX08LA251Accident · No injuriesLimited investigationFinal reportCessna TU206E · Murrieta, CAA malfunction of the flight control system and loss of engine power for undetermined reasons.NTSB ANC94LA098Accident · No injuriesLimited investigationFinal reportCessna 206 · Juneau, AKThe total loss of power for undetermined reasons. The pilot's failure to follow the prescribed procedure for the use of the auxiliary fuel boost pump switch, operating the airplane with a improperly operating switch, and the lack of suitable terrain in the…NTSB LAX93LA343Accident · No injuriesLimited investigationFinal reportCessna TU206G · Marble Canyon, AZfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft either prior to departure or enroute.NTSB LAX85FA262Accident · 2 fatalField investigationFinal reportCessna TU-206E · San Manuel, AZThis plt was attempting to air drop illegal drugs to someone on the ground. While executing an intentional low pass, at dusk, theacft inadvertently collided with a cactus tree & crashed.NTSB LAX84LA069Accident · No injuriesLimited investigationFinal reportCessna TU206E · Red Rock, AZThe acft taxied into a ditch after landing on a road at night. After the acft came to rest it was apparently intentionally burned. Sob & injuries are presumed. The landing site was marked by the placement of white cloths along the edges of the road. The acft…NTSB ANC79DA003Accident · No injuriesClosedCessna TU206E · Kenai, AKNTSB FTW79FPG01Accident · Serious injuriesClosedCessna TU206 · Kirby, ARNTSB OAK77DVA28Accident · No injuriesClosedCessna TU206E · Modesto, CANTSB SEA76AS073Accident · 1 fatalClosedCessna TU206E · Salmon, IDNTSB LAX76FUJ72Accident · No injuriesClosedCessna TU206E · Mesa, AZ