Cessna 170B
FAA incident reports · 854
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 ('2072306', '2072307')
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 ('2072306', '2072307')
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 19730219006009ACessna 170B · Mobile, ALBrake puck angle wear caused piston to cock,fluid bypassed o ring. Ann insp 2/16/73.N74309 sub dmg.Accident 19730127000989ACessna 170A · Headquarters, IDPhotographing elk. Recovered 1/28/73.Accident 19730117001979ACessna 170B · Willcox, AZDens alt aprx 5500FT.abt 150LBS ovr gwt,exceeded aft CG 1.5IN.20DEG flap tkof,crashed ret to fld.Accident 19730106000389ACessna 170B · Leadville, COIp did not take control soon enough to be able to effect safe recovery.
Back to Cessna 170B