NTSB investigations: Cessna U206G

8 cases on aircraft the registry lists as Cessna U206G, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Cessna U206G per year, 1982–2026: 8 cases
1982	2
1988	1
1990	1
1991	2
1995	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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 ('2073356', '2073315', '2073314') 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

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 ('2073356', '2073315', '2073314')
      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 ('2073356', '2073315', '2073314')
    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

Run 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 MIA07CA070Accident · Minor injuriesData collectionFinal reportCessna 206G · Fort Lauderdale, FLThe pilot's improper fuel management during the landing approach, resulting in a loss of engine power due to fuel starvation, and a forced off-airport landing.Apr 1, 2007 · N828EW · Substantial damage NTSB ANC95LA126Accident · No injuriesLimited investigationFinal reportCessna 206G · Skwentna, AKThe pilot's improper handling of the aircraft (prolonged yawing maneuver during step taxi turn), which resulted in uncovering of the fuel tank outlets and subsequent fuel starvation during takeoff.Aug 2, 1995 · N4596U · Substantial damage 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.Dec 9, 1991 · N756DE · Substantial damage NTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.Mar 8, 1991 · N756XE · Minor damage NTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.Sep 16, 1990 · N756JC · Substantial damage NTSB ANC88LA149Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Homer, AKJust after liftoff the airplane experienced a complete engine failure, the airplane crashed on the mud flats approximately 500 feet off the departure end of runway 21. The chief pilot stated that the pilot did not check the fuel supply prior to this flight…Sep 30, 1988 · N4634Z · Substantial damage NTSB NYC82DA166Accident · No injuriesFinal reportCessna U206G · Batavia, NYThe aircraft had been parked at the genesee county airport since the fall of 1981. The accident flight was the first the aircraft had flown since the fall. As the aircraft cleared the end of the runway, and attained an altitude of approximately 300 feet, a…Jul 25, 1982 · N8198G · Substantial damage NTSB ATL82FA145Accident · Serious injuriesField investigationFinal reportCessna U206G · Norfolk, VAThe eng quit during final approach. The acft had a history of problems with water in fuel system leading to engine problems. On 2/8/82 significant quantities of water was found in the fuel system. Post crash examination revealed water in the fuel system.…May 29, 1982 · N777HD · Substantial damage