NTSB investigations: Cessna 206, TX
9 cases on aircraft the registry lists as Cessna 206. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2015 | 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\" = 'TX' 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 ('2073302'))
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" = 'TX' 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 ('2073302'))
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 CEN15LA366Accident · No injuriesLimited investigationFinal reportCessna 206 · Pecos, TXThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB FTW02LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Midlothian, TXthe pilot's failure to maintain control of the aircraft while taxiing from a landing. A contributing factor was the gusty wind conditions.NTSB FTW95LA367Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Whitesboro, TXThe pilot's improper flare, which resulted in a hard landing.NTSB FTW89LA052Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Austin, TXThe pilot's inaccurate fuel consumption calculations and improper positioning of the fuel tank selector valve.NTSB FTW86LA109Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tahoka, TXThe acft nosed over during a forced landing in a fld following a loss of pwr due to fuel exhaustion. The plt reported that after aprx 9 minutes of flt a total loss of pwr was experienced. The plt selected an open fld in which to land. The nose gear sunk in…NTSB FTW82DA079Accident · No injuriesFinal reportCessna U206 · Noack, TXThe pilot stated that he was on a one hour flight for aerial survey to giddings, Texas and return. The right fuel tank ran dry and he switched to the left tank which indicated nearly 1/4 full. Approximately 20 minutes later, the engine stopped operating. A…NTSB FTW67F0551Accident · Minor injuriesClosedCessna 206 · Tyler, TXNTSB UNK65X1444Accident · No injuriesClosedCessna 206 · Harlingen, TXNTSB UNK64X0354Accident · Minor injuriesClosedCessna 206 · Wichita Falls, TX