NTSB investigations: Cessna TU206G, AZ
10 cases on aircraft the registry lists as Cessna TU206G. 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
| 1978 | 1 |
|---|---|
| 1980 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 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\" = 'AZ' 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 ('2073357'))
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" = 'AZ' 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 ('2073357'))
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 LAX96LA059Accident · No injuriesLimited investigationFinal reportCessna TU206G · Eagar, AZthe pilot's failure to assure an adequate amount of fuel was on board for the flight.NTSB LAX93LA126Accident · Minor injuriesLimited investigationFinal reportCessna Soloy TU206G · Cochise, AZThe pilot's continued flight into known forecasted icing conditions, in an airplane not certificated for such flight, which resulted in an engine flameout due to engine ice/water injestion, and the pilot's inability to restart the engine due to inadequate…NTSB LAX88LA093Accident · 2 fatalLimited investigationFinal reportCessna TU206G · Kirkland, AZDuring a cross country flt, the acft struck power lines that were stretched across a canyon. The unmarked wires were aprx 500 ft AGL. There were no reported mechanical failures or malfunctions. No explanation was given for the low flying.NTSB LAX87LA334Accident · 1 fatalLimited investigationFinal reportCessna 206 · Williams, AZThe aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled…NTSB LAX86LA112Accident · No injuriesLimited investigationFinal reportCessna TU206G · Flagstaff, AZWhile returning from grand canyon, AZ, 14 CFR 135 sightseeing flt to scottsdale, AZ, the plt reported the acft experienced a power loss; all other instrument indications were normal. The plt enriched the mixture and changed fuel tanks but to no avail. The plt…NTSB LAX85LA221Accident · Minor injuriesLimited investigationFinal reportCessna TU-206G · Pinon, AZAt the conclusion of a cross country business flt, plt initiated a straight in approach after monitoring the wind conditions by observing a flag, which he reported as 'limp.' Plt reported that touchdown occurred at '50 knots' following a full flap approach at…NTSB LAX83FA458Accident · 2 fatalField investigationFinal reportCessna TU206-G · Flagstaff, AZThe acft collided with trees shortly after takeoff. The weather was marginal with 700 ft scattered, ceiling 3000 ft WITH8 miles visibility. The plt received two weather briefings about an hour apart while waiting for weather improvement. The briefer commented…NTSB LAX80DUJ56Accident · Minor injuriesClosedCessna TU206G · Parker, AZNTSB LAX80FUJ29Accident · No injuriesClosedCessna TU206G · Glendale, AZNTSB LAX79DUJ08Accident · No injuriesClosedCessna TU206G · Gila Bend, AZ