NTSB investigations: Cessna U206, CA
8 cases on aircraft the registry lists as Cessna U206. 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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2012 | 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\" = 'CA' 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 ('2073306'))
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" = 'CA' 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 ('2073306'))
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 WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.NTSB LAX96LA123Accident · No injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAthe pilot's improper use of the elevator control, while landing.NTSB LAX96LA024Accident · No injuriesLimited investigationFinal reportCessna 206 · Long Beach, CAthe failure of the pilot to maintain control of the aircraft while maneuvering by visual reference to the surface in IFR conditions. An additional factor was the pilot's failure to continue with the missed approach.NTSB LAX91LA195Accident · Serious injuriesLimited investigationFinal reportCessna U206 · Tulare, CAAn in-flight fire in the cabin/crew compartment area of the aircraft, due to failure of a fuel line located in the left doorpost area.NTSB LAX76DUG60Accident · No injuriesClosedCessna U206 · Palms, CANTSB OAK73FVD43Accident · No injuriesClosedCessna U206 · Novato, CANTSB LAX68F0376Accident · Serious injuriesClosedCessna U206 · Thousnd Oak, CANTSB OAK66F0149Accident · No injuriesClosedCessna U-206 · Napa, CA