NTSB investigations: Cessna 206

6 cases on aircraft the registry lists as Cessna 206, 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 206 per year, 1982–2026: 6 cases
1982	2
1983	2
1989	1
2003	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 ('2073302') 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 ('2073302')
      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 ('2073302')
    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 MIA03LA184Accident · No injuriesLimited investigationFinal reportCessna 206 · Okeechobee, FLThe total loss of engine power due to fuel exhaustion for undetermined reasons. A finding in the investigation was the inadequate preflight inspection of the airplane by the pilot-in-command for his failure to note a partial blockage at the inlet of the left…Sep 15, 2003 · N206SK · Substantial damage NTSB FTW89LA052Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Austin, TXThe pilot's inaccurate fuel consumption calculations and improper positioning of the fuel tank selector valve.Feb 18, 1989 · N5175U · Substantial damage NTSB NYC83FA248Accident · 4 fatalField investigationFinal reportCessna U-206FG · Jones Beach, NYThe acft ditched in the ocean about 4 miles se of Jones Beach, NY following eng power failure. The 4 occupants drowned. The plt was going from Washington,DC to westhampton Beach, NY, the acft was last refueled before its departure from westhampton Beach on…Sep 17, 1983 · N50807 · No damage NTSB MIA83LA201Accident · No injuriesLimited investigationFinal reportCessna 206 · Plymouth, FLDuring the previous week the acft had been outside & several heavy rainshowers occurred. Both the plt & the plt-rated passenger stated they drained the fuel tanks using a one-pound coffee can & did not notice any appreciable amount of water. After takeoff…Aug 12, 1983 · N5140U · Substantial damage NTSB LAX82DA126Accident · No injuriesFinal reportCessna 206-F · Winters, CAAfter takeoff as the aircraft climbed through 550 feet AGL the engine lost power. The pilot attempted to turn the aircraft around and land on a taxiway but landed in a soft area near it. The nose gear collapsed and the aircraft slid across the taxiway and…Apr 1, 1982 · N35919 · Substantial damage 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…Mar 1, 1982 · N5131U · Substantial damage