Cessna TU206B
NTSB investigations · 25
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('2073324')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2073324')
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 WPR20LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TU206 · Tusayan, AZA total loss of engine power due to fuel starvation as a result of contamination in the airplane’s fuel system.NTSB GAA17CA432Accident · No injuriesData collectionFinal reportCessna TU206B · Sandy, ORThe pilot’s improper bank control during landing in gusting wind conditions.NTSB CEN10CA378Accident · No injuriesData collectionFinal reportCessna 206 · Albuquerque, NMThe pilot's improper recovery from a bounced landing.NTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.NTSB ANC05LA133Accident · No injuriesLimited investigationFinal reportCessna 206 · Yakutat, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain adequate airspeed during takeoff initial climb from a remote airstrip, which resulted in the airplane descending to the ground and colliding with soft terrain beyond the end…NTSB MIA97FA021Accident · 1 fatalField investigationFinal reportCessna TU206B · Jasper, GAcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from rising/mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB CHI94LA118Accident · No injuriesLimited investigationFinal reportCessna TU206B · Canton, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB LAX87LA188Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Temecula, CADuring an aerial survey flight, while on final approach to the arpt, the engine began running rough then quit. The plt was unable to land the acft at the arpt, therefore, a nearby dirt road was selected. During the landing roll the acft collided with the…NTSB LAX82DA288Accident · No injuriesFinal reportCessna U206B · Grass Valley, CADuring arrival, the pilot entered the traffic pattern to land on runway 25 with a reported wind from the southwest at 10 KTS. On his first approach, the pilot experienced a rough ride with fluctuating airspeed and rate of descent. He was overshooting so he…NTSB FTW81FA079Accident · 1 fatalClosedCessna TU206B · Beaumont, TXNTSB LAX75DUM28Accident · No injuriesClosedCessna 206B · Imperial, CANTSB LAX75DUJ18Accident · Minor injuriesClosedCessna T206B · Nogales, AZNTSB CHI74FEE37Accident · Serious injuriesClosedCessna TU206B · West Chicago, ILNTSB DEN74DQA73Accident · No injuriesClosedCessna TU206B · Roswell, NMNTSB OAK74FVD08Accident · No injuriesClosedCessna TU206B · Livermore, CANTSB OAK73AP004Accident · No injuriesClosedCessna TU206B · Lone Pine, CANTSB DEN70A0037Accident · Serious injuriesClosedCessna 206 · Rawlins, WYNTSB ANC70A0032Accident · 6 fatalClosedCessna TU206B · Anchorage, AKNTSB MKC69F0088Accident · Minor injuriesClosedCessna TU206B · Anoka, MNNTSB LAX68D0415Accident · No injuriesClosedCessna 206B · Winslow, AZNTSB LAX68D0314Accident · No injuriesClosedCessna 206 · Pinon, AZNTSB SEA68A0036Accident · Minor injuriesClosedCessna U206 · Glendale, ORNTSB OAK68F0132Accident · No injuriesClosedCessna 206 · Reno, NVNTSB DEN68O0001Accident · No injuriesClosedCessna 206 · Zapotes, MexicoNTSB MKC68A0081Accident · Serious injuriesClosedCessna TU-206 · Thedford, NE
Back to Cessna TU206B