NTSB investigations: Cessna U206G, TX
8 cases on aircraft the registry lists as Cessna U206G. 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
| 1980 | 2 |
|---|---|
| 1983 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 2025 | 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 ('2073356', '2073315', '2073314'))
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 ('2073356', '2073315', '2073314'))
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 CEN25LA301Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Kerrville, TXThe pilot’s failure to confirm the fuel quantity before flight which resulted in a loss of engine power due to fuel starvation.NTSB FTW92FA035Accident · Serious injuriesField investigationFinal reportCessna U206G · Pasadena, TXFuel starvation due to the pilots' improper boost pump procedure. Factors were pilots' failure to follow checklist, dark night, and unsuitable terrain.NTSB FTW89LA122Accident · No injuriesLimited investigationFinal reportCessna 206 · Del Rio, TXPilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise.NTSB FTW87FA206Accident · 3 fatalField investigationFinal reportCessna U206G · Lissie, TXThe Piper aircraft, N1038U, departed from runway 32 at the municipal airport, wharton, Texas, on a northbound flight, about two minutes after the Cessna aircraft, N4745U. About 10 minutes later the two aircraft experienced a mid-air collision about 16…NTSB FTW87FA190Accident · No injuriesField investigationFinal reportCessna 206G · Georgetown, TXTeardown of the aircraft engine revealed that the engine counterweight vibration damper assembly was out of tolerance. This allowed excessive engine vibration which resulted in failure of the camshaft drive gear and total engine failure. The pilot executed a…NTSB FTW84LA027Accident · No injuriesLimited investigationFinal reportCessna U206G · Midland, TXThe plt took off to check the wx & intended to proceed on a business flt, if conditions permitted. After taking off, he noted that the wx would not be satisfactory, so he elected to land & travel by other means. His apch to land was high & the acft touched…NTSB FTW80FA123Accident · No injuriesClosedCessna U206 · Austin, TXNTSB FTW80FRG22Accident · No injuriesClosedCessna U206 · Rio Grand City, TX