Final NTSB investigations: Cessna TU206D
13 cases on aircraft the registry lists as Cessna TU206D. 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 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 ('2073344'))
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 ('2073344'))
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 MIA93FA109Accident · 1 fatalField investigationFinal reportCessna TU206D · Culebra, PRFatigue failure of the engine crankshaft that originated from a heat check crack in the journal, adjacent to the #2 main journal forward fillet.NTSB FTW89LA033Accident · Serious injuriesLimited investigationFinal reportCessna TU206D · Alamo, TXAirplane's collision with trees and terrain during an attempted forced landing at night following an engine faiure. The engine failure was caused by fuel starvation as a result of a faulty fuel system which the operator had failed to correct.NTSB DEN87LA140Accident · Minor injuriesLimited investigationFinal reportCessna TU206D · Garrison, NDThe plt and a photographer were photo-mapping at 3,000 feet MSL. The plt reported that the engine quit at cruise. The plt selected a gravel road for the forced landing. The aircraft landed short of the intended touchdown pointin a plowed field and on…NTSB ANC78DAA36Accident · No injuriesClosedCessna TU206D · Mankomen Lk, AKNTSB SEA78DYP01Accident · No injuriesClosedCessna 206 · Priest Rpd Dam, WANTSB SEA77FYC12Accident · No injuriesClosedCessna TU206D · Farmington, ORNTSB DEN76AD043Accident · No injuriesClosedCessna TU206D · Aspen, CONTSB OAK76AP033Accident · Minor injuriesClosedCessna TU206D · Cantua Creek, CANTSB SEA75AS026Accident · 3 fatalClosedCessna TU206D · Palmer, WANTSB NYC74DFA22Accident · Minor injuriesClosedCessna 206D · Saranac Lake, NYNTSB OAK72DVG53Accident · Minor injuriesClosedCessna 206 · Woodland, CANTSB DEN70FXD09Accident · No injuriesClosedCessna TU206D · Aspen, CONTSB UNK69X0119Accident · No injuriesClosedCessna 310N · Montreal, Canada