Champion 7ECA
FAA incident reports · 367
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 ('21101NN')
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 ('21101NN')
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 19771025036539ABlanca 7ECA · Sonoma, CAWind gusts to 15K. Student briefed on use of brakes while taxiing.Accident 19770928030859ABlanca 7ECA · Blythe, CAAccident 19770925035469ABlanca 7ECA · Nacogdoches, LA1750FT sod strip,pwr lines n end,trees s end.Accident 19770924028129ABlanca 7ECA · Byers, KSWing caught cane feed,initiated g/a.decided to lnd aftr clearing feed.Accident 19770809027509ABlanca 7ECA · Race Point, MAAcft sank at sea, 8 miles east of Race Point.Accident 19770807039299ABlanca 7ECA · Greenville, SCHigh tension wires located 1/4 mile off departure end rwy.Accident 19770716021449ABlanca 7KCA/ · Manistique, MIAccident 19770710025349ABlanca 7ECA · Ikpek, AKOne tire flat.Accident 19770701029249ABlanca 7ECA · Lebanon In, INAccident 19770528017049ABlanca 7ECA · S.J.Capistrano, CATow cable caught on non-standard steering bar,caused loss of rudder ctl. Hit girl on t/d.Accident 19770327006889ABlanca 7ECA · Churchville, MDGusts to 15KTS.Accident 19770121001199ABlanca 7ECA · Richfield Sprg, NYPlt rounded out to land acft 15 ft above rwy.Accident 19761119035559ABlanca 7ECA · Dalton, PABanner pick up,loop on tow rope caught on l lndg gr. Plt un maintain flt.Accident 19761105034759ABlanca 7KCA* · Simi Valley, CAPilot tried to land on unlighted afld.Accident 19760902028169ABlanca 7ECA · Wallowa, ORDa 5700FT.atmtd operation fm short pvt strip,aborted when it appeared acft would not clr obst.Accident 19760821026269ABlanca 7ECAAccident 19760801028529ABlanca 7ECA · New Smyrna Bch, FLBanner tow.Accident 19760730025249ABlanca 7ECA · Westbrook, MNCause of control problem not determined.Accident 19760725028979ABlanca 7KCA* · Union City, CAAccident 19760724025159ABlanca 7ECA · Black Canyon, AZPlt doing low altitude aerobatics. Crashed drg loop recovery.Accident 19760722023039ABlanca 7ECA · Miami, FLDitch along the side of the rwy.Accident 19760619015979ABlanca 7ECA · Summerton, SCAcft hit an oil storage shed.Accident 19760617015959ABlanca 7ECA · Goodway, ALAccident 19760613019689ABlanca 7ECA · Frazier Park, CADrifted r,r elev hit fence post. Cont flt & lnd at van nuys ok.Accident 19760601013739ABlanca 7ECA · Batesburg, SCPilot lndd on road to visit with peach farmer.Accident 19760229007719ABlanca 7ECA · Whitefish Lake, AKLost pwr at lift off frm snow covered river.Accident 19760108000059ABlanca 7ECA · Plymouth, MIAccident 19751221039949ABlanca 7ECA · Mediapolis, IAAlso hit hangar & parked C-172.Accident 19751218038209ABlanca 7ECA · Mckinley Park, AKTkof frm snow covered rd. swerved off rd to avoid sign post. Ski hit partially covered rock.Accident 19751101037289ABlanca 7ECA · Kyburz, CAPilot anxious concerning erratic fuel gage. Lnd on winding mtn road. Found tank 1/2 full.Accident 19751021036039ABlanca 7ECA · Fair Haven, NYManifold gasket wedged inside #1 manifold & intake port of cyl. All plugs fouled. Crashed offshore.Accident 19751016032959ABlanca 7ECA · Las Vegas, NVLnd in desert,tanks empty.Accident 19751013035349ABlanca 7ECA · Winters, CAAccident 19750914029189ABlanca 7ECA · Knoxville, TNLost ctl drg go-around acft veered off rwy into a briar patch.Accident 19750904028569ABlanca 7ECA · Gillette, WYLnd too fast in hayfield.Accident 19750816024919ABlanca 7ECA · Calhan, COGusts to 15K,downdrafts. Density alt abt 8000FT.Accident 19750729024179ABlanca 7ECA · Martha Vinyard, MAPlt unable restart engine. Ditch acft near fishing boat.Accident 19750625016329ABlanca 7ECA · Susanville, CA4Th ldg of 1st solo flt.Accident 19750607014539ABlanca 7ECA · Lantz, MDCollided with stone wall drg turn to avoid tree line.3.1 hrs aerial ag exp.Accident 19750420011869ABlanca 7ECA · Zwolle, LAAccident 19750409007499ABlanca 7ECA · Gainesville, MOR brake lining worn excessively-piston stuck.Accident 19741211040859ABlanca 7ECA · Hanson, MACircling home while dscndg to lwr alt.Accident 19741006035199ABlanca 7ECA · Talkeetna, AKLnd on snow covered rwy. Gr broke thru crust.Accident 19740915033319ABlanca 7ECA · Earlville, ILPlt didnt apply full rich mixture and or carb heat.Accident 19740909036749ABlanca 7ECA · Seattle, WAFloat equipped. Ip deplaned onto float for docking ops,moved fwd into prop.Accident 19740825029429ABlanca 7ECA · Englewood, CODensity alt about 8500 ft.Accident 19740824030899ABlanca 7ECA · Linwood, MIType flt pln cap. Stall lndg into abt 5FT of water. Acft changed direction 180 deg aftr t/d.Accident 19740728029532ABlanca 7ECA · Aiken, SCCollided at intersecting taxiways.Accident 19740717022819ABlanca 7ECA · Marthas Vnyd, MEDitched in ocean. Crew wore life vests. Rescued by USCG helicopter. Acft sank in deep water.Accident 19740608016289ABlanca 7ECA · N.Canada Plant, ME
Back to Champion 7ECA