NTSB investigations: Cessna U206F
8 cases on aircraft the registry lists as Cessna U206F, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073333', '207333A')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073333', '207333A')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 NYC03FA197Accident · 3 fatalField investigationFinal reportCessna U206F · Greenville, METhe pilot's improper fuel management by which he failed to position the fuel selector in the proper position and resulted in fuel starvation during the initial climb.NTSB ANC97LA065Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Hope, AKa loss of engine power resulting from fuel starvation due to the pilot's improper positioning of the fuel selector, and the pilot's failure to identify and correct the deficiency during the ensuing emergency descent.NTSB MIA92GA134Accident · 1 fatalFinal reportCessna U206-F · Live Oak, FLImproper maintenance of the fuel system by the pilot/mechanic resulting in an engine failure on takeoff over terrain unsuitable for a forced landing. Contributing to the accident was the pilot's improper in-flight decision to turn back to the runway, and…NTSB MIA87LA006Accident · No injuriesLimited investigationFinal reportCessna U206F · Caribbean SeaThe acft was destroyed upon ditching in the ocean after sustaining eng failure several minutes after takeoff. The plt stated that he checked the fuel tanks with a calibrated dip-stick and determined there was 20 gals of fuel in the left tank and 15 gals in…NTSB ANC86LA004Accident · No injuriesLimited investigationFinal reportCessna 206 · Tanana, AKWhile en route, the eng lost power, so the plt made an emergency landing on a gravel bar. During the landing, the acft nosed over & came to rest in water. An exam revealed that the fuel sumps & lines were frozen & there was ice in the fuel pump.NTSB BFO85LIA01Accident · No injuriesFinal reportCessna U206 · Leesburg, VAThe acft was on a round-robin x-country flt from Leesburg to manassas, VA, gaithersburg, MD & return to Leesburg. When the plt departed gaithersburg on the final leg of the flt, he estimated he had 11 gal of fuel. He reported that during arrival at Leesburg,…NTSB LAX84LA269Accident · No injuriesLimited investigationFinal reportCessna U206F · Modesto, CAAcft departed at 0950 hrs with 55 to 60 gals of fuel on board. At 1219 hrs the acft was cruising at 6500 ft when total power loss occurred. The pilot attempted a forced landing on rwy 28 at modesta city arpt. Pilot was unable to fly the acft to the arpt and…NTSB NYC82FNC09Accident · No injuriesFinal reportCessna U206 · Millinocket, MEBefore departing smith pond, Maine, the pilot checked the fuel and estimated he had between 30 and 40 gallons on board. He flew to waterville, then to katachdine lake, and was on the next leg of the flight when the engine lost power. He switched tanks and the…