NTSB investigations: Cessna T206H

58 cases on aircraft the registry lists as Cessna T206H. 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, newest first

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 ('2073303')) 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 ('2073303'))
  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 ('2073303'))
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 CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…May 28, 2004 · N9548D · Destroyed NTSB DEN04FA043Accident · 1 fatalField investigationFinal reportCessna T206H · Walcott, WYThe pilot not following proper IFR procedures for tracking a VOR radial while on an IFR flight plan in IMC conditions, and not maintaining clearance with terrain during cruise flight. Contributing factors were the mountain, and the cloudy weather condition.Feb 6, 2004 · N51192 · Destroyed NTSB ANC03FA106Accident · 3 fatalField investigationFinal reportCessna T206H · Chickaloon, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with mountainous terrain while maneuvering. Factors contributing to the accident were weather conditions consisting of clouds/mist and low ceilings, and the…Sep 2, 2003 · N72598 · Destroyed NTSB LAX02LA140Accident · No injuriesLimited investigationFinal reportCessna T206H · Sedona, AZThe pilot's inadequate compensation for the variable, gusty and crosswind conditions, which led to a bounced landing and a subsequent pilot induced porpoise oscillation. A factor in the accident was the pilot's decision to continue the landing in a crosswind…Apr 19, 2002 · N377ME · Substantial damage NTSB DEN01LA100Accident · No injuriesLimited investigationFinal reportCessna T206H · Watkins, COthe pilot's failure to maintain the proper decent rate during the flare resulting in a hard landing. Contributing factors icing conditions and accumulations of wing ice.May 2, 2001 · N72582 · Substantial damage NTSB OAK79DXQ01Accident · No injuriesClosedCessna 305A · Lee Vining, CAOct 1, 1978 · N5197G · Substantial damage NTSB MKC77DEQ36Accident · No injuriesClosedCessna 182 · Derby, KSMay 21, 1977 · N2445R · Substantial damage NTSB IAD76FID39Accident · No injuriesClosedCessna 172 · Lovingston, VAAug 13, 1976 · N35353 · Substantial damage