Aeronca 7AC
FAA incident reports · 707
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 ('2110102')
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 ('2110102')
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 19730513012789ABlanca 7AC · Murray, KYEngine cowl came open drg clb aftr tkof. Pilot un to maintain flt,dscndd into trees.Accident 19730425019609ABlanca 7AC · Rice Lake, WIPlt left a suicide note.Accident 19730304004019ABlanca 7AC · Indian Trail, NC2Nd apch,bounced ldg,acft veered l,plt initiated goarnd-dscndd onto muddy earth.Accident 19730225004489ABlanca 7AC · Apache Jctn, AZWas checking rd prior to lndg. Hit wires.Accident 19730219003529ABlanca 7HC · Beverly, MARear stick secured by rear seat belt. Plt did not check controls prior to take off.Accident 19730130002119ABlanca 7AC · Sloughhouse, CARecovery too late.Accident 19730125001459ABlanca 7AC · Sonoma, CA
Back to Aeronca 7AC