Cessna TU206F
FAA incident reports · 107
Matched to the registry by N-number and event date, newest first.
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2073353')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('2073353')
ORDER BY event_date DESC, report_number 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.
Accident 19770214001969ACessna TU206F · Albuquerque, NMTransporting marijuana. Pilot not identified. Injury index,total aboard presumed. Stolen acft.Accident 19761111036659ACessna TU206F · Albuquerque, NMAcft refueled from storage drums. Rust and sand in acft fuel system.Accident 19760831041229ACessna TU206F · Spokane, WAAccident 19750412008429ACessna TU206F · Mccall, ID1 Way mtn strip.Accident 19750411008769ACessna TU206F · Peoria, AZLtg info in aim incorrect. Mistook ltd pole for pwr line & pulled up.Accident 19731218041999ACessna TU206F · Jal, NMAcft stolen. Accdt date & inj index presumedAccident 19730417009009ACessna TU206F · S.Francisco, CAKnown gusts to 34K.
Back to Cessna TU206F