Cessna 140
FAA incident reports · 861
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 ('2071602', '2071603')
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 ('2071602', '2071603')
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 19770814022559ACessna 140 · Kimball, NEGusting to 15 observing deer hit power lineAccident 19770728026059ACessna 140 · Rufus, IDTake off was attempted during high gusty wind conditions.Accident 19770724020999ACessna 140 · Whitesburg, GAAccident 19770717019119ACessna 140 · Isle Of Palms, SCCrashed in canalAccident 19770701022119ACessna 140 · Monticello, MNAccident 19770624016269ACessna 140 · Leedsville, VAWheel struck chuck holeAccident 19770623015119ACessna 140 · Jordan, MTAccident 19770601014219ACessna 140 · Stevensville, MTFcst tstms,hi winds & hail. Wind 24KTS on departure. Encountered hi winds,turbc,downdrafts.52KT gustAccident 19770520017429ACessna 140 · Farmingdale, NYWind gusts to 20K.Accident 19770511011109ACessna 140 · Potsdam, NYAccident 19770506010349ACessna 140 · Walls, MSAccident 19770428009909ACessna 140 · Marion, ARAccident 19770421008159ACessna 140 · Vancouver, WAFirst student solo. Wide downwind,low on final,applied partial pwr attempting to clr trees.Accident 19770409008539ACessna 140 · Monticello, NYGusts 30 knots.Accident 19770407007139ACessna 140 · Kirwin, KSPlt rprtd acft did not appear to be accelerating properly.Accident 19770322006289ACessna 140 · Long Beach, CAAccident 19770306004609ACessna 140 · Philip, SDAccident 19770218004109ACessna 140 · Crawfordsville, INSnow bank on side of rwy.Accident 19770214001979ACessna 140 · Hinsdale, MTAttempted tkof fm snow-covered field.Accident 19770130001739ACessna 140 · Redlands, CAProspective buyer over applied rudder & brakes.Accident 19770112007492ACessna 140 · Riverside, CAPilot failed to follow FAA recommended procedure for traffic pattern entry.Accident 19761120036759ACessna 140 · Brookfield, WIDisplaced threshold aprx 500FT fm pwr lines.Accident 19761017034589ACessna 140 · Peoria, ILRt flap inop. Time of fail unk. Plt rptd no flt control problems.Accident 19760925033679ACessna 14* · Vandalia, MOLeft magneto distributor block malfunction-84 hours since factory overhaul on failed part.Accident 19760823026349ACessna 140 · Salisbury, MOEmerg ldg in rough pasture land.Accident 19760726023059ACessna 140 · Elgin, NEPlt un ck hi sink rate aftr low pass.Accident 19760720023539ACessna 140 · Norfolk, MAPlt states acft stalled after takeoff.Accident 19760718021259ACessna 170B · Salix, IATail wheel broke off.Accident 19760714020789ACessna 140 · Englewood, COEng misfired on 2 occasions durg taxi when pwr rdcd to 800 RPM. Nr 2 exhaust value stuck.Accident 19760710021119ACessna 140 · Lake Mills, IASearching for cattle,180 degree turn after low pass.Accident 19760627018339ACessna 140 · York, NEHit back side of badger hole,sheared l gr bolt.Accident 19760608016359ACessna 140 · Byers, CODensity alt abt 7500FT.Accident 19760606016329ACessna 140 · Silver Springs, NVHit rutsAccident 19760521017209ACessna 140 · Jasper, TNAbt one half cup of water drained fm fuel tanks.Accident 19760427012599ACessna 140 · Dana Point, CANumber one connecting rod failed.Accident 19760427008989ACessna 14* · Cambridge City, INFire in area of r rudder pedal. Blacklike soot on firewall blo wiring. Muffler cracked near tailpipeAccident 19760410008459ACessna 140 · Peyton, COAccident 19760404009239ACessna 140 · Green River, WYDensity alt 9000 ft.Accident 19760403009219ACessna 140 · Pensacola, FLSelector on both off. Fuel tank selector value positions-l tank, r tank, both off.Accident 19760318006489ACessna 140 · Bardstown, KYFuel sel l tank-empty.r tank full fuel. Eng restarted on short final. Plt discontinued apch,eng quitAccident 19760220006922ACessna 172M · Ormond Beach, FLAccident 19760118003019ACessna 140 · Kenosha, WIL wheel ctctd snow pulling acft off rwy.Accident 19760107001589ACessna 140 · Price, UTPlt said he removed heavy frost with rag bfor tkof. Hit ditch.Accident 19760104000339ACessna 140 · Minonk, ILAccident 19751227039559ACessna 140 · Shaver Lake, CAFog in valley ahead,mtns behind. Un locate pass,lndd in swampy tree stumped area.Accident 19751222040439ACessna 140 · WAAccident 19751206036949ACessna 140 · Des Moines, IAAccident 19751128036909ACessna 140 · Mineral Wells, TXEarlier precautionary ldg in pasture due wea. Insufficient tkof area. Avoided trees beyond pastureAccident 19751123038849ACessna 140 · Peru, INEntrd plowed fld adj to rwy.Accident 19751115037439ACessna 140 · Reynolds, INWind gusting 25K.acft deptd rwy into a plowed area.
Back to Cessna 140