NTSB investigations: Cessna TU206F, ID
7 cases on aircraft the registry lists as Cessna TU206F. 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
| 1975 | 1 |
|---|---|
| 1977 | 1 |
| 1986 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2013 | 1 |
| 2021 | 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\" = 'ID' 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 ('2073353'))
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" = 'ID' 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 ('2073353'))
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 WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB WPR13LA382Accident · No injuriesLimited investigationFinal reportCessna 206 · Boise, IDThe mechanical failure of the nose landing gear for reasons that could not be determined because impact damage prevented a complete examination.NTSB SEA07LA209Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Nampa, IDThe total loss of engine power for an undetermined reason. Factors include a power transmission line between the point were the aircraft lost power and the runway that the pilot was attempting to reach.NTSB SEA03LA113Accident · No injuriesLimited investigationFinal reportCessna 206 · Soldier Bar, IDThe overload failure of the nose landing gear assembly during the landing roll, due to an improper maintenance installation. A factor was the rough/uneven terrain condition.NTSB SEA86LA124Accident · Minor injuriesLimited investigationFinal reportCessna 206T · Murphy, IDThe pilot attempted to land with excessive airspeed and altitude. A bounced landing occurred with a touchdown being more than 2/3 way down the runway. During VFR co-around, a departure stall was entered and the aircraft struck the ground with the left wing…NTSB SEA77DA022Accident · Minor injuriesClosedCessna TU206F · Warren, IDNTSB SEA75DYG35Accident · No injuriesClosedCessna TU206F · Mccall, ID